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))
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.
Here’s a short video covering your use case to format dates in Dutch 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
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?
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
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?
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.
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”, …)