How do I add a table to my application form?

The Tables feature enables organizations to include fillable tables in their application form. Organizations can upload a spreadsheet template into their application form, including common spreadsheet formulas such as SUM or COUNT. This creates a table in which applicants can enter data. As the applicants enter data, the table will automatically make calculations based on any formulas in the spreadsheet template.

Tables are useful for collecting data in a tabular format, such as a budget or inventory list. Grants organizations find these especially useful for their application process. Tables can be added to any account for an additional fee. To sign up for this feature, please contact our sales team at sales@submittable.com.

 

How to Add a Table to an Application Form

1. In your Categories page, click Add Category or click the name of an existing category for which you'd like to add a table.

2. In the Form Designer tab, drag and drop the Table field from the Toolbox onto your application form.

3. Rename the Table Label to your preferred name, such as Budget.

4. To create a spreadsheet template on a PC, you can use Microsoft Excel or Google Sheets. If you’re using a Mac, please create your spreadsheet in Google Sheets, due to a current incompatibility issue between Microsoft Excel for Mac files and the Tables feature.

5. The spreadsheet template must be in .xlsx format. For a full list of spreadsheet formulas supported in Tables, see our help article. The table will be as wide as your farthest right column that contains text or a formula (e.g. Column E in the below example), and it will be as long as the last row that contains text or a formula (e.g. Row 6 in the below example). This sample spreadsheet template for a budget contains formulas to calculate subtotals and a total:

6. Once you have created your spreadsheet, save it as a .xlsx file, such as budget.xlsx. (Note: If you’re creating the spreadsheet in Google Sheets, click on File > Download As > Microsoft Excel (.xlsx) to download a .xlsx version of your file.)

7. In the Form Designer tab of your submission category, locate your Table field and click Select a file. Choose your .xlsx file and upload it. If you’d like to use another file, click Remove file and upload another file. Click Done when you’re finished.

8. Make any other preferred changes to your application form, and click Save Category.

9. To see what your table looks like to an applicant, click the View Your Site button at the top right of any page in your Submittable account and select the appropriate category. Locate the table on your application form. As the applicant fills in your table, any formulas you entered into your spreadsheet template will automatically generate calculations.


10. To see an expanded view of the Table, click Expand. To go back to the application form, click Close.

11. After the applicant has submitted the form, you can see the applicant’s table data by clicking on the Table file in the Submission Details page for his or her application. Optionally download or print the table as you would with any attached file.



Interested in adding Tables to your organization's account? Email us at sales@submittable.com.


Organizations

  1. Getting Started With Submittable Guide
  2. How do I create or edit a submission category?
  3. New status: Completed
  4. How do I set up a submission category to sell a subscription or single issue?
  5. How do I use the Form Designer when creating or editing a category?
  6. How do I create a hidden category?
  7. How do I set up a blind review process?
  8. How do I add auto-labels for our submissions?
  9. How do I turn submission categories on and off?
  10. How do I set acceptable file types for a category?
  11. How do I add conditional logic to my submission form?
  12. How do I accept multiple files with a submission?
  13. Can I request metadata from submitters when they upload a file?
  14. How do I manually enter submissions?
  15. Can emailed submissions be automatically added to my submissions manager?
  16. How does submission scoring work?
  17. How do I review, make a note on, and rate a submission?
  18. How do we display submissions online for a public audience?
  19. How do I create a review form?
  20. Can reviewers edit finalized review forms?
  21. How do I hold a multi-round review process?
  22. How do I add a table to my application form?
  23. What spreadsheet formulas can I use in Tables?
  24. How do I add a field for internal use to my application form?
  25. Can I send additional forms to submitters to request more information?
  26. Can I schedule reminders for reviewers to review submissions or for submitters to complete additional forms?
  27. How do I use keyboard shortcuts to navigate between submissions?
  28. How do I add a private note to a submission?
  29. How do I add a Terms and Conditions checkbox to my submission form?
  30. How do I request agreement to terms and conditions when I accept a submission?
  31. What are the character limits for the Category Guidelines and Organization Profile Guidelines fields?
  32. How do I add a publication date to a submission?
  33. How do I use or remove the Calendar feature?
  34. How do I filter and organize the submissions in my submissions list?
  35. How do I label submissions?
  36. How do I assign submissions to team members for review?
  37. How do I automatically assign team members to incoming submissions for a specific category?
  38. Can I randomly assign submissions to a set number of reviewers?
  39. How many submissions are assigned to each team member and how many have they not yet reviewed?
  40. How do I attach a file to a submission?
  41. How do I replace the file on a submission?
  42. How do I send submissions to my Kindle?
  43. How do I delete a submission?
  44. How do I archive or unarchive submissions?
  45. How do I export our submission data?
  46. How do I batch export custom review data?
  47. How do I send an email to a submitter?
  48. How do I ensure new submissions get an automated response?
  49. How do I add a team member?
  50. How do I edit a team member's account?
  51. What does each team member level see?
  52. How do I customize the look and feel of my submission form?
  53. How do I upgrade or downgrade my Submittable subscription?
  54. What is an inactive plan?
  55. How do I sync the Calendar with other calendars?
  56. How do I change the default view displayed in the Submission Details screen?
  57. How do I cancel my Submittable account?
  58. Can I batch archive or batch delete submissions?
  59. How do I add and delete a file for a submission?
  60. How do I change the category of a submission?
  61. Can I integrate my Submittable account with Google Analytics?
  62. Does Submittable have an API?
  63. How do I use Zapier to connect my Submittable app to 3rd Party apps?
  64. How do I use the Submittable plugin on my WordPress site?
  65. How do I allow a submitter to edit a submission?
  66. How do I turn on or off the ability for submitters to request an edit on a submission?
  67. How can my organization receive reference letters?
  68. How can using Submittable increase the number of submissions our organization receives?
  69. How do I view and print submission document files?
  70. Can I charge a fee on my form?
  71. How do I sell memberships, subscriptions, or merchandise in my submission form?
  72. Can I charge submission fees in a non-US currency?
  73. What happens to my organization's account if we exceed our submission limit?
  74. Why did I get an error message when paying my invoice by credit card?
  75. Video File Transcode Error
  76. How do I unassign submissions?
  77. How do I remove a team member?
  78. How do I use response templates to send automated email messages?
  79. I have a Yahoo! or AOL email address. Why do my organization's emails come from notifications@email.submittable.com?
  80. How do I duplicate a submission category or form?
  81. How do I archive a submission category?
  82. When I do a batch file export, can I copy all files attached to the exported submissions into a single destination directory in Windows?
  83. How do I promote my organization’s creative call?

Feedback and Knowledge Base