DataMesh Settings

Leslie Murray

Hi All - Reposting, as it's showing that this was answered (but it was my own comment)

Q1. Can I set-up Data Mesh to copy over data one time?

Below is the settings that I think are correct, but unsure. I want the target to get the info from the source at the start, then the target will get updated manually. I don't want Data Mesh to override the data(Attached image below, hopefully)

Q2. (unrelated) Can I set-up Data Mesh to send data when there is no look-up value match? My source is one event, and my target is all events. I can't seem to trigger it when there is no match to create a new row in the target. Are you supposed to do this through Data Shuttle?

• 
  
• Thanks!

Genevieve P.

Hi @Leslie Murray

1. Yes! Your current configuration in overwriting data of "No" means that the workflow will only add information to blank cells one time, and won't overwrite that information the next time the workflow is run.

2. In this instance you'll want to set the Data Mapping Format to be "Copy and Add Data" so that when new rows are added to the source sheet they're added to the target sheet as well.

See: Smartsheet DataMesh: Eliminate typos, avoid duplicative data entry, and more

Cheers!

Genevieve

Leslie Murray

Thank you!! Appreciate the help, @Genevieve P.