Iโve almost finished making an App from of a Google spreadsheet to โtrackโ materials over time (location, amount, โownerโ etc).
The main Sheet contains unique rows of each material, with many characteristics, one of which is the โamount (X)โ. It is simple to do things like โmove material to new locationโ (from dependent dropdown) or โduplicate the materialโ (row) and assign it a new unique ID via Actions and save it in the Sheet.
What is not so easy for me to grasp is making a new action to separate the material into a โparent rowโ (i.e. the one copied from), and a โnew copied rowโ where the amount of material in the โparent rowโ is less the amount in the โnew copied rowโ on saving (or some other event)
The amount in the โnew copied rowโ should be validated to be less than the โparent rowโ, or perhaps from another view/workflow? I would also contemplate using a sheet formula to do the math if there was a way to track which rows were affected and pass that to the event structure (e) in google sheets (though probably not possible in the current API).
Any advice/pointers are appreciate!
Craig
Instead of copy, use a LINKTOFORM and set all the data you need. Then on save run another action that marks the old record as old, and drops the reference to the new row.
Thanks. Almost there but seem to lose a reference to the row somewhere.
Nevermind - found this missing [_THISROW]!
I did not appreciate how useful the LINKTOFORM was in this context -
thanks!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |