Lookup, referencing.. Help!
Hi, I have 2 tables. Lets say Table A and Table B. I would like to call data from Table B to Table A, hence I get into table A and made a relationship to Table B... I do not click the relationship field to Table B to specify which row to choose from.
In table A, I have a text field "9" written on to it.. How can I lookup the ID number 9 from Table B to Table A?
I would like to lookup the row ID according to the text field..
Please someone help me, I am really stuck!
1 reply
-
Hi Vinson,
if you just want a specific record field/are using this in a formula for other information to be populated used
let t := this; record('Table B', t.number('text field'))
This will return the record from the text value from Table B
If you're trying to retrieve the whole record into a view, so you can display it then use the formula
let t := this; select 'Table B'[number(id) = t.number('text field')]
Hope this helps!
Content aside
- 1 yr agoLast active
- 1Replies
- 115Views
-
2
Following