Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FileMaker Topics / June 2004

Tip: Looking for answers? Try searching our database.

FM -> HTML via Homepage: checkboxes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Barbara White - 23 Jun 2004 16:31 GMT
I'm using FM 6.0 (on Windows 2000) 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 one field
(Editor/Designer Name) to appear as a checkbox and to allow multiple
entries into it.

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, please dumb it
down for a very new user. :-)
Tim 'Webko' Booth - 24 Jun 2004 01:10 GMT
> I'm using FM 6.0 (on Windows 2000) and have used Claris Homepage to
> create the Web interface to the database. I'm then customizing the
[quoted text clipped - 8 lines]
> [FMP-VALULIST: Editor/Designer Name, LIST=-Editor/Designer Name]
> <checkbox symbol> [FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST]

This looks like fair code for what you want...
BUT
It will only work if the page it is in is called as a FileMaker format file,
eg
http://localhost/filename.html
will NOT work
http://localhost/FMPro?-db=db.fp5&-format=filename.html&-view
will

> 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?

Try the above for a start.

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

Feel free to mail me off the newsgroup - I can write some demo stuff fairly
quickly if required.

Webko
Barbara White - 28 Jun 2004 13:25 GMT
What Tim suggested below worked...the checkboxes actually appear in
the Web interface file now. (Now I just have to figure out how to
get edit permissions to "take" so that we can actually make changes
to existing records using the Web interface. I sent mail to Tim
about this.)

Thanks, everyone, for the help. Particularly, thanks to Tim for
figuring out what the problem was.

Barbara

>>I'm using FM 6.0 (on Windows 2000) and have used Claris Homepage to
>>create the Web interface to the database. I'm then customizing the
[quoted text clipped - 34 lines]
>
> Webko
Barbara White - 29 Jun 2004 14:21 GMT
I've fixed the problem with the edit permissions not "taking". I'm
not sure which of the fixes did the trick, but here's what I did.

In the FM file, if any of the fields had "prohibit modification of
value" checked, I unchecked it.

I also configured the Web Security Database to allow edit permission
for all records. (I suspect that this had little to do with the
solution because the database was set to use Filemaker access
privileges and I did not use groups or passwords on the file.)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.