Validate Form Entry Against Table Column

[Haypipi]

I'm trying to create a form for an inventory return, with inputs for staff_id, shop_id, and item_id.

I tried the formula IN("staff_id",staff[staff_id]), but the parameters disappear after.

How can I check these values entered by staff against their respective tables to ensure they are valid entries? I would like to prevent submission if there are errors.

[Denny774 · Accepted solution]

Hey man,

all these Fields have to be of type "Ref". No further formulas needed.

[Haypipi]

Thank you very much. Problem solved!

[AleksiAlkio]

Good to hear 🙂

[AleksiAlkio]

When typing IN(), it generates a list of values to choose. If you want to check the selection, you need to add something to your formula like.. 

AND(TRUE,IN([staff_id],staff[staff_id]))

[yousseflf9]

i want when i type a name in a field to validate it by loocking if it's already exist or no in my table if it exist it warn me by text , if anyone got the formula for this validation