Hey everyone,I have a 2 formula fields that generate prefilled form links. The forms are nearly identical and contain a number of linked record fields. I have noted that some of the prefilled linked record fields fail to prefill when opened with diff...
Here's the system:Base A: Used for Project Management for an event in January.Interface A: Created on top of Base A for use by other members on the team where data access needs to be considered.Base B: Use for Project Management for an event in Febru...
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 just return an empty string if the target field is empty, ie:IF(Variance = "", "")For this use case, you can just return an empty string as your default return when no other conditions have been met (the false return in your last IF statement...
It all depends on the use case. Renaming within the base offers the ability to ensure that the filenames adhere to the expected naming convention whether they are downloaded in bulk, or one by one from within AT.If downloading single files is never e...
I have a script that renames images when added to the record using info from the record:let config = input.config();
let table = base.getTable("Musicians/Presenters");
let query = await table.selectRecordsAsync();
let record = query.getRecord(config....
"This past week" refers to the previous 7 days (including today). Ie if today's date is September 11th, then September 4th-11th would fall within "this past week.""This calendar week" refers to Sunday through Saturday of the current week. If today is...
