Hii i am create a Form in Appsheet when doer selected SOA Number basic filed Like product Name and Mould name come automaticaly but some time doer Mould Name not coming because mould Master is not updated i want if mould is blank dont submited it show its pendingHi, I am creating a form in AppSheet. When the doer selects the SOA number, basic fields like product name and mould name should automatically populate. However, sometimes the mould name does not appear because the Mould Master is not updated. I want to ensure that if the mould name is blank, the form cannot be submitted and should show a status of “pending.” But curently is submited eveny is star marked.Hi, I am creating a form in AppSheet. When the doer selects the SOA number, basic fields like the product name and mould name should automatically populate. However, there are instances when the mould name does not appear because the Mould Master is not updated. I want to ensure that if the mould name is blank, the form cannot be submitted and should display a status of “pending.” Currently, it can be submitted even when this field is marked as mandatory.
Hi @DME1
lots of copy-paste in your question 
You may want to edit this column, go to the Data validity section /Valid if expression and use this expression:
- if [mould master] is type ref:
ISNOTBLANK([Mould Master].[name])
- if [mould master] is type text:
ISNOTBLANK(LOOKUP([Mould Master], "mould", "mould_master_column", "mould_master_name"))
You must adapt these expressions to your current table structure and column names.
Hope this helps!
Thank you for informing me about the copy and paste issue. I created a form called “Oursource RC” where I select a SOA number. Based on this number, I receive the HRL part code and mould name. However, sometimes the person responsible forgets to update the mould master, which causes the Mould name column in the Oursource RC form to not display correctly. If he had update in Mould master then Mould Name is showing in Columns
Hi @DME1
I’m afraid this is a situation relating to the original data source.
You may want to make the Mould Master information to be mandatory in the source table, by ticking this option:
