How to correctly set up linked data in a form?

Ask the Community Views
1

Hi all,

I need to use a linked column and lookup in a form.Or at least I believe that’s what I need but possible I’m tackling this completely wrong.
Here is the link to a screencast of my waste of time so far :smile:

“ClickUp”

I would appreciate a push in the right direction

Cheers

Edwin

2

Hi Edwin,

The best way to go about getting right information in the ‘Link row’ model on forms is that you can create a primary column as an ID that will be a join of Country + Province in your case in Table 2.

You can use CONCAT () function for that. Check out the image below:

CONCAT in forms
CONCAT in forms1124×551 39.4 KB

Then this ID becomes your primary column and you can choose it in the link model form accordingly.

3

Txs @StackbyHQ.

I already imported a concatenated row from my source spreadsheet, but yeah, I should have done it as per your example.
Txs!