7 Replies Latest reply on Feb 5, 2014 11:58 PM by austin_ck

# Calculation for check box (Yes / No)

Hi Filermaker Members,

I'm newbie in filemaker 13, I had created a checklist for my dispatch veicle checklist.

I have the checklist, I need the approve or reject auto calculate based on my checklist (I use radio button and value list "YES" or "NO")

I have no ideal how to create auto calculate my checklist. APPROVE or REJECT.

• ###### 1. Re: Calculation for check box (Yes / No)

care to provide a user name and password??

• ###### 2. Re: Calculation for check box (Yes / No)

for my stuff record

• ###### 3. Re: Calculation for check box (Yes / No)

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

• ###### 4. Re: Calculation for check box (Yes / No)

I don't know what exactly you are trying to do however you can use the following statement

If field = "Yes"

Approve

Else

Reject

End If

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.

• ###### 5. Re: Calculation for check box (Yes / No)

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,

Mardi

• ###### 6. Re: Calculation for check box (Yes / No)

Dear Helper,

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 ".

Dear Mardikennedy,
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.

• ###### 7. Re: Calculation for check box (Yes / No)

Dear Jrefrew,

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.