Other Internet Technologies

I am using CDML for the first time and am getting along fairly well. I do have a question on a find. Here is what I want to do. Have the page allow them to pick a word from a list (value list) then hit find to get those records. It looks like I need to define the field, then define the select (name=-op) then input the field that I am doing the search on but it is free text not the list I desire. Am I making this to difficult. Please help.

I know this has been explained before in this forum but I having trouble getting checkboxes to update on or off in an record detail page. I am using the code below with no luck. <INPUT TYPE=hidden NAME=cam VALUE=""> [FMP-VALUELIST: cam, LIST=need] <INPUT TYPE=checkbox NAME='cam' VALUE='[FMP-ValueListItem]' [FMP-ValueListChecked]>[FMP-VALUELISTITEM: Always, HTML] [/FMP-VALUELIST] The valuelist used has one entry: Yes The field in FM is a text field with no value required. I tried moving the hidden field up the html but no luck. As a test, I redirected my form to a friend's (non filemaker) server and he saw…

Hi I want to use a url like this; http://mydomain/FMPro?-db=mydatabase.fp5&-layout=detail&-format=results.htm&-error=search.htm&materialstatus=searchtermtofind&-sortfield=destinationsort&-sortorder=ascend&-find to find a set of records but to omit a specific value in searchtermtofind - in this case I want to find every record other than ones with "Completed" in the JobStatus field. I thought I might be able to use something like -LOP=neq etc, but according to the CDML reference this only works AND & OR. I can do it by creating another calculation field to search on but would rather do it this way - any ideas?!

hi all I

Here is my set up. (OSX) Apache web server: running muitlple web sites. all web sites are forms (FMU) using the Web Security.fp5 files. A new web site using the same (FMU) but does not need any security. example a user clicks on a link Information on a web site and the link: http://localhost/FMPro?-db=infocallweb.fp5&-lay=web&-format=infocall.htm&-new goes straight to the form and does not ask for a user name and password. Can I append the user name and password to the link? There is no passwords for the DB. The other web sites need the web security but this on does not. Help. Thanks

I have tried numerous combinations, apparantly haven't found the key. Please help me to get this FMP-If statement to work. (* myself been playing around with the {}, "{}" and FMP- pairs. *) [FMP-IF: FMP-Field:Id .neq. {CurrentToken:1}] What is the secret ? Thanks JItse

Hi There, Originally I specified a particular layout within my FM database, and all connections, etc worked fine. Then I had a rethink and created a new FM layout with the same name as the previous layout (which I renamed ...DNU). Interestingly enough the web companion continued connecting to the old layout which I no longer used! This is not a problem for me anymore as I have gone back to the original layout, called it web, and dumped most fields on it to avoid problems. But I am curious to know why I couldn't change layouts and re-direct the WC to the new layout. I think it is because WC doesn't use the name, but the layout id, but I'm curious to see what…

Hi, we are running in a strange problem after testing on IE on the MAC and PC. To publish standard web pages from FM we need to use frames, so we are calling a framset via -format. to put the DATA in the subframes we have used FMP-LINK as shown here: <frameset rows="140,*" frameborder="NO" border="0" framespacing="0"> <frame src="[FMP-Link: r]&-format=Header.html"&-find name="headerframe" scrolling="no" > <frame src="[FMP-Link: r]&-format=Main.html" name="mainframe"> </frameset>%00%00 In a safari Browser everything works fine, but on a IE on PC and MAC there is just a empty page, but …

FileMaker is telling me I can't use port 80 and to select another. I assume it saying that because I'm already serving a site from my computer. Is there a preferred port for FileMaker? I know almost nothing about this. Mac OS X allows me to serve web pages and I'm doing a personal site over DSL and I want to publish the database for one or two people to be able to access. I'm mainly concerned with not selecting a port that might be needed for something else in the future or selecting some other reserved number. Second question: Does this mean that to access the database, one will have to go to http://123.23.456.67:99 where the 99 is the port number that is specified…

Does anyone know who to overcome interference of Lasso with JavaScripts's Array brackets '[]'? Example from JavaScript code: 'Manufs[Count]=tempString;'. Lasso thinks that 'No tag, type or constant was defined under the name "Count"'.

I've got several databases up on one server and doing well. But now, I'd like some field information to simply be viewed on a website hosted on a different server. On the Filemaker server, each person has a record. On the main website server, each person has an html page. On a table cell, I want to include that person's email address, which is contained in the Filemaker database. The Filemaker files are located at http://newcomer.ub.org/global/fmpro? The email field is called "email" What exactly do I put in a table cell on the static html page to call up this info from the database? I just want to see the information--not have a form box or any kind…

