Relation/Lookup column to edit a value from another column

Ask for Help
1

HI,

I am having an issue and I am not being able to undestand how to make a lookup column to modify data from one table to another one.

I am finishing a gym workout routine app for my local gym.
I have one table called “Exercises” where you have a list and a button to add the exercise to a workout routine.

The workout routine is on another table called “Data”. When you add an exercise it dissapears from the exercise list because you added it by toggling the “Hide” boolean, but I want that when the user deletes the exercise from the routine i need to toggle the “Hide” boolean from the “Exercise table” to off and I am not being able to do it. I know it might be with the lokkup feature right?

How can i acces the exercise table throught the data one when the user clicks on “Delete exercise”?

Thanks in advance!

2

You can’t change a value through a lookup, but you can change a value through a single relation. If you have a single relation to a specific row in the exercise table, then you should be able to set column values through the relation.

1 Like