Jump to content

Count checkboxs on multi-select list


Recommended Posts

Hi,

Im trying to create a feedback  form for a new empoloye.

his manager will create a new form with a unic Email and password and on the update form he will see only his own relevant form.

He will need to fill in a multi select list the topics he learned.

after the update i want him to see a chart that show how many topics he finished (%). 

Is it possible?

It seems like Caspio cant count checkboxs on the multiselect fields

 

Regards!

Link to comment
Share on other sites

Hello @Amirf,

As far as I understood from your description, you have a field in the table with the List-String data type. And on the Submission form it is set to the Multiselect Listbox:

zan4YLX.png

If so, List data types have a list of restrictions and it is better to avoid using them in case you need more than just submitting and displaying the values. 

FBRPXaM.png

This article can be helpful https://howto.caspio.com/tables-and-views/data-types/list/

 

1) You may use Text(255) data type instead and apply this solution to allow multiselection

https://forums.caspio.com/topic/3148-js-select-multiple-values-from-a-listbox-in-a-webform/

2) Since selected values are added to the table as comma-separated values, it is possible to count them in the Formula field:

CASE
WHEN LEN([@field:Text_field]) = 0
THEN 0
ELSE LEN([@field:Text_field]) - LEN(REPLACE([@field:Text_field], ',', '')) + 1
END

Replace the field name with your local field name.

Here is the result:

qQ3e4n8.png

 

I am hot sure that this is the case for you but hope this helps. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...