Hi all.
I have a form with two text fields, "txtDate" and "txtStaffNumber".
When the "cmdSend" button is pressed, the script needs to find that date entered, go along the row to cell O which will either contain a 0, 1, 2, 3 or 4. I need the following results to display back on the form if the cell contains certain numbers...
If 0, then a label box saying UNAVAILABLE and thats it.
If 1, 2, 3 or 4, label box saying AVAILABLE and a button to appear next to it "cmdBook", (which I already have the code for what I want that to do.)
I'm guessing it will be done by entering the labels and button before, hiding them and then unhide if the result is in the right parameter, but I don't know how.
Can anyone help please?
Many thanks.
Bookmarks