care to provide a user name and password??
login : admin
for my stuff record
Here's an approach
convert the fields to numeric
Use a value list with values of 0 and 1
but rather counterintuitively set the yes value to be zero and the not ok value to be one
Then you can add all the fields up together. If the total is zero then approval is OK , if there is any value it is not OK
The way to show that is with a copy of the field set as Boolean but with zero values set to yes and no-zero set to no
The button is the field shrunk down to show the first (0) value in the list as a button which sets the value of the field to 1 if it 0 and 0 if it is 1 ( self xor 1 )
I have shown the first three fields as an example
Dispatch Vehicle Check.fmp12.zip 882.3 K
I don't know what exactly you are trying to do however you can use the following statement
If field = "Yes"
I'm not sure what exactly you are trying to do with the Approve or Reject but this simple if statemet will allow you to then perform the necessary functions.
Sorry Austin, I think I'm missing something here... At the bottom of your layout, you have a Yes/ No approval or rejection, which seems to be a *judgement call* entry, ie it is not a formulaic sum based upon the various Yes/ No answers provided in the section above?
Could you describe the relationship more explicitly, between the final decision and the earlier inputs?
All the best,
attached the photo for I higlight, I need check all this items in YES (except Side Guards Damage and Trailer Frame Damage tick "NO), the total result for approve will be autoselect to "APPROVE", if either check point different with I highlight will be fall to " Reject ".
Yes, you right, I dunno how to create calculate for it, so now I only set it to be manual check "APPROVE " or "REJECT", I wish it be automatic.
Thanks for your solution, by the way, the layout display is " 0" and "1", possible for outside layout display still same with my old " YES" or "NO" but actual record in field is "0" and "1"?
actually for Side Guards Damage and Trailer Frame Damage I must tick "NO" only consider Pass result, because this is the trick request by my auditor, instead of my stuff just click "YES" for all without reading it.