Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Web restriction: One user-One register

Featured Replies

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.

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

  • 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.

  • 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.

  • 2 weeks later...

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

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.

  • 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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.