Choose multiple parent record while updating a child table

[Aditya_Vinayak_]

Hello Team,

I have a parent table : Pet Details
And a child table referenced to it : Service Details

Currently I am recording all the services availed by each pet.

What I want to do is that when I open a service form, I want to be able to select multiple pets as it makes the work faster if 2 pets are taking the same service.

please guide me on how can it be done

[Tommy62]

Schaue dieses kurze Erklärvideo: 2 Möglichkeiten zum automatischen Ausfüllen von Formularen 

[Aditya_Vinayak_]

I am sorry, I am not able to understand how this will help...

[AleksiAlkio]

How about using an EnumList with the base of Ref? You will loose the inline view, but you can then create an action button with a proper LINKTOFILTEREDVIEW() formula. 

[Aditya_Vinayak_]

I am trying the Enumlist with base as Ref, but for some reason, it is showing me only 1 pet whereas there are 2 pets under the customer.

[AleksiAlkio]

What's you formula with the Suggested field?

[Aditya_Vinayak_]

I have not put any formula. If i use the formula it is taking both the pets as compulsory & i am not able to edit it.

[AleksiAlkio]

If you are using the suggested values filtering the pets as per the customer, you are able to select from those pets like one, two or what ever the amount of pet is. Your formula needs to be something like SELECT(Pets[KeyColumn],[Customer]=[_THISROW].[Customer])

[Aditya_Vinayak_]

Okay thank you it worked. 

Can you help on the linktofilteredview part. I have never used that.

[AleksiAlkio]

Something like.. LINKTOFILTEREDVIEW("ServicesViewName",IN([_THISROW].[PetID],[PetsEnumList])).
More details in here.. https://support.google.com/appsheet/answer/10107338?hl=en&sjid=11194239923458924951-EU

[Aditya_Vinayak_]

When i use this formula, in suggested values it should only show me the pets that belong to that customer right? For me it is showing all the pets. I think some issue with the formula I used.

[AleksiAlkio]

Yes. What is your formula?

[Aditya_Vinayak_]

SELECT(Pet Details[Pet ID],[Customer ID]=[_THISROW].[Customer ID])

[AleksiAlkio]

It sounds you have the option "Auto-complete other values" as ON. Set it as OFF.

[Aditya_Vinayak_]

ohhh yess thank you it worked. 

So what i am trying to do is choosing multiple pets as well as multiple services in the same form. I followed the same method but it is showing as belows:

What is the reason for the symbol?

[AleksiAlkio]

Sounds like you are trying to read with the formula other than key column. When using Enum or Enumlist with base type of Ref, you need to use the key column with your SELECT formula.

[Aditya_Vinayak_]

Thats right. I have used SERVICE DETAILS[Service Name]

How can I make services also ENUM?

For services I have a different table altogether

[AleksiAlkio · Accepted solution]

You need to use the key column with your formula. I assume your "Service name" is not a key column.

[Aditya_Vinayak_]

Yes service name is not the key column. But in the service list in the form I want all the services to be visible & the user should be able to select multiple services. So will the select formula only work here or any other formula?

[AleksiAlkio]

You need to use the key column, but if you use it without SELECT(), it doesn't filter any rows. And if you need to multi select, then use EnumList.

[Aditya_Vinayak_]

Thank you!

[Aditya_Vinayak_]

What information would you need to guide me better?