Using inline editor on an live sheet

Options
JacobReynolds
JacobReynolds Domo Employee

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?

Best Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**