Newbie Q: Computed column not seen on my screen. Suggstions? (w/Vid link)

Okay…

So firstly, if all you wanted was a real time calculator:

  • Use a table as the source of your screen that has only one row.
  • Add a RowID column to the table (this isn’t used for anything, it just ensures that the row isn’t empty)
  • Add columns for each of your inputs. These columns MUST be User Specific
  • Add a math column to do your calculation
  • On your screen, DON’T use any type of form component or container.
  • Just add a regular container, and then add input fields for each of your input columns
  • Add a regular text type component and point it at your math column
  • What you should then find is that as you enter values into your input components, the result of your calculation should be displayed and updated immediately
  • If your need to “Reset” the input values, add a button to the screen and configure the associated action to do “Set Column Values”, clearing the value in each of your input columns

Next, if you need a permanent record of each calculation in a new row in a table:

  • For this, you can use a regular form
  • You will need a table to accept the form entries, and your form should be configured to write to this table
  • Important thing to note here is that you will not see the result of the calculation in real time. This is because nothing is actually written to the table until after the form is submitted (but see below)
  • If you need to capture things such as which user submitted the form and when, you can use Special Values in your form

If you actually need both of the above - that is, save each calculation and see the results in real time before form submission - that is possible by using a Custom Form.

2 Likes