Getting numbers into Airtable

🏁 Getting started.
1

Hello,

Does anyone know why when scrapping a table on a webpage, it only appear if it is from “Get Text” variable, but it is actually a number that I need, the problem is when I send the table to Airtable it does not appear.

Why is this? does anyone know what I have to do to convert the text to a number?

Screenshot 2024-09-17 at 8.10.30 PM
Screenshot 2024-09-17 at 8.10.30 PM1920×1025 121 KB

Screenshot 2024-09-17 at 8.10.40 PM
Screenshot 2024-09-17 at 8.10.40 PM2326×800 56.3 KB

Thanks !

2

Hi again,

I see your Airtable columns are of a Number format and that would require values to be sent as numbers (scraper sends them as text).

There are options to resolve this:

  1. Change column type in Airtable:

  1. Format scraped values before sending using “Convert to number” action. You will need to add such an action for every number value:

Hope this helps!
Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community

3

Thank you very much Victoria! It worked, the other post to… it was very hard getting the correct rows and columns but I got it working.

4

Nice to hear Julio! Thank you for keeping me updated.

Have a great day.
Victoria

Customer Support - bardeen.ai
Knowledge Base https://support.bardeen.ai/hc/en-us
Explore | @bardeenai | Bardeen Community