• No Approval

    By Greg Robertson 2 decades ago

    Hey All - Great database!



    I would like to use it so that if someone requests a vacation and gives 7 days notice it will be auto-approved. Anyone know if this is possible through formulas or any other method?



    Cheers,



    Greg

    • You Could Write An Agent

      By Bob Brodsky 2 decades ago

      Hi Greg,



      Thanks for your interest in Vacation Request!



      You could write an agent to look at pending requests and approve them if they are more than 7 days old and then schedule that agent to run daily.



      Another solution would be to make all system participants administrators and then they could approve their own requests. You might want to add some code to the LR form that would not permit it to be saved as Approved unless it was old enough …





      HTH,

      Bob

      • By Greg Robertson 2 decades ago

        Hey Bob thanks for getting back to me. I have only started playing about with creating databases so really don't have much of an idea on how to go about creating an agent for this unfortunately…Watch out google here I come!



        Thanks for the tip though because this Agent sounds exactly like what i need.



        Cheers,



        Greg