Solved Redirect to the form after Upsert

[elmarra]

Hello, I need your advice.

I use the upsert module to insert data from the 'Bookings' list to the 'Completed' list. When the check is marked as 'completed', the upsert module creates a new record with the data I selected in the 'Completed' list.

I would like that when the user in the 'Bookings' form checks a checkbox or a button as 'done', they are automatically redirected to the corresponding form in the 'Completed' list to complete the data entry for the new form.

How could I do this?

 

[troester]

So the user checks "Completed" and then Save,
the upsert is running after the save
and then the redirect?

The redirect with condition ...if done is checked...

redirecting to
- You don't have the id of the newly created "Completed" record at this point
- I assume you have some element like a FK in "Completed" pointing to the "Bookings" record? Assuming completed___fk-element = bookings___id for now.
- Then you could set the jump URL to something like ....view=form&formid=X&usekey=fk-element&rowid={bookings___id}

 

[elmarra]

Thank you,
It works, I then inserted a redirect in the "completed" list to be directed to the list. Otherwise I went back to the bookings form .