This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello, I am trying to create an automation for assign shifts to contractors.
Here is the current structure:
Look for checkbox = true as triggerFind records in “Scheduling” where Name from record in step one is in “Offered to” linked record field.Add ...
You can use an IF() formula to do this.The formula below checks to see if a value is present in the old address field. If there is, it returns that value, otherwise, it computes the address using the formula referenced above. TLDR, this prioritizes t...
This would be easier to do with a script. If you use a formula though, here are some functions you'll want to look at to get construct a method for each case:SEARCH()SUBSTITUTE()LEFT()RIGHT()MID()LEN()I really suggest using a script though. This form...
See this documentation for reference on synced tables:https://support.airtable.com/docs/getting-started-with-airtable-sync TLDR:Airtable allows you to sync in data from other bases, but "two-way sync" (editing the same data from both bases) is only a...
You're very close!You are still using the wrong input for the "Record ID" field. Notice that in your last image, the input value for "Record ID" is "2023-11-03." This value should look something like: "recFtKBNr6zr12SGV"The value you should use is la...
If you decide to do option B by using the a Button to trigger the script, look at the API reference for the input.textAsync method.This allows you to ask for user input. Note that you need to turn the input variable into an integer (assuming that you...
