Formidable Forms Community Site

The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk
Subscribe

Calculation CountIf

Labels

This Discussion is public

Notifications

Hi,

I have a form that allows me to submit types of Shifts

I also have another form displayed in a format of a shift pattern Sun to Sat, with lookup fields that populate in a dropdown selection for each day of the week over a 52 week cycle.

I am tryng to figure a way to calculate how many times during that shift cycle each shift has been used. Just like a countif statement but i can't seem to find a way of doing it. Is anyone able to point me in the right direction please.

Thanks Chris

Attachment:

You need to be more specific and provide an example of what you are trying to accomplish. For anyone not familiar with your forms or process, your requirement is vague. I don't understand what you want to achieve.

My form will fetch text values from another form named "shifts"

The form will run Sun to Sat week 1 - 52.

I will be selecting various shifts from the drop down selections like the image provided.

I'm trying to calculate how many times each shift is being used within the form.

For example.

Sun to Sat: each day will be a "M" shift on week 1. So that's a total of 7 "M" shifts that week. Week 2 might be 5 "M" shifts and 2 Rest Days "RD". So over the cycle I can populate an accurate total of shifts and rest days.

Thanks Chris if you need access then please let me know

Thanks

Your issue requires more support than I an comfortable providing as a community volunteer. You may want to consider hiring a developer to help you with this one. This could take a couple of hours to resolve.

Hi Chris,

Have you had a look at the Field Totals & Statistics documentation here: https://formidableforms.com/knowledgebase/add-field-totals-and-statistics/#kb-field-filters

I think you could achieve what you need using field filters and just getting for 'X' if it equals 'X'

E.g
[frm-stats id=123 type=count 123="A100"]
You might have to play around with it bit to get it working the way you need but it should do the trick (if i've understood your requirement correctly).

Thanks

Chris

Thank you both for your replies. Yes Chris that is what I am trying to achieve but the issue is this.

If users were to create x amount of shifts 10,20,30 etc then it would be highly impossible to know what shifts they create for me to add the condition.

I thought maybe is it could be referenced by the ID of the shift itself then it may possibly work. I.e A100 is ID=1 and if I add a condition equals to ID then the count may work.

Thanks Chris

Discussion closed.