Jump to content

  •  

Photo

Script trigger on date field

date field script trigger

  • Please log in to reply
5 replies to this topic

#1 m.r.mymandms  member

m.r.mymandms
  • Members
  • 6 posts
  • FM Application:11
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Novice
  • Time Online: 3h 55m 14s

Posted 04 January 2012 - 02:51 AM

Problem. I have a date field. After "so many" days I need a reminder that it has
been "so many" days since that date was entered. I need the reminder to replay
everyday at a noon until it is turned off without deleting the date in the field.
I hope someone is willing to help me and I thank you in advance for your help.
I'm not even close to being a developer and I have to struggle through when
I have to do something like this so your patience is appreciated as well.
  • 0

#2 comment  consultant

comment
  • Members
  • 23,499 posts
  • Time Online: 299d 9h 51m 12s

Posted 04 January 2012 - 05:43 AM

You could do this by installing a OnTimer script every time you open the file - i.e. your startup script would calculate the time remaining until noon and install the reminder script to run then. The reminder script would either turn off the installation or set the interval to 24 hours, depending on user's choice(?).

It's not clear what the date represents, though. Is there only one such date in your entire file?


Note also that OnTimer scripts are installed in the current window - so you must make sure the window is not closed during routine operations.
  • 0

#3 m.r.mymandms  member

m.r.mymandms
  • Members
  • 6 posts
  • FM Application:11
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Novice
  • Time Online: 3h 55m 14s

Posted 04 January 2012 - 06:01 AM

There will be two date fields, one needing to send a reminder in a week and the other one in 3 weeks. It needs to keep sending the reminder until the
action is performed and then it needs to stop.
  • 0

#4 comment  consultant

comment
  • Members
  • 23,499 posts
  • Time Online: 299d 9h 51m 12s

Posted 04 January 2012 - 06:28 AM

OK, but in a database you normally have many records in a table - say a table of company employees with 258 records. So the question is, does each employee (or whatever) have their own date - or is there one "housekeeping" date for all of them?
  • 0

#5 m.r.mymandms  member

m.r.mymandms
  • Members
  • 6 posts
  • FM Application:11
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Novice
  • Time Online: 3h 55m 14s

Posted 04 January 2012 - 08:30 PM

OK, but in a database you normally have many records in a table - say a table of company employees with 258 records. So the question is, does each employee (or whatever) have their own date - or is there one "housekeeping" date for all of them?


There is one housekeeping date for all of them.
  • 0

#6 comment  consultant

comment
  • Members
  • 23,499 posts
  • Time Online: 299d 9h 51m 12s

Posted 05 January 2012 - 05:56 AM

OK, then try what I said earlier. Have your startup script compare the date against current date and check the reminder status (turned off or on) and if needed install the reminder script to run at next noon.

The reminder script should give user to option to "snooze" or turn it off. If user chose the former, the script will install itself to run at next noon (in case they do not close the file overnight). The other choice will result in setting the reminder status to off.
  • 0




FMForum Advertisers