Using inline editor on an live sheet

JacobReynolds

Is there a way that I can use the inline editor on a live data set connected to google sheets? I'm trying to edit information that I'm getting from a google sheet, but every time the data set updates the inline edits I made are overridden. Is there a way I can work around this?

ArborRose

If the source is from Google, you wouldn't be editing the google data, you would be editing the dataset in Domo that came from google. Any edits would be overwritten when the dataset is refreshed from Google Sheets.

You could create a dataflow to isolate the inline edits. That way it would not be updated by Google's refresh. But that doesn't seem like a proper solution unless you don't need the direct update.

GrantSmith

You'd need to write the changes to your dataset back to Google Sheets so the orginal source is updated. You can leverage a Google Writeback connector within a Dataflow.

ArborRose

If the source is from Google, you wouldn't be editing the google data, you would be editing the dataset in Domo that came from google. Any edits would be overwritten when the dataset is refreshed from Google Sheets.

You could create a dataflow to isolate the inline edits. That way it would not be updated by Google's refresh. But that doesn't seem like a proper solution unless you don't need the direct update.

GrantSmith

You'd need to write the changes to your dataset back to Google Sheets so the orginal source is updated. You can leverage a Google Writeback connector within a Dataflow.