How to edit a specific related row in another table

AppSheet AppSheet Q&A
1

Hi there,

first post and a relative new user of Appsheet. I found a lot of help on other post but i can´t figure out how to do the following:

I have a table with data of workers, from there each one is registered with an action in a table for courses. If people don´t participate, i change the assitance status in the courses table, and the worker has to be registered again for a cours in the future. If the person does not asist again, i want to edit the last course added. I use the LINKTOROW( ) function, with lookup to get the key, but it always brings the first registration.

table workers : ID(Key), name, course_status, related courses. table courses: ID_courses(key), ref_ID, course, asistance.

my target looks like this: LINKTOROW(LOOKUP([ID],“Courses”,“ref_ID”,“ID_courses”),“Courses_Form”)

I also tried with select, but i only get blank form and it ads another row with the following target:

LINKTOROW(SELECT([Related Courses][ref_ID],[asistence]=true),“Courses_Form”)

Thanks in advance for any help.

Patrik

2

Check out MAXROW()

3

I tried MAXROW() in the select function, but i don’t get the courses_ID value with select.

How would i integrate MAXROW in with LOOKUP?

4

MAXROW would take the place of SELECT/LOOKUP. It already returns a key value, which is what LINKTOROW needs.

LINKTOROW( MAXROW(…) , “view” )

1 Like
5

I did not know that, thank you very much, solved my problem.