Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jun 24, 2019 08:25 AM
How do I get information from one table with a certain status (on schedule) to automatically update to another table?
All of my tables are linked, but I cannot get the IF formula to move the information to another table automatically.
Jun 24, 2019 01:40 PM
I’m not sure about your base architecture, but one way would be to create a conditional field in the first table that is either empty or contains the desired status, depending on your schedule — something like
IF(
DATETIME_DIFF(
NOW(),
{DueDateAndTime},
'seconds'
),
'Status Value'
)
Then, in your remote table, use a lookup or rollup field to reference the conditional field you just recreated.
The mechanism is a little different from how you describe it: You seem to imply you want to push a value from your main table to your secondary table — which can’t be done in Airtable. (However, it is conceivably possible using a SaaS integration service, such as Zapier or Integromat.) Instead, what you want to do is pull a value from your main table into your secondary table. This is done using a lookup or rollup field, with the secret being to make sure the pulled field is empty until expiration of your schedule.