Jump to content

This topic is 7530 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi...I posted this under the "Fields" topic, but someone suggested that this topic might be better. (They were right.)

I am very new to Filemaker and Claris Home page, but so far so (reasonably) good. I do not have CDML experience, but I have been using HTML and HTML forms for years, so I can customize the output that Claris Homepage produces with its Filemaker Connection Assistant.

I have a question about how checkboxes interact with the FM database.

I'm using FM 6.0 and have used Claris Homepage to create the Web interface to the database. I'm then customizing the HTML pages. When I created the interface with Claris, I instructed the one field (Editor/Designer Name) to appear as a checkbox and to allow multiple entries.

In the HTML file, for the checkboxes, this appeared once:

[FMP-VALULIST: Editor/Designer Name, LIST=-Editor/Designer Name] <checkbox symbol> [FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST]

The field (Editor/Designer Name) is derived from a value list that contains about 30 names. How can I get each of these names reflected in the Web interface AND do so in a way that allows the user to view a record and ADD new checkmarks to a record without overwriting the existing ones?

I tried to fix this in the HTML by creating a radio button for each of the people in the Editor/Designer value list and associating those radio buttons with the correct field. This works, but it overwrites existing checked entries in the database. For example, imagine that a user is viewing a record with a checklist that looks like this:

__ parsley

__ sage

__ rosemary

__ thyme

and record #1 indicates that a user has checked these items:

X parsley

X sage

X rosemary

__ thyme

Another user sees this and decides to check "thyme" also. So he does and then clicks the submit button. The problem is that now the record displays only thyme as the checked item. The second user replaced the items that the first user checked instead of augmenting them.

How can I fix this in either the Connection Assistant, FileMaker, or in the HTML files? (If you do have an answer for me, can you super-dumb it down for a very new user? :)-)

This topic is 7530 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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