Hi,
Let's say I have an order table + a line item type A table + a line item type B table. (Line items A and B have different characteristics).
I want to calculate and or update the discount value on item(s) B based on the presence of some specific Item A on the order.
When Item A is selected first an Appsheet Formula can immediately provide the value when adding Item B but,
When item A is selected after item(s) B (or item A was previously chosen then it is removed), Appsheet Formula does not update/remove the discount on item(s) B. When a Bots is used in this context instead of a Formula, there is a delay before relevant values are updated.
Am I overlooking options to achieve that in real-time (while making customer-facing real-time quotes)?
LinkedIn
Twitter
