I have an app that requires a change in a % figure annually which is required for all records in one table. Currently this change is made by updating an equation field via the builder. To make this easier for users, is it possible to create an update point on the GUI to make this change?
Does the object (knack table) that needs the update have a Parent connection? If so, you can create a field in the Parent that holds the value of the percentage multiplier. Then you could edit that value in a form in the Live App.
For example, the commission percentage for a sales person is editable in the app and would apply to all the child sales records for that sales person.
What I have done when I want “global” fields, is create a table (I’ve named mine _main or _bigBucket depending on mood) > create one record (or row) and connect it to all the records that need to be updated.
Use a conditional rule in the child tale (sales in our example) to connect them with the single record in the parent table.
Now you have one field to update for a global change.
Thanks Erik, that makes sense. I will give it a Go.
1 Like