Join the Webstudio community

Updated 2 months ago

Baserow Question

At a glance

The post is a question about Baserow, and community members are providing suggestions to address the issue. The suggestions include:

1. Creating a boolean field to track if a record is published or not, potentially using a function based on the current date in Baserow.

2. Passing a filtered URL as an API endpoint to Webstudio to only pick up published items.

3. Binding the status code (maybe a redirect) using a conditional statement in Webstudio.

4. Using tools like n8n or make.com as a last resort if the other options are not viable.

One community member also suggests saving the data in Google Sheets and using Google Apps Script to send a row to the Baserow table daily.

There is no explicitly marked answer in the comments.

this is baserow question, but if anyone know here, can answer thanks.
Attachment
image.png
J
r
3 comments
You could create a boolean if it's published or not. (You might even be able to do as a function based on the current date in Baserow - you'll need to confirm, as it's a theory). Something like: IF(date_column = TODAY(), TRUE, FALSE)

I know a little about Baserow, but not a ton. You might be able to pass a filtered URL as your API endpoint to Webstudio, which will only pick up the published items.

If not, I'd try something else like:
I'd bind the status code (maybe redirect) using a conditional statement in WS.

My last attempt would be using something like n8n or make.com if the other options are viable.
Attachment
CleanShot_2025-03-05_at_14.35.212x.png
About Today()
It will give a new date every day. On that specific day those links will be live, once that day is over and new day comes, yesterdays Link will be unpublished and new day link will live.


I will check other options you suggesting about filtered URLs.



N8n or make is last option when nothing is working I'll have to go to n8n or make.

I have other option for n8n

I'll save all data in google sheets and with App Script daily triggers I will send one row everyday to baserow table.
Maybe a condition where you test to see if the day is today or previous.
Add a reply
Sign up and join the conversation on Discord