Forum Discussion

JesseBerry1's avatar
JesseBerry1
Qrew Trainee
7 years ago

Snapshot based on summary field not working on first record

I have a Stores table and an Orders table. On the stores table, I have a summary field called MaxEnding# that is based on the max value of a numeric field in the Orders table.  The orders table the...
Forms
Formulas and functions
Relationships
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
7 years ago
If your example persists where it is only happening on the very first order, it might be a behavior related to their not being a value for the first record, so the lookup field for starting number has to reset for the first time. You can probably get it to work if you add a catch in your starting # formula that if you don't have any orders saved yet to force it to remain at 1 rather than adding the additional counter

Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base