Question Fields: Ability to make Charts/Tables/Grids
It would be a great tool to have in the application, review and reporting stages to have the ability to create tables for grantees to fill out (text fields, not necessarily complex budget tables (But Budget tables would also be appreciated ;) )
Although I understand the background work to make this happen is difficult, I think it would be a very strong and well used feature.
I hope you are doing well! While this request has been out here for a whole we have read all of your comments are starting to dig into defining this functionality.
As move of you know we have moved to an iterative approach to development. As we do this we want to make sure that the first piece of the functionality we deliver will be useful and will deliver value. This is where I could use your help.
As look to develop this first round of tabling/grid questions or biggest questions are around reporting expectations. Once, data has been entered into the solution via grid how will you be using it? How does it need to come out of the solution.
We will be actively engaging in this conversation over the next month(s). So please chime in and keep subscribed as I will continue to post the requirements of this functionality here.
Amy Nossaman commented
Do you ready for a beta tester for the table/grid functionality yet? I am building a new process in my Sandbox and would love to insert a basic table
Paula Bellemore commented
One way in which we would use this is to keep track of resource attributes - for example - of 100 acres to be conserved, how many are wetlands, how many are forest etc. The sum feature wouldn't be needed in this example because one particular acre might fall into two different attribute categories.
Liz McClure commented
I'm seeing a lot of comments about NPO budgets in grant applications and I think that's a fantastic use that our grants manager would also utilize. As a scholarship manager I would love to use a table for students to enter their extracurricular activities, with school year and activity as the rows and columns. This is something our evaluators are always clamoring for as it's hard to keep it straight in their heads as they're scrolling through 20+ questions about different activities students may or may not have participated in.
Christopher Spencer commented
Where do I find my rubric or evaluation forms in the system?
Deanna Poelsma commented
We would like to use the tables/charts for applicants to enter itemized project budgets that auto total at the bottom. We continually struggle with applicants entering budgets that don't add up and/or are not in the requested format and are difficult to read.
We used to have folks upload excel documents but we need to be able to run reports that pull the total project income and expenses which isn't possible with uploaded documents and trying to string together 300+ individual documents into a single column in a workbook was too cumbersome.
Looking forward to continued updates on this feature!
Indiana Arts Commission
Gina Kelly commented
Thanks for the update Sammie! We would most immediately use this feature for demographic information (number and percentage of Board, Staff, Clients who identify as POC). But I also think that we would use the feature in the future for budgets and to dig further into target populations (projected number served broken down by geography or sub-population).
I would hope that the data would be able to be pulled out of the solution in individual columns that we could then manipulate as needed. For some fields, I may care about the raw number (is operating budget above/below a certain number), for others I may care about the percentage between two given numbers (% of BOD who identify as POC), and for others I may care about the difference between two numbers (projected budget vs. actual budget).
Thanks for working on this!
Hi Sammie, for our applications this year, we added questions to find out more about organization's board & staff demographics (race/gender). We had to create indivdual questions and the organizations provide us with a # for each question. We created a merge template to create a chart of the data we collected to create an application packet for evaulators to review. On the reporting end, I use a pivot table and combine the data to create graphics.
We are also starting to require organizations to provide us with reports on their progress after grant funds are disbursed. It would be interesting to see how we could utilize this.
Sarah Winig commented
Like others, we are looking to move the budget that we ask applicants to fill out in a separate Excel file into the application itself. So, the ability to specify the number of columns and ideally the ability to do simple calculations, such as sum line items (quantity x price) and a sum of the whole table. The number of rows should expand based on how many items an applicant needs to enter. Reporting would be nice, particularly for the table totals.
Gloria Dillard commented
I emailed you the spreadsheets that I currently have my applicants complete and upload. It would be nice to create the same spreadsheet within the applications so that the applicant can input the necessary information. I would also like for the spreadsheet (table) to calculate and for me to input mandatory not to exceed calculations. What I mean by this is, for us, the applicant cannot charge more than 10% of their salary towards the grant. I would like to max this field to calculate 10% of the salary, thus, the applicant would not be able to charge more. This is just based on a few rows, thus; is why I would like to be able to have this option by fields. I also agree that it would be nice to be able to create reports based on the table field.
As with the other comments, as this project progresses, I'm quite sure that I'll have more input.
Amy Nossaman commented
I currently use or would use a table/grid in 2 ways. I would like to build it into a form for a budget in the LOI or application phase and then a final budget in the reporting phase. The other way I would use a table is when a create a multi-year or multi-installment grant agreement to show the date of each installment, the amount of the installment, any reporting requirements w/due dates. I am able to pull the multiple installments but almost always have to manually format it. I have attached the 2nd page of a current multiyear grant. Thank you!
Hi Sammie, This is very exciting that you are looking to develop it. I would gladly support and engage in conversations over the next month.
You will more than likely get a varied response from the ways different users would use tables, but from my perspective it would be for two main reasons:
1. Efficient Applicant, Evaluator and Admin: If we had fillable grids, it would make questions simply easier to get answered. Right now we have applicants have to download additional Excel Templates, fill them out and then re-upload them (All not report-able or available for data pulling)
Easily access the data visually on the application through a grid so that the applicant can fill it out easily, the evaluator can review it easily within the application and the administrator doesn't have to download, upload, open extra documents to check.
(Right now it appears as either the option to have a download this Excel form and then upload it filled out OR ask about 10,000 additional questions to get the same answers that would be in a table)
2. Ease of data reporting - if there were grids/tables, I would hope them to auto-sum/auto-calculate based on the organizations needs based on the column and row. Bonus would be if they can auto calculate a separate section for match ratio based on parameters such as what the ask is versus type of match funding provided (Cash, IN-kind, federal etc..)
I'm sure I'll have more along the way, but I'm happy to sidebar or participate on any think-tank type groups if needed.
Karli Moore commented
It would be best in my work if the table could translate cell for cell to an Excel file. I want to be able to add by rows and columns.
Isabel Eljaiek commented
This is the biggest hurdle we face in asking for data on our applications. To get demographic %s for multiple groups within groups is confusing for applicants and a nightmare to pull out into a report.
Great need for these as well as learning/sharing sessions on data management and using data to make decisions.
Julie Wright commented
This is a place where we happen to be stuck right now in the design of a new follow up form. We want to collect ZIP Codes served and number of patients in each ZIP code. If you have a work around for this (rather than a REALLY long f/u form) we'd appreciate it. Will X-post in Compass.
Sara Cryan commented
Building on to this idea. It would be nice if there were a bullet points question type so that applicants could complete a list that's much easier for our reviewers to read vs a large text area. There are a lot of text area questions we ask that would make it much easier to read if it was bullet points such as listing the additional scholarships/grants/funding that applicants are receiving, leadership activities, work experience, college schedule, etc.
We include instructions on how to give this information, but any way to make answers more streamlined for our reviewers is a win because then they can compare apples to apples vs apples to oranges.
Ariana Diaz De Leon commented
I would like to second Gina's comment. This feature would help resolve our problems with collecting demographic information.
Gina Kelly commented
This would be really helpful when collecting demographic information too!
The use of tables in scholarship applications would be MOST welcomed—the activities sections in scholarship applications become very cumbersome with the current limiting layout.
I agree, this is a significant deficit in my opinion.