Update parent record data with one of the child records dinline action on the child record

AppSheet AppSheet Q&A
, ,
1

I have 2 tables:

  1. Booking Table
  2. Service Availed Table

Structure: Its an app where one customer can have multiple bookings. And within multiple bookings there can be multiple services that a customer wants to avail. Currently, the user has to create a booking, and within it multiple services which are being availed by the customer.

Problem Statement: A situation when there is a change in the booking of a customer, for example a change in the check-in & check-out date, currently I have to make the change at both the levels by clicking on edit. Which is extra work for my team.

I want to understand can I create an inline action for service availed records, so from which ever record I want the booking to be updated with. I just click on the action & it updates the data at booking level also.

please guide me on how to accomplish this at the earliest.

2

Hi @Aditya_Vinayak

Rather than having to update it manually, you could benefit from using virtual column instead of real column.

These are calculated on the fly, hence there is no need for any action from users to update the result.

Would that be useful for your need?

For reference:

Use virtual columns - AppSheet Help

Columns: The Essentials - AppSheet Help

You can create these using this:

Aurelien_0-1696793298133.png

3

Hello @Aditya_Vinayak

I didn’t find the possibility to have an action executable in one table and edit any row value in another table.

Instead, I will make "check-in & check-out date" only presented in “Booking” table.

  • Further in “Service Availed” table, the check-in and check-out dates are virtual columns, whose values are expressed as LOOKUP([_THISROW].[key reference],“Booking”,“key reference”,“check-in & check-out date”).

  • In “Booking” table, the default Edit action will be used to update the “check-in & check-out date”.

  • In “Service Availed” table, first deactivate the default Edit action, and then create a customized action to do this: App: go to another view within this app. The target expression is LINKTOROW([_THISROW].[key reference], “Booking”).

Then either in Booking or Service Availed table, the edit action opens the record in Booking table and updates the check-in and check-out dates.

Hopefully this matches what you want.