Greetings community,
My name is Vikrant. I do freelance work in Appsheet.
I am working on a Sales Management App where in the Sales form I have to Add Items(Child Table). After Adding the Items, there are fields which perform calculation based on the Items. These calculations are based on a Virtual Column which depends on the Items. My observation is whenever those calculations kick in, the child table disappears and the Virtual Column field calculation also disappear. But after I save the form, all data is Saved properly. It is only in the form that the values are disappearing.
Flow-
First New Sale Form is launched. Customer Details are entered.
In the same form, multiple Sale Items with Quantity and Price are added.
Total_Amount (Virtual Column) calculates the Sum of Amounts of Order Items.
Payment Type is Enum with value as Cash or Instalment.
Initial Payment is entered by the User.
Number of Instalments is entered by the User.
Instalment Amount (Non Virtual Column) calculates based on (Total_Amount - Initial Payment)/(Number of Instalments).
When the User selects the Payment Type, Sale Items table disappear, Total_Amount calculation disappear.
Kindly share if any have insights on this behaviour.
Thank you for having me.
Vikrant