Hi,
Iโm building out a quoting app, and Iโm having a hard time with getting Appsheet to update a value, based on the sum of other values. For my quoting app, I have a spreadsheet for quotes, and a spreadsheet for two things that go into my quoting items - manufacturing time and materials. Since any item Iโm quoting can have multiple materia, I obviously use a reference for that. Same with multiple manufacturing times.
Iโm able to create a virtual column that basically does the followingโฆ
- Add up all the costs of material line items 2. Add up all the costs of manufacturing time line items. 3. Display total cost per item being quoted.
This works great with virtual columns - I have a virtual column named โtotal_costโ. The moment I add a material, the virtual column updates, which is great.
However, I donโt want to just display the column โtotal_costโ. I want to save it so I can access this cost from other apps Iโm building. I have a column called โsaved_costโ with the app formula โ=[Total_Cost]โ. This works when you first are creating an item and adding materials and manufacturing times, but once you save that item, it locks the saved_cost. I can then add materials, manufacturing times, and delete them, and the virtual column โtotal_costโ gets updated, but the โsaved_costโ column doesnโt.
In order to get the saved cost to update it, I essentially have to click โeditโ on a quote, and then save. Because Iโm editing it, it updates โsaved_costโ with the virtual column value.
Is there a way around this? Iโm thinking one of two waysโฆ
- When Iโm saving a material that Iโm adding to a job, have an action that replaces โsaveโ which updates that original quote column with the new cost. 2. Have some sort of โrefreshโ or โupdateโ button/action that will recalculate the total_cost and copy it to the โsaved_costโ column.
Or is there an easier way to do this Iโm missing?
Thanks!
LinkedIn
Twitter
