Percent format reset while pasting with chains
Hello!
I am having a problem with my chain. This chain helps with the rollforward by coping the information of an specific range of cells of the current year and pasting it in another range of cells of the past year. The problem appears when a percentage is being pasted, the percent value resets and applies again the percentage when the chain pastes it (For Example: If my value is 18%, when the chains makes the action, the new value it will be 0.18%)
The problem is appearing when the values are being pasted, so it can exist a problem with the Workiva module "Overwrite Sheet Data"?
Thank You!
-
Hi Mounir Chebicheb de la Torre,
Luckily, there is an easy fix for this! The issue of percent formats resetting while pasting chains can be fixed by updating Platform API. In your chain command, make sure that the "Platform API" box is checked. By doing so it will respect certain properties of the spreadsheet fields. I've included an example below.Hope this helps!
0
Hi Isabel! Thanks for your fast response.
I made that change but the chain didn't run. In the Logs appears this:
Command description: Writes the data provided in the tabular data set to the region specified in the sheet.
Error: Unable to update sheet data.
Result: Error updating sheet data: No valid API token provided
0
Hmmmm. What appspot are you on? One reason might be that the connector is not correctly configured for Platform API. You can use this support article, specifically the note about Platform Overrides, for additional information. In the meantime, I'm going to connect you with support who can take a deeper look into the issue and help you from here!
0
Thank You so much Isabel!
I will investigate a little bit more about this too.
0
Comments
5 comments