First time using AppSheet, so sorry if this has already been covered somewhere
Iโve got 3 mySql tables, one called โLocationsโ, one called โDevicesโ and one called โDeviceTypesโ
The setup (Obvious) is each Location can have many Devices, and each Device is linked to 1 DeviceType
Everything is properly viewable, but Iโm having trouble referencing more than 1 table. The โDeviceTypesโ reference keeps showing me the โLocationsโ table whenever I click on the link.
I tried to manually enter the key via mySql into the โDevicesโ table for the correct โDeviceTypeโ, and it shows the โLocationsโ + the key I manually entered at the bottom of the listโฆ
I even tried creating Slices from the table(s) to be referenced with the same result (Assuming the column name has to match the referenced table/slice name)
Any thoughts?
Thanks.
Solved! Go to Solution.
Never mind
For any other noobs out there, you have to manually edit (click on the pencil) the row to select the referenced table! The in-line editor dosenโt display that data
Never mind
For any other noobs out there, you have to manually edit (click on the pencil) the row to select the referenced table! The in-line editor dosenโt display that data
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |