- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2023 04:26 PM
Doing some work for an ATM Placement Company.
When a client signs on, we have a set # of ATMs that we promise to place for them after they set up their bank account.
Currently we are looking for a way to update a dropdown status based on a few factors (possibly a formula).
We are currently tracking # of days since "Bank Account Opened" and are looking to automate a Green, Yellow, Red Status based on these factors....
If we have not placed an atm within Days 60-90, they are a red status
if we have not placed an atm within Days 30-60, they are a yellow status
If we have placed at least 1 atm between Days 0-90, they are a green status
In one of the columns we have a formula to see if an ATM is placed or not. 1 means not placed, 0 means at least 1 atm has been placed. (Photo Below)
We also have a column with a formula tracking # of Days since bank account was opened
And we are looking to auto populate statuses in this column
Looking for any support possible, and please let me know if there is more information needed to do this (and if its even possible)
Thanks everyone,=.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2023 05:19 PM
These are pretty straightforward automations (not formulas).
In the automations tab, create a new automation for each one.
Trigger: When a record matches conditions
Configuration:
- Select your table.
- Conditions For Red/Yellow...
- When "1:Not Placed 0:Placed" = 1 AND When "Days Since..." >= (60 for red, 30 for yellow
- Conditions for Green:
- When "1:Not Placed 0:Placed" = 0
Action: Update Record
- Select your table
- Record ID: Click "+" > Use Data From "When A Record Matches Conditions" : Airtable Record ID
- Fields: Scouting Status
- Select relevant single-select
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2023 05:19 PM
These are pretty straightforward automations (not formulas).
In the automations tab, create a new automation for each one.
Trigger: When a record matches conditions
Configuration:
- Select your table.
- Conditions For Red/Yellow...
- When "1:Not Placed 0:Placed" = 1 AND When "Days Since..." >= (60 for red, 30 for yellow
- Conditions for Green:
- When "1:Not Placed 0:Placed" = 0
Action: Update Record
- Select your table
- Record ID: Click "+" > Use Data From "When A Record Matches Conditions" : Airtable Record ID
- Fields: Scouting Status
- Select relevant single-select
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 28, 2023 05:59 PM
Thank you so much Kenneth. Worked like a charm.