ray_m

Go to today's guest?

Discussion created by ray_m on Jun 23, 2018
Latest reply on Jun 27, 2018 by ray_m

I've set up a database for my vacation rental. It's now working very well, but I'm trying to put the icing on the cake.

I would like to add a button that will take me to the current guest.

I've tried scripting a loop that will go to today's date (based on arrival date) then, if not found, try yesterday, then the day before etc. etc. until if finds the last arrival date ... and hence the guest currently in residence (or last guest, if noone is currently staying).

I'm still very new to this and I'm fumbling around in the script workspace. Could someone suggest how I could do this?

 

Thanks, in anticipation.

 

Ray

Outcomes