February 1, 200124 yr Please, help me (I'm spanish so sorry about my english). I'm a recent newcomer to the Filemaker 5 Pro's world. I need to make a database with web companion. I have a huge form, which users can fill, then when an user clicks on save, the form is saved and where an user returns, writing two or three fields of the form (or a password), he can finish filling the form, which is filled with the data already wrote. Of course, one user only has to fill one register and can't access the others. Could anybody help me? If you don't know how to do, could you tell me a good book where the answer is? Thank you.
February 4, 200124 yr try this book it's good for beginners. I don't know if there's a spanish version though! http://www.amazon.co.uk/exec/obidos/ASIN/0201696657/qid%3D981263527/026-0337411-2198016 **when you've read the book** the easiest way to make a user name and password access is when they create their record collect a username and password add these fields together in a calculated field on the database (field1 & field2). Then when they come back have a format file with two HTML forms in it. The user name and password text boxes in one "<form>" in another "<form>" on in the same format file have a hidden form object with the same name as the field on the database that is the username and password added together. put the -find action on the form with the hidden form object. in the "<input type=submit etc" tag add the JavaScript something like onClick="document.nameofform2.name_of_the_hidden_form_object_and_the_field_on_your_database.value=document.nameofform1.name_of_username_text_object.value + document.nameofform1.name_of_password_text_object.value" (I'm very tired at the moment so that may not be exactly right!) what this does is add the users username and password input together and then does the find based on that (and not on the first form) Why go to all this trouble I hear you say....I found that it's the easiest way to get a username and password access to a record with out finding on either the username or password which will happen otherwise. I hope this helps and have fun
February 6, 200124 yr Author Thank you very much. I'll buy the book and I'll try your solution (at this time, I don't understand it very much) Bye.
February 13, 200124 yr Author Hello, I'm again. Well, I've learned a bit more about CDML and I've programmed the search page. It works fine and when I put a name and a pasword, I found the correct register. But I have a new problem. In the results page, I've put a button to edit the results, and when I click on it, an error happens. Sometimes is a "register not found error", sometimes is a "access privileges error". It seems to depend of the "exact search" and "exact edition" privileges of the fields, that I put in the Web Security Database. Anybody knows what is happening? Thank you very much.
February 22, 200124 yr Have you given "All Users" the ability to search, add, and edit in the web security database? Also if you want to edit or delete you must incude the record ID tag with form you submit so WC knows which record to act on (I can't remeber the Web copanion tag for this I use lasso and it's different. It will be in the book you got!). I hope this helps Scratch
February 22, 200124 yr also if you've put exact search for the fields you must include those fields in every record specific search, with the eq operator. this shouldn't affect editing & deleting though as these actions only require record ID hope this helps.
February 22, 200124 yr Author Thamk you, but I've solved the problem. The next line wasn't in the results file, where I have the Edit option: <input type="hidden" name="-RecID" value="[FMP-CurrentRecID]"> I put it and It's all right, but thanks again.
Create an account or sign in to comment