Hi Expert
Is it possible to make this valid at EDIT after the form been saved? The expression at STANDARD TOOL IS is SELECT(TOOL ASSIGN[ASSIGN ID],[ACCESS CODE] = 0)
I want to nest this condition
Are you asking two questions here?
If so, I do not understand the first one.
The purpose of Valid-If function is to prevent invalid data from being saved. Why do you want to save invalid data??
The second one.
Couldn’t you replace
in the SELECT expression with the long condition you mentioned?
1 Like
Sorry for make this very confuse. Consider this question closed and I will post an new question
1 Like
Its ok I manage to create a coding table and feed that coding expression into the valid_if field and that resolve everything. Actually the issue here is the form need to be edit 2 times after saved. There is no simple feature in appsheet that allowed me to accept the Standard ID which is unique to be save again on the same row at the second and the tthird time eidt.
By putting virtual column and using ANG(SELECT(… to lookup the result at other table and feed this vitual table result as acceptable code at Valid_if that will resut it.
IF(OR(ANY(SELECT(TICKET ISSUE COUNTER[REPAIR CODE],[_Thisrow].[STANDARD TOOL ID]=[STANDARD TOOL ID]))=4,ANY(SELECT(TICKET ISSUE COUNTER[REPAIR CODE],[_Thisrow].[STANDARD TOOL ID]=[STANDARD TOOL ID]))=4.1,ANY(SELECT(TICKET ISSUE COUNTER[REPAIR CODE],[_Thisrow].[STANDARD TOOL ID]=[STANDARD TOOL ID]))=4.2,ANY(SELECT(TICKET ISSUE COUNTER[REPAIR CODE],[_Thisrow].[STANDARD TOOL ID]=[STANDARD TOOL ID]))=4.4),4,0)
