How can use a field several times within a form?

Hi. I need to collect feedback about several programs using a form. The form should include the same questions for each program. Any ideas about workarounds that allow me to use a field several times within a form? I want users to receive one form to collect their feedback about the different programs.

Answers

  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭

    Hi,

    I am hoping I can follow this better, please bear with me. Are you looking to use the feedback to match up with a single program?

    So Program 1 would have a Feedback1 and Program 4 would have a feedback 4? If not, then the feedback would be Feedback for any program?

    If you were able to use the field on a form more than once, then it would imply that feedback is for ANY program because it would be, in theory, overwritten each time so if I commented on Program 1, the feedback would be for Program 1 until I gave feedback on Program 4 then the feedback would be overwritten by that feedback and you would lose the feedback for Program 1.

    I hope that makes sense. If it's feedback for ANY, then you should tell them to provide the program number in the feedback OR a set of checkboxes to indicate which program(s) the feedback covers. If not, then you would want a feedback field for each program and you would not need to use the same field in the form.

    A shorter answer is that you cannot use the same field more than once on a form but I feel there is more to your request that is able to be accomplished. Please let me know your thoughts and we can try to explore more.

    Thank you,

    Kevin

    Happy to help if I can.

    ☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an(Accepted Answer)

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi@User251

    我希望你逢l and safe!

    Here's a possible workaround or workarounds

    • I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.
    • Using Form Logic to show the different programs.

    Would any of those options work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    了我的帖子(s)帮助或回答你吗r question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Kevin Smith
    Kevin Smith ✭✭✭✭✭✭

    This is a great idea!

    Thank you,

    Kevin

    Happy to help if I can.

    ☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an(Accepted Answer)

  • User251
    User251
    edited 05/10/22

    Thanks,@Kevin Smithand@Andrée Starå, for the valuable feedback.

    The explanation that Kevin provided is logical, and that I why I wondered whether there is a workaround that could avoid writing off answers. Survey applications such as Qualtrics and SurveyMonkey offer the possibility of asking the same questions under different sections in a survey. Here is the structure that I need in my form :

    Program 1

    • Question 1
    • Question 2
    • Question 3

    Program 2

    • Question 1
    • Question 2
    • Question 3

    Many of the respondents are responsible for a minimum of 5 programs, so I want to void sending them several forms with the same questions.

    Conditional Logic will only display a set of different questions for each program.

    @Andrée Starå, can you please share the solution you developed with me?

  • User251
    User251
    edited 05/11/22

    Hi@Andrée Staråwill the solution you suggested using the two forms work in my case? If yes, how do I implement it?

Yes below the Trigger when creating a workflow there is the option to add a condition you would just need to set up your conditions. Once you choose one condition it gives you the option for otherwise to create your next condition.<\/p>

You would need a helper column to indicate if the amount is greater than or less than to indicate in the conditions as the workflow doesn't allow the use of formulas.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105686,"type":"question","name":"Error with smartsheet","excerpt":"Hi we have a recruitment tracker and we have received an error - I need this urgently for a meeting today - can anyone help?","categoryID":321,"dateInserted":"2023-05-25T13:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T14:06:54+00:00","insertUserID":161789,"insertUser":{"userID":161789,"name":"Alison Kay","url":"https:\/\/community.smartsheet.com\/profile\/Alison%20Kay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-25T14:13:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-25T16:54:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3370047618,"url":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105686\/error-with-smartsheet","format":"Rich","lastPost":{"discussionID":105686,"commentID":377557,"name":"Re: Error with smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377557#Comment_377557","dateInserted":"2023-05-25T14:06:54+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-05-25T16:54:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/N0JZB9RNZYI5\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T14:14:13+00:00","dateAnswered":"2023-05-25T14:02:15+00:00","acceptedAnswers":[{"commentID":377555,"body":"

@Alison Kay<\/a> that's a Smartsheet error. Keep an eye on https:\/\/status.smartsheet.com\/<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":105663,"type":"question","name":"New Attachments Preview Window?","excerpt":"Did they just change the attachments window yesterday and how it previews an attachment? I cannot for the life of me find a way to quickly print attachments from SmartSheet like I used to do without downloading the file so that I can get a print option from whichever default program opens it up. @Genevieve P. Where am I…","categoryID":321,"dateInserted":"2023-05-24T18:38:14+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T16:01:47+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2swDSBf8UVqLz0TNb7O4SvBO4L_SdaeBQp4xqD=s96-c","dateLastActive":"2023-05-25T15:59:45+00:00","banned":0,"punished":0,"private":true,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2swDSBf8UVqLz0TNb7O4SvBO4L_SdaeBQp4xqD=s96-c","dateLastActive":"2023-05-25T15:59:45+00:00","banned":0,"punished":0,"private":true,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":93,"score":null,"hot":3369990601,"url":"https:\/\/community.smartsheet.com\/discussion\/105663\/new-attachments-preview-window","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105663\/new-attachments-preview-window","format":"Rich","lastPost":{"discussionID":105663,"commentID":377601,"name":"Re: New Attachments Preview Window?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377601#Comment_377601","dateInserted":"2023-05-25T16:01:47+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu2swDSBf8UVqLz0TNb7O4SvBO4L_SdaeBQp4xqD=s96-c","dateLastActive":"2023-05-25T15:59:45+00:00","banned":0,"punished":0,"private":true,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/38CA8TIKSLZ7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-25T00:09:21+00:00","dateAnswered":"2023-05-25T00:02:08+00:00","acceptedAnswers":[{"commentID":377492,"body":"

Tech Support says this is a new feature just rolled out yesterday.<\/p>

It wasn't part of the Early Adopter program or I would have suggested they add a Print button which is missing from the preview window.<\/p>

The tech support guy said he's receiving calls on this. I just cannot imagine the thinking of their programmers not to have a print button there that is easily accessible.<\/p>

This is like the Data Shuttle drop downs not being automatically sorted alphabetically. These are features which it doesn't take a lot of thinking will be needed in the functionality they're building. Why aren't these very basic things being thought of before they're implemented?<\/p>"},{"commentID":377527,"body":"

Hey @Mike TV<\/a> <\/p>

This was a new release that came out this week, yes! Here's the Community Announcement <\/a>on it. <\/p>

It was released in two stages: the initial new preview window (as in your first image) with a fast-follow of adding in the \"Open in a new Tab\" selection (as in Jason's first response). <\/p>

Jason's suggestion of opening it in a new window from the main panel is what I would recommend as well:<\/p>

\n \n https:\/\/community.smartsheet.com\/discussion\/comment\/377491#Comment_377491\n <\/a>\n<\/div>\n

Note that you can also use keyboard shortcuts to open in a new tab: Ctrl+Click<\/strong> (Windows) or CMD+Click<\/strong> (Mac)<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet