Binding GoogleSheet-data

Hi,

I want (for my first - experimental - project) bind a simple GoogleSheet to my Weweb-project.
No problem to bind, but it seems that the field-types are “converted” as string, even if they are formatted in the Google Sheet as dates or numbers.

Also, when I tried to add a date-element to my Weweb-section, I can’t display it in the correct European format as Weweb thinks the first element is the month and the second the date (in my Google Sheet - record 2 has date 8-4-2025 which means 8th of April 2025, not 4th of August !!
(I changed the format in Weweb (see at the right DD/MM/YYYY))

So my questions:

  • how to change field types in Weweb to math Google Sheet-data
  • how let Weweb ‘read’ dates as European dates, not as English dates
  • how to set the language to Dutch, so I can get “maandag” in mstead of ‘Monday’ and “maart” instead of ‘March’

I’m still learning how to use Weweb, but can someone give me some little help if I want users give the possibility to change (edit) one of my fields. Like changing number value in one record from 77 to 99.

Thanks!

Hi @WimDC :waving_hand:

Here’s a short video covering your use case to format dates in Dutch :slight_smile: Date Formatting 📅

I hope it helps!

Regarding giving users of you app the possibility to edit the values of a field, you won’t have that option in WeWeb if you’re using Google Sheets as a data source. Our GS plugin is read-only.

If you’d still like to give WeWeb a try but don’t want to look at more technical data sources like Xano or Supabase for now, I’d recommend testing with Airtable :slight_smile:

Hi Joyce,

Thanks for the video and mentioning the limits of the GS-plugin.

I want to switch from Glide to Weweb, so my current datasources are all GS with a lot of spreadsheet-formulas.

I saw Baserow as an Airtable alternative (also with spreadsheet-like formulas) because Airtable has a limit of 1000 records in their free plan.
Or NocoDB.

(How) Can I use Baserow and NocoDB with Weweb (read/write/add)? Where can I find more help?

Wim

Hi @WimDC :waving_hand:

Yes, you can.

We don’t have native integrations with Baserow and NocoDB yet but I can put you in touch with a WeWeb user who has a lot of experience building apps with WeWeb and Baserow. He’ll be able to point you in the right direction when it comes to setting things up securely :slight_smile:

I’ll send you his email address in a DM.

Hi @Joyce ,

Is it possible to use more than one Airtable-database in one WeWeb-project and can multiple Airtable-databases “linked” together with lookup-function or queries in their free plan?

Hi @WimDC :waving_hand:

I don’t know about Airtable’s pricing but it is possible to work with multiple airtable databases in a single weweb project. It is also possible to fetch data that is in a lookup in airtable or to use lookup formulas in weweb directly to lookup data that are in different Airtable tables.

I would recommend watching this mini-course to learn the basics of a weweb / airtable combo: https://academy.weweb.io/build-with-airtable/

Hi @Joyce ,
I’m now using Airtable as datasource for my first Weweb-project where one of the fields is a date-field.
But when fetching this field (and other fields) in Weweb, it is “converted” as a string.
So it’s not possible to filter the records as I want only those records with a date >= today.
(Weweb only gives me conditions for strings, like “contains”, “starts with”, …)

What am I doing wrong?