Nov 16, 2023 05:32 AM
So I have two tables the "products" table and the "Wholesale Products Sync", the trigger of this automation is when a field is unchecked in the "products" table I would run this find records action:
then I would run this script to delete the record in "wholesale products sync" but I get an error:
Nov 16, 2023 05:03 PM
Is Wholesale Products Sync a Sync table?
It looks like you can edit it if you have an Enterprize plan, but normally it is not editable. So "Automation" would also result in an error.
Nov 17, 2023 05:22 AM
@Sho What type of limitation is this?
Nov 17, 2023 07:30 PM
I tested it and this is the error I got when I tried to delete a record in the Sync table.
ERROR
Error: You are not permitted to perform this operation because the table "table" (tbl~) has been configured to limit who can perform this operation
at main on line 5
Are you specifying the record ID of the product table instead of the record ID of Wholesale Products Sync table? Please check.