Hey all,
I am kind of new to asprunner so please forgive me if my questions seem a bit stupid.
My company has asked me to develop a tracking system for current manual processes that require a very long paper trail. In other words they want me to make an online system that will speed up the process from 200 days to 2 days.
Soooo here I am giving asprunner a shot. And to my amazement it seems to be able to take care of the majority of my needs, with a little tweaking here and there. If I can get a demo up and running soon I am sure my company will cough up the money for the Pro version.
My problem is that many of these processes that I am having to automate are time sensitive, i.e. after 5 days the status of one DB entry will change from active to overdue. My idea was to have a script run when the first person accesses the site every day (specifically the list page). This script would check against submission dates and the current date using the datediff function. When the difference exceeded a certain time period it would change the value of a DB entry.
I can get everything but the last part. I don't have a clue how to sumbit changes to the DB from the list page.
I know there is a loop occurring when the list page is displayed and that I would have to write my script to run within this loop, but again accessing the DB and being able to modify the information is the problem.
Is it possible to submit these kinds of changes without having to create a new form on the list page? Or is there a way to submit to a DB without a submitting a form?
Any help in this area would be greatly appreciated.
Thanks,
John
