How to check if a value is in a table column.

Question

I have a table called zipcode which contains the list of zipcodes we are currently supporting.&nbsp;I want to add a record in other table field (say orders), if entered zipcode for this (orders) table is from supporting zipcode value then "traiaged" else "not triaged ". how to achieve this through formula ?
------------------------------Uday Pratap Singh------------------------------

donlarson · Answer

Uday,Is the field Zip Code your Key Field?&nbsp; &nbsp;Have you related [Orders] to [Zip Codes]?

If you create the field Related Zip Code in the Orders table first as a formula field, then relate the tables together you can then create a Triage Field to check if the Parent Zip Code actually exists.

Here is a formula check box in the Orders table

if ( [Formula Number]=1, True, False)

You now have a check box that will tell you if the Orders Record has a Parent in the Zip Codes Table.

Use that for your reports and status such as Triaged.

Forum Discussion

How to check if a value is in a table column.

Related Content

Find and Replace Field Values

Default column widths on embedded reports obscuring data

Using AND with Null values

Rearrange Fields/Columns in table

Jinja If statement equals field value