Sign in to follow this  
Followers 0

Script trigger on date field


6 posts in this topic

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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?

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0