GLM & SLM Idea Lab
31 results found
-
Summary Column in Tables
I love the addition of tables and the summary row but I also would like to see a summary column so we can have totals automated on both ends of the table.
21 votesFor Summary Columns is "sum" the only function needed or would their be others?
-sammie
-
Table-style questions: Allow calculations across more than one table question
We have a budget form with a table for Revenue and a table for Expenses. It would be great to be able to calculate the net (revenue minus expenses) without the applicant having to do math or cut-paste totals from the separate tables into a third table or field.
18 votes -
Custom Column Widths in Tables
Currently the columns in tables are all the same width, but there are use cases where it would make sense for one column to be wider than another.
For example, in our budget we have 5 columns - Expense, Request, Cash Match, In-Kind Match, and Calculation/Description. By my calculation if you have 5 columns only 33 characters are visible at one time. However, in our use case, 3 of the fields would not contain more than 7 characters (plus the characters for the column headings). Being able to resize those columns would free more real estate for fields where users…
12 votes -
Clone question
We really like the clone feature available when editing a table, and it would be helpful if this were available for all questions. Having to manually copy over the drop-down items and additional information is very time consuming.
11 votes -
Score based on answers to questions on application.
Need the system to generate a score for the application based on how questions on the application are answered. For example: a GPA between 3.8-4.0 would receive 10 pts, 3.6-3.79 would receive 8 pts, etc. This could be a % score.
9 votes -
allow us to enter the number of rows we want when cloning rows in tables
Have the option to enter the # of rows you want when cloning. Instead of having to clone 10 times, i can click "clone row" 1 time and enter a number and badaboom badabing i have that many copies of the row. Magic!!!
9 votes -
Ability to add attachments
Currently, the only way to provide a form to be completed is through links. I'd like to attach an excel spreadsheet that needs to be completed and uploaded by applicants. We have run into issues where links to forms break and it would be much simpler to provide the attachment within the application question.
8 votes -
minimum character count
It would be great if the admin could set both a minimum and maximum character count for such questions as "Integer." For example, if we require a 7-digit number, we can set the maximum to 7 characters, but we don't have a way to set the minimum character count to 7 as well, which can contribute to mistakes with ID submission.
8 votes -
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%7 votes -
I would love to see every question have the option (or not) to be in print packets. We have a few explanatory sections that no one (applican
I would love to see every question have the option (or not) to be in print packets. We have a few explanatory sections that no one (applicant, staff, evaluators) needs to see when reviewing.
7 votes -
branching from table responses
Need to be able to branch from table responses. For example. We formerly used 2 radio button questions for reporting year and reporting month. When grantees respond with specific months (end of quarters), certain question groups will open.
Now, we want to convert 2 questions into 1 table (a column for year and another for month), but we can't use our branching groups now.....:-(
6 votes -
Option to hide questions on forms that are no longer relevant
While I understand why you cannot delete question fields once an applicant or staff member has submitted a response on it, sometimes that question needs to be deleted moving forward and based on how we have set things up it is preferred to not create/copy a new process when we want to make deletions. It would be nice to be able to "toggle"/hide a question from the applicant/grant manager on forms when we no longer want them to be answered/used.
5 votes -
Relabel 'Text and Upload' Question Type
Change the name of the 'Text and Upload' question type to 'Text or Upload' or 'Text and/or Upload' to better represent the functionality of the question type.
5 votes -
summary row
Could you format the summary row in tables to match the format on the rows above. In particular, use the thousands "comma"? It looks weird now if you use a summary row because the formatting is different.
4 votes -
Allow Instruction Questions to be Shared Questions
We input scholarship fund information as instruction questions on our UA application form. We would like to be able to share these to our evaluation forms so that the applicants and the evaluators both have the fund information with staff only needing to update the fund information in one place (currently we have to update in both the application and on the evaluation forms).
4 votes -
Allow for Copy + Paste or Import in Tables
Currently, if I copy a table in another application like Excel or a web browser, it pastes all the values into the destination cell. It would be great if I (and our grantees!) could paste or upload table data from other sources.
3 votes -
Question Required Type Visibility
When we set up forms, the questions alternate between the required types (required, optional, read only) and visibility (internal, everyone, etc.). It would be helpful if the questions required type was visible at-a-glance similarly to the visibility so that we didn't have to click on the actual question and open it, just to see if its a read-only or optional.
3 votes -
Collapse branching logic rule groups
I have some very involved branching logic. When I'm trying to troubleshoot/debug the logic, it would be helpful if I could collapse rule groups that I don't need to work on. I'd like it to behave like Outlining in Microsoft Word - where I can expand and collapse to different levels overall, or expand/collapse individual rule groups. It would allow me to "declutter" what I'm looking and more easily find my way through the maze of rules.
3 votes -
select multiple rows/columns in tables
Add the ability to select multiple rows/columns when building tables, so that when you mess up for the 50th time, you can delete all your extra rows at once. :-)
2 votes -
Table Question - Ability to Edit Read-Only Cells
When building a table question, It would be GREAT to be able to edit read-only cells. I confirmed with Support that at present, read-only cells do not allow you to edit their content other than their label, yet applicants cannot see cell labels. This means that any read-only cell that is not in a summary row will always show up to applicants as a blank cell.
This is confusing because it makes it seem like you have the option to do something you don't, e.g. put readable content in read-only cells. I would love to be able to do something…
2 votes
- Don't see your idea?