Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 25, 2024 03:27 PM
We needed a "quick" way to see that a calendar entry was canceled (in the label, which is a text field named "Short Name") without typing it. (We use a check box to "cancel" the event)
Forgive me, I'm new. This may not be the most elegant way of doing this, and I may have missed something
I built an automation that when the check box is modified,
AND the value of the checkbox is checked (a FIND table with that conditional and the Airtable ID as the record output)
THEN run a script to update the text field (because putting the text and the field was not working in the non-script format)
I added input parameters of recordID (the airtable ID from the find field)
and xText which is the existing text in the field "Short Name"
the script looks like this:
Solved! Go to Solution.
Apr 25, 2024 05:52 PM
Just this would work fine:
let table = base.getTable("Productions_calendar");
let config = input.config();
let recordID = config.recordID;
let xText = config.xText;
let c = "Canceled: ";
c += xText;
await table.updateRecordAsync(recordID, {"Short Name" : c, });
You can also do this without a script by setting it up like so:
And I've set up both automations here
Apr 25, 2024 05:52 PM
Just this would work fine:
let table = base.getTable("Productions_calendar");
let config = input.config();
let recordID = config.recordID;
let xText = config.xText;
let c = "Canceled: ";
c += xText;
await table.updateRecordAsync(recordID, {"Short Name" : c, });
You can also do this without a script by setting it up like so:
And I've set up both automations here
Apr 26, 2024 12:06 PM
Thank you for the tip on the script! It's funny, the latter (no script) method you suggested didn't work for me. It threw errors and would not run. It was what I tried first.