Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Lookup field does not sync values

Topic Labels: Views
Solved
Jump to Solution
1996 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sylvain_Poncele
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi fellow community members,
In the Tool I am building to follow-up auctions, i created 2 tables:
Table 1: “list of lots in auction”
Capture d’écran 2022-05-31 à 11.37.19
Table 2: “Price obs table” in which i made a link with Table 1
Capture d’écran 2022-05-31 à 11.38.18

My target is, in table 1, to retrieve info from fields “Max Bid Price”, “Max Bid Calculation” and “No bid” fields from table 2 linked with the concerned record.

Lookup field trial has failed.

Any suggestions guys?

Thanks for your help :winking_face:

1 Solution

Accepted Solutions

Hi Adam_C, thanks for your input, meanwhile, I found the reason of my issue: i linked in a former field Table 2 to Table 1 but I renamed it, so that by creating a second link field, data was not pulled. In other words: do not create 2 linkfields to the same table! Thanks anyway to have spent time analyzing my problem which is now solved! :ok_hand: :clap:

See Solution in Thread

3 Replies 3
Sylvain_Poncele
5 - Automation Enthusiast
5 - Automation Enthusiast

As additional info, I created in table 1 a linkfield to table 2 “Price obs” and created a lookup field with max bid price field link with no result. (see pics)
I thought the reason was the empty name of the record but even with info in name field, no result
Capture d’écran 2022-05-31 à 12.20.25
Capture d’écran 2022-05-31 à 12.20.09

Hm, in your screenshot, the field price obs table in the table List of lots in auction is empty. In order for the lookup field to display anything, it needs to have a linked field to pull data from.

Could you try adding links in the field price obs table and seeing whether the lookup field updates?

Hi Adam_C, thanks for your input, meanwhile, I found the reason of my issue: i linked in a former field Table 2 to Table 1 but I renamed it, so that by creating a second link field, data was not pulled. In other words: do not create 2 linkfields to the same table! Thanks anyway to have spent time analyzing my problem which is now solved! :ok_hand: :clap: