重新上传数据与DataShuttle
亲爱的!
我想创建一个工具，使用数据穿梭。基本想法是要求用户上传附件(通过表单)，这将触发数据穿梭，附件中的信息将转到过渡表，从那里它将自动移动到目标表。它工作得很好，但是，我需要考虑他们想要更正以前上传的数据的可能性。在理想的情况下，我会在表单中添加一个复选框，上面写着“重新加载?”，如果用户勾选了这个复选框，就会触发一个机制，删除以前上传的数据(可能基于一个通用标识符和复选框的值)。你知道这是否有可能实现吗?我试图插入复选框，但它没有以任何方式更新repload列(我猜是由于数据穿梭和自动化)。
基本上，我想避免从需要手动维护的目标表创建一个重复的表。
你觉得呢?
提前感谢您的帮助☺️
最佳答案
-
肯•阿姆斯特朗 ✭✭✭✭✭不客气总有一天，平台会允许这样做，但现在我们等待。如果我的回答是足够的，请把你的问题标记为回答。
肯•阿姆斯特朗
Carelon医疗福利管理高级系统分析师
认证Smartsheet管理员
要坚定!是公平的!是友好的!诚实! !
答案
-
肯•阿姆斯特朗 ✭✭✭✭✭
我不相信这在这个时候是可能的。我所做的重新运行数据是一个重新运行复选框，但我必须手动进入并删除最后一个附件和重新运行。
肯•阿姆斯特朗
Carelon医疗福利管理高级系统分析师
认证Smartsheet管理员
要坚定!是公平的!是友好的!诚实! !
-
谢谢你，肯，这正是我害怕的。
-
肯•阿姆斯特朗 ✭✭✭✭✭
不客气总有一天，平台会允许这样做，但现在我们等待。如果我的回答是足够的，请把你的问题标记为回答。
肯•阿姆斯特朗
Carelon医疗福利管理高级系统分析师
认证Smartsheet管理员
要坚定!是公平的!是友好的!诚实! !
类别
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-07T03:48:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"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-07T03:48:01+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":41,"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>
