Table-Style Questions: Ability to apply regular expressions (REGEX) to a field in the table
Request: Ability to apply regular expressions (REGEX) to a field in a table-style question.
Use Case: Applicants are asked to assign percentages (%) to demographic questions about the population served. The total at the bottom must add up to 100%.
Example:
* 20% -- A
* 20% -- B
* 20% -- C
* 20% -- D
* 20 % -- E
* 20% -- F
TOTAL: 120% <-- would be rejected because it is not 100%
Tracy Larimer
shared this idea
-
Renea Muellerleile
commented
I strongly support adding expressions to Table functionality. My example would be with the entry of expenses (actual to budget is a key function for grant management). Often the grantees do not enter a "-" number and this creates additional work to reconcile the overall Table. I would like to see more of a "formulaic" capability ("spreadsheet like") to broaden the budgeting tool. Thank you for your consideration.
-
Lisa Stachula
commented
I have worked with a couple of clients that want budget tables to track remaining grant balances against expenses. Being able to enter a regex that converts a number to a negative number would allow for this, when using the summing row feature. For example, Row 1 captures the amount awarded for each budget category. Row 2 the client enters how much was spent in each category, and the regex converts that number into a negative. Row 3 is a summing row that now displays for the client and applicant how much is left to spend in each budget category.