I'm running into race conditions some report summaries automations, and am wondering if anyone has come up with a better solution than I have in placeI have a table that is automatically updated when a user adds values from a csv report. I need to su...
Hello!I'm not sure how to approach this issue, as I'm fairly new to scripting. I am creating a script to copy a cell value from the last filled cell in a column to a cell in a new column if the value in the first column is blank. The use case here is...
Thanks again! I just tried this and it works - for anyone else looking for a solution for this, I scripted out the "Processing" check and it works like a charm. Here's the code: let table = base.getTable("table")
let view = table.getView("reports")
...
Thanks for your reply! Not quite - but close.User submits .csv fileAutomation triggers based on new record creationTo avoid a summary record being created for each new record added, I check to see if a record for that date exists already. If it does,...
I just finished writing up a script that does something very similar. You may want to make some edits to this as I'm entering the data from my merged records into a separate (already created) field. What may be incredibly complicated is that your des...
