Power Platform Community Forum Thread Details

Date and number formatting issue in Cognito Forms & Google Sheets Integration

Hi everyone,

I created a flow that records in a Google Sheets sheet each new input from a Cognito Forms form.

I am having problems with the formatting of fields such as "Date" and another field which is numeric. When registering in Google Sheets these fields come out with a single quotation mark at the beginning, which makes Google Sheets not recognize it neither as date nor as numbers.

This is how the data is in the Cognito forms:

This is how they are registered once the flow is activated in Google Sheets:

To the date field add that quotation mark:

and to the numeric fields as well:

Once I remove the single quotation mark manually in Google Sheets it already recognizes those fields as date and numbers, however I want them to be registered correctly from the moment they enter into the sheet 😞

If I download the data from Cognito Forms, when I open in excel it recognizes them correctly as date and numbers.

I hope there is a solution for this. I tried to use the formatting option but it generates an error.

Thks:S

Quick Links

Leaderboard