selecting multiple values in dropdown using url query string
![Hilbert Kok](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi I'm trying to get multiple values into a form using url query string. I have created a formula.
=URL string to form? + "PBM=" + IF([PBM 5]@row; "value 1" + "&" + "PBM=" + IF([PBM 7]@row; "value 2")+ "&" + "PBM=" + IF([PBM 8]@row; "value 3"))
The form has vertical checkboxes and the column is a dropdown with multiple select.
I do not get the values to be selected, I have used different way's but no result.
any tips?
Best Answer
-
Hi thanks for your response. The IF function is only a part of the total formula. I figured out why it did not work. The destination form had remark fields filled that had different names then the column names, apparently the remarks field overrules the column names in case of a url. Cleaning out all remarks field, did the trick.
Answers
-
Hi @Hilbert Kok, I would move the 3 "IF" statements into 3 helper columns and see what values those return. Then add these together in the formula.
The IF functions also don't look correct, the logical expression in particular: IF( logical_expression, value_if_true, [value_if_false, ] )
-
Hi thanks for your response. The IF function is only a part of the total formula. I figured out why it did not work. The destination form had remark fields filled that had different names then the column names, apparently the remarks field overrules the column names in case of a url. Cleaning out all remarks field, did the trick.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives