I am building a lead generation app based on points system. So, for every leads purchased by the agents, their points will be deducted from their existing points that will be appointed to them every month. All of these are tabulated and solved. What I want to do next is,
For the section with the form, I want to ensure that once the categories are filled up, the points redeemed will be auto-tabulated and displayed below to show the users the total points redeemed. How do I go about it?
The problem with native forms is that the input values are only written to the underlying table when the form is submitted, so you cannot access them to perform any calculations prior to that. With a custom form, the input values are written to user specific columns as they are entered, and so you can “do stuff” with them.
The general approach:
Create a details screen, and add whatever input components are required
Target each of the input components at a user specific column
Use those columns to do your calculations, and display the results
When the form is submitted (you’ll need to add your own submit button), take the values in the user specific columns and use them to create a new row using an Add Row action.
so, this is the form. I want the total number of points to redeem based on the leads chosen to display below the quantity field, to show the user the amount of points they will redeem once the submission is done.