Help

Get value from linked table based on input

Topic Labels: Formulas
Solved
Jump to Solution
1372 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

I have table with pin code, city and state,
Have second table with contacts
In contact record, if I type pin code then how can I get city and state value filled in related field from linked table, IF function not works for me as pin codes are 26k records.

1 Solution

Accepted Solutions
W_Vann_Hall
13 - Mars
13 - Mars

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.

See Solution in Thread

2 Replies 2
W_Vann_Hall
13 - Mars
13 - Mars

Like this:

  1. In your [Contacts] table, your {PinCode} field should be a linked-record field that links [Contacts] with the [PinCode] table.
  2. In [Contacts], define two lookup fields, {City} and {State}. These would be lookups based on the value in {PinCode} and reference the values in {PinCode::City} and {PinCode::State}, respectively. ('{PinCode::City}’ means ‘the value of the {City} field in the [PinCode] table.’)
  3. When you select the proper {PinCode} for your contact record, {Contacts::City} and {Contacts::State} will be populated automatically.
Manish_Patell
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you very much for your reply, this solved my problem. Much appreciated. :thumbs_up: