Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of sessions at a time fo a specific client (they report name, and any relevant session dates) using a webform. I was then going to DataMesh the reports back into the Main tracker, but I am hitting a snag. When a coach submits a second report for the same client, (to update subsequent sessions) Datamesh can't handle the duplicate entry (keyed off client email id) and no further updates are carried across.
I need to find a way to accumulate multiple entries from a webform into a single line in another smartsheet.
What ideas do you have?