Hello!
I have a parent form, which has a nested form and I would like to auto-populate information input from the parent form into the child form.
Parent Table: CONCIERGE
Child Table: RETURN FORM CLAIMS
Reference Table: RETURN COVERAGE
The flow:
I've tried using lookup() but the field does not show on the child form when I input an app formula.
Lookup("ID RETURN FORM CLAIMS", "CONCIERGE", "CLAIMS RETURN FORM", "CARRIER RETURN")
Any suggestions?
Supposing the ref column in your child table is named [Concierge] and the [Return Carrier] in the parent table is the name of the column you populated before you opened the form then, you can get the value by [Concierge].[Return Carrier]
Hi @TeeSee1 thanks for your reply!
I'm getting an error when in input [Concierge].[Return Carrier] as the formula for RETURN CARRIER (in the child table RETURN FORM CLAIMS)
In the child table the link to the parent table is:
I noticed in my parent table that not all of my ref columns, have a virtual column w/ Ref_Rows. Not sure if that will cause an issue.
You do not have REF_ROWS in a child table.
REF_ROWS are generated in a parent table.
It would help if you shared the definitions of both Concierge and RETURN FORM CLAIMS.
Hi @TeeSee1
Sorry, the image was from the parent table Concierge.
Sorry, I'm not quite sure what information you are looking for when with definitions, can you elaborate?
What is the name of the ref col in the child table to table Concierge?
This is what was generated in the child table
This is on the parent table:
Well now that you have shown me this, I see there has been a misunderstanding.
What you have indicates that CONCIERGE is the CHILD and RETURN FOMR CLAIMS is the parent. (See this VIDEO around 00:50)
So based on your original post, you are populating RETURN CARRIER in a child record (table CONCIERGE) and trying to pull this into its parent row. Since a parent row can have multiple child rows, you need to select one. Assuming you use the first row you can use the following expression
INDEX(
[Related CONCIERGEs][RETURN CARRIER],
1
)
Having said this, this configuration is not 'standard' and I suspect you may need to rethink how you design your App.
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |