I have a form that is connected to an external collection in Airtable. In my Form I have the user entering 2 ‘visible’ fields and I have the form generating 2 ‘automatic’ fields. In one of the automatic fields, I would like to calculate and populate the field with the maximum value from another field in that same external collection. However, for some reason, whenever I submit the form it returns 0 for the maximum value. Has anyone else had this problem? is this a bug or limitation in the calculation options in a form?
For additional context, The field I am trying to calculate the maximum for is ‘Row Number’, so I know it is an integer field type. Here is a snapshot of the setting I have for this field in the form.
Thanks for the help!