Have a schedule auto sync to the event taking place at the current time

Ask for Help
1

I have a schedule in my app that lists items chronologically. My organization has another schedule app we’ve used that will synchronize the schedule when you open it to show the current event at the top of the screen, with the preceding events above (off the screen) and following events below. Basically, it moves the list so you’re in the middle of it.

Is there a way to do this in Glide? Like look up the current time and then shift the table to a particular event but not hide all the ones before it?

2

I have a prototype ready, I’ll share today.

3
1 Like
4

Ahh I happened to see that focus setting earlier today and wondered what it was for. Thanks for the info and video!

1 Like
5

I applied this solution and ran into an issue.

I use a table to compute whether or not a particular event is the current event taking place. (This is done by subtracting the current time from the start time, subtracting the current time from the end time, and multiplying the two together; if the result is <0 then it means the event is taking place right now.)

After doing this, I’m unable to link the input text form element to the “Focus?” column because Glide doesn’t allow that. What can I do to get around this?

EDIT: Nevermind! I figured it out. I needed to have the field pull in a value from one field but set Visibility from the “Focus?” column.

1 Like
6

That’s a bit of a roundabout way to do it. A simpler approach is to use a single if-then-else column:

  • If Start Time is after Now, then null
  • If End Time is before Now, then null
  • Else true

If the if-then-else column is checked, the the event is in progress.

1 Like
7

I went with the solution I have because of how the date and time information is formatted. I can certainly tidy it up and will try to do so, but for now it works.

I do not have access to a CSS option for the plan I’m on (the free plan for now, eventually upgrade to the Maker plan). So I need to find a solution to making the text input form hidden but “visible.”

8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.