Forum Documentation Showcase Pricing Learn more

Dynamically display text from Database on Specific Days of the Week

Hello everyone,

I’m fairly new to Bubble so I apologize if this question has been answered somewhere, but I have been dealing with this question for almost 2 weeks to no clear avail.

So, I have a Repeating Group that contains text that is currently dynamically displaying text from my data. However, I want the dynamic data to change every Monday, Wednesday, and Friday, with each respective day displaying specific text from my data.

Then I would need it to display different text from my data the following MWF, so on and so forth. I’m guessing I need to use Conditional Formatting but I can’t figure out how to accomplish this for specific days of the week and changing information over weekly schedules.

Help would be greatly appreciated!!

1 Like

Without providing a screenshot of your data table(s) structure, and giving specific examples, you are not supplying enough information to allow others to help.

Screen Shot 2020-03-26 at 4.04.06 PM

Screen Shot 2020-03-26 at 4.04.18 PM

So the data structure is pretty simple. I have the tip that will be dynamically displaying in my text box with the corresponding date on which I would like it to be displayed.

I just need to be able to connect this to show in one text box (without creating text box for each tip) to display with the corresponding date.

I have the Editor and Conditional format for what I have now. I’m just not sure it’s right

Hope this clarifies

How about a conditional

WHEN: Do a search for Tip + Date (conditional date=current date): count > 0

TEXT: Do a search for Tip + Date (conditional date=current date)’s Tip

I’m not sure how to handle the date format issue to ignore the time. Perhaps someone else better at dates might chip in now.

Let me know if that works. It’s headed in the right direction I think but I’m on phone so can’t experiment.

Hm, I think that might work. So, ultimately:

WHEN: Do search for Tip + Date, Sort by Dates: item #2’s Date: formatted as 3/26/20 is Current date/time: formatted as 3/26/20
TEXT: Do search for Tip + Date’s Tip: item #2

We’ll see if it works…

You do not need to refer to specific item #. Do a Search for’s conditionals could be set up to search for any records with today’s date. If the count is more than zero, meaning it found one (or more than one) match, then you display the result (s) of that same search in your text. Does that make sense?

Of course, I know you will likely have an issue with the times not matching because Bubbles dates are date+time and without my laptop I can’t experiment. Reach out again if you get stuck and I’ll try tomorrow.

So I tried doing it without the item #s and what happens is that both tips show up simultaneously in the text box, which I don’t want to do.

How are both tips showing up. Have they both got a date that equals the current date?

Show me the text conditional as you did above. Also show me the conditions you have on the Do a Search. The popup box that displays alongside your text properties box.

@coaching it’s late here. I’m finished for today if you post the screen grabs, including the conditional for each Do a Search then I’ll look first thing in the morning if you haven’t sorted it between now and then.

So, IF I followed your instructions correctly (which I’m not positive I did) and the dates in the Data are different (as pictured earlier) this is what my condition was that showed both tips simultaneously

The condition I tried with the item #s is as follows:
Screen Shot 2020-03-26 at 6.45.29 PM

Let me know if you see anything I did wrong. Thanks for your help!

Do you see the +Add constraint button. Press that and put the date check in there instead. That’s where I’m not sure about date handling but see what you can do. That will return a list that only matches your date constraint of today I.e. zero out more items. So the dynamic text could be the Do a Search with the today constraint and it will be blank if there is no matching records and will show the tip(s) if it finds any.

Hm, okay! That makes sense, thanks!