I have created a form with that can be populated with existing data in a table. So that edits can be made. In the form I have a calculated field (as a default value) that is dependent on other data in the form loading to calculate. Currently I am getting incorrect results.
Is there a way to add a delay to the function I have in the default value field so that all the dependent data loads before the function runs.
Disclaimer - I am new to all of this. I'm guessing there is a simple solution but I couldn't find it.
Thank you for reaching out! Default values should automatically update once the data is correctly populated in the table. Since your example has many fields with different names, it’s a bit challenging to pinpoint the exact issue. Please feel free to share your application with me by exporting it to JSON.
Here’s an example I created to illustrate your case. We have a left column and a right column. The budget (gross) formula is simply the sum of the net budgets in the same column multiplied by the allocation percentage: (net_budget1 + net_budget2) * allocation_percentage.
Hey @Jared_Lake! Welcome to the community. I'm going to pick up the conversation here on behalf of @gonzalo.
I've received your app JSON and dummy data and am unable to replicate the behavior that you're seeing when modifying an existing plan. I've included a screen recording of my interactions with the app here.
Is there a particular way you're using the app that triggers this unexpected behavior?
I'm going to pick up the conversation here on behalf of