With my online database there are a number of forms for users to submit, however, some users complain that submitting the form, getting a reply format page that returns them to the updated results is annoying. The reply page uses the following to return back to the updated found set; FMPro?-db=Media_UMC.fp5&-format=mediadetail.htm&-lay=detail&-op=eq&JobsRecID=[FMP-Field: JobsRecID]&-sortfield=destinationsort&-sortorder=ascend&-find Is it possible to build this URL into the update form to eliminate the reply page? - Thanks

Hi, I have recently converted our databases over to IWP using FMPro 6. In one of the primary DB's there is one particular record that displays fine in FM but produces an IE error (see attached) when I try to access that particular record from a browser. I can navigate to any of the other records just fine. It's just this one record! I get the same error when I try to Search or Sort. As an expiriment I tried setting up Web Companion so it would sort the records before it reaches the Browser... I got all the records but once again, when I navigated to that one record.. Ouch! Unsorted, this "bad" record is the last one, so I'm wondering if there is some sort …

I have a web enabled file (main.fp5) that relates to another file (assignments.fp5) on my web server. There's a portal showing related records. If I connect to the main file using FMP6 and I create a new record in main.fp5, the blank portal row is there and I can add new related records as usual. If I connect using a web browser and create a new record in main.fp5, I cannot add a portal row, unless one has already been created using the client. We're running Unlimited 5. Is this a limitation with 5 or is this just a limitation of web companion? BTW, I'm using IE for Mac OSX. Any insight appreciated.

Does anyone know how I might be able to implement Spell Check in CDML using FileMaker Pro's spell check feature. I have a form that allows the users to post summaries/articles and they would really like the ability to implement spell check but I'm not too sure how I would be able to implement this, particularly returning the results of the spell check. Thanks.

Im a littleor (alot) confused here, and need some help please. The following code comes from CDML referance from filemaker. <form action="FMPro" method="post"> <input type="hidden" name="-DB" value="contacts.fp5"> <input type="hidden" name="-Format" value="displaypage.html"> <input type="text" name="-MailTo" value="[email protected]"> <input type="text" name="-MailCC" value="[email protected]"> <input type="text" name="-MailBCC" value="[email protected]"> <input type="text" name="-MailFrom" value="[email protected]"> <input type="text" name="-MailSub" value="The Subject"> <input type="hidden" name…

Hi Does anyone know if this can be done; I have an -edit page that contains a list of bookings related to a master job record. The records are contained within [FMP-Record][/FMP-Record] tags. Each record is updatable so I've stuck an update form for each row. Is there anyway you can have it as above but use a single form to update all the records in one go? Thanks!!

Does the field validation preference work on the web? I have a database hosted in which users are required to fill in data on certain fields that have validations on them i.e. "not empty", "strict data type- 4 digit year" or "strict do not allow user to overide validation". Users get an error page upon submitting forms if it is incorrectly filled out. That is, if the fields are empty or don't have valid date entries they get the error page. The problems is that even if the user doesn't finish entering the information to create a new record or simply quits out of their browser, new records with blank fields get created. In the last two days I have had about 20-30 new rec…

I have set up a database and designed my website to search and display records. Is there a way I can display a field in different colours on my results page for different contents of that field. Example field in the database call "Status" I have two Statuss in that field "Complete" and "Not Complete" When the database is searched it displays the list of records and any that the field is "Complete" are a different colour to the ones that are "Not Compete" ?? Hope this makes sense

Hi, I have a large number of layouts that I need to open in order to display on the net (around 50). Is there a way of automating this process in respect to the checking web sharing and defining the views in stead of having to do it for all 50 pages individually Regrds, D

Hi! My startpage have one field (date)that I search the db. If I find at least on record I can pass the value to the next page and I

How can I display formatted text, from a FMPro field, using CDML/HTML. When shown in the browser the text appears as unformatted, ie. one line. Thanks in anticipation.

Hi I have two fields "start_date" and "end_date". I use validation for both of them : Start_date -> start_date>=status(currentdate) End_Date -> End_date<(start_date+62) These validation does not seem to be working on the web. I tried JS but I found only validation for empy fields. 1. why these validations does not work on the web (FMP 6 U!) ? 2. Any other way it can be done ?

Hey I've currently built a database in filemaker Pro 6 and which to use CDML to link the database through to my dreamweaver site. I understand that i have to use CDML tags but i dont know what they are or how to use them. Any help would be great. If you can post here or send to [email protected]

Filemakerpro 6 Unlimited Windows XP Professional Here's my situation: I've got a 2 dbs: sample.fp5 and sample_plant.fp5. Sample.fp5 contains information about individual samples (date in, date out, plant, etc) while sample_plant contains just one field -- plant. I've got a relationship from sample_plant to sample matching the plant name, and a record for every single type of plant that appears in sample.fp5. The reason for doing this is because I want to have a heading -- plant -- when I generate the search results page. The idea is to first do a search against the sample_plant.fp5 db to pull up every single type of plant available, and then performing an in…

