AWM Calculated Date Field

Help / Discuss
1

We have created an App Within Minutes that has a Review Date field that is dependent on two other custom fields (Effective Date [date] + Review Period [number]). The Review Date is calculated from the Effective Date + the Review Period (x number of months). We want the Review Date to be searchable so we opted for a custom property rather than a computed value. Our question are:

  1. How do we compute the Review Date (Effective Date + Review Period [months]) - For example: 01-JAN-2021 + 12 (months) - 01-JAN-2022
  2. Where would the script to perform the calculation go? In the Sheet, Template, or somewhere else?
  3. What triggers the script to recalculate the Review Date (property value change or saving the page)? 4) Can the Review Date calculated value on screen change dynamically if the user changes the property value of one of the fields used to perform the Review Date calculation?
  4. How do we make the Review Date field read only so the user cannot alter the calculated value?
1 Like