I integrated launch27.com to monday.com using zapier however the problem is launch27.com is returning the price data in text format example $17500.00 therefore in the monday.com there is no column to accept this data except the text type column but i don’t want to insert data in text field because I want to apply the some formula on price number colum.
Same issue with date and location column. In date column zapier API adding data in the exact same format (i.e May 20, 2021) but still monday.com doesn’t accept this and getting an error - invalid value as shown in this screenshot.
Third strange point is the platform doesn’t accept data in location field. At-least this should accept text data as there is no format for location column to accept data.
Can anyone please give me some guidance in how to sort it out?