I have 3 columns
names are like below
1 link
(single line text)
2 scheduled
(date with time 12hours, timezone)
3 slug
(forumula type
link and scheduled will be already filled up
with texts and dates
now I want third column to show the content from first column only when
current date and time matches with second column
how can I structure the formula,
tried but it’s giving errors
This will match if the hour is the same. Not to the minute.
However, it’s important to note that this will not update in real time in the UI. You would need to refresh in order for this formula to be executed for the current time.
IF(DATETIME_FORMAT(NOW(), 'YYYY-MM-DD HH:mm') = DATETIME_FORMAT(field('Scheduled'), 'YYYY-MM-DD HH:mm'),
field('Link'),
'')
@cwinhall thanks for understanding and making the formula.
but what happen here is if current date passes,
when scheduled date compare with NOW(some new date), older links gets disappeared.
hope you understood,
for example if your table have scheduled date 04/03/2025
if this comparision happens tomorrow, links will be automatically gone from slug.
because Scheduled Date is not equal to 05/03/2025 (tomorrow)
no problem matching with hour. I don’t want minute matching , even day matching also fine. but as we move into future date results gets reversed and links gets removed…
I’m not sure I fully udnerstand your requirement. Can you create some example data for me how you would expect it to work exactly?
Ok
I’ll send my table screenshot
Forget the first question I aksed, here is the main requirement I have.
I am using Webstudio website builder, and Baserow as backend.
One row in Baserow table is one page content in Webstudio.
Now I will add 100 row data (100 web pages data) with CSV import.
How webstudio picks content is by looking at a specific column which we given to webstudio.
In that column we mention slug(page links)
eg1. about
eg2. contact
eg3. services
webstudio will look my links column and if it found about,
it will publish the data on that row on example. com/about
similar for other two rows content will be published on
example. com/contact and example. com/services .
now I have added 100 pages in Baserow, but I want to send 1 page everyday to webstudio.
So I thought I will add links every day with date formula, but its not working.
in future if I add 1000 blog posts, one in each row, and want to add one link every day, so webstudio will pick the link everyday and show that row content as blog post in website.
how can I schedule this in baserow?
