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.

1 Reply

Related Content

Report Column labels not saving

Autofill user field when a checkbox is checked

Time of Day field values are not in 24-hour format in Pipelines

Incompatible value error

Working with %%rid%% and checking a box

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.