How to specify form data key for ambigious column name?

I have a table, the data comes from a select statement including a JOIN statement.

Additionally I have a form and I am using the initial state function referencing the selected row in the mentioned table.

Now the thing is, due to the JOIN statement I have a column name that is in both tables.

Now if I type in tablename.columnname into the form data key of a field, it doesn't work. If I type in the columnname, it seems to be referencing the first table.

How can I specify which column to reference?

{{table1.selectedRow.data.columnName}}

1 Like

Hi Scott, as I said, the column name is ambigious.

Let's say I am joining these tables:

table1
column_a
column_b

table2
column_a
column_b

If I use {{ table1.selectedRow.data.column_b }} which column does it pick, as there are two column_b? {{ table1.selectedRow.data.table1.column_b }} doesn't seem to work.

If I use {{ table1.selectedRow.data.column_b }} which column does it pick (this would pick the columnb from table 1), as there are two column_b? {{ table1.selectedRow.data.column_b }} (you had an extra reference to the table1 )
For table2
{{ table2.selectedRow.data.column_b }}

Hi @Rupur any chance you can share some screenshots of your app set up? Thanks!