Question

Asked a question 8 months ago

Hello guys, i have a question on formula. Say i have the following fields and i want to submit a diagnosis e.g if i check 3 places on a condition it automatically generates a diagnosis.How do I write the formula in clappia. I know its a COUNTIF question

Where am I?

In Clappia Community you can ask and answer questions and share your experience with others!

Enter with Google

Answered 8 months ago

You can use below formula to count the number of checked options in the multi-selector block.

IF({hormone_pr_1}="", 0 , COUNTIF(SPLIT({hormone_pr_1}, ","))).

You can also retrieve the comma-separated values of the options checked in multi selector block using below formula.

SPLIT({hormone_pr_1}, ",")

Liked by Willis Ngure

I have an Asset Request App on Clappia. I want some sections of the App to be hidden from the requester and visible only to the requester's manager. Is it possible?

For Mobile no., I've applied a specific validation. LEN(Mobileno=10) was the formula I used. It is not necessary for me ... number. Please provide a solution.

I want to show the total score of the user only after they have submitted. How to achieve this?

Ok i see, thankyou. Does this mean on every page i put the page break and the header or can this be achieved ... disappears. Look at the attachment.

I have marked some fields as mandatory in the app and also used some other validations. Will these validations work if I create submissions by bulk uploading an Excel file?

Can I upload an Excel file or CSV file to automatically create multiple submissions? I don't want to create submissions ... as I have more than 5000 entries.