
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2021 03:47 AM
Hi,
I am looking to write a formula that counts the total number of marks of a question and sum them up together as a value in a column.
marks of a question may be identified by square brackets in a field (e.g. [1] means 1 mark, [2] means 2 marks)
A sample of the field looks like this:
"Study the diagram below.
a) Circle what happened to the amount of food in the bowl after a few days. [1]
b) Based on the diagram above, name one substance this animal needs so that it
remains alive. [1]"
The total number of marks for this question would be 2 ( there are 2 [1]s which sums up to 2)
I was thinking that I may count the string “[1]” but the formula does not seem to have this function. I would need to find another way to work around it.
Any inputs/ ideas would be very much appreciated.
Thank you in advance!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 23, 2021 05:47 AM
Best approach is likely…
- Create an automated action that fires whenever a record is added or changes.
- The action should have a script step.
- The script step would read the record and perform the metrics in javascript to find the occurrences you seek.
- Lastly, the script would save the data to the desired field(s).
Javascript’s string and regex capabilities makes this especially easy to do.
