I’ve moved a column in a table called sync, then did a Regen Columns. Then got this error on all tables with a “Are updates allowed” formula:
Table ‘Customer’ has an invalid update mode expression ‘=IF(IN(“Admin”,ANY(Select(Staff[Type],[Login Email]=UserEmail()))),“ALL_CHANGES”, IF(IN(“Manager”,ANY(Select(Staff[Type],[Login Email]=UserEmail()))),“ALL_CHANGES”, “Read Only”))’. Unable to find table ‘Staff’, did you mean ‘Staff’?
After much faffing, simply getting the app to so a save & verify sorts it. But it seems this is a bug that has crept in someswhere.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |