How to Use a Reference Column with Images and Another Column as Key

V-A
Silver 1
Silver 1

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:

VA_0-1677548169928.png

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:

VA_1-1677548454374.png

Is there a workaround to have the referenced "Exercise" column displayed correctly AND use another column as that table's key?

0 9 336
9 REPLIES 9
Top Labels in this Space