186. Notice of Data Format Changes for Google Sheets Integration 2025.01.23 08:29:21

Notice of Data Format Changes for Google Sheets Integration

Hello,

When integrating with Google Sheets, there were occasional instances where response data in numeric form was transmitted in a date format. This was due to Google Sheets' built-in functionality, which automatically applies what it determines to be the most appropriate format when a number is entered. However, this feature sometimes mistakenly identified non-date numbers as dates, applying a date format and causing unintended formatting issues that made it difficult to work with the data.

To address this, we have updated the system so that all data is transmitted to Google Sheets in "text" format. This ensures that the data is sent exactly as entered, without unexpected formatting issues. However, please note that this may result in a difference in format between data transmitted before and after today’s hotfix. If you need to adjust the format, you can do so by selecting the column header, choosing the entire column, and navigating to the "Format" menu to apply your desired format. Although this may be slightly inconvenient, it will ensure that all data within the column is uniformly formatted.

This measure was implemented immediately without prior notice to fully resolve the rare issue of data being transmitted in an unintended format. We appreciate your understanding regarding this matter.

Thank you,

Moaform Team.