Using a macro to update a value in Google Sheet Input
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello there, hoping someone can assist.
I'm attempting to create a macro which will process the end user's data input according to requirements specified in a google sheet. I have the processing part of the macro functioning, however, I'm having trouble updating the value of the Google spreadsheet (NOT the sheet/tab name but the name of the Google Sheet). I'm not given an error, but the macro will only reference the requirements in the default spreadsheet. Below is a screenshot of my workflow. Any ideas?
Thanks,
Kaitlyn
Solved! Go to Solution.
- Labels:
- Connectors
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello KS,
I believe that the issue is due to Google having multiple parameters that correspond to a Google Sheets Workbook. There is both a Workbook ID and a Workbook name that need to be updated simultaneously.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! Adding an action to update the workbook ID fixed the issue I was seeing. However, now I'm encountering another issue. Each time I re-point this macro to a different Google Sheet, there is a CrossTab tool which looses it's configuration and as a result is causing the macro to error out. Is this an issue commonly seen in macros/is there a solution? The data being run through this tool is different each time, but follows the same format (same set of standardized fields).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The crosstab tool unfortunately does not take in dynamic or unknown fields the way many other tools do. You can potentially get around this by doing a dynamic rename to whichever fields you bring in from google sheets so that the fields will always have the same names going into the crosstab.
