Master Table Referencing

Ask for Help
1

Hi I’m having what feels like an elementary issue using the calculated columns. I made a custom unique ID with a template column and can use it to query another table in one instance, but not in another. Attached is a visual of how the data is mapped.

Users define a project profile which fills multiple “component” tables with a rows of data. The user can then “submit” the project which adds a single row to the master table, including the unique ID. The unique ID is a reference for query columns in the master table to pull in the relevant rows from the component tables. I use a query instead of a relation since two qualifiers are needed: the project-specific unique ID and a category ID. The master table has no trouble relating to a single row in one table or querying multiple rows in another, but replicating the latter has proven challenging.

Thank you!

Master Table Query Mapping
Master Table Query Mapping1107×346 9.38 KB

2

Any chance you have copied and pasted the values at some point in your flow? There’s a data editor bug in the past few weeks that would affect something like what you described.

I would suggest retyping “Item 1” and “Item 2” on your own in table 2 to see if it works.

3

Thank you! We were spinning our wheel on that one

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.