更新请求单次使用链接
有没有人知道，如果有一种方法允许“发送更新请求”的收件人使用相同的链接不止一次更新一个特定的行?
我的组织中的安装是一天的事件，但可以跨越一整天。我可能需要现场技术人员多次签到。
今天，我向我的现场技术人员发送了一个更新请求，当他回复说他“在现场”时，链接不再有效，我必须在同一天为相同的任务创建一个新的“发送更新请求”。
我知道我可以为一个时间和日期创建和安排多个请求(例如12月17日上午9点，下午12点和下午3点)，但对于我正在跟踪的数百个安装来说，这是非常低效的。
如果可以将请求设置为在特定时间后过期，而不是单次使用，那么就可以在一天中进行多次更新，而无需设置多个请求。有一个内置的细胞历史，所以变化仍然会被版本化(而不是一个可报告的字段)，我仍然有能力看到是否有多个变化。此外，当执行更新请求时，我会收到一封电子邮件，因此我也将拥有更改的电子邮件历史记录。所以修订控制不是一个真正的问题。
谢谢,
埃里克
评论
-
特拉维斯 员工嗨，埃里克，更新请求只工作一次，因为你已经发现。如果你需要你的团队在现场更新数据，我建议他们使用我们的Android或iOS移动应用程序，这将使他们能够从几乎任何Android或iOS设备上的任何地方更新数据。然后，你可以设置通知，一旦他们做出改变，就给你发电子邮件。
-
埃里克·W。 ✭✭✭✭
嗨,特拉维斯,
谢谢你的反馈。
需要注意的是，问题不在于我的现场团队如何访问智能表单(应用程序还是电子邮件链接)。这是关于需要在一天内接收一行信息的几个更新，并且必须为此反馈设置几个“发送更新请求”通知。
与遍布全国的30多名现场技术人员共享整个表格，为错误的生产线提供了太多更新的机会。通过向技术人员提供我想要更新的具体细节，发送特定的行请求可以减轻这种风险。我只是在寻找一种更有效的方法来实现这些请求，而不必在同一天为同一行创建两个或多个请求。
谢谢,
埃里克
-
特拉维斯 员工
谢谢你的跟进。你考虑过使用报告吗?您可以为每个字段技术创建一个报告，仅显示他们需要更新的行(或行)。他们可以通过移动应用程序访问报告，并根据需要更新行。
这将需要一点时间来进行初始设置，但一旦构建完成，它就可以自我更新。例如，您可以将报表设置为仅显示分配给技术人员且已打开的行。报表将随着工作表的更新而自动更新(根据您的标准添加和删除行)。
以下是关于创建报告的信息:http://help.smartsheet.com/customer/en/portal/articles/522214-creating-reports
类别
Ok I think I got it. It's due to the times you need to combine the dates and times to get it to consider both as a whole and not individually. So you will need a helper column for your start date\/time and end date time. I titled mine as Start Date Time Helper and End Date Time Helper. If you title them the same you should be able to copy and paste formulas.<\/p>
Start Date Time Helper<\/p>
=IFERROR(VALUE(YEAR(DATEONLY([Start Date]@row)) + \"//www.santa-greenland.com/community/discussion/3792/\" + IF(MONTH(DATEONLY([Start Date]@row)) < 10, \"0\") + MONTH(DATEONLY([Start Date]@row)) + IF(DAY(DATEONLY([Start Date]@row)) < 10, \"0\") + DAY(DATEONLY([Start Date]@row)) + IF([Start Time]@row < 1000, \"0\") + [Start Time]@row), \"//www.santa-greenland.com/community/discussion/3792/\")<\/p>
End Date Time Helper <\/p>
=IFERROR(VALUE(YEAR(DATEONLY([End Date]@row)) + \"//www.santa-greenland.com/community/discussion/3792/\" + IF(MONTH(DATEONLY([End Date]@row)) < 10, \"0\") + MONTH(DATEONLY([End Date]@row)) + IF(DAY(DATEONLY([End Date]@row)) < 10, \"0\") + DAY(DATEONLY([End Date]@row)) + IF([End Time]@row < 1000, \"0\") + [End Time]@row), \"//www.santa-greenland.com/community/discussion/3792/\")<\/p>
Formula to get your Yes\/No's<\/p>
=IF(COUNTIFS(SAP:SAP, SAP@row, [End Date Time Helper]:[End Date Time Helper], @cell >= [Start Date Time Helper]@row, [Start Date Time Helper]:[Start Date Time Helper], @cell <= [End Date Time Helper]@row) > 1, \"No\", \"Yes\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106584,"type":"question","name":"Index Match, how to recognize multiple values?","excerpt":"Hello, I have an issue with my index match formula. I want to locate the facility for a serial number. This works perfectly when there is only one value inside. However to reduce the amount of columns and options on the corresponding form, I changed it to one column that has multiple values. The formula is having…","categoryID":322,"dateInserted":"2023-06-18T21:21:35+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162488,"lastUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":29,"score":null,"hot":3374265958,"url":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","format":"Rich","lastPost":{"discussionID":106584,"commentID":381112,"name":"Re: Index Match, how to recognize multiple values?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381112#Comment_381112","dateInserted":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NDLYM9DFIQOI\/f1-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"f1.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T02:22:26+00:00","dateAnswered":"2023-06-19T02:12:19+00:00","acceptedAnswers":[{"commentID":381111,"body":"
