Script to have your form check the contents of a cell and reply different results

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.

Hi Solus.

Yes, I'm sorry, I did mean 'Column O'. And yes the dates are in 'Column A'

Thanks.

Hiya!

Thanks for your reply. I have only just had a chance to have a go at it. Unfortunately it doesn't seem to work. I have tried fiddling about with it but it just doesn't seem to work. It does hide the cmdBook, but if you put text in and hit cmdSend, it does nothing. But if you press cmdSend with nothing in the text boxes, it comes back 'unavailable'. Any ideas??

I will attach a copy of the document so you can see what I mean.

Many thanks.
Steve.

Hi Solus, works great!! Thank you. Apologies for not telling you that the cell was a formula.

Just one small thing, and probably a small fix, but when I run the form and press send, I get a Run-time error 13: Type mismatch and after clicking debug, the following line gets highlighted as the problem...

Please Login or Register  to view this content.

I have tried finding out what the error is and from what I've read on the net it is a problem with a value in the spreadsheet, however the only thing that I can see that it might be, is that cell A1 is a heading 'Date' (the site I read from started going into strings, integers, numbers, etc etc which is where I got lost) but thought maybe its this?

Thanks again Solus, Steve.

Hiiiiiiiiii.

I don't know what its missing, but when I downloaded it and tried to run it, I get a compile error, could not find project or library. Also on the form there txtDate box has diasappeared, but then looking through the new script, I can't see any mention of it so presume you replaced it with something else, which for some reason, isn't coming accross on the file.

What did you replace txtDate with?

The system it is going to be run on is actually windows, but I use a mac at home to make it. I will try it in work on windows and see what happens

In Mac you may not use Windows Common Controls (DTPicker) or RefEdit. If the titles in row 17 may be removed or placed above the data the code in #6 will work on Mac and PC.

Hi Solus and thanks for the update. I will steal my fathers windows laptop tomorrow and give it a whirl on there. I will get back to you with the results. Thank youuuuuuu.

Hi ya. Its been a while, been very busy at work. Happy new year.

I finally managed to get my fathers windows computer but it is still saying that it is not a file that is recognized and I don't know why?? Any ideas?