then I use ‘Get table sorted by’ and assign the value ‘Scrape data on active tab : Table Row .Batteriekapazität to the string “Nutzbare Batteriekapazität”.
finally I connect the ‘Get table sorted by column: Table Row .Nutzbare Batteriekapazität with the Airtable cell (#Numbers) “Nutzbare Batteriekapazität”.
After spending few additional hours to find the bug or better say a solution for my problem, I have found out, that there must be a bug in the bardeen system.
After I have found this advise, I have re-connected my airtable connection inside the playbook. But it didn´t helped me. Although I want to copy a number from a cell into a field formatted as #Number within Airtable, I always get the error: Provided data were dropped due to schema mismatch.
I then found a solution, but it is not a real solution. If I reformat the column from #Number to Single Text within AirTable and reconnect the AirTable Connection within Playbook, then it later takes over the number to be copied. But unfortunately this is not a solution, because I cannot leave the column as single text within AirTable. It must remain #Number.
Please give me some help on how to solve the problem.
After reviewing the references you shared, it appears that there was no advice given to convert text to a number. Scrapers typically extract any data as text, and conversion to number does not occur automatically. Please try using the “Convert to number” action and let us know if this resolves your issue:
It already works with some numbers, but it doesn’t work with the “Price” field yet. If I scrape price e.g. 44.800 €, then only 44 appears in Airtable.
What would I have to do to scrape the price completely, but without the € sign? I don’t need the dot either. Only the number 44800 needs to be scraped.
I have tried to apply a RegEx formula. But it only removes the € character.
