Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Automatically Publish Data from a Connected Sheet

Answered
Request Demo

Hi there.  We have a spreadsheet that is auto-populated via a chain ("Overwrite Sheet" command) multiple times per day.  We then publish the contents of the sheet to other users as a connected sheet.  This requires us to hit the "REPUBLISH" icon each time the data on the sheet is refreshed by the chain command (See screenshot below of the icon - highlighted in yellow). 

Is there a way to set this up so that each time the sheet is updated from the chain command that the sheet is then republished automatically, so we don't have to keep hitting this button?  

There is a chain command called "Publish Spreadsheet" but this doesn't seem to work. Thanks for any help. 

 

0

Comments

1 comment

Date Votes
  • Jeff Hickey

    Hi Bradley, Data Sets cannot be republished via the Spreadsheet API. Alternatively, a Chain could pull the data from BALANCE_SHEET and then overwrite other sheets with that data. Or cells could be linked to propagate data where needed.

    The Publish Spreadsheet command is used to publish links.

    0

Please sign in to leave a comment.