I am attempting to update multiple records in a single automation in a Synced Table. I am unable to update Synced Records from RunScript as I get 'Error: Edits to synced field "Stories Automation" (fldxxxxxx) are not allowed from this origin'.I know ...
Found this a bit infuriating but NOW() is the fix. Tried all combinations of today() with and without setting timezone and didn't get the correct data in the fields. e.g. SET_TIMEZONE(TODAY(), 'America/New_York') (set the formatting timezone to UTC a...
Having this same issue. I have submitted a feature request to add a button like it has to allow edits from automations, to allow from syncing, or to add a user called "sync" and allow us to select that as a user to allow edits through. The reason is ...
Currently the only solution I have is to create a new field in the synced base, make changes to that field that is then synced into the original base and updates via automation on the original base. NOT ideal.
For me, the record it was trying to update was a drop down, single select that was synced from another base. The issue was that the option it was trying to update to was not an option in the drop down select and the automation didn't have permission ...
