Data Columns Formula Help

[jesslm17]

Hello,

I have a table titled "Technician Data" and another table titled "Salvager Data". In table "Technician Data" under columns I have a column (barcode) I would like to add a formula to that looks up Salvager Data column (Type) and if (Type)="Salvage" then true as in proceed with form, if false unable to submit form. When I selected the formula icon I could not find "Salvager Data" table as an option. It only listed the "Technician Data" table and another table I have titled "User". So i need to figure out why "Salvager Data" isnt showing but more importantly I need help creating a formula. Thank you so uch

[AaronTerry]

Would love to assist and sounds possible but going to need better information, try adding some screenshots of your data and your AppSheet app preview to help explain.

[jesslm17]

Hi Aaron,

Thank you for taking the time out to help me. Basically I am trying to create tables for our manufacturing business as like a work-in-process or workflow using barcodes. For example "Step 1 (Supplier)" submits table form and next "Step 2 (Technician)" would attempt to fill out form and scan barcode. That barcode would be used to lookup "Step 1(Supplier)" spreadsheet for "barcode (column)" match and that the "Condition (column)"="Salvage". If it does not an error message displays or some way of preventing submission.