Hi Vinish! I have another question for my system. As shown in the photo, is it possible to automatically reject the booking with the BOOKID of '0007' when I approve the booking with the BOOKID of '0006'? (as they are booking the same equipment on the same day) if so how can I do it? Thanks!!
Vinish Kapoor
Hi Celinehy,
To do this, you need an SQL Update statement something like below:
Instead of hard-code '0006', you can use your Apex page item and do the same for equipment ID.
Now, if there is not only booking id '0007' but if any other booking id exists, that will also get rejected. You can also use a date field (PICKUP_DATE) to run the Update statement for a day, that is up to your requirement.
Please let me know if any doubts. Thanks.