Using the AppSheet Workout Log app template found here, the "Workout Log" table has a column "Exercise" that references a column in the "Exercises" table with the same name. That Workbook Log table's Exercise column is set as the table's key, as shown below. I want to make that column editable and key columns cannot be edited per documentation.
Before changing the table's key:
Per the docs, I've created a separate column in the spreadsheet for "Row ID" and set that as key. This solution however prevents the images from appearing.
After setting the new "Row ID" column as key:
Is there a workaround to have the referenced "Exercise" column displayed correctly AND use another column as that table's key?
User | Count |
---|---|
25 | |
15 | |
4 | |
3 | |
3 |