Hi, I have a set of tasks in a table in Glide. I used Glide tables for speed, but am wondering whether I should have used Google Sheets now… Let’s say I have 20 tasks, and 5 of them are marked as “Recurring” using a checkbox when they are added. These will get completed during the day, but I would…

What I would do is get rid of the Completed boolean column, and replace it with an if-then-else column, configured along the lines that Jeff suggested. That is: If Last Completed is within Today, then true If Last Completed is empty, then null If Recurring is not checked, then true Here is how th…

I think you can apply a bit of Glide computed column logic here. Try the following: In your Tasks table, add a Date/time column. Use this column to record the last time a task was completed. So when a user completes a task, use an action to set that column to the current date/time Add an if-then-e…

Hi Darren, Thanks for your input. I managed to create the column that records the date/time when a task is completed. I can get the If/Then/Else to detect whether that column is “within” “today” and return a True/False. I am struggling with how to also check for the Recurring status being checked…

What exactly isn’t working with @Darren_Murphy ’s solution? You can add multiple checks within an IF column. Can you show a screenshot of the IF column configuration? The way I’m understanding, it should work. If the task was completed today then it’s a completed task, so the status should be com…

[image] Darren_Murphy: – If Last Completed is within today, then Task Status – If Recurring is not checked, then Task Status Just revisiting this, I think we need one more condition added to the IF column to account for empty task dates. – If Last Completed is within today, then true – If …

I was working on the assumption that there is an existing boolean column that indicates task status, so I used that in the if-then-else logic. So instead of returning true/false, my logic returns the state of that column (or not). It seems to work… :thinking: [CleanShot 2023-04-26 at 09.37.08@2x] …

Hi Jeff and Darren, Thanks for assisting me. I am new to Glide and still trying to get my head round how some of the functions work. Maybe it would be clearer if I give you a specific example of what I am trying to achieve. [image] If you can imagine we are looking at this as at 26 April 2023, …

Hi Darren, Thanks, I think this works now. I am implementing it on my app and will see for sure tomorrow when hopefully my recurring task will reappear on my list as incomplete :slight_smile: I am updating my filter to use ifCompleted instead of Completed and will rely on the fact that the Last Co…

[image] Jonathan: Have you published any apps on Glide that you have people pay for? I am wondering whether I can use Glide for this or whether it will only be just for my prototype. I would like to charge people to use the app maybe as a subscription or a one off payment, You could publish y…

Thanks. I will consider doing that. Thanks for all your help so far :slight_smile:

Daily Query and Update on a Glide Table

Ask for Help

Darren_Murphy April 27, 2023, 12:09pm 13

You could publish your App as a template in the Glide Template store, see below:

Topic		Replies	Views
Automating Repetitive Daily Tasks on Glide Ask for Help	1	70	July 17, 2024
How to write to other tables (Not just User profile) - using list with checkbox behavior Ask for Help	9	88	July 4, 2025
Create recurring weekly events Ask for Help	14	4135	January 17, 2024
Ask about glide table math Ask for Help	20	195	February 14, 2024
User specific data using a date formula in google sheet, input in glide Ask for Help	15	579	February 15, 2023

Daily Query and Update on a Glide Table

Related topics