- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 17, 2023 05:22 AM
@Sho What type of limitation is this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.