I have two tables for tracking tool inventory/locations. โTool Transferโ is filled out as a form to track when and to where the tool is being transferred. I then have a โCurrent Tool Locationsโ table where I want to just show where each tool is currently.
Using several virtual columns, I have been able to get the most recent transfer date and the current location of the tool. The problem is, I would really like to have this information in my Google Sheet so the data can be viewed there. Whenever I have tried to use non-virtual columns with the same formulas, it shows the correct information in โtestโ but doesnโt show in the app (or in my spreadsheet).
Is it possible to have non-virtual columns and still have this work so that my data can be reflected in my spreadsheet?
Hereโs the formulas for the columns I would like to be non-virtual:
Most Recent Transfer:
MAXROW(Tool Transfer, Timestamp, [Computed Tool ID] = [Tool ID])
Current Location:
LOOKUP([Most Recent], โTool Transferโ, โTimestampโ, โTransferring toโ)
The problem with your idea is thisโฆ your data is changed in another table and if you want to read that with a normal column, it wonโt work because app formulas with the normal column will be recalculated only, when you open and save the record. If you would like to see this happening, you would need to open every โToolโ record and save them somehowโฆ and you probably donโt want to do that.
What you could doโฆ every time when you add a new โTool Transferโ, you could update the โToolโ itself with an Event action. Check this sample app โEventActionโ from this linkโฆ https://www.appsheet.com/portfolio/531778
very useful examples, thanks
I was able to get this to work! Thanks so much.
Youโre welcome
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |