Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 06, 2023 09:35 PM
I have a Payment Interface with a Form that creates a new record in my Payment table. There is a field for Dues Amount and another for Donation Amount. Both are define with a Currency data type, and with a Default Value of $0.00. In most cases only one of these fields will be updated by the User. The problem is that the default value is not being applied to the field the User fails to update.
What am I missing? It appears that the Default Value feature that is available when defining the field characteristics (e.g., name, data type, default value), doesn’t work properly.
Solved! Go to Solution.
Mar 07, 2023 09:02 AM
Thanks for the insight. Good suggestion. I did what you suggested, but to my Interface Designer "Create New Record" form. This is the form that gets activated with clicking on the "+" on the Interface. Unfortunately, the Default Values I entered are not being stored, and/or do not show up on this form. To me it looks like a "bug".
Mar 09, 2023 08:15 AM
The solution I discovered, was to write an Automation that filled the empty fields with my default value, after the record was created. Record creation is my triggering event. This works well since I am having the collaborators perform data entry via a designed Interface. Thanks for your help!
Mar 06, 2023 10:00 PM
The default value function applies for records created within a grid view I believe, and doesn't apply for records created via forms
As a workaround, perhaps you could prefill your form with the default value instead? For example:
https://airtable.com/shrA7MAAqRKVdii9Z?prefill_Value=0
Mar 07, 2023 09:02 AM
Thanks for the insight. Good suggestion. I did what you suggested, but to my Interface Designer "Create New Record" form. This is the form that gets activated with clicking on the "+" on the Interface. Unfortunately, the Default Values I entered are not being stored, and/or do not show up on this form. To me it looks like a "bug".
Mar 09, 2023 08:15 AM
The solution I discovered, was to write an Automation that filled the empty fields with my default value, after the record was created. Record creation is my triggering event. This works well since I am having the collaborators perform data entry via a designed Interface. Thanks for your help!