Other Internet Technologies
Discussions on various or otherwise legacy and deprecated web technologies.
Instant Web Publishing (iwp), .net, flash, ajax, fx.php, PHP site assistant, FMStudio Lasso, CDML
4,570 topics in this forum
-
In one of our databases the Web Companion plug-in box gets unchecked everytime the database is closed. Its a FM5 database running off of a FMServer. There are several other databases running in the same arrangement and this doesn't happen to any of them. Any ideas? Thanks, M.
-
- 2 replies
- 592 views
-
-
Hi, I've read up on the posts I could find regarding instant web publishing and entry into a portal. I have a database file that needs to be published via the web and needs to be resticted to the "data entry only" option. Needless to say this will not work. Some posters have mentioned work arounds for this problem. If anyone could elaborate on them here I would be greatful. I have a moderate knowledge of filemaker and html.
-
- 2 replies
- 647 views
-
-
I need to pull a date field out of FM5 in the format dd/mm/yyyy - which is the format it's stored in thge database. however, any leading zeros are being stripped ie 02/02/2003 become 2/2/2003. Is there any way to force the correct format ? Dazzjazz
-
- 2 replies
- 575 views
-
-
I have been using the following CDML send mail redirect for weeks now. All of a sudden it stopped working and I have changed nothing. I am using the CDML send mail on two different database actions and the both stopped working. I am left scratching my head on this one. Any ideas? <HEAD> <META HTTP-EQUIV="refresh" content = " 1; URL=FMPro?-db=cases&-lay=dr&-format=order_upload.html&-mailto=[FMP-field:dentist_info::email]&[email protected]&[email protected]&-mailsub=Your_SmilePix_Order&-mailhost=pop.bstn.qwest.net&-mailformat=mail_order.txt&-recid=[FMP-Currentrecid]&-Find"> </HEAD> …
-
- 2 replies
- 536 views
-
-
hey, all. i recently learned about these modifiers to [FMP-field]. i was able to get the break modifier to work, but i'm having trouble getting the HTML modifier to work. i typed it in as [FMP-field:nameoftextfield, HTML], and i assumed that all i needed to do in the individual record was to type something like blah blah blah <b>blah</b> for it to work, but it didn't. i also tried the <strong> tag. is there something i'm missing? also, what kind of html tags am i limited to? any help will be greatly appreciated. thanks!
-
- 1 reply
- 532 views
-
-
tia for the help. i have a database called teacher.fp5, which has 80 records in it. each record has the following text fields: welcome, schedule, assignment, contact, and myclass. i also have two other text fields, named teacher and recid. i used the instant publishing to set up a web site where the teachers can locate their particular file and update any one of those fields. that was great! now, each teacher has their own web site with the following pages: welcome, schedule, assignment, contact, and myclass. i want the welcome page for Mrs. Johnson to pull out only the welcome text field information from her record; i want the schedule page to pull out only t…
-
- 18 replies
- 1.5k views
-
-
i am creating an online order system for the company website and at the moment it all works fine. it fairly simple with just three tables running the whole thing (user , user items and catalogue) i only have one small problem. the inline actions to check the users cart for reports in the list. at the moment the user come into the shop and is automatically given an ID num and a new row is created in the user table, the id num is passed from page to page via a token, once they are in they are presented with a search page of our reports. the result page has an inline action at the end of each row searching the cart for any rows with the user id num(in token 1) an…
-
- 3 replies
- 493 views
-
-
I seem to recall doing it, however, I can't seem to remember how ( I can hear the snickers now). I have a value list in a database that is from a related file in another (ie. Value List Name = Name, Source = From Relationship, Values = Field: "Database::Field Name" I can't remember how to write the FMP-Option values to access this Value List. Thanks in advance.
-
- 0 replies
- 441 views
-
-
I am a newbie. I am having trouble trying to run a script. If done correctly it will open e-mail on the client side and automatincally send email. It works on the database side now but not with the web page. I have tried using the CDML code below but it doesn't work. <INPUT TYPE="hidden" name="-Script" value="Send FO"> Is there something else I should be adding?
-
- 6 replies
- 771 views
-
-
Hello Folks, I know that there is a tag of sorts that types in asterisks or another character, in lieu of the actual characters being typed (when the user is inputting his/her password on a web) but I can no longer find it. Does anyone know what tag (or attribute probably) to use?
-
- 7 replies
- 688 views
-
-
just a quick question is there any way i can make a text field mandatory for a user to fill in before they can submit a form for an edit or search Cheers
-
- 2 replies
- 552 views
-
-
In the bottom of my resultpage (a single record found) I would like to place an Inline-search for simular records based on the result of the first search. Something like this: [FMP-InlineAction: -db=db.fp5, -lay=cgi, subjekt=[FMP-Field: subjekt], -Op=eq, -max=5, -find] I know I can
-
- 6 replies
- 750 views
-
-
I think I found a loophole in the Web Companion. When I was playing around with the Claris HomePage Assistants, I saw that the program was able to dowload the entire list of open databases on any server, a list of all the layouts in any database specified, the field names of all the fields in a specified layout and also any related list values. Being the inquisitive programmer that I am, I fired up interarchy to see how it was doing this. I saw that it was sending out some inline CDML that I had never seen before. To access all the databases it was going to: http://thehost/FMPro?-dbnames For the Layouts it was accessing: http://thehost/FMPro?-db=[DATABASE-NAME]&…
-
- 84 replies
- 8.4k views
-
-
First i would like to say that i have been trying to learn cdml and have found these forums to be of great value. Now on to my question. I have database where the user can preform a range find. Hear is what my code looks like. <TD ALIGN=LEFT VALIGN=TOP> <input type="hidden" name="-Op" value="gte"> <INPUT TYPE="text" NAME="ID" VALUE="" SIZE=2></P> </TD> <TD ALIGN=LEFT VALIGN=TOP> <input type="hidden" name="-Op" value="lte"> <INPUT TYPE="text" NAME="ID" VALUE="" SIZE=2></P> This produces two fields on the find screen and works great. The problem is if …
-
- 4 replies
- 518 views
-
-
hi, I have 2 related db's that share info over the web. All works fine, th eonly thing I dont get working is a list of the most frequent users. I want to see a list of the 5 frequent users when I open the main page with -findall. How do I set up a calc/sum field to 'count' records per users, and remembering the best 5. So it will be like a top 5 on the mainpage. The trick to do this (wich I don't get) is to make FM to calculate something without a fixed username (since anyone can signup and become a user). Anyone familiar with this? Thx
-
- 8 replies
- 766 views
-
-
can i set a token to the [fmp link] tag in a link if so, how please help
-
- 6 replies
- 812 views
-
-
i have my profiles up and running in cdml which works great, but the profiles show all the visit reports and business contacts related to each profile in portals at the bottom of the page. i want to know if its possible to edit these related record. i want to be able to have a pop up window with the details in to edit. the pop up bit is fine it can be done with javascript. but is there a way that i can get a field from the portal to find the record. cheers
-
- 1 reply
- 470 views
-
-
Cookies are cookies, right? If another system sets a cookie, can I access it as an FMP cookie? DETAILS: I work at a university that has a campuswide authentication system through the web based on cookies (and tokens?). I want to use that authentication system for my FMP databases rather than my own but I have to be able to parse and check that cookie's data and send info to the authentication server. They provide cookie-processing programs for apache/perl/php but I'm using FMP/WC and want to use CDML. Any wise sages out there know if I'm doomed before starting and can save me some time and trouble? Any other recommendations (lasso or others)? Thanxalo…
-
- 1 reply
- 512 views
-
-
Is there a simple way to record who enters the database? I have a database on the web and would like to keep track of when my clients visit it. I could create a separate database where this information is stored if that is necessary. I know the logs are one way, but it is too cumbersome. What I would like to create is something like: Client name that visits and the date and time visited. Thanks in advance - Sam
-
- 3 replies
- 495 views
-
-
Can anyone tell me how many characters a token can contain?
-
- 1 reply
- 574 views
-
-
This might be a newbie question. Sorry if it's already been discussed. I'd like to build a general template showing a random book cover with a link to the book's record in the margins of every page in my website. For example, the Catalog results page should show the titles of the found books, and a cover randomly chosen. Any ideas?
-
- 2 replies
- 536 views
-
-
I am using corporate Internet LAN, and have FM 6 and my FMP 6 file open in Web folder and configurations done. I am trying to reach my file via a colleague's computer. How do I setup an address, do I need a static IP or is there another way to find out what IP address my computer was assigned. What would the URL look like? Thanks.
-
- 4 replies
- 1k views
-
-
I have a search page that is not in a frameset but I would like to return the results into a frameset but I can't get the results to show it only shows the cdml code. Any ideas.
-
- 6 replies
- 632 views
-
-
I recently created a database/web solution using CDML and successfully hosted it on my computer via FM Companion. But my company needed to have the website online all the time, so we selected a Filemaker hosting company and now the database is on their servers. Only problem is, they use Lasso. They told me that the only change I would have to make is change the form action to "action.lasso", which I did, and most of the CDML format files work fine, with one exception. That exception is that value lists that I'm calling dynamically don't work. The website has a page where our members can edit their own profiles. The non-value list fields, like "type in your name" come…
-
- 0 replies
- 608 views
-
-
My clients create a new record and on submit they are taken to a redirect page where an email confirmation is sent to them, they are then taken through the redirect page to a page where they upload a photo. Some of my clients are getting the FM Error Code #4 and are unable to proceed to the upload photo page. Most of my clients are having no problem and those that are, are using different operating systems so I am having trouble tracking down why it works for some and not others. Here is the code on the redirect page that sends the email (this is where the error code is showing up): <HTML> <HEAD> <META HTTP-EQUIV="refresh" content = " 1; URL=F…
-
- 5 replies
- 781 views
-
-
Greetings all, First let me say thank you for this fantastic forum and apologize for this long post. Over the last several days I've gone from knowing nothing about tokens to implementing them rather successfully by reviewing past threads here. A fantastic site! Clearly I've ran into a problem however, otherwise I wouldn't be here. I have a page called addtaxon.htm, which roughly looks like this: <form action="FMPro" method="post"> <INPUT TYPE="hidden" NAME="-db" VALUE="Faunal_Entry.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="Web Access"> <input type="hidden" name="-format" value="confirmtaxon.htm"> <input type="hidde…
-
- 2 replies
- 538 views
-
-
is it possible to query a second db from within an existing value list like below? I run into an 102 error format not found. <option value = "/fmpro?-db=calendar.fp5&-lay=pressroom&-format=pr results.html&-token=print date&-new"> Pressroom</option> ?? The value list was created to search a scheduling db and works perfectly on its own. The cdml/html for the calendar.fp5 db also works fine on its own. However it would be beneficial to have a common search frame to query both dbs. Calendar.fp5 is stricly for pressroom which is why i've placed the coding at that option value. The whole html appears below...I've…
-
- 9 replies
- 758 views
-
-
All I am looking for an example of a editable portal in a custom page. I have successfully created a simple non-editable portal on a record detail page but I have found that making this editable is quite tricky. Any suggestions or example code would be greatly appreciated Thanks Chris
-
- 5 replies
- 667 views
-
-
Ok... I've been trying to setup a database to be viewable via the web. Unfortunately there is not much help from FMP on this... Setup: FMP5 Unlimited & WSC-IIS OS - NT4.6a WS - IIS I don't know how to display a field's value on the web. This is driving me nuts! I've downloaded Brian Dunnings "CDML" Master Class which helped me alil' but I just can't get the ******* thing to work. I'm not sure if it's a setting or what! I've already set up the Admin to host that particular database. I've set up the database as directed in the WSC connector PDF. The Form properties are right... I tried creating a test, but nothing seems to work. I've got to…
-
- 10 replies
- 828 views
-
-
First of all I want to thank those that have helped me with questions in the past. This forum has helped me develop a database solution for my clients that would have cost me thousands of dollars if I had hired someone to do the work. The problem: I have clients that sign in to the database through the web to view their records and place new orders. When they place a new order they also submit a photo through an upload photo page. This upload photo page is not through filemaker because to my knowledge there is no way to upload files through filemaker. The upload photo page has a cgi form that after the photo is successfully uploaded takes the client to a success page…
-
- 8 replies
- 606 views
-
-
I am trying to get my search results format file to appear as a FileMaker layout would look with a sub-summary part in preview mode. ie Search results Category1 record1 record2 record3 Category2 record4 record5...... etc does anyone know a truly dynamic way of achieving this? I don't care if it is a mixture of html/cdml/java whatever. Cheers - Halbj **No Philosophical comments here**
-
- 2 replies
- 524 views
-
-
Got a strange problem here - I've seen similar posts on various forums, but haven't yet seen a definitive answer. I have a Filemaker database with a foreign field in the web layout I'm using. All this data displays fine on the web page via CDML - there's no problem there. The problem comes when I try to update the data in that field. I have two text boxes next to each other, in a form on the web page - one of which is a field "native" to that database, and the other is a foreign field. The Foreign field text box displays the value of the field (By setting the HTML "value" attribute in the <input> tag to [FMP-Field: Database::field]). However, w…
-
- 1 reply
- 449 views
-
-
How can I use the find statement to search both (Userid and password) fiels at the sametime.! -op= or -lop=??
-
- 13 replies
- 1.2k views
-
-
i set a token using the --- input=hidden name=-token value=[FMP-Field: Name] --- and it works just dandy... Problem is i need the token to work in a link and it's not... It's an auto refresh link, they enter their name and some other info and the next page uses that information to auto forward the user to a different page depending on what they entered in certain fields... we do this using a calculation field in the actual data base and in the code of the page (not the header) we have: META HTTP-EQUIV="REFRESH" CONTENT="1 ; URL=[FMP-Field: URLRedirect]" It always redirects just fine... so since now i need to set the token and PASS the token through the redirect,…
-
- 6 replies
- 628 views
-
-
I've sorted through the forum for an answer to this problem but have not found it...if this is a faq i apologize.. very simple...adding a new record with one field only (see below)...I click submit and encounter the ubiquitious Error 4. When I click the back button to return to the initial screen and click submit again, the -new request works fine and the correct format page is returned. Any thoughts... <html> <body> <h3>Enter Date Below</h3> <form action = "FMPro" method = "post"> <input type = "hidden" name = "-db" value = "Calendar.fp5"> <input type = "hidden" name = "-lay" value = "Pressroom"> <inpu…
-
- 3 replies
- 1.1k views
-
-
I have successfully completed a database/website for a client via CDML. The database is currently located on my computer, but it will be moving to a dedicated computer at my client's workplace. My questions is--knowing that the format files are located in Filemaker's Web folder--is there any way to get access to these via FTP from a remote site, such as my office? It worries me that these pages will not be "updateable" if needed. (I am a freelance web designer, and I'm used to being able to connect to any given website for updates as needed.) If anybody has any insight into this, it would be appreciated. Thanks.
-
- 4 replies
- 698 views
-
-
I've been flicking through the posts trying to find a plausable fix, and I think I've created one. I've managed to alter the WC with a hex editor, so that the -raw command (host/fmpro?-db=[database]&-format=-raw&find) doesn't work. What I'd like to know is whether this will create any problems? The WSC doesn't seem affected... I realise this wont affect -dbnames etc (Im guessing WSC probably needs this) but it's the main cause of alarm as it actually turfed the database contents. Tony
-
- 7 replies
- 882 views
-
-
Hey all! I have a login/password page which, when submitted, does a "-find" action on a database, comparing both the login and password textboxes to two fields in the database (login and password, respectively). My problem is that the "-find" action will allow anyone to enter the site who types in something similar into a login/password in the database. Is there a way to only find exact matches in a database? Thanks, C
-
- 7 replies
- 829 views
-
-
I am using FMP 5.5. I have questions about the webcompanion. 1) I want to share my db on a cd but don't want others to buy FMP to view the data. Will the webcompanion work without a host computer? Will it run off a CD? 2) Can I publish my db on the web just by FTPing my database to my ISP? If so, how? I can't have people accessing my home computer. 3) I set up the web companion but the only file that is in the WEB folder is the default.htm with the instructions. How to I get it to create a homepage for me? Or do I have to do that? and if so, how do I link it to the data? Kathy
-
- 1 reply
- 750 views
-
-
I have a database here that powers an online store. Some weird things are happening. (duplicate order numbers for different customers, etc.) One of the fields is named RecID and is defined as "Status(CurrentRecordID)". I seem to remember reading that this is a very bad idea. But I forget why. Why?
-
- 4 replies
- 574 views
-
-
See if anyone can solve this one: I have a working Search page, which searches a database of members by multiple parameters. What I would like to do is have a Search Results page that not only lists the members found from a given search, but also has a single link that when clicked, would be an e-mail link to all of the "found" members. Is there any way to set this up? I suppose it has to be some kind of dynamic field that is based on the search results of a particular search.
-
- 1 reply
- 534 views
-
-
I'm using the format file "search" from the CDML "employee" example database, and I've become stymied on the drop down menu. This is the code I have: <SELECT NAME="Taxa"> <OPTION VALUE="" SELECTED>All [FMP-option: Taxa] </SELECT> I'm trying to do a drop down menu using the field "Taxa" and the value list "taxa of expertise." But all I keep getting is one item on the menu bar that reads "All [FMP-option: Taxa]--in other words, the code is on the menu bar. I've tried to use the FMP-option code from the CDML database, and my HTML editor told me that that code was redundant in part, so no help there! Anybod…
-
- 13 replies
- 1.1k views
-
-
I have been doing some testing with FM and PHP. The PHP is standard on an OS X Server. I have been able to find data and edit records from a FM database using the PHP 'readfile()' function. Like this: <?php readfile ("http://10.0.1.2:1154/FMPro?-db=combotest.fp5&-lay=web&-format=hworld.html&name=bloggs&-recid=1&-edit"); ?> Hope this is of interest. Garry
-
- 14 replies
- 1.7k views
-
-
I am using CDML Record Navigation with FMP Link Tag on my web published database to allow my clients to browse their records detail page by going to the previous record and next record. My problem is this: when a client edits a record on the detail page, they are then taken to a page that tells them the record has been edited successfully. When they go back to the records detail page the option of going to next and previous record is gone and they have not been returned to the record they have edited, but are returned to the first record in the initial found set. Is there a way of returning them to the record they edited in he records detail page with the next and pr…
-
- 0 replies
- 491 views
-
-
hi everyone. i have my database online and i have some sound files that i want to publish online. now i have a field that will create the url automaticly. the server that i have is set up and it all works perfectly. the problem that i am having is i will be using an external drive to house the sound files. i just don't know how to point to that drive. right now the field is /sounds/"nameOfSound".aif from a folder from the web folder. any idea's? thank you everyone peter
-
- 2 replies
- 464 views
-
-
I have successfully put a FM database on the web using Instant Web Publishing. However, none of my merge fields show up when I view the database online. Am I doing something wrong, or do merge fields not work online? Can't find any information in FM's documentation about this. Any help would be appreciated. Thanks.
-
- 3 replies
- 869 views
-
-
have loads of custom soloution on the web using cdml and i am wondering if it is worth the move to ldml. i have heard a bit about it but want to know more, what are the benfits , what are the costs and the hardware required. i am currently serving the dbs from mac 9.2 through the web companion on a single g4. what changes need to be made to cdml. will it work on pc, we are currently phasing out macs to a minimum
-
- 9 replies
- 1.1k views
-
-
I have a database for my clients that I want to require two fields for them to sign in with (name and password fields). I would like to avoid using the Web Security Database for configuration reasons. What I have now is not working properly. All the client has to do now is fill in one of the fields to gain entry to the database. How do I create a login page that requires both fields to be filled in before allowing entry into the database? Thanks in advance for you help
-
- 4 replies
- 560 views
-
-
My database is being served by lasso, and I'm using CDML. There are some minor syntax changes when using portals, and I can't get an FMP-If statement to work. When using a portal, it would be incorrect to use [FMP-Field:PortalName::FieldName]. You would receive an error pointing to the double colon. Lasso recognizes [FMP-Field:"PortalName::FieldName"] syntax instead. When I finally got an image to display from a field, the syntax again was an issue. The html that worked was <img src=[FMP-Field:"PortalName::FieldName"]> and not <img src="[FMP-Field:"PortalName::FieldName"]"> OR <img src="[FMP-Field:PortalName::FieldName]"> So now my problem…
-
- 1 reply
- 631 views
-
-
I need some help with checkboxes. In my FM database, I have a field set up as a value list with checkboxes. When I send it to my format page via CDML, I would like the "checked" boxes to show up as just text results. I don't want checkboxes on the HTML page--hope that makes sense. I've tried to solve the problem by just using a regular [FMP-field: fieldname] tag (where the fieldname is the field that contains the value list) and that gets the result that I want, except all the checked items run together (i.e., "bacteriology" and "zoo medicine" are checked, and they appear on the page as: Expertise: bacteriology zoo medicine Maybe there is a way to format …
-
- 2 replies
- 597 views
-
-
I am just starting to get into learning CDML, after successfully posting a database on the web with IWP and finding the limitations. I have spent all evening trying to wrap my brain around how CDML works. (To little success!) Hopefully this isn't *too* dumb a question: I'm a little confused as to which format file will appear first when a visitor enters the website. I have my HTML page set up as a default for the web companion, but I'm not sure about the "name and path" of the format file to link to. How does one usually start this? I'd like the database/format file to first display a list of all the names in the database, but I'm not sure how to go about that. …
-
- 4 replies
- 830 views
-
-
I have not found answers to these questions in FileMaker documentation. I am hosting on a Mac, but I am assuming the answers would apply to both PC and Mac versions of FileMaker. I am hosting the database through the web and also tcp: 1. On a computer that is sharing the database does anything bad happen to the host database if the application freezes or the computer crashes. 2. If the host database is in the layout mode or Define Fields is open or the ScriptMaker is open, will the database still be accessible through the web? I know it is not if it is shared by tcp. 3. When I open the shared database on another computer, it always opens at a particular record, not …
-
- 3 replies
- 454 views
-
-
Hey all. What is the proper syntax to format the {currentdate} tag in an inline action request (in this case a -new)? I tried {currentdate:short} and got an error 500, invalid date format. Also tried {currentdate,short} but got an error 4, unknown command. For the second question, I am trying to display the contents from a date field, but force it to show in the format mm/dd/yy, however it insists on a 4-digit year date, even if it's formatted on the proper layout as 2-digit. Can you do something like [fmp-field: fieldname: short]? I know this doesn't work, but something similar? Both of these problems are a result of filemaker insisting on entering dates v…
-
- 3 replies
- 519 views
-
-
When a client submits an order through the web database I have created a redirect page that then sends an email to them to confirm their order. This is what I am using: URL=FMPro?-db=aureal.fp3&-lay=cgi&-format=reply.htm&-mailto=[FMP-field:Email]&[email protected]&-mailsub=Thanks&-mailhost=smtp.yourhost.com&-mailformat=mail.txt&-recid=[FMP-Currentrecid]&-Find" I would also like to get the email confirmation sent to my email so I will know that an order has been placed without having to check FileMaker. I tried this but it did not work: -mailto=[FMP-field:Email], [email protected] Is there a way to send tw…
-
- 3 replies
- 703 views
-
-
Is there anyting new on WC6? Is WC6 compatible with FMunlimited 5,5? Is WC5.5 compatible with FMunlimited 6?
-
- 1 reply
- 699 views
-
-
2 related DBs (recruit and visit), related by a serial # which is unique in the recruit database. When editing an entry in the visit DB, I am getting error 504 when the form incorporates any related fields from the recruit DB. The only field that would require unique validation is the ID field in the recruit DB, but that's not being altered in any way. I need the option to edit on this form certain fields in the recruit DB, and it doesn't make sense why I am not allowed to. If I try to do it manually in FMP, I am allowed to edit the related fields. Any suggestions? Bevin
-
- 6 replies
- 730 views
-
-
Does anyone know of a good reference for setting up Web Security? Peter
-
- 5 replies
- 669 views
-
-
I have a text field that displays notes on a certain item. I only want to display the first line of the notes on the general listing page. then when the person clicks through to see more details they wil see the entire text field. I can display the whole text field but don't know how to limit it when needed. Thank you, Dan
-
- 2 replies
- 523 views
-
-
I have developed an online progress report which stores student grades in an FMP database. Teachers have requested a checkmark as one of the progress indicators. I can't seem to get the checkmark to transfer from the web into the FMP database as a checkmark. It turns into an A with a ~ above it. Does anyone have scripting suggestions?
-
- 1 reply
- 859 views
-
-
hi there, here is a hard one, well for me anyway. i have a cdml page that has an input field for performing a find. so if you input an account number and press the find button it takes you to your found screen. is there a way take that account number pass on to an error page if the account number is not found. i want to it to say "sorry the account number "account number entered at search screen" is not found. please send an email regarding this record." i have tried to use a token but i have never used one before. Peter
-
- 1 reply
- 541 views
-
-
I have two databases. Let's call them database A and database B. Both have the first and last names of the same person. Database A holds all of the employee stuff like their addresses and bio stuff. B logs all of the times they clock in and out of the system. I have a list of all of the employees names from Database A using an [fmp-inlineaction] tag. But now I would like to have all the hours they worked during the pay period in Databse B appear next to their name in the list compiled using Database A. I know this works because I tried it, but it only works if I use the [fmp-inlineaction] tag to search for only one name on the list. It looks like this: [FMP-InlineAc…
-
- 14 replies
- 1.2k views
-
-
Need a lasso ower to help me make a Snapshot of my Data base File Its FmPro File. and simply eMail me the snapshot I have Lasso But hav had no Luck Trying to set the think up for the Wizard to creat snapshot ... TECK Suport Is Not that great with Lasso....So Can I hire a Lasso use to help me with this task WILL BE HAPPY TO PAY for this service. After I have the Snap shot I think I can take it from their. [email protected] THANK YOU [email protected]
-
- 0 replies
- 631 views
-
-
Hi there, is there a way to export records using CDML ? I need to enable "exporting" as offered within FileMaker ( a .tab file). Any idea ? I've been developing a solution using odbc and sql requests, but I was wondering if there existed a faster/easier solution with CDML. Thx, Jerry
-
- 3 replies
- 551 views
-
-
I am a beginner at CDML and have managed to get the Search, Results and Detail pages to work. However, I have one primary database with a relationship to another database. How can I get information from the "related" database to show on a results and/or detail page? I cannot figure this out. Is it possible?
-
- 3 replies
- 563 views
-
-
Hello, So I am a newbie here, and this might be an easy fix, but somebody told me once, when you get in a bind, consult the experts. I am running OSX 10.2 on my local machine, and 10.1.5 on the server. local machine has fmp 6 unlimited, and the server has 5.5 unlimited. I have built a type of registration system, that you go to a our site, login, and can register for classes. The form creates a new record in our request databse, then is supposed to generate an email, doesn't seenm to want ot work. I would like to have FM send a confrimation email to the person who registered, as well as the party that is admin. However it does not even send any mail, it does a…
-
- 3 replies
- 678 views
-
-
i have my solution nearly completed, apart from one thing which would make it ten times better. i have an online input system to add company profiles and contacts they have at the company. at the moment i have the profile up on screen with the contacts in a portal, when the user clicks on a contact to edit or add a new one a small window with a form to add the details pops open. at the mo once they save the changes it then goes to a screen in the same pop up saying cheers, close the window go back and perform a re-find to update the contact portal is there any way i can make the window close once they click save and then make the parent window refind the record to up…
-
- 4 replies
- 506 views
-
-
I'm new to WC, and can not get it to work, I'd appreciate any help. I'm using FM Pro 5.5, OS X.1.4. The instructions I have for TCP/IP say to set 10.10.10.10 for my static IP address, but when I put in http://10.10.10.10 in IE, I get an error message that says "A connection failure has occurred". WC is enabled in app prefs, using port 80, nothing else using port 80, document is open and sharing is on. Any advice? Thanks! Russ Conte
-
- 1 reply
- 683 views
-
-
Hi everyone, i have a database and all the fields are set to uppercase. in my html file i have this for every field: [FMP-Field: name, raw] i am tring to get the text from the records to be in titlecase like the database. thanks peter
-
- 6 replies
- 866 views
-
-
Hi, i have some pages that show the current month calendar when you go into them. I'm generating the url using SSI, so the code looks like: blah blah&-op=eq&monthlink=<!--#config timefmt='%B %Y'--> <!--#echo var='date_local'-->&-find which nicely returns blah blah&-op=eq&monthlink=october 2002&-find Can I use a Filemaker tag instead so that it's independent of the webserver? I can find [FMP:currentdate] and even [FMP:currentday] but I want a 'current month, current year' thanks, jeff
-
- 5 replies
- 503 views
-
-
I have a web based db that lists several items. I would like to be able to have the user send an email to me requesting more information on a particular record (item). How do I do this without entering more information into the database, specifically the user's email address. I know how to send emails form FMP 5.5 with a form etc. but I have always done that when adding a new record. I want the email to contain the FMP field for the item id, description, etc. Thank you in advance for the help. Dan
-
- 5 replies
- 551 views
-
-
hello, I want to set the field Date in the database with the value of current date. <FORM ACTION="FMPro" METHOD="post"> <INPUT TYPE="hidden" NAME="-db" VALUE="Main.fp5"> <INPUT TYPE="hidden" NAME="-lay" VALUE="main"> <INPUT TYPE="hidden" NAME="-format" VALUE="mainmenu.html"> <INPUT TYPE="hidden" NAME="Field1" VALUE="Done"> <INPUT TYPE="hidden" NAME="Date_field" VALUE="[FMP-CurrentDate]"> </FORM> but I receive the error "your attempt to edit failed because of the following error:" then a scroll bar which I cannot scroll so I cannot read it. The field Date_field is a date field. …
-
- 4 replies
- 926 views
-
-
Hi there, i have a database and all the fields are set to "title case". when i do my html and call the info from the field it's in lower case. i have the field tage set to "raw". any ideas? peter
-
- 2 replies
- 762 views
-
-
i have a layout on filemaker that contains a few check boxes and radio groups. i am trying to recreate this in cdml for people to edit online. but i am not sure how i can get the check boxes with the current values already in them, i also want the check box to change by what is in a value list (if poss). is there any way to do this, at the mo i just have text boxes which won't constrain them to particular values
-
- 1 reply
- 521 views
-
-
I am using the recid as a token when he first entires the site, because this is needed when the user orders products (as a relationship in a portal). this token is used troughout the entire site so that it can follow the user, but if the user ads the page he is on to his favorits in his browser the string will be automaticly copied. The user finishes the entire process in the site (buys products).(the token will then be deleted). How can I check if the the token(recid) is still there in the database. I had a idea; < body "[fmp-inlineaction:-db=otherwhererecordismade, -lay=otherlay,-recid={fmp-currenttoken},-find][fmp-if.currentfoundcount.eq.0]onload…
-
- 1 reply
- 451 views
-
-
How can I change the url in the browser so that the user cannot see the url or sees a different url!
-
- 1 reply
- 521 views
-
-
what is the need for the username on login to a web hosted db apart from displaying the name to welcome the user or mabye using it in searches to find the records they have added in their name. but as their is no security check on it and as long as you put in a correct password they will open the database regardless of username. what is its point!!! just a thought i had
-
- 4 replies
- 561 views
-
-
I am ticked off... I just tried emailing from the web companion in FM5 unlimited (classic mode) and it works fine. However the FM 5.5 unlimited under OS x doesn't work... ideas on what broke?
-
- 9 replies
- 1.1k views
-
-
Hi, Have web site that has 3 sections, each time user completes section sets a field in FM to that section is complete. I'm currently passing the recid token. Can I pass the date as well? Would like to pass the date each section is complete to FM. Any thoughts? nati
-
- 1 reply
- 473 views
-
-
Dude, Is it possible to customize the Web Security Database? Or else, have any of you ever tried doing so? I want to put in some scripts in it to automate few things. The thing is if you have couple of databases and you want to share all of the for a specific set of users - it's kinda cumborsome to reenter everything for every new database. Just wonderring if Web Security database can be modified and have any of you ever tried doing so. If so, how much?
-
- 1 reply
- 710 views
-
-
Been reading the CDML reference guide as well as posts here. I am still a little lost on checkboxes. What I was trying to do was include a checkbox in my form layout on my web page. The checkbox on my filemaker layout is a simple "Yes" checkbox. I want the checkbox on my html form layout to show up as checked if it is checked in FileMaker, and to not show up as checked on the web page if it is not checked in FileMaker. I have played around with some code (the checkbox is part of a table) <tr> [FMP-ValueList: specs images, List=Yes] <td width="234"> <div align="right"> <input type="checkbox" name="specs images" value="[FMP-ValueListItem]"&…
-
- 6 replies
- 632 views
-
-
Even though I have been working with CDML a lot lately, I never had to do this: How do I compare for two fields being equal in {FMP-IF] tag? Do I do? [Fmp-IF: field1 .eq. field2] ....... [/FMP-if] Or do I do? [Fmp-IF: Field:field1 .eq. Field:field2] ....... [/FMP-if] I have tried both and neither works... SOS
-
- 2 replies
- 546 views
-
-
I have a projects file with a calculation field that is a container that displays an image from a pref file based on the calculation. Everything is fine in Filemaker but will not display on the web. If I create a container field and run a script to set the calculated image into it that field displays fine. I am assuming that because the calculated image is unstored it will not display. Is there anyway to store the calculated image so it will display or is there a better way of doing this? Thanks, Wayne
-
- 4 replies
- 678 views
-
-
I have my update page working, and it updates added checks in check boxes, but it doesn't update when checks are taken off. Has anyone seen this or know how to solve it?
-
- 2 replies
- 637 views
-
-
i would like to recieve data into one record from another web site that is using cgi to submit their forms. at the same time they submit the info to their db, i would like to have the same fields submit (-new or -edit) into a filemaker db. any experience with this? thanks.
-
- 7 replies
- 731 views
-
-
I'm having trouble with the following code All Subjects All Grade Levels: [FMP-ValueList: ] <input type="checkbox" name="All Subjects All Grade Levels" value="[FMP-ValueListItem]" [FMP-ValueListChecked]> [FMP-ValueListItem]<br> [/FMP-ValueList] I'm writing an update record interface and the browser is ignoring the CDML tags completely. It prints All Subject All Grade Levels and then nothing. It works fine with text fields, but it's having trouble with check box fields. I am serving this with FMP/WC. Thanks for any help Bill
-
- 1 reply
- 681 views
-
-
I stumped... Suddenly the email functions in our database stopped working. We checked and the smtp server is still working. We tried other methods of email that seem to work... only filemaker 5.5 unlimited is having problems sending email. (on a Mac under OSX) Here is the code from the web page <FORM ACTION="FMPro" METHOD="POST" NAME="checkoutform"> <DIV ALIGN="left"> <P><INPUT TYPE="hidden" NAME="-db" VALUE="PUB_WebOrder_.fp5"> <INPUT TYPE="hidden" NAME="-format" VALUE="thanks.htm"> <INPUT TYPE="hidden" NAME="-error" VALUE="checkout.htm"> <INPUT TYPE="hidden" NAME="-lay" VALUE="ForWeb"> <INPUT TYPE="hidden" N…
-
- 8 replies
- 806 views
-
-
When I submit a form from the web, I get an error that my reply file cannot be found, but it's in my web folder. The path is correct and when I type it's actual url in I get the reply page up. I have this working on another database so I'm not sure what's wrong. I'm still new to the custom web interface thing and with CDML and I thought I had a handle on it 'til now. Has anyone seen this before? I think I have all my hidden fields set up right. Bill
-
- 4 replies
- 615 views
-
-
Ok, I think I've solved the problem of the sumbission by taking all the check boxes out of the form. My syntax is wrong. I used the CDML tool to create compatible check boxes, but the CDML tags are showing up on the html document. Is there some header line that needs to be included to make the CDML extensions recognizable? How do I hide these tags? Bill
-
- 1 reply
- 453 views
-
-
How would one make a table using portal records that has 3 columns and multiple rows as needed? I've only succeeded in making a table 1 column and multiple rows OR multiple columns and 1 row.
-
- 8 replies
- 715 views
-
-
How would one make a table using portal records that has 3 columns and multiple rows as needed? I've only succeeded in making a table 1 column and multiple rows OR multiple columns and 1 row. (1 record per cell.)
-
- 1 reply
- 566 views
-
-
Thanks to inputs from this forum I've been able to successful build a value list from a another database using FMP-InlineAction. Now I'd like to be able to select a default value in the value list based on the current value for the field in the record being edited. So my question is, in the code below I use the literal value "2" for my FMP-If comparision, but what I really need to do is compare to the value in the field of the current record in my database being edited. I just don't know the syntax to refer to a field in this database once inside a InLineAction tag. Hope this is clear and any suggestions are of course appreciated. <SELECT NAME='ge…
-
- 8 replies
- 733 views
-
-
hi there, i have a simple database. one of the fields is a url to a file. this url is created by a calculation. in my html file i have this calling the info: <a href="[FMP-Field: sound link]">Sound Link</a> the only problem is there will not always be a link, but it will still be clickable. any help? Peter
-
- 2 replies
- 494 views
-
-
CDML Reference in FM Dev 5.5 says the following in describing [FMP-IF] tag: First parameter: The left side of the operator. Can be one of the following reserved words: Boolean comparisons CanDelete - Do password privileges allow for deleting records? CanEdit - Do password privileges allow for editing records? CanNew - Do password privileges allow creation of new records? IsSorted - Is the database currently sorted? Please Explain.. Specially whether the password privilege means password for the user or password that the database was opened with in FMP. Also, Has anyone used these parameters?
-
- 2 replies
- 530 views
-
-
Hi to all, I serve a custom web publishing with Fmp Unlimited 5.0v3 on win2k Server box. I can access the site fine from pretty much any os/browser combination BUT Mac OS X ! Using either Internet Explorer 5.2 or Netscape 7 I cannot access the site... it stalls on "sending request to <<ip address>>". The previous page does not even disappear. Anyone knows what I'm doing wrong ? Any help is greatly appreciated ! Thanks.
-
- 3 replies
- 691 views
-
-
I have created a table that displays a row for each record. It works fine execpt that it creates a blank row with a ">" symbol in it for each record it displays. So if I have 9 records in my table, it begins with 9 rows of ">", then displays the 9 records properly. Here is my code: [FMP-Record] <tr> <td valign="top" width="105" height="124"> <p>[FMP-Field: First Name]</p> </td> <td valign="top" width="137"> <p><img src="image/[FMP-Field: websitetphototitle1].jpg" width="94" …
-
- 1 reply
- 523 views
-
-
Does anybody have the exact syntax required to do a FIND based on 2 or more pop-up lists? I have two pop-up lists on my website. The first has the following code: <select name ="select" size="1"> <option>choiceone</option> <option>choice2</option> <option>choice3</option> </select> The second pop=up list has this code: <select name ="select" size="1"> <option>apples</option> <option>pears</option> <option>grapes</option> </select> What code do I attach to a "search" button so it will search on the two selections above? Thanks
-
- 3 replies
- 531 views
-
-
what is the best way to setup a hompage for filemaker? If my domain name is pointed to 1.1.1.1, what is the best way to have that page with a search form on it to work so that is know to search 1.1.1.1:591/folder/ I tried to set the form action to ":591/folder" but it put a slash before the ":".
-
- 6 replies
- 988 views
-
-
For some reason my -db value does not end up in the search string when executed on a PC but on the mac it is fine. (hosted from FMP6) <form action="FMPro" method="post"> <strong>SEARCH</strong> <input type="hidden" name="-db" value="Client_Accounts.fp5"> <input type="hidden" name="-lay" value="Edit"> <input type="hidden" name="-error" value="result.html"> <input type="hidden" name="-format" value="result.html"> <input type="hidden" name="-LOP" value=AND> <input type="hidden" name="-SortOrder" value="Ascending"> <input type="hidden" name="-SortField" value="ac_CompanySortName">…
-
- 2 replies
- 530 views
-
-
Hi, I'm new to Filemaker so I need all the help I can get. I've created two related databases to keep track of my foreing exchange orders and my bank loans (which are mostly used to finance international purchases). Anyway, I designed the relationship so I have one layout that shows the international purchase detail, (supplier, country, items, etc) and a portal within with the financial information about it, which includes the loan amount, currency, bank, etc. In FM, whenever I click in the portal, it goes to the "Banks" database and displays the related record. So far so good. Until... We only have one license for FM, so I share the database over the intranet. …
-
- 4 replies
- 853 views
-
-
I need your help! Using CDML, a web-user can create a new record in the database. On submit, a script is run that finds all the records in the database that particular user has created and using a loop, edits each record in a certain way. My question is...while this looping, going to the next record and field modification is going on...if a different user visits the site, runs the script, could there be any mixups between the two users doing things simultaneously? Thanks!
-
- 10 replies
- 666 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online