robmcmumbi

OK, I had a dim moment. I see only 50 records because I am using a trial version of 5.5. Forgive the waste of space. R

Dear friends, I run approximately 30 databases on FM Server 5.0, through FM Unlimited onto the web. I was dismayed to discover this morning that all of my databases now have only 50 records in them (as opposed to over 1,000 in some). All databases are protected and backed up every night. Unfortunately, the back up also only has fifty records. Do you have any idea how this could have happened? Any similar experience? Thank you, Rob Mc

I used the HTML workaround. i.e. I made the field a standard field, then used HTML for a pop-up menu that directed the input to the appropriate field. Thanks for all your help...I would still like to make the value list thing work one day, but not today. Thank you all for your help on this.

Hello again, Perhaps it would be helpful if I "post my code." Value lists don't work, but I am running into a pop-up menu being generated with CDML code inside it, a problem to which you referred, Vaughan. At the 3 or 4 points where you see MULTIPLE OPTIONS, that is where I want my value lists to come in. You will note that I have an action in the form that is "-Find." <sigh> ... <form action="FMPro" method="POST"> <INPUT TYPE="hidden" NAME="-db" VALUE="cfarmembers.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="basicinfo"> <INPUT TYPE="hidden" NAME="-format" VALUE="memberhit.html"> <input type="hidden" name="-Find"> <table border="4" cellpadding="0" cellspacing="2" bgcolor="#fff8dc"> <tr> <td> <table border="0" cellpadding="4" cellspacing="0"> <tr> <td colspan="4" bgcolor="#0000ff "> <center><font size="4" color="#fff8dc"><b>Please enter your search criteria below.</b></font></center></td> </tr> <tr> <td> <br> </td> </tr> <tr> <td><div align="right"><font color="#0000ff "><b>Last Name</b></font></div> </td> <td> <select name="pilast"> <option value="" selected> [FMP-VALUELIST: pilastname List="pilast"] <option value="FMP-ValueListItem">FMP-ValueListItem [/FMP-VALUELIST] <select name="pilastname"> <option>MULTIPLE OPTIONS </select> </td> </tr> <tr> <td><font color="#0000ff "><b>First Name</b></font> </td> <td> <select name="pifirstname"> <option>MULTIPLE OPTIONS </select> </td> </tr> <tr> <td><div align="right"><font color="#0000ff "><b>Institution</b></font></div> </td> <TD> <select name="institution"> <option> <option>The University of Alabama at Birmingham <option>Southern Research Institute </select> </TD> </TR> <TR> <td><div align="right"><font color="#0000ff "><b>School</b></font></div> </td> <td><font size=-1> <select name ="school"> <option>MULTIPLE OPTIONS </select> </font></td> </tr> <tr> <td><div align="right"><font color="#0000ff "><b>Department</b></font></div> </td> <td> <font size=-1> <select name="department"> <option>MULTIPLE OPTIONS </select> </td> </TR> <TR> <td><div align="right"><font color="#0000ff "><b>Division</b></font></div> </td> <td> <select name="division"> <option> <option>MULTIPLE OPTIONS </select> </td> </tr> <tr> <td colspan="4"> <hr> </td> </tr> <tr> <td><div align="right"><font color="#0000ff "><b>Research Interests</b></font></div> </td> <td> <select name="researchinterests"> <option> <option>MULTIPLE OPTIONS </select> </td> </tr> <tr> <td bgcolor="#0000ff " colspan="4" align="center"> <input type="hidden" name="-DB" value="cfarmembers.fp5"> <input type="hidden" name="-lay" value="basicinfo"> <input type="hidden" name="-format" value="memberhit.html"> <input type="hidden" name="-Find"> <input type="submit" value="Start Search"> <input type="reset" value="Clear Form"> </FORM> </table>

quote: Originally posted by Vaughan: Inside your form put: [FMP-ValueList: fieldname, list=listname] <input type=checkbox name=fieldname value="[FMP-ValueListItem]" [FMP-ValueListChecked]>[FMP-ValueListItem: always, html][/FMP-ValueList] You may already know this, but for the benefit of others: the valuelist and checkboxes are only generated if the format file is processed by Web Companion before viewing. That is, the page cannot be viewed directly by a browser, it has to be accessed through a -view, -find, -findany or -findall action. direct viewing through a browser will result in the user seeing the cdml tags and not the checkboxes and values. I hope you might get this, Vaughan. I have tried without success to follow the advice of those on these fora regarding the use of valuelists. You said the above, and I wonder if you could clarify that for a newbie like myself. I don't understand what you mean. I have read the woefully inadequate CDML reference on -Find, -Findall, -view, and -findany. How do I apply these to make valuelists work? (Pity the CDML Reference doesn't make reference to this. Judging from the number of people who ask this kind of question...it could have caused a lot of headaches!) With thanks, Rob McDonald

APOLOGIES!! I meant to name Keith above!

Thank you all for your help. Brian, I tried what you suggested. I made a duplicate layout, and changed the field to a standard field. You were correct; the text did appear in the field. Unfortunately, the valuelist still did not work online. Can't figure it out, but I'm moving on...other fish to fry. <!> Thank you all again, R

One last statement of bafflement...I have gone directly in opposition to the principle of using FMP-option and just went ahead and coded the HTML <option>s...about 200 of them. I used the following, where "pilastname" is the name of the field, and "pilast" is the name of the value list. <select name="pilastname"> [FMP-option ilastname, list=pilast] </select> Also, I designated the correct database and layout in the beginning of the form. The search works fine with the HTML I labored out, and I've resigned myself to that for now, but I am absolutely puzzled as to why the FMP-option value list is not working! It seems like it should be a very simple function. The value list is not relational, I don't believe, so... ?? One thought I had was when viewed in Filemaker, the value list is defined as a "from field" value list. In other words, the values of the list are summoned from the data that already exist in the field. Therefore, one can not view the values within the define valuelist function of Filemaker Pro. However, I tried another valuelist using comparable syntax as above, but employing a valuelist that is a "custom list." Alas, the FMP-option function online did not work...again. Ideas, oh gurus of FM?? Mer

oh, ok. Well, I have tried that syntzx also, naming the field that uses the valuelist as well as the valuelist itself. I must be doing something else incorrectly. Thanks for the insight, though. Can't blame it on valuelists not working! Rob

Hi Folks, Having done some basic research on this outstanding forum, I am approching the conclusion that there is a fundamental problem in applying [FMP-Option] in custom web designs with Filemaker. Is this correct? For example, from my CDML reference guide, I would expect the following... <select name="Groups"> [FMP-option: institutions] </select> ...to generate a pop-up menu of form inputs that are the values of my valuelist associated with the field called "institutions." (Given that I already designated the correct value list for this field, the correct database, the form action, etc.) Do I sound like I'm on the right track? Is the use of [FMP-Option] problematic? Many thanks, Rob

I found my answer amidst the help from many of you on the Intenet forum. Thank you. Clarity...ah!

BINGO!!! sp, Vaughn, et al. Thank you. I have been using instant web publishing, and sometime in the middle of the night I realized that I have to create my own html pages to incorporate the CDML utility. Thank you all for your help! Rob

Hi folks, Still baffled, I'm afraid. Yes, the standard HTML tags would work, but they don't for my FM database. Somehow the email fields are not hyperlinks. I think that Andreas' reply is closer to the solution, but I do not know how to incorporate that sample CDML code into my existing page. (http://138.26.20.115/FMRes/FMPro?-db=cfarmembers&-op=bw&Last%20Name=Hunter&-lop=and&-format=zFormVwCSS.htm&-lay=Basic%20Information%20Form&-max=1&-skip=0&-token.0=25&-token.1=&-fi nd) Perhaps it helps to say that I am not developing my own web pages. Rather, I am using the one of the default layouts provided with FM. Many thanks to all and any advice.

Hi Folks, having scanned these fora for answers, and finding some gems of information, I still find myself at a loss. Please help, knowing that I have only beginner's knolwedge. What I have: On Mac OS 9.1 platforms, a FM Server 5 machine, serving files to a FM Unlimited machine, which makes them accessible and viewable on the internet. One database that is being served and viewed is a contact database that includes a field with the email addresses of individuals. What I believe to be true: One can make the email address data clickable, similar to how HTML does with <a href="mailto:email@mailserver.ser"></a>. I think this can be done with CDML, but one can only use CDML if (1) Web Server Connector is operational, or (2) one has FM Developer. Am I warm? What I don't know: Must I use Web Server Connector to make the email links work? Must I have FM Developer to use CDML properly? Thank you one and all... Rob McDonald newbie

Hi Folks, having scanned these fora for answers, and finding some gems of information, I still find myself at a loss. Please help, knowing that I have only beginner's knolwedge. What I have: On Mac OS 9.1 platforms, a FM Server 5 machine, serving files to a FM Unlimited machine, which makes them accessible and viewable on the internet. One database that is being served and viewed is a contact database that includes a field with the email addresses of individuals. What I believe to be true: One can make the email address data clickable, similar to how HTML does with <a href="mailto:email@mailserver.ser"></a>. I think this can be done with CDML, but one can only use CDML if (1) Web Server Connector is operational, or (2) one has FM Developer. Am I warm? What I don't know: Must I use Web Server Connector to make the email links work? Must I have FM Developer to use CDML properly? Thank you one and all... Rob McDonald newbie