Hi I have the following on my web page : [fmp-inlineaction: -db=web users.fp5, -lay=webmain, -recid={fmp-currentrecid},released="Y",-Edit][/fmp-inlineaction] [fmp-inlineaction: -db=web users.fp5, -lay=webmain, -recid={fmp-currentrecid},-Delete][/fmp-inlineaction] Any ideas why it doesn't work?

hi there I use InlineAction to display a couple of picture links on the right side of a website. Inside InlineAction I use [FMP-Record] so I can display more than one link. Unfortunately I haven't found a way to have the links sorted - is there a command? If not, could I use a script somehow to realize the sort? kind regards PJ Wassermann

hi there, i have a file that i am serching the date for. now i have 50 dummie recods all of them have the same date. now when i seach for that date i get only 25 records coming up. any idea why? everything works. i get a list in table format with all the info, just not all the records. help!!! Peter

Hi, I have checked the numerous posts here on Portals, but unfortunately have not been able to work out a problem I have. SImple ordering system with 3 files: customer, item and line item. I display the items in the customer file through a portal. Clicking on an item then adds that item to the line item file linked to the customer record. All works well in FM. Am very close on the web, but not quite there. The following displays the portal rows correctly, but for some reason the pk_cust_id is only working on the first portal line. So if I click on the first portal line the record is added successfully, but not on any other portal line. [FMP-PORTAL: lr_…

I am trying to determine if a search field on a form has a value after it is submited. I have used: [FMP-If: TicketN .gt. 0 ] this does not seam to do it.

I wonder is it possible to pass a token in a form submit. What i mean is this sample code: <FORM name="myform" action="http://10.0.1.2/FMPro" method="post"> <input type="hidden" name="-DB" value="medewerkers.fp5"> <input type="hidden" name="-Lay" value="L1"> <input type="hidden" name="-Format" value="check.htm"> <input type="hidden" name="-Error" value="retry.htm"> <input type="hidden" name="-Token.0" value=[FMP-Field:Naam]> Gebruikersnaam:<input type="text" name="Naam" Value="MensoMolag"><BR> Wachtwoord:<input type="text" name="Wachtwoord" Value="Menso"><BR> <input type="submi…

Hello, Currently the web site has login, enter password and display people information (name, phone, etc) based on password. What would need to do then is to then after display comes up to be able to click on a button in any person line to do another search in db to display that persons entire record. I have the thoughts to create a form around one field (say name) and pass that to do search but no idea as to how. many thanks, nati

I have two fields, category1 and category2 with the same value list - category. I want to search for records with a selected category in category1 or category2 which I can do with: FMPro?-db=photo.fp5&-lay=data&-format=search_results.htm&-op=eq&category=Arts&-LOP=OR&category2=Arts&-sortfield=pictname&-max=100&-find%20">Arts</option> How would you write the code to do this search on a form with a single drop down field (instead of a separate drop down for category1 and category2). And a related question, can you do a key word search on two fields at the same time using one text field ?

I have 3 tables..... 1) Companies (Details of company) 2) Services (Services offered by all companies) 3) Company_Services (linking table to resolve the many to many relationship between tables 1 & 2 and comprising only of company_ID & service_Code). I have an HTMl page which shows an individual company with a portal showing each service_Code offered by that company and want to create a hyperlink to another page which will detail a description of the service (held in table 2). Creating such a link from a portal would normally involve referencing a related field name which uniquely identifies the row to be displayed form table 3 upon click…

I'm looking for a way to use the value of a field as an include on an CDML page. Does anyone know if this is possible? I was thinking of trying this [fmp-include: [fmp-field:fieldname]] But I doubt that will work... should I put the entire include in the context of the field and simply put the field tag on the cdml page? [fmp-field: fieldname] (where the value id [fmp-include: theIncludeFile.html] If anyone knows this off the top of their head, I would really appreciate it. Thanks,

How we can do to not press exectue button to refresh the page with the web companion. for exemple one of my field is in relation with an other, and i aklways have to press execute to refresh the field... do we you have a trick

I am using Instant Web Publishing with my own home page for a simple on-line survey. I am wanting to create one button that submits the data then takes them to a page on our web site. I am using these two scripts: Exit Record/Request then Open URL but it only goes to the url and does not submit the data. Any ideas or at least know this is not possible?

IMHO - you are not passing any valid information for the delete. Get the record number from search or something, and then delete. Also -- does Web Security db allow delete?

does any one know how I can set a FM field on a webpage to the current date? By JS or just using FM? Thanks Hal.

Hello, I was wondering if it is possible to add styled text (underline, bold, italic) to a Filemaker Unlimited database using a custom web page "add" format file. Or, is it only possible to send plain text through a web form? I would like our contributers to be able to enter their own written text directly into the DB but fear that all styles will be lost. Thank You

Hi I'm new to filemaker so be gentle... I'm attempting to create a value list (non relational) which shows a list of clients departments currently held in the DB. The DB is called "TD5_Clients", the field with this data is called "Clients_Dept" and the value list is called "Departments". So far I have..... <select name="Client_Dept"> [FMP-Valuelist:Client_Dept, list=Departemnts] <option [FMP-valuelistitem] checked>[FMP-Valuelistitem] [/FMP-ValueNames] </Select> but this only displays a list with one entry showing [FMP-Valuelistitem] [/FMP-ValueNames] I notice that the tag doesn't appear to quote the DB name i.e. "TD5_Clients"…

Hi, I am searching my products database for products. When the search is returned I want to show data from the search results and then a second database that is not related to products but that reflects the current token of the search. Is it possible to show data from two seprate databases without a relationship in CDML? Like and include or something? Thanks

Im really new to the WEB part of Filemaker so im in need of help. In I couple of days I manage to learn some CDML and got my own HTML code that worked with my WEB COMPAIONG plug in perfectly. I could add, search deleat etc. Every thing cool. Now, ive been reading that this way isnt the best when you want to share 1 database with a number of user because only 1 could use it at a time so a friend gave me Filemaker Server to check it out. I installed it and though it was going to be like another plug in but I didnt see anything diferent. I ran a DOS command to start the server...ok....i went to filemaker and press OPEN HOST....ok... I see 3 databases with sta…

Can anyone help me? I can't seem to get my code to work - it searches & retrieves data but it won't display in the designated fields.... Would anyone be able to look at my code & tell me what's going on??

Hi, I have a Field, "Status" which has two radio buttons, "accepted" and "not accepted." When records are added to the database neither option is selected. I then go through the submitted records and click one or the other. I was wondering if there is a way to select the records with an empty field (with neither "accepted" nor "not accepted" selected) in a CDML URL so I can show all of the new records in a display page. I thought I could use: &Status="" Where the empty double quotes would act as a null value. This has worked for me in a pop-up menu in the past. Will I have to use an FMP-IF statement to accomplish this? Below, I have included an URL wh…

I am running FM4.0 and Trying to set up a database for web access through IWP. I have followed the steps in the manual and when I type in the IP address (192.168.1.100:591 try it!) I can see the a link to the database, but when I follow that link I get the messsage/error "Database Not Open". I'm new to this, but I'm pretty sure I've got it open on the host, because if I close the DB on the host, then its name doesn't show up in the browser when I type in the IP address. Any clues what step I'm missing?

My wish is to create our Web Site with a list of our products at first, then to go into a Online Store. I have File Maker 5.5. Can I use CDML with it ? I have no experience in Web design, and little in FM. What software to use for design and how do I publish my db on the Web. Can I have only some part of it online ? Very large question I guess, but I don't know from where to start. Thank you.

How would I put this find criteria together using a CDML link? In FMP Client I think of it as: (Name=Joe AND Status=1) (New Request) (Name=Bob AND Status=1) (New Request) (Name=Mary AND Status=1) <a href="FMPro?-db=DB.fp5&-lay=web&-format=results.htm& [color:"red"][WHAT GOES HERE?][/color]&-error=error.htm&-Find">Find Joe or Bob or Mary where status is one</a>

I have been laying around with numerous solutions but haven found he correct one. Is it possible to have a code like this : [FMP-If: (CurrentToken:6 - 5 .eq. 8)] some HTML [FMP-If] What is mean is if Token:6 is 13 then include some HTML code. Needless to say that CurrentToken:6 is non static I have also tried to build a javascript that returns true are false but too no avail. Can anyone help me on this one ? Thanks Jitse

Hi, I've been having trouble adding a button which searches for cases that aren't closed in a support database. I though this was going to be a five minute job! <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="support"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1"> <INPUT TYPE="hidden" NAME="-format" VALUE="search_results.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm"> <INPUT TYPE="hidden" NAME="-SortField" VALUE="user_name"> <INPUT TYPE="hidden" NAME="-SortORder" VALUE="Ascending"> <INPUT TYPE="hidden" NAME="-max" VALUE="20"> <INPUT TYPE="hidden" NA…

Hi, I've just been having real problems with a very simple search, to find any employee who doesn't have our normal 25-day holiday entitlement. I had this button: <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-DB" VALUE="Master_contact_list"> <INPUT TYPE="hidden" NAME="-Lay" VALUE="Layout1"> <INPUT TYPE="hidden" NAME="-format" VALUE="search_results.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="search_error.htm"> <INPUT TYPE="hidden" NAME="-SortField" VALUE="surname"> <INPUT TYPE="hidden" NAME="-SortOrder" VALUE="Ascending"> <INPUT TYPE="hidden" NAME="-max" VALUE="20"> <INPUT TYPE=…

I have just set up a new Filemaker Web Server system Filemaker server is running on one machine with all of the databases This is a secured server. Filemaker Unlimited and Web Companion are running on another machine. The databases are remotely opened using Unlimited and the web pages are placed in the Unlimited Web folder. Now the problem: When you try to access the databases through the web ie. https://webaddress/foldername/FMPro?-db=databasename.fp5&-lay=layoutname&-format=file.htm&-view I get an error message that says format file not found. I can run it locally and it works fine but on the web server it fails. I have read o…

E-mail has been covered a lot in this forum, but I can't seem to find anything that answers my question. If there is, I appoligize up front. I am trying to get a CDML solution to e-mail the results for a form to me as well as the user sending in the form. The e-mail gets sent fine, but the values are all blank except for one that is a global field. Here is the form (I have changed the mailfrom & bcc value): -- <form action="FMPro" method="get"> <input type="hidden" name="-DB" value="fOnlineCalendarSubmissions.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Input"> <INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-current…

Hello People! I know this does not belong in this forum but let me ask the question anyway.: Is there another way (a keystoke) for navigating FM records...beside the little "rolodex" icon? (win platform here) thanx

I have two date field on my web page. End Date and Start Date. Start Date is a pull down. Start Date can be blank. If Start Date is not blank. I need to be less than the End date. I have a Field Validation in Start date field. If(not IsEmpty(start date) and end Date %u2264 Start Date,0,1) I do have an error page based on error 507 ( failed calc validation) This works sometime on the web and sometime not. it needs to contestant. Would Java be easier? Thank for any help.

Hi Iv'e been tryin to perform an automatic email sending with no success. The goal is that if a user forgot his password, it will be sent to him. First the user click on "Forgot your password?" and get redirected to "mail.htm" with "username" field (as a new record) . After I press submit and no errors occure, the page redirects you to "mail_reply.htm". " Email with your password has been sent to you " is displayed and... nada! 1. I need an automatic email sending as I enter "mail_reply.htm". what is the best to do that without the need to press "send message" (example from FMP reference). 2. The "body" of the mail can be only a file? can I d…

I'm having a little bit of difficulty on how to save a particular search criteria that a user has just performed. What I'm attempting to do is a user can perform a search and then the results, they can then delete one of the entries. When they -delete one of the records, they are then taken to another format page that reinitiates the search that they just did. Obviously with the record that they just deleted being gone. I want to pass the search criteria in order to preserve the search that they just did, I do fine with text fields, radio buttons but with the checkboxes, since checkboxes allow multiple selections, I'm not quite sure what approach to take considering …

Hello People! Yes I too have inherited a DB with 3000+ records with Images saved into the file itself . "For some reason our file is 1.99 GB but it does not have that many records..." was the line when I received it. When I delete the images file is only 500 MB as it should be. Now, my question is how to extract images nameing them based on RecordID? eg. IF RecordID = XYZ-1001 THEN extract image to C:images with a name of "XYZ-1001.jpg" BATCH process all this? any thoughts or ideas? thank you very much!

Hi, I've got a quite complex question. You see I've been working with FileMaker for over a month now as an interaction designer. And we recommend using FileMaker Pro to all of our clients. And by doing that. We're now trying to get our client on to the web. one of our clients (www.tdsl.nl) Already have a PHP based database. But we're now trying to make a FILEMAKER pro one so that they don't have to input the offline database and the online database, as they do now. BUT my question is..... Is it even possible to make such a database on the web (FileMaker pro)? I mean.. i've been searching around on the web aand couldn't find anything simular. we already ha…

I'm trying to search on a value that contains a @ character (specifically, an E-mail address). My code is as follows: [FMP-InlineAction: -db=Services_.fp5, -lay=Web, -Max=10, -SortField=Email Name, Email Name="[email protected]", -Op=neq, Delete Flag=1, Email Customer ID={FMP-Field: Customer ID}, -Find] If I search on any part of the address besides the @ sign, everything works fine. I've tried it with and without quotes. If anyone has any insight as to what magic I must work to get this going, it would be much appreciated..

Is it possible to format your results so that you can have your results pull up in 2 columns ? I am working on a photo database. my search page pulls up small thumbnail photos. I would like the results to pull up rows of photos instead of each row with just one photo. Is that possible and if so could you share the code with me. (I am a newbie, and don't know too much yet). Thanks for your help !

(Preface) Since I've been using cdml, I've always search with a text field. Now I'm being asked to provide a new type of search that I haven't figured out how to do. It seems very logical in application, but to produce is another for me. (Help) I need to have a pop-up that has (options)

Hi I have table called "DB1", a layout called "LAY1" and a page called "Page.htm" I aslo have a field "Field1" Is it possible to create a link that insert a value into "field1" in the same record ? I've tried to use "[FMP-LinkRecID: format=page.htm, layout=lay1]" but I don't know where to insert the "field1=any_value" ......

Hi I've been reading here that there is a problem in CDML with valuelist with related values. I've tried all the examples/suggestions and still didn't get it... Structure & func': Web_users.fp5 is the file that I use for web interface with the rest of the DBs. "username" is the field that I use in the relationship with units.fp5. Relationship name is : "Units List for active systems" After a user enters his username,It displays all the units of that user in a portal. "Sys_id_main" is a field that belongs to units.fp5. I need to be able to have a drop down menu for that field with all the "sys_id_main"s that belongs to that user, so …

First, create a relationship in your web DB for a value list based on a relationship. Create a portal on the Layout that you based your web page on. In the portal put the field you want to appear in your value list. Next, put this code below in your web page. Text between ##.....## are just notes, not code. select name="FieldName"> ##This "FieldName" is the field name you want to set with an item in the value list.## [FMP-PORTAL: RelationshipName] ##substitute "RelationshipName" with name of the relationship you created.## <option value="[FMP-Field: RelationshipName::FieldName]">[FMP-Field:RelationshipName::FieldName] [/FMP-PORT…

I just did a registration for two identical summer conferences. The FIRST item on the web page was to select which month with a radio button <tr> <td><input type=radio name=which value="June">June </td> <td><input type=radio name=which value="July">July</td> <td><input type=radio name=which value="either">No Preference</td> </tr> This worked fine and entered the data in the Filemaker. If I was actually doing it IN Filemaker and left off this field ("which") then Filemaker gave me an error message. From the web, Filemaker was happy NOT to have this required value field fil…

I'm trying to have a drop down value list for a student that is found by the user. The value list should only contain dates that are related to this student. The dates are in a seperate file. The relationship is based on a unique student ID. This is weird, here is my CDML for my code for my value list . <select name="T027 Test Date_text"> <option value="" SELECTED>--Select-- [FMP-OPTION:PretestDates, list=PretestDates] </select> If I change the value list in my database to "Use Custom value" it works. If I change the value list in my database to "Use value list for another f…

This is absolutely driving me insane... For some reason, my form won't find my -format page. It says "format file could not be found" I cannot understand why? I checked the file name (numerous times) and I typed it correctly. The format file does work because I get to it fine when I click on a link in some other page. Basically, summarylist.html list out all the record and I click on the reference number on the list which basically gives me a more detailed information regarding the record that was clicked. summarydetails.html is the format file in summarylist.html form which contains the information of the record in a web form so that they can update the record. W…

I have a DB and CDML Files in my FMPro web folder. Everything seems to work right, but ... I can

Can anybody tell me how to upload pictures, i think that this is not possible using cdml only. I don't very much mind how it is done i just need to get it maybe asp or something?.

I am using the next step to send my email. META HTTP-EQUIV="refresh" content = " 3; URL=FMPro?-db=database.fp5&-lay=WEB&-format=newreply.htm&-mailto=[FMP-field: email]&[email protected]&-mailsub=email&-mailformat=mail.txt&-mailhost=mail.provider.com&-recid=[FMP-Currentrecid]&-Find"> In the [FMP-field: email]field are two addresses like [email protected];[email protected] when the redirect page wants to send the email it returns with error 4 (active error). When I use one email address there is no problem! How can I send more email adresses using only -mailto? I don't wanne use CC or BCC G…

I've been reading about sending mail while creating a new record. The way to do it is reported as: <input type="hidden" name="-MailHost" value="YourMailHost"> <input type="hidden" name="-MailTo" value="YourEmailAddress"> <input type="hidden" name="-MailSub" value="New Record Added"> <input type="hidden" name="-MailFormat" value="MailFormat.txt"> MailFormat.txt is a text file in your Web folder which can contain CDML tags, if you like. -- This is great as I've managed to get it right so far then, but what I want to do is have the value of the -MailFormat the same value as what a user inputs into TEXTAREA box on the form in the sa…

Ok what am I doing wrong the I got web companion running but when you click submit it takes 4 min to submit the form!!!! I have a G3 Blue and White with FM5.5 384mb ram. Running System 9.1.1 does anyone have an Idea on what I should do?

I post my DB on the web with web companion and I want to make a script or other thing to be able to link a file with a record and be able after to download it after I don't know how to do it I really need help! PIC

Is it possible to display the found contents of a field as a url in a web published database? I am using a filemaker 6.0 database with web companion, there is a field for users to input their favorite web pages, they use the full URL, such as http://www.apple.com and create a new record. Now when they do a search they find this URL but it is in text form and not a link, is there a way to display this URL as a link from the found data that can be clicked on and launched? This is for a class of 7th graders to share their favorite links, ideally they should do a seach, find a URL and click on it to launch it, now they find it but have to copy and paste it. The test da…

After doing a search for "name", the query will come back with all "name" results(10 found). What I'd like to do is have a hyperlink for "number" that will then resort those records found in first search "name", into a "number" sort. I've found some documentation that works, but the link will just find all records(30 found) and sort them to "number". I only want to resort my original found records (10). Any help would be grateful. BTW: here's a snippet for my code for the link: < href="FMPro?-DB=FigureOut.fp5&-Format=EndPage.html&-SortField=number&-SortOrder=descend&-FindAll">SortByNumberDescending</> BTW(2):My final resul…

Is it possible to preserve the formtting used in the FMP db when displaying fields using CDML? For example, I have a calculation field that computes the average of several other fields. In the FMP db I can format this field to only display 1 value after the decimal, but the CDML output file displays all the values after the decimal. thanks

Can anyone help? I am trying to display an email address from a db using an Inline Action. I need it to find the Email Address where the Customer and the Site equal the values stored in two tokens. My code below will not work and I am not sure what I am doing wrong? I think the problem area is to do with Customer={FMP-CurrentToken}, Site={FMP-CurrentToken:1}, and the way in which I have written the code. I have hard coded the values for Customer and Site and it works prefectly. I have tried writing it like this [FMP-CurrentToken] and this [{FMP-CurrentToken}] and this "FMP-CurrentToken" and this "{FMP-CurrentToken}" but with no success! Can anyone tell…

Hello, I

I am trying to build an online form to interface with a database (you can see the current version at <http://www.PaloAltoOnline.com/calendar/calendarform.mainform.shtml>, if you want). As you can see if you submit a record (just put TEST in the first field, none of the fields are really required), you are directed to a 'results' page that resides on the machine running the database file. This was (somewhat) easy and was not that big of a deal to set up. I would like to create a page that would allow the user to submit the form and then get to a page where they are presented with a summary of what they submitted (again not hard), but I want that summary to be ed…

Here is my problem: I have two databases. DB1 has a field with a calculation that creates available dates. DB2 has a field with a valuelist created from the related field in DB1. DB2 is served to the web using CDML. Every field works except the related value list nothing appears on the web site. This happens to be the most crucial part of the database. I cannot have a static valuelist because the dates change and can only appear if they are available. Everything works fine in the data files but not on the web where it needs to work. Any ideas would be greatly appreciated. Sherry

I'm trying to perform a numeric compare. Here is my code: [FMP-If: RangeEnd.neq.CurrentFoundCount] <form action="email_next.asp" method="post" name="NextEmail"> <td><input type="submit" type="button" value="Next >>"></td> </FORM> [/FMP-If] No matter what I do, the above does not work unless an actual number is on the right side of the compare operator. Both variables contain numbers. I'm at a loss as to why this doesn't work, and how to work around it.

This may be a really stupid question..... I was testing my solution. I got to the "search" page where I have a blank that they are suppose to input a "password". I accidentally clicked on the Find button without putting in a password and it retrieved absolutely everything in the DB. I was really shocked! So, it goes and gets everything regardless of whether or not something is in the password field?:?: Am I just missing something in my code to prevent this? The search is supposed to only retrieve the agency's record for FY2003 and the one that matches the password. The part of the code that's relevant is below: [color:"blue"]<form name="myf…

Thanks to gary i could get a start with a code to create multiple records in one submit. The code looks likes this: <script> function subForms() { nAllForms = document.forms.length; for (i=0;i<nAllForms;i++) { document.forms.submit(); }; } </script> Hello World <BR> [FMP-InlineAction: -db=test.fp5, -lay=L1, -FindAll] [FMP-Record] [FMP-Field:Key]<BR> <form action="FMPro" method="post" name="controls[FMP-CurrentRecordNumber]" target="frame[FMP-CurrentRecordNumber]"> <input type="hidden" name="-db" value="test.fp5"> <input type="hidden" name="-lay" value="L1"> <…

Does someone know where I can find a tutorial for using Lasso Tags ? LVA

hi Guys! Here is another VERY concerning security new: http://www.securityspace.com/smysecure/catid.html?id=11586 Category: Remote file access Title: FileMakerPro Detection Summary: connects to port 49727 and says 'hello' CVE: Not Available Bugtraq ID: 7315 Description: The remote host is running a FileMakerPro server on this port. There is a flaw in the design of the FileMakerPro server which makes the database authentication occur on the client side. An attacker may exploit this flaw to gain access…

Hello People! I was wondering if there is a way to capture-redirect user if one tries to update a unique field. Eg. Update PO#....IF new PO# not in use update it ok...but IF it IS in use ....the respond I get is "Can't find Format_file_name.html ". I know that : [FMP-If: CurrentError .eq. 504] will capture this process If I try to add a new PO that is unique....but what would be the error for Update! Thank you All!

Using FMP 5.04 on Mac with Instant publishing enabled. No user access restrictions implemented. When selecting "Submit" after editing a record, receive the message: Field Access Restriction You do not have access privileges to perform the action: Edit Any ideas?

I have a field in my database that uses a field value list using checkboxes and in my CDML page, I use a FMP-ValueList to display the field using checkboxes as shown below: [FMP-ValueList: normal_edition_type] <input type="checkbox" name="normal_edition_type" [FMP-ValueListChecked] onClick="if(this.checked){unCheckSpecials();}">[FMP-ValueListItem]<br /> [/FMP-ValueList] Everything appears fine and great but for some reason when I try to update the record with a change in the checkbox such as unchecking all of them, the field in the database still shows the value that it had prior to the update. All other fields a…

I apologize, this is probably a basic question, but I couldn't find it in the first 4 lists of forum questions. We have FileMaker 5 and only just started using WebCompanion. The table and form views shown for each record show ALL of the possible values for fields that have multiple-choice entries (e.g. radio buttons, check boxes, pulldowns). How can I make WebCompanion show ONLY the entry chosen for this record? Example: field has two radio buttons, Yes and No. Both Yes and No appear for that field for record #1, even though the record was entered with only "Yes" checked. In the equivalent FileMaker view, both choices are shown but the radio button ALS…

I have a search result page displaying several records using CDML. Is it possible for me to select 3 records from that page using checkboxes and displaying a detailed record of those 3 randomly selected records. Can anyone help me please!!!!

With the help of Beverly Voth, from Moonbow Software I could finally draw two drop down conditional menus using javascript to call a source document wit the arrays previously created. Now I can see the "makes" and "models" in the search form with the other CDML search tags but when I submit the selected values FMP ignores the "makes and models" selected options. How can I point the selected values in the javascript menus to the correspondent field in the DB? Thank you

How can I get the following to work? [FMP-LINKPREVIOUS]<a href="" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('previous','','images/arrows_01b.gif',1)"><img src="images/arrows_01a.gif" ></a> [/FMP-LINKPREVIOUS]

I am trying to use Web Companion to publish an fp3 file. The records seem to be available, but when I use the search page, there are no input fields--just the drop-down "contains/does not contain". Any idea why I cannot enter a search? (Using FMP 4.1).

Hi I want to be able to simulate a 'Sub-Summary When Sorted By...' on my results page. I want them sorted and summarized by category ie. Cat1 record record record Cat2 Record Record..... etc I was adivsed that this could be done with a java script, to do the summarizing, post CDML processing. Is this possible? Does anyone know of such a script?? Be cool Halbj

I have a format page that has three consecutive inline actions. This format page works well in FMP 5 Unlimited but causes my server to crash in FMP 6 Unlimited. I'm runnning this on a G4 Mac using ASIP 6.3.3 with Eudora 5.1 as my mail client. Any and all help would be greatly appreciated. Here's the code: [FMP-InlineAction: -db=requests.fp5, -lay=Form View, -mailto="{FMP-Field:Email}", [email protected], -mailsub=Thank You, -mailhost=mydomain.com, -mailformat=thankyou.txt, Email_Sent="True", -RecID={CurrentRecID}, -Edit][/FMP-InlineAction] [FMP-InlineAction: -db=requests.fp5, -lay=Form View, [email protected], -mailfrom="…

hello People! I know this might not be news to some but I just though of using this function. LogOut user (close the frame or window) after an X amount of time! Someone else might benifit from it so here it is: adjust your "minute needs"! Another approach would be (if you are using cromeless windows) is to redirect user to either blank-not important-page or Login page by using: where user is redirected to Login page after x (60 here) seconds There my little contribution

In some HTML Selects inputs, the associated value is different from the one shown to the user in the list. i.e. <select name="test" size="1"> <option select value="somevalue1">Test1 <option select value="somevalue2">Test2 <option select value="somevalue3">Test3 </select> How can I use the value that is different from the list that is shown to the user. What I have is a FMP-Option showing the filenames and I want the value of the select to be the filename uniquie id number. Is this possible since FMP-Option already creates the <option tag>

I have an image for each file in a museum database, sized for single-page view. I'd like to include a thumbnail version in a report form. Applying fixed width/height values will distort them, since some are tall and some are wide. I tried % values, but that's interpreted as a percent of the size of the cell. Any ideas on code for proportional resizing or else "locking" the cell size to constrain the images? Thanks again! Ernie

In the help of my FilemakerPro 5.0 there in no mention of CDML. Is it some sort of secret only the chosen few should know? I also have the Developer edition as well as Unlimited. Are there any online tutorials? Where can I learn about basic and advanced CDML. After searching for awhile I found out that CDML means: Claris Dynamic Markup Language. Oh wow, now what do I need to do? Is this included in an Evan y of the mentioned packages or is it a separate purchase? Is there a web site I can go to get official info about it? HELP! Evan