Question

IMPORT EXCEL INTO CASPIO - DIDGIT PROBLEM !

  • 18 April 2023
  • 3 replies
  • 19 views

Hi ! I have a zap who transfert data of a row from an excel worksheet to a table in caspio. My problem is the number with comma in excel don't transfert correctly. Example: 3,5 in excel become 35 in caspio table.

Someone can help me ?

 

Thanks in advance

Sebastien


3 replies

Userlevel 7
Badge +6

Hey there @SEBASTIEN_JOSEPH,

Welcome to the Community! 🎉

Before we dig deeper into this, could you please a detailed screenshot with how your Zap is configured? Please don’t include/blur out any personal information in the screenshot.

Thanks! 😊

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

THIS IS MY ZAP

 

AND WATCH HOW IT FINISHES IN MY CASPIO TABLE:

 

Userlevel 7
Badge +9

Hey there, @SEBASTIEN_JOSEPH! Thanks for reaching out in community. 🤗

Hmm, I wonder if it has something to do with the number format being used in the Excel sheet? Here’s a similar question that uses a Formatter step as a possible solution:

Do you think that could work? Let us know! 

Reply