What new features do you want to see in Forms?

Nish
Nish

Hey!

We run a form-building service at FormCrafts (https://formcrafts.com/) and have been considering building a native integration for Smartsheet.

I'd love to get some feedback and suggestions on what people are looking for that's missing in Smartsheet forms.

Some ideas we have so far:

  1. Being able to add custom text, images, and such on the form
  2. A more powerful dropdown field - limit selections, add images to options
  3. More powerful conditional logic. Maybe use logic to send emails, trigger redirects?
  4. Restrict form access by password
  5. Use math calculations in forms
  6. Create multi-step forms
  7. Allow form to update an existing row (is this already possible?)


I'd love to hear some thoughts and suggestions.

Tags:

Comments

  • coby
    coby ✭✭✭✭

    We have a big issue that Smartsheet only allows a maximum of (8) conditional logic branches for each field. We have a complex form we are looking to implement that would need dozens of branches for each field. Going in the direction of jsonschema form on an external site that sources the schema from Smartsheet API data but would be sweet if there was an easier way.

  • skarkhoff
    skarkhoff ✭✭
    Answer ✓

    All of your ideas are great! I'd love to see something that could filter dropdown options based on a previous response, currently I have to use 2 columns and combine using a formula.

    Being able to format text and add images would be helpful as well.

    Also, being able to select calendar options for date selections (i.e. exclude weekends, or only show dates over 2 weeks out, etc.)

  • Nish
    Nish
    Answer ✓
    We have a big issue that Smartsheet only allows a maximum of (8) conditional logic branches for each field. We have a complex form we are looking to implement that would need dozens of branches for each field. Going in the direction of jsonschema form on an external site that sources the schema from Smartsheet API data but would be sweet if there was an easier way.<\/p>","bodyRaw":"[{\"insert\":\"We have a big issue that Smartsheet only allows a maximum of (8) conditional logic branches for each field. We have a complex form we are looking to implement that would need dozens of branches for each field. Going in the direction of jsonschema form on an external site that sources the schema from Smartsheet API data but would be sweet if there was an easier way.\\n\"}]","format":"rich","dateInserted":"2021-03-19T02:05:48+00:00","insertUser":{"userID":100246,"name":"coby","url":"https:\/\/community.smartsheet.com\/profile\/coby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/X1UMY0ILSAJX\/nEND6JC0UKQAO.JPG","dateLastActive":"2023-08-11T06:43:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/284159#Comment_284159","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/284159#Comment_284159

    We have no limits on the number of branches you can have for a field, or the number of fields it can affect. We have tons of users who have 50+ logic steps, each with their own set of 'actions'.

    I am curious though - why does the form require dozens of branches for each field? If you have more info I'd love to see ways it can be done more easily.

  • All of your ideas are great! I'd love to see something that could filter dropdown options based on a previous response, currently I have to use 2 columns and combine using a formula.<\/p>

    Being able to format text and add images would be helpful as well.<\/p>

    Also, being able to select calendar options for date selections (i.e. exclude weekends, or only show dates over 2 weeks out, etc.)<\/p>","bodyRaw":"[{\"insert\":\"All of your ideas are great! I'd love to see something that could filter dropdown options based on a previous response, currently I have to use 2 columns and combine using a formula.\\nBeing able to format text and add images would be helpful as well.\\nAlso, being able to select calendar options for date selections (i.e. exclude weekends, or only show dates over 2 weeks out, etc.)\\n\"}]","format":"rich","dateInserted":"2021-03-19T02:14:48+00:00","insertUser":{"userID":113191,"name":"skarkhoff","title":"","url":"https:\/\/community.smartsheet.com\/profile\/skarkhoff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-21T20:39:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/284162#Comment_284162","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/284162#Comment_284162

    We have the features that allow text and images, and the ability to customize the date field.

    We don't have a feature where you can edit the options list of a dropdown field based on a selection. Our users usually create two dropdown fields in this case and show the one with the correct option set via logic.

  • coby
    coby ✭✭✭✭
    edited 03/19/21

    Could go into more detail if you wanted to discuss further. Looking at your business model/service it looks solid, but I guess we are looking for a more malleable solution.

  • Melitta
    Melitta ✭✭✭✭

    We use forms to collect information from specific people in roles at the university. We don't have an enterprise license so - there may be some things that are precluded due to that.

    2, 3) I'd love a more powerful dropdown field and conditional logic.

    4) I'd have some questions about the restrict form access by password. I can see where that would be helpful but right now, getting everyone on board with what we're building - that people don't have to log in to use the form is important.

    6) Multi step forms? YES!

    7) And if the form could update an existing row - sounds complicated to implement but I would love that.

    Thanks

    Melitta



    1. Being able to add custom text, images, and such on the form
    2. A more powerful dropdown field - limit selections, add images to options
    3. More powerful conditional logic. Maybe use logic to send emails, trigger redirects?
    4. Restrict form access by password
    5. Use math calculations in forms
    6. Create multi-step forms
    7. Allow form to update an existing row (is this already possible?)


  • We use forms to collect information from specific people in roles at the university. We don't have an enterprise license so - there may be some things that are precluded due to that. <\/p>

    2, 3) I'd love a more powerful dropdown field and conditional logic. <\/p>

    4) I'd have some questions about the restrict form access by password. I can see where that would be helpful but right now, getting everyone on board with what we're building - that people don't have to log in to use the form is important. <\/p>

    6) Multi step forms? YES!<\/p>

    7) And if the form could update an existing row - sounds complicated to implement but I would love that. <\/p>

    Thanks<\/p>

    Melitta<\/p>

    1. Being able to add custom text, images, and such on the form<\/li>
    2. A more powerful dropdown field - limit selections, add images to options<\/li>
    3. More powerful conditional logic. Maybe use logic to send emails, trigger redirects?<\/li>
    4. Restrict form access by password<\/li>
    5. Use math calculations in forms<\/li>
    6. Create multi-step forms<\/li>
    7. Allow form to update an existing row (is this already possible?)<\/li><\/ol>","bodyRaw":"[{\"insert\":\"We use forms to collect information from specific people in roles at the university. We don't have an enterprise license so - there may be some things that are precluded due to that. \\n2, 3) I'd love a more powerful dropdown field and conditional logic. \\n4) I'd have some questions about the restrict form access by password. I can see where that would be helpful but right now, getting everyone on board with what we're building - that people don't have to log in to use the form is important. \\n6) Multi step forms? YES!\\n7) And if the form could update an existing row - sounds complicated to implement but I would love that. \\nThanks\\nMelitta\\n\\n\\nBeing able to add custom text, images, and such on the form\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"A more powerful dropdown field - limit selections, add images to options\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"More powerful conditional logic. Maybe use logic to send emails, trigger redirects?\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Restrict form access by password\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Use math calculations in forms\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Create multi-step forms\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"Allow form to update an existing row (is this already possible?)\"},{\"attributes\":{\"list\":{\"depth\":0,\"type\":\"ordered\"}},\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\\n\"}]","format":"rich","dateInserted":"2021-03-21T14:15:08+00:00","insertUser":{"userID":131821,"name":"Melitta","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Melitta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7FjR-2zeSSY!zOlQs_Tjxjo!J3yyx3hqT9S","dateLastActive":"2023-08-25T17:25:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/284376#Comment_284376","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/284376#Comment_284376

    Thanks for the feedback! And yes, of course, requiring an access code for the form would be an optional feature.

  • Could go into more detail if you wanted to discuss further. Looking at your business model\/service it looks solid, but I guess we are looking for a more malleable solution.<\/p>","bodyRaw":"[{\"insert\":\"Could go into more detail if you wanted to discuss further. Looking at your business model\\\/service it looks solid, but I guess we are looking for a more malleable solution. \\n\"}]","format":"rich","dateInserted":"2021-03-19T18:48:13+00:00","insertUser":{"userID":100246,"name":"coby","url":"https:\/\/community.smartsheet.com\/profile\/coby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/X1UMY0ILSAJX\/nEND6JC0UKQAO.JPG","dateLastActive":"2023-08-11T06:43:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/284310#Comment_284310","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/284310#Comment_284310

    Yes, I like to know more about your use-case. We are trying to make FormCrafts work with varied requirements, and it would help to know about your workflow. We can trade feedback - you can email me at nish at ncrafts dot net.

  • I have been struggling with some similar requirement re form security and came up with a solution that partly fits the bill.

    It would be great to have a true password requirement in order to access a form, to ensure that not just anyone can complete it. But, obviously, SS does not support this yet.

    Instead, do the following:

    1 - Create a sheet and corresponding form. In the sheet add a Password column (simple text) and also add that to the form as a required field.

    2 -形式,使电动汽车的展示ery other field conditional on the value of the Password column matching a specific value, by using conditional logic. Optionally, add a description to the form or field that explains what the Password is used for.

    3 - Create a copy of the sheet.

    4 - Create a rule in the original sheet to copy a record to the copy sheet if the password matches that same value.

    5 - Share the password value separately with the people who need to access the form.

    This approach will NOT stop a user from completing the form, but without the password they will not be able to fill out any fields except for password itself. That's the reason to have a copy of the sheet, so that you can use the copy to limit the records to ones where the user had the password and completed the rest of the form.

    If you have an existing sheet, then make a copy of that sheet, base the form off of the copy and when a record has the right password, copy the record to the existing sheet.

    Note that you can create different forms for different groups of users, with different passwords (and possibly different fields available to each group), and share each form link and password with each group. You can store the passwords in its a separate sheet, identifying which group of users it corresponds to (Sales, Marketing, Clients, etc.) and insert that group identifier in the sheet via VLOOKUP.

    如果一个密码太广泛共享,你可以alter the form to require a different password value and reshare that to the identified recipients.

Hi @Matthew Drake<\/a> <\/p>

There currently isn't a way to overlay an Outlook Calendar on top of a Smartsheet Calendar; you can do the reverse, publish dates from Smartsheet into Outlook.<\/a><\/p>

Please provide your feedback to the Product team through this form, here.<\/a><\/p>

Thanks,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":91824,"type":"question","name":"Dynamic View - Dropdown Lists","excerpt":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…","snippet":"I have certain single and multiple select list columns that do not have the \"restrict to dropdown values only\" checked on the source sheet but in Dynamic View we are unable to add…","categoryID":343,"dateInserted":"2022-06-06T17:24:20+00:00","dateUpdated":"2022-06-14T14:39:36+00:00","dateLastComment":"2023-08-25T19:03:11+00:00","insertUserID":113932,"insertUser":{"userID":113932,"name":"Emmy Anderson","url":"https:\/\/community.smartsheet.com\/profile\/Emmy%20Anderson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jplUI_CI3bw!8o9VN1d3-no!6TkM7ozjpN6","dateLastActive":"2023-05-04T14:55:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":156788,"lastUser":{"userID":156788,"name":"Chris Broughton","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Broughton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p0HeqRqVoXw!8_nRN9ijwLw!lUie_n6pld_","dateLastActive":"2023-08-25T18:59:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":569,"score":null,"hot":3347530651,"url":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91824\/dynamic-view-dropdown-lists","format":"Rich","tagIDs":[319],"lastPost":{"discussionID":91824,"commentID":392652,"name":"Re: Dynamic View - Dropdown Lists","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392652#Comment_392652","dateInserted":"2023-08-25T19:03:11+00:00","insertUserID":156788,"insertUser":{"userID":156788,"name":"Chris Broughton","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Broughton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p0HeqRqVoXw!8_nRN9ijwLw!lUie_n6pld_","dateLastActive":"2023-08-25T18:59:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-08T12:36:40+00:00","dateAnswered":"2022-06-06T18:38:56+00:00","acceptedAnswers":[{"commentID":332119,"body":"

Hi @Emmy Anderson<\/a> <\/p>

You are not missing anything. This is how DV works with dropdowns unfortunately. My work around in the past is to create an other option in the drop down, user chooses save. Then have logic built for a text field that appears so the user can input the values not present in dropdown. <\/p>

Hope this helps<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"}]},{"discussionID":66594,"type":"question","name":"Is there a way to use OR in a Dynamic View filter condition?","excerpt":"In a View, I can create a custom filter that selects where the Project Lead is \"Mike\" but I want to also say \"OR Debbie.\" Is that possible? It looks like I can only choose AND.","snippet":"In a View, I can create a custom filter that selects where the Project Lead is \"Mike\" but I want to also say \"OR Debbie.\" Is that possible? It looks like I can only choose AND.","categoryID":343,"dateInserted":"2020-03-09T22:27:57+00:00","dateUpdated":"2022-06-14T14:36:49+00:00","dateLastComment":"2023-08-23T08:56:50+00:00","insertUserID":34501,"insertUser":{"userID":34501,"name":"MikeChambers","url":"https:\/\/community.smartsheet.com\/profile\/MikeChambers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/CT5AV825MQ3E\/nG12D47VYRO8A.jpg","dateLastActive":"2023-03-05T01:19:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":441,"score":null,"hot":3276579287,"url":"https:\/\/community.smartsheet.com\/discussion\/66594\/is-there-a-way-to-use-or-in-a-dynamic-view-filter-condition","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66594\/is-there-a-way-to-use-or-in-a-dynamic-view-filter-condition","format":"rich","lastPost":{"discussionID":66594,"commentID":392055,"name":"Re: Is there a way to use OR in a Dynamic View filter condition?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392055#Comment_392055","dateInserted":"2023-08-23T08:56:50+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/814\/KBHVAAPJ5RYA.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"OR.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-12T17:06:46+00:00","dateAnswered":"2020-03-12T13:01:18+00:00","acceptedAnswers":[{"commentID":242817,"body":"

You are more than welcome!<\/p>

Glad to hear that it worked for your present use-case. <\/p>

Remember! <\/strong>Did my post help or answer your question or solve your problem? Please help the Community by <\/em>marking it as the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":643,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts