Push a button every 30 minutes

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Basically I am looking for a way to write the current date and time on all record contained in a report every 30 minutes.
I know this cannot be done natively, but maybe there is a way for me to employ some external application that could help with this? I know there is a google application that could open a page on a schedule (CronTab). Maybe there's something out there that would also interact with that page?
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
  • good

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Interesting question. Can you explain the business problem you are trying to solve?
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
Hi Mark,
I'm looking to send notifications based on the current time. So I would have two fields, one would be the current date/time, that I'm looking to update every 30 minutes, and the second would be task due date/time. Then I would be able to calculate the difference between the two and send the notification if the task due date/time is within 30 minutes from the current date/time.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
One thought that i have had but never implemented is to create a sync table of your main table to a mirror table. That could include a date / time formula field with a formula of Now().

Then that would be set to update every hour,  and you would then trigger a notification when that date time field changed in the sync table  and other conditions were true like you described above

So its not 30 minutes, it is 60 minutes, but it keeps you to a native solution with no 3rd party add ons or Chron jobs which could break.
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
So would the Now() formula update each time I did the import?
Would I create the mirror table by adding the records in there via a webhook or action from the main table? In other words, each time I add a new record in the main table the action would add the same record in the main table. then every hour I would have the main table sync with the mirror table for the purpose of updating the Now() field?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
You would create a new table and specify it to be a connected table.  It will then guide you though the process to select a source (QuickBase) and then which app and which table.  You will then decide which fields to bring across in the sync.  The fields will come across as non formula fields so yes, when the Sync updates each hour the current value for Now() will be updated in the Sync table.

 It will also capture any new records in the main table and update any existing records.
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
That could work...
I'll give that a try and report back
Thanks Mark!
Photo of @lin

@lin

  • 820 Points 500 badge 2x thumb
Works like a charm.
Thanks Mark!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
Thx for testing.  I always had that thought but never had a reason to test.