Base form conditions from a table

Here is what I'm trying to do:

I have a table A where I keep track of my inventory.

I'd like to build an order form that's separate from table A but that checks if a specific product in table A has an amount of > 0 before allowing the user to continue with the next step in the form. Then when they have checked out, I'd like to reduce that number according to the order.

Is something like that possible with Jotform?

Hello,

I hope you're doing well and thanks for reaching out.

No, basing the form condition(can your user go to the next page of the form) from a table(separate, external, or internal) is not supported.

You can only use form conditions using the values that are available inside the live form.

I suggest you give the Inventory widget a try and see if that works well for your requirement.

Let us know if you need further assistance.

Best regards,