动态下拉
有人知道下拉菜单中的选项是否可以链接到表吗?
我有一个表单，用户可以从下拉列表中选择一个“提供者”。该提供程序与帮助填充该工作表中的其他列的vlookup相关联。但是，“提供者”列表是动态的，并且在向数据库添加新的提供者时发生变化。现在，每次发生这种情况时，我都需要复制并粘贴新列表，以便下拉列表包含新名称。有别的办法吗?
答案
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
不幸的是，这是不可能的，但这是一个很好的想法!
这里有一个或多个可能的解决方案
- 高级应用程序，数据穿梭
我最近为一个客户开发了一个解决方案，使用高级应用程序Data Shuttle来更新下拉列表。它不是实时的，但可以满足你的需要。
这是一种选择吗?
我希望这对你有帮助!
注意安全，周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成或/和作为公认的答案．这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
-
RRIOS ✭这可能行得通;然而，我不是很精通数据穿梭。我的组织确实有这个应用程序可供使用。你能帮我探索一下吗?
-
大卫Tutwiler 优等生
我还可以确认DataShuttle将用于此。我们使用它来更新表单中的许多下拉列表。安德鲁是个了不起的帮手，我相信他能帮到你们。如果他有事没空，我很乐意告诉你我们是怎么安排的。
-
dqsoutherland ✭✭✭我认为数据穿梭会起作用，Andree是一个很好的资源。他也帮我们公司安排了这一切。
-
cdt ✭
你在《数据穿梭》中是怎么做到的?
-
科尔比) ✭
对于那些想知道如何使用数据穿梭来达到这个目的的人来说，这里有一些对我有用的东西，在我用这些形式阅读的东西进行了实验之后。
您将需要创建两个自动化，一个卸载自动化和一个上传自动化:
先从卸载自动化:
- 在源步骤，首先选择包含要为其创建动态列表的列值的工作表。
- 然后在目标步骤，选择"内容附件”然后是与第一步相同的工作表。选择您想要的标题名称，并选择CSV(如果您愿意，可以包括标题，您只需要记住它们存在于文件中)。
- 在下一步中，应用过滤器如果需要的话。我只是让这个字段空着。
- 在映射节中，除了用于填充Dynamic Dropdown的列外，我删除了所有列。
- 时间表将自动化设置为尽可能频繁地运行，这将决定当新数据进入时，您的下拉菜单更新的频率。最后,名字你的自动化。
现在我们来看上传自动化:
- 从“源位置”作为“内容附件”,选择在上面的卸载自动化步骤中使用的相同文件。根据“选择附件”最近的“．如果保留标题，请选中表示这样的框(数据仍从第一行开始)。如果在卸载步骤中选择CSV，则分隔符将为逗号。
- 在目标部分，选择您希望在其中添加动态下拉菜单的智能表。然后选择“更新所选列的下拉选项”
- 添加过滤器如果需要的话。
- 在映射步骤，将包含所需下拉选项的列映射到Target destinations下拉列。
- 在下一节中，选择在附件上运行
- 添加一个表达式如果需要。
- 名字你的自动化和测试一下！在卸载自动化发生之前，上传自动化不会运行，因此您可能希望手动运行一次以进行测试。
-
特雷弗·布朗 ✭
感谢您提供以上信息。你知道是否有一种方法在卸载(或上传阶段)排序数据?例如，我正在卸载的单列和上传作为下拉菜单是在一个文件中，以不同的方式排序，便于使用
-
约阿希姆Mund ✭✭✭✭✭✭
你也可以通过使用smartsheet API来做到这一点，例如使用Google apps脚本。
该脚本可以每分钟触发一次，这将更新下拉列表。
类别
She will be shared to whatever workspaces the group has at the same permission level as the group.<\/p>
<\/p>
It also works in the opposite direction. If someone has access to a Smartsheet item through a group then they will no longer have access to that item if they are removed from the group unless they are shared as an individual back to the item.<\/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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106011,"type":"question","name":"Why do I get a #Incorrect argument set error with the formula below\/","excerpt":"=IF(Status@row = \"Not Started\", \"Blue\", IF(OR(AND(TODAY()>[End Date]@row, Status@row = \"Not Started\"), AND(TODAY()>[End Date]@row, Status@row = \"In Progress\")), \"Red\", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = \"Not Started\"), AND(TODAY(-5)>[End Date]@row, Status@row = \"In Progress\")), \"Yellow\", IF(Status@row =…","categoryID":321,"dateInserted":"2023-06-05T15:02:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T15:26:32+00:00","insertUserID":159166,"insertUser":{"userID":159166,"name":"Carole M.","url":"https:\/\/community.smartsheet.com\/profile\/Carole%20M.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T17:00:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T01:11:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":42,"score":null,"hot":3371957940,"url":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106011\/why-do-i-get-a-incorrect-argument-set-error-with-the-formula-below","format":"Rich","lastPost":{"discussionID":106011,"commentID":378815,"name":"Re: Why do I get a #Incorrect argument set error with the formula below\/","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378815#Comment_378815","dateInserted":"2023-06-05T15:26:32+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-07T01:11:58+00:00","banned":0,"punished":0,"private":false,"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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-05T15:22:11+00:00","dateAnswered":"2023-06-05T15:14:09+00:00","acceptedAnswers":[{"commentID":378809,"body":"
14 opening parentheses, 15 closing parentheses.<\/p>"},{"commentID":378815,"body":"
It's an easy mistake to make. Glad I could help.<\/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":105939,"type":"question","name":"Admin Centre - multiple admins","excerpt":"Allow more than one user the ability to administer the admin centre. It is common for enterprise clients to have more than one administrator, therefore this creates bottlenecks in user management tasks, if that one user is busy or on annual leave.","categoryID":321,"dateInserted":"2023-06-02T10:50:44+00:00","dateUpdated":"2023-06-06T09:42:35+00:00","dateLastComment":"2023-06-06T09:48:22+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":139581,"lastUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":39,"score":1,"hot":3371750646,"url":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105939\/admin-centre-multiple-admins","format":"Rich","lastPost":{"discussionID":105939,"commentID":378949,"name":"Re: Admin Centre - multiple admins","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378949#Comment_378949","dateInserted":"2023-06-06T09:48:22+00:00","insertUserID":139581,"insertUser":{"userID":139581,"name":"darkmatter","url":"https:\/\/community.smartsheet.com\/profile\/darkmatter","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XHPS3zzuBP4!m3DRfwiLWvQ!vLAErbBT_f5","dateLastActive":"2023-06-06T09:47:38+00:00","banned":0,"punished":0,"private":false,"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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T09:47:55+00:00","dateAnswered":"2023-06-06T09:42:13+00:00","acceptedAnswers":[{"commentID":378948,"body":"
Hi @darkmatter<\/a> <\/p> Thank you for clarifying! It sounds like you request has to do with Group Admins (versus System Admins).<\/p> Please feel free to add your comment and vote to this other Idea post on the same topic: Multiple Owners to add users to Smartsheet Groups<\/a><\/p>
![https:\/\/us.v-cdn.net\/6031209\/uploads\/I0YY2Y23M2BP\/dynamic-dropdown.png<\/a><\/p>","bodyRaw":"[{\"insert\":\"Does anyone know if the options in a drop-down can be linked to a table?\\nI have a sheet that users can pick a \\\"provider\\\" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the \\\"provider\\\" list is dynamic and changes when a new provider is added to the database. Right now, everytime that happens, I need to copy and paste the new list so that the drop-down contains the new name(s). Is there any way around that?\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/I0YY2Y23M2BP\\\/dynamic-dropdown.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/I0YY2Y23M2BP\\\/dynamic-dropdown.png\"}},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2022-03-20T05:53:39+00:00","insertUser":{"userID":140333,"name":"RRIOS","url":"https:\/\/community.smartsheet.com\/profile\/RRIOS","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-04-18T22:08:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/89189\/dynamic-drop-down","embedType":"quote","name":"Dynamic Drop-Down"}">](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/I0YY2Y23M2BP\/dynamic-dropdown.png\"){kind=link}