Hi,
say I have two tables, Boxes([id], [nam]) and Objects([id], [boxid], [name]). The column Objects[boxid] refers to an existing Box[id].
Now I have the Boxes detail view, in which I can click an action to navigate via LINKTOFILTEREDVIEW to the Objects, filtered with the specific Boxes instance I selected. Thatโs like opening a specific box and looking into it.
If I add an item in the filtered Objects view, I expect to be able to specify the correct boxid value, that would be like putting an object in the right box.
How would that be possible? I understand that the only source of this info is the filtered view, and without some parsing that would not be possible since the filter condition is arbitraryโฆ So what should I try? Would I succeed? Seems like such a trivial task to me, but donโt figure out how to do that.
Solved! Go to Solution.
Hello @Riccardo_Mazzei
You might want to check out References; they allow you to connect tables together, and AppSheet will automatically create whatโs called โReverse Referenceโ on the connected table.
From your example: I would imagine that the โBoxIDโ column in the Objects table would be a reference to the Box table.
Also, just as an FYI, hereโs some further info about how to use the community effectively.
Hello @Riccardo_Mazzei
You might want to check out References; they allow you to connect tables together, and AppSheet will automatically create whatโs called โReverse Referenceโ on the connected table.
From your example: I would imagine that the โBoxIDโ column in the Objects table would be a reference to the Box table.
Also, just as an FYI, hereโs some further info about how to use the community effectively.
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |