Other Internet Technologies

Hi everyone We have just launched our new extranet site for our business to business clients. We have produced it entirely using FM7 and IWP. Below is a movie demonstration of the site. It uses many of the work arounds and advice provided through this forum. For all those that have posted to this site over the past 6 months - thank you. http://propertypa.com/Resources/Video/Intro.html Regards Neil

Just curious if it is possible to integrate Flash in Filemaker. Is this a new forum. I have not seen a single post in here How is this done. Using PHP and filemaker or some other way? I wished I could use filemaker in the place of MySQL somehow. Though they say MySQL is powerful, I found it extremely difficult to use from the commandline.

Via IWP, I'd like to allow a person to create a new record, and have a few chances to edit it before the session ends (they logout or time-out). I want to make sure, however, that nobody can accidentally (or maliciously) view or edit another person's records. Has anyone come up with a simple yet robust solution for IWP? I really wish there was a Get(IWPSessionID) function! Since there is not, I'm consider some other ways of doing it. What about storing the record creation timestamp, and the Get(SystemNICAddress) value, and then setting custom record access using a formula with the current time and current SystemNICAddress. This would, in theory, limit…

We recently started using Lasso to connect to FMSA and we have searching and listing records working, but how do I get the username and password dialog to appear and then authenticate with Filemaker security? If someone can just get me pointed in the right direction or just post a quick example - I'm having trouble finding where to even start to figure this out. Much thanks, -Dan

If, in FileMaker, I have two valuelists, eg Section and Subsection, I then make a valuelist with the values of Section and another with the related values of Subsection (Using a relationship Section=Section), then I can enter Find mode, choose a section from the dropdown valuelist then choose in the subsection field from only the subsections that are in that section. How do I do this on the web with a Lasso search page? I presume some processing needs to happen in between the Section being entered in order for the subsections values to be updated? Thanks for your help

I know that FM can be connected to Dreamweaver through fxphp. But this is very complicated. On my own website we use fxphp to be able to use FM (www.sevag.com). But for this I need a specialist to do the fxphp stuff. Is there a chance that we who are using Dreamweaver as main tool for web design one day will be able to "connect" to Filemaker just as easy as we can do with MYSQL today? I am sure that the DW - FM connection would be great for many of us, and would probably bring many new users to FM. Any comments? Best regards from Oystein

I have a formatted Radio Button Set that is two colunmns. However, when I publish it to the web, it runs the choices together not formatting them. Is there a way to preserve spacing and formatting when publishing to the web?

I am using a Password field with CDML and I cannot get FileMaker to return an exact match. I've tried a few different things, but this is the code I have right now: <input type="hidden" name="EIN" value="=="> <input type=text name="EIN" id="EIN" value="" size=30 class="monospace" tabindex="1"> <input type="hidden" name="-Find" value=""> <input type="submit" name="-Find" value="Submit"> I've tried an op=eq tag, with and without an id parameter in the text input field, etc. Can anyone see what I might be missing? Thanks!

This article: http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=408 says basically that under IWP, the "Open URL" script step will fail if there are any javascript or popup-blockers in use. Since a large percentage of users are using popup-blockers, this basically means that the Open URL script is next to useless. I think this is ridiculous! FM's suggests that you ask your users to disable their popup blockers is not gonna work in the majority of circumstances. How hard could it be for FM to just put a standard HTML <A href=...> link in the page's html? Even a javascript location.href= xxx command should work, as…

Hello all, I have a database that keeps on crashing when people access it via the web. I have not been able to narrow down the problem yet. I can't tell if it's the CMDL stuff or the database itself. I know this is a bit vague, but can someone suggest some trouble shooting steps? when it crashes it won't open up via the web, but it's still open on the Filemaker server and all of the other database work via the web. Thanks, Jaser

Is it possible to construct a URL into a IWP database so that the database can be opened on a particular layout with a particular record or set of records displayed? In effect, the URL would open the IWP database, run a search on one or more fields and display the results of the find. Or will I have to resort to CWP?

Hi All, Thought this would be easy, but I can't work out the elegant way to acheive it. I have a drop down list which contains all my field names. Using this, my users can select the field they want results to sort by when submitting a form. Easy. My problem is that the field names don't translate to human readable format. eg. I have a field called "serialNumber", but I want the list to show "Serial Number". Or worse, field is "sites::siteCode", list should display "Site Code". I could use if statements, but I'm sure there must be a more efficient way. Appreciate any help! Cheers...Sean.

Hi I've created a database and I've created some custom CDML pages. And it is driving me mad. The form works fine but there is only one problem. When I fill in one of the fields and hit enter something strange happens. In safari i get the result as you would expect but in Internet Explorer I'm redirected to the error page i defined. When I press the search button in Explorer, everything works fine but when i press enter it won't. Even stranger, this page is an adaptation of a page i made for another database, and this one works perfectly in both safari and Explorer. I've tried almost everything that I could come up with... I've changed the names of the fields, tur…

Hi, I don't know much about FM yet, but i'm working on it. I'm working on a program that will run on both mac and pc and when a person first opens it, it will go to an asp page and verify the user in SQL or MYSQL. I'm ok with the asp part and SQL but how do i send data to the asp page from FM and then also return the results to the FM program. I know there has to be a post out there somewhere but again i don't know FM that well at all. any suggestions or sample code would be great . thanks in advance danny

Hey everybody, hope you're having a good friday. I've been publishing my databases using IWP for about a month now and this morning when i restarted the host computer and opened filemaker, it gave me a dialogue box saying that FM couldn't publish on the web because of a port conflict and asked me to change from port 80. this would be okay, but i've configured my router to forward to the host computer on port 80 and don't want to change that if i don't have to. is there something else i can do? any reason why it so abruptly said that it couldn't publish on port 80? your help is very much appreciated. thanks.

I am very new to using Lasso and am in the process of moving our site over from CDML. I hope someone can help with this query which I also hope is a basic one: Two databases, one where each record is an Event; another where Client creates a New Record as a Booking for one of the Events in the first database. Scenario: Client browses Events database, then has link to an "Add New Record" page in the Booking database, with two of the fields from the record they were looking at Events database having been entered into two of the fields in the Booking database. I could possibly call a script in FileMaker (set Global Values to two other fields etc.?) but how do …

We ran into a problem today. Our IWP database gets display garbage if someone tries to "scroll" through records too fast. (using the book to move to the next set of 25) It doesn't clear unless you go to a different layout and come back. It displays the right data, just in the wrong place. I've attached a screenshot. It only seems to happen when in list view, and if you click to move ahead while it's still drawing the current set.

Have a searchable database on the web using FMP 5.5 and CDML The original search page works fine but I now need to make an amendment. The present page has a -LOP setting of AND because the search can be refined by searching in more than one field as thought necessary. The fields are Town - with user text entry of a full or part name County - selected from a drop down list Postcode - with user text entry of full or part postcode All this works with no problem at all and returns the correct entries. However I now need to also find a record which cannot be found by by using the above search parameters but has a specific entry in another field. I…

I'd like to include an image file stored in a FileMaker container field, 'schoolimage', in a FileMaker database, 'Schools' on the record detail page. So, following the description in Omnipilot's language guide, I have created a file, 'schoolimage.lasso': ********** [inline: -Database="Schools", -Table="Schools_online", -FindAll][Records][Var: 'Bytes' = (Database_FMContainer: 'schoolimage')]...[/Records][/inline] [inline: -Database="Schools", -Table="Schools_online", -KeyValue=(Action_Param: 'ID'), -Search][File_Serve: (Database_FMContainer: 'schoolimage'), -File='schoolphoto.jpg', -Type='image/jpeg'][/inline] ********** and then put an image link on t…

ok folks, i am a complete and utter novice when it comes to dreamweaver, but our company (a newspaper)'s website is done in this program, and we are keen to create an online directory of our advertisers which needs to be dynamic. i have read some stuff in dreamweaver and understand that it is possible to link the website to our database using a database driver and application server and various other things i'm getting to grips with, but first of all, i wanted to make sure our database has the capacity to share data for an unlimited number of web users. we are only using filemaker pro 7, no developer or server software at all. will this work? if not, would the nex…

I thought I posted this question yesterday but it doesn't seem to show up! I have a question about using FileMakers Web Security Database. I want to have two different types of logins for one database. I want All Users to be able to login and browse the database but not be able to change anything. Then I want another set of users to be able to login with a login id and password such as Twinky/Twinky and those people will be able to browse, add, delete, etc. I tried to do this in the Web Security Database for this particular database, but when I try to enter the database, it automatically takes me in as "All User" and lets me browse around, but there ar…

When a database on my filemaker unlimited server either quits unexpectedly or stops publishing on the web (this is an identified problem with the web companion)and i try to access a CDML web page i get a javascript application error window come up saying that the database is not open. What I want it to do is move to a static error page designed by me. I have specified it as a URL: <A HREF="http://172.17.201.8/mpc/wg/FMPro?-db=wg_shot_tracker&-lay=cgi&-format=shot_tracker.htm&-Error=default.htm&-view"> I have put error pages in all the folders jsut in case i have got the path to the error page wrong. To no avail. Any help would be appre…

Hello, I'd like to find a set of records using omit. I can't find an answer in my copy of FX.php in 8 Hours or in the forum. I know how to search a field by a value, how do I find omitted records with that value? Is there a published list of operators used by FX.php? Here's my code: $Instance = new FX($serverIP,$webCompanionPort); $Instance->SetDBData('Database.fp7','Layout'); $Instance->SetDBPassword('user','pass'); $Instance->AddDBParam('FieldName',"FieldValue",$op="eq"); $Instance Result=$Instance->FMFind(); Thanks! Shannon -=-=-

Hi all, I'm setting up FileMaker Pro Server 7 Advanced on a MacOS 10.3.9 system and am attempting to use Instant Web Publishing. I'm having two problems that may be related. I'm hoping that solving one will solve the other! Here are the problems: 1) On the server, in the FileMaker Server Admin application, if I go to Configure > Clients, I have text in the Identifier and Passcode fields, but nothing shows up in the Web Admin Console field, and I know that my server should show up there. How do I get it to appear in that field? 2) On a client system (MacOS 10.4.1 running Safari) I can see the name of the hosted database via Instant Web Publishing but when I c…

It seems as though one can not scroll a calculation field or a global field in IWP. I can scroll those fields in FM 7 but not IWP. Dose anyone have any insights into this and have a work around? There is no mention of this in the FM documentation. Thanks in advance - Sam

If I have a database and assign background colors to different parts, then when viewed in FM the color fills the window in browse mode. However, when viewed via IWP, the background only extends to the limits of the page. How do you get it fill the entire window? Thanks, Carlisle

Hi guys, I have several people who use the same data file, but they view the data differently via layouts. Is it possible with IWP to give each user a URL to jump directly to one of their layouts? I could handle it by scripting based on the login account, but a URL would better. If not, any other suggestions? Cheers... Sean!

Hi, I am new to Filemaker and PHP (I am using FX.php) - so speak very slowly... I am very familiar with Filemaker 6 and CDML and custom web publishing. On the opening page to my site an inline action is performed that searches an article database and pulls up the article that is marked with the correct date. I want to do this with Filemaker 7 and PHP - I can do a search with a find page and a result page, but am not sure how to duplicate the inline action that I do in CDML so that the search automatically happens when the inital page is loaded... If someone can let me know how to do this I would be forever grateful! Laura

I've got FMP5 and Lasso 3.6, here's what i want to do. I want visitiors to a site to be able to complete a form, that creates a new record, and then upload a file to the server that gets imported into a container field in that record. If i can't have it imported into FileMaker then uploaded with a reference to it in the database that i can link to. But i don't want people to have to alter file names, i'd like it kept simple for them. Can i do this? Do i require a Plug-In? Thanks in advance.

How can I publish online filemaker pro 7 Database without using Filemaker Server Advanced 7? It all must run with Windows and MAC

I've built a pop up calendar in FM7 that is scripted so the user can select a date, and it inserts that date into the field. The "New Window" command is supposedly compatible with the web, but it doesn't make a popup window appear, it just replaces what I'm looking at with the new layout. When the script hits the "Close Window" command my previos layout returns. Anyone else looked into making a popup that does the script, and how did you do it? Thanks.

Help! I've developed a very intricate database that tracks a combination of individuals and companies along with various pieces of information about each. It was a hit! Now the problem, they want to move it to the web. IWP is out of the question because of little quirks and we need more control over how it looks and operates. My company is talking with an outside vendor (who is very ignorant about the power of filemaker and hasnt tried to explore the filemaker option) and he has suggested that the entire database be rebuilt in a mysql/php environment! I know mysql/php are very powerful but I need help in ANY suggestions about how to link the web and filemaker …

I have a database that has a container field. In it is a link to a PDF file. I know I tested this on my machine by hosting it to IWP through FMP client and I was able to double click on the pdf & it opened. Now that i have it hosted on Advanced server, I cannot double click on the container field to open it. Any ideas on how I can get this to work? Thanks! John

Can I run online my filemaker pro 7 database with only Filemaker Server 7 installed (without FM Pro 7 and FMSA 7) and using ODBC/JDBC and PHP or JavaScript? And I need many connections (not 5) and good design (not like Instant Web Publishing) I need it working with MAC.

I hope that this is the right forum for this. As another thread said, in IWP picking from a first pull-down list doesn't trigger the appearance of a second field's pull-down list (in my case the second one is a self-join based on what was picked in the first field. I've gotten around this by having the user click on a trash script - this triggers the second field's pull-down being refreshed. Can a script be attached to picking from a list, thus not requiring my trash button/script? I can't find this capability in FM doc's but thought I've seen it, maybe in earlier version - I'm using 7. Doug

Hello all, I have a db published using IWP in FMPS 7v03 advanced. I've made a webpage with a link to the database (bypassing the IWP database homepage). When I use the "exit application" function, my database closes and I am brought to the IWL database homepage. How can I force my exit application button to bring me back to my original homepage (can I direct a URL)? Thanks in advance.

When a new order is being made through IWP, a new record is created in IWP. I have found that the record is committed even if the "Commit Records/Requests" script is not in the script. Can anyone explain to me why a record is being committed when there is no "Commit Records/Requests" in the script? Is this another FM bug or am I doing something wrong? I am using FM7 Server Advanced to host the FM file (Mac 10.3). Thanks in advance - Sam

Hi! My IWP sessions doesn't time out. Site has a log out button and time limit for sessions are set to 15 minutes. If the user doesn't log out manually the session never ends. Did I miss any vital settings? All insights are helpfull!

I just installed updates to my Filemaker Server 7 Advanced to 7.0v3 a couple of days ago on a Windows 2003 Server. Now my open url scripts do not work properly with the native filemaker pro 7.0v3 client. They trigger my IE 6 browser but the address gets messed up. Filemaker is adding an extra / into the calculated address. For example: My calculated url field shows: http://tps/fmp/form2.pdf What gets put into the address box on IE 6 was: http://tps//fmp/form2.pdf. Where did the extra / after the tps come from?? This script is of course is triggered from a button in the database and is also triggered from IWP on the web. However it works from IWP and…

I have received an answer from FM Tech Support concerning the following request: Question: Session is timed out at the client side (works correct), but the host still keeps this session alive. Happens only when field validation "Is Empty" is used and field is empty after the user has been disconnected. Bug? Answer from Tech Support: I was able to replicate this issue as well. I have actually simplified the steps down to a validation on "Not Empty" and setting the timeout to be less than 2 minutes. The account does not seem to matter nor does the script steps. What does seem to cause the issue is the validation on the field since the field is empty after the …

Hi Guys, I have only a little experience with fx.php, and none with fm-and-php. Could anyone please tell me if there are any reasons why I should choose one over the other in a server I am about to setup? Thanks, Sean.

Hi - First post and new to FileMaker. I have created reports with calc fields, sub-summary groups and trailing summary. The reports are fine when previewed in the FileMaker application. When publishing in IWP, the report format is wrong. It publishes in browse mode which looks like only one record for each sub-summary - and the trailing grand summary. I see that the preview script step isn't compatible for IWP. How do you publish this type of report? Thanks, Peter.

Hi all, Can anybody help with access to a published database? I want guests to access a database via the internet without seeing the filemaker screen and without having to log in. I am happy making a HTML page to get there. Ta Colin

I just got a static ip address so that i can share my databases with colleagues in another country. i just gave them the ip address, configured port forwarding on the router and it works great. i'm worried about security though. even though the databases are password protected, i'd like to have another step of security either on the router or on filemaker. any suggestions?

When a user clicks the logout button, the browser then displays the FileMaker Home Page, the list of available databases. Is there a provision for directing the user to some other page upon logout? Our users get to the database through any one of several home pages of our own. We want to return them to the page where they began.

Here's a curious situation: my colleague in brazil reports that when he tries to access a value list from a portal (through IWP), the value list will not show up unless there already is another record in that portal. Any idea why this might be? Can i Fix it?

Who can say me. Where i cah read about: how to coonect from php to fm files. Thank!

Can IWP play QT movies from within a container field? If so, where does the QT movie reside in a FMP server advanced configuration setup? Does the QT movie need to be stored in the web folder of the server running FMSA?

My online database is launched and working...Hooray (and thanks for the help!!) I have another question: How can I get a required field to work in the search screen? This is what I have for the field: Enter Species (Required) <INPUT TYPE=hidden NAME="-op" VALUE=eq> <SELECT NAME='Species'> <OPTION VALUE="-"> [FMP-VALUELIST: Species, LIST=Species] <option [FMP-ValueListItem]> [FMP-VALUELISTITEM] [/FMP-VALUELIST] </SELECT> I thought by making OPTION VALUE="-", it would default to that value if no other value was selected. But, the search is working even if Species is not ente…

We have moved our site from in house to a third party ISP... All the databases have been registered and set up. Some of the information is even returning correctly, however the most important part of the site isn't. The code being used to pull the information is: [Field:'LLNew Selectees.fp3::firm'] The database name is correct, the field name is correct and it comes back blank. I've been working on this problem for four weeks and I'm getting nowhere fast. Help?

I have a whole bunch of PDF files (tens of thousands) - what I want to do is use Lasso to search on the text inside the PDFs. Is is possible to get Lasso to search directly inside the PDF files? My other alternative is to catalog all the key words in the files into Filemaker as well as the filename so it serves up the file when the user selects it. In this case is it possible to open the PDF in the browser with the search term highlighted throughout the file? An example of something similar to what I am trying to achieve is the dtsearch web with spider (http://www.dtsearch.com) Any suggestions would be greatly appreciated.

help! I've setup several online forms for users to enter information. Most fields are free-form text. I have both the database and the server itself set to "disconnect after 60 minutes" (the maximum allowed by Filemaker). I thought 60 minutes would be enough time but I've heard complaints about "session timed out" messages when they go to submit. With check boxes etc. I can commit the record but in free-form text boxes I cant commit the record (thus saving the already typed info) until they click out of the field, right? Does anyone have any suggestions about something else to try? Are using PHP and/or XML the answer? Any help would be greatly appreciated.…

I have set up two databases on IWP. Both can be viewed on the internet ONLY when I am logged into both databases on the computer at the same time through Filemaker Pro. As soon as I exit the databases/close filemaker, it says the website cannot be reached. How is it that I create the databases on IWP so they can be viewed at all times on the internet even when I am not logged into filemaker?

New as of 4/20/05, that is. 1. New in Web plug-in 7.0v5 1.1. Instant Web Publishing now displays 25 records per screen in View as List, and 50 records per screen in View as Table. This change is not documented in Instant Web Publishing Help. 1.2. Fixed a problem that prevented you from creating a related record at the same time you create a new master record. 1.3. Updated several error strings to be more informative. 1.4. Stability improvements. Here's the link: http://fmdl.filemaker.com/MISC/Win/fm_70v3_win_iwp.zip -Brad

Hi, I'm getting a weird error message sometimes when adding and updating. FileMaker Error 958, Parameter missing (returned only by web-published databases). Any ideas of what it might be?

Is this a "feature" for FMP7? I have a text field with show vertical scroll bar enabled. The feature is available on the client, but in IWP I don't get the scroll bar. Any way around that? If not, can I resize a field based on it's text? In other words, it's a big box with text which I'd love to grow & shrink depending on how much is entered. I know how to do this in preview, but that's not available in IWP. TIA, Heather

I need an effective automated logout procedure for IWP. It cannot involve the use of the status bar. I have used a logout button that activates the "exit application" script. This brings you back to the "File" screen, but when you click on a file you don't need to reenter login/password info. I need something that will prevent this and require a relogin after a logout. Thanks

Hi, is there any way to bypass IWP user login window? Meaning that it will open the database based on the user on "File option, logon using". The reason why I want to bypass it is... it will save the user from entering their username and password twice. On our database we allow users to only access their own record. On my initial screen, they will enter their Member ID, Password and Birthdate (all fields input), then they click logon button that triggers a script to direct them on their own record (status bar locked) and no way for them to browse other records. Any ideas? Garry

You can go directly to the website with the address. But if you click on the login file it comes up with a windows login window. I enter my username and login and hit ok. the login window goes away like 30 sec then comes back and tells me to login again but my administrator password for the server will not let me open the file. How do I get rid of this darn login window all together. I do have it set in IIS to allow annonymous logins but does not seem to be working.

Login=heritage&-find Basically this looks at the field called "Login" and finds the record that contains "Heritage" Is there a way to compare two fields instead, something like: Login=[FMP-Field:Compare]&-find Larry

[FMP-If:([FMP-CurrentFind][FMP-FindValueItem][/FMP-CurrentFind].Eq.[FMP-Field:Login_Match])] surveyerror.html [FMP-Else][FMP-field:URLLink][/FMP-If] Does not quite work. I am sure I just have the format a little wrong. Any suggestions? Larry

I am using [FMP-field:Login::ValidateJava] as part of a java script. A portion of the java script on my web page is filled in by the contents of [FMP-field:Login::ValidateJava] I am having something strange happen. The contents of [FMP-field:Login::ValidateJava] includes && But when I view the source code of the loaded web page, && is coming through as &#38;&#38; ValidateJava is a calc field, but I have tried many variations of trying to include && in that calculation text, but it always comes across as &#38;&#38; in the web page source code. Is there anything that can be done to stop this? Larry

Quick question: I know how to make a URL that will create a new record in my database. I know how to use a form the create a new record in my database if the user is already logged into the database. Can a form create a new record if the user IS NOT logged into the database? For example, the user goes to a standard web page NOT being part of a FM solution. On that page is a form. I would like the user to be able to fill out the form, hit submit, and have the information submitted as a new record to a database. I know how to use something like: <form action="FMPro" method="post"> <input type="hidden" name="-DB" value="names.fp5"> <inp…

Trying to set a database for IWP; but in Sharing only FileMaker Networking is available. I turned off Networking, rebooted FileMaker Developer - still no IWP available. What could possibly be my error? any ideas? ~Dennis

I have been using FM for 3 years, but have never had a need to publish on the web till now. Are there security risks in IWP for the computer since you are making an IP address available on the web. We are behind a pretty secure firewall, but did not want to make any compromises. Can people "sneak" into other databases such as a related one? Thanks for your help.

Is there a "Get" calculation or other way to set up a field that will return the current user name logged into a database over IWP? Not the user name of the individual logged in on the server side. Thanks

Hi, I am finally moving into FM7( I know it's late). I had too much invested in FM6 to make the transition. Anyway, i am looking it now. FM7 IWP seems very promising but I am getting a lot of bugs using it Safari. And most other developers have problems as well. Is there anyone using FM7 IWP successfully in a production environment? If it's a public site, can you please give us the URL to have a look at? I am looking into developing a B2B catalog for resellers. It's just for displaying pricelist and searching. I am giving it a go but there are just too many problems with IWP. Many thanks in advance.

HELP! I have got some behavior I just cant figure out. I do a search to access a particular record: http://xx.xxx.xx.xxx/FMPro?-db=Research....tures&-find This works as I would expect. I can see my FM database file perform the find, it locates the one record that matches the search. My CDML tags displays my information from the record correctly on my web page, EXCEPT... I have one tag that is not displaying the correct information. [FMP-IncludeField: ifredirect1] What this tag is doing is displaying the contents of the field called "ifredirect1" from a different record other than the found record. In fact, it is displaying the contents fr…

I'm using FM7 on Windows XP... For some reason I can't start Instant web publishing. As soon as I open Filemaker, I get the message that Filemaker cannot share files over the web because instant web publishing cannot be started. I've tried playing around with settings to no avail. I'm sure this is something simple that I'm not getting. Any help is appreciated.

It's me again!! Thanks for the help. Here's the situation... I have 2 files. One file references info (including images) from the other. The 2 files are linked together with a field called "Project Number". When I enter the project number in the first file, it matches up with the project number in the second file and the referenced data pops up on the screen. It's basic filemaker 101. No problem, right. It works fine. Here's the problem I'm having when I accessing these files with IWP through my browser. Everything works fine, but the pictures. All the text info is correct but the pictures are not. It's showing pictures from the wrong record. I can't figure t…

My database has users who are assigned projects (some projects have multiple users). I am using a linking table to associate users to projects. I have an activity table with a portal to a log table. In the portal I show a log::project field that has a edit list related value list and this works in the non-IWP great. Only the related projects for the user shows up. But when I publish on the web, this field list is empty. Is this a limit in the IWP or a mistake in my design/logic? Thanks

I thought that I read somewhere that you could dictate which page launches when IWP is accessed, but I can't find it. Does anybody know if this can be done? Thanks, Brad

Hi there ! I am developing a database for IWP. On my main details layout I have several portals for related records off telephone numbers etc... When performing data entry in FilemakerPro a new portal record is automatically created each time you enter data into the last portal row. When using in IWP this does not happen... You have to commit the record and then re-enter edit mode to create a new portal row. Is there a way of automating this so that evry time data is entered into a portal row a new record is created? Thanks in advance for any help Steve

The transparent background for the buttons I've made (.pngs) doesn't seem to be working with IWP (they are surrounded by black) but they display properly when the database is open with FMP 7. I used the Insert Picture command to put the .pngs in.

I've been looking at this for the past hour and a half and frankly I'm frustrated. How do I take this code <a href="/stubs/printprofile.lasso?-Database=New%20Selectees&-Layout=webDetail&Record%20Number=[Var: 'recnum']&-token.searchby=[Token_Value: 'searchby']&-Search">... And have it return the information without the -Layout? [color:"blue"] [color:"blue"] [color:"blue"]

I work in a product testing facility (were I essentially DESTROY products) and I use filemaker to host a database that contains all our "Request for Test" forms and "Test Results" reports. We almost always need to insert pictures of the test results in the reports so that users can "see" the results. Basically, We take digital pictures to document the tests and then do the old "insert picture" in the container field. In FM7 this functionality is not a problem, but I have not been able to find a way to add a picture to a container field with IWP. BTW, the pictures needs to be viewable on the report so that they can be seen on the screen and printed as part of the repo…

I've got FileMaker Pro 7 running and I'm trying to get IWP to work but been unsuccessful. Below are the steps I did: 1. Created my FM File 2. Under Sharing I selected "Instant Web Publishing...". 3. Turned on Instant Web Publishing 4. Selected my FM File and had it accessible to All users. I figured I just needed to type in my IP in my browser but my browser says in cannot connect to server. Is there something fundamental that I am missing to get IWP to work? I've read the documentation and followed their instructions but still no luck. Thanks for any advice...

Is it possible to attach docs/pdfs to a record via the web interface generated w/IWP?

I am only posting one database via IWP and would like to eliminate having to send people to that not-so-attractive web site that links the DB. I know I could go dress up the web page, but I really have no need for it. So does anyone know of a way to send people straight to the DB? Thanks, Brad

Hello all, I have FM 5 runnning on a Windows 2000 PC I have an issue with one of my action calls. I have a database that hold all my computer,server, printer info. On our webpage there's a link that when clicked it show all the info from that database. I would like to narrow it down a bit and only show the computer info. Here is was is there right now: <a href="http://127.0.0.1/FMPro?-db=computer.fp5&-lay=main&-format=computer_list.htm&-findall"> I would like to repace the findall with someting that will only find computers. I have a field in the my main layout that has a drop down called device type. In there I have a value list that has…

After pulling most of my hair out, I finally got FileMaker Server 7 Advanced working with Instant Web Publishing. I made a test database and successfully accessed it. Then I added several other databases to the server. Some I can access fine, others I can't access, and even others don't even show up. In the FileMaker Server Admin Tool, all the databases have a status of normal. In the Web Publishing Admin Console, only some of the databases show up, but they all have a + under IWP. I have 5 databases working fine. Another one shows up, but asks me to login. It won't take my username and password. I activated the guest account, but it still asks me for …

Does anybody know how to allow scrollbar in a field in iwp? I notice the scrollbar would appear only if the field is editable, but not in read only format. As such the field size becomes the limiting factor as one can't have more text inside than the field size. Regards, Clifford

Does anyone have any idea if Filemaker7 and php can do a log in Domain authentication?

Hi Guys, Ok, I suspect I have found a nasty bug - could anyone confirm, or tell me how I can get around this? I have two scripts, each one line only and each linked to a button. The first does Open Record/Request. The second does Revert Record/Request. Now in IWP, pressing the first (open) button should put me in edit mode, with the submit and cancel buttons appearing in the status bar. This works fine. If I now make a change in a text field, then press the second (revert) button, I should leave edit mode with the field as it was originally. BUT what actually happens is, the field gets updated (the nasty part)! The status bar Cancel button wor…

I'm planning on upgrading from plain FM7 to Server Advanced. Will I then be able to use the Custom Dialog script step in IWP? If not, how can I send a customized error message without having to make a custom-made layout? Does Server Advanced in general allow script steps in IWP that plain FM7 doesn't allow? If so, where can I find this info? Does Custom Publishing allow mscript steps that IWP doesn't? Thanks for any help.

I have a solution on FMP7 server advanced. I am accessing my solution via IWP (from the server). On a layout, I have a field with a popup menu. I've made the field a button with a script running. If a condition is met, some other field is set to a value(shows a message in a text box), otherwise I go to the field (where the user can select a value from the list). I'm attaching a screen shot of the script. My solution works great when running from the FMP7 client, but I have difficulty on the web interface. The drop down list shows, but I can not select anything. Any thoughts?

First, I want to thank those who unselfishly give help and information on this forum. Without their help I would not have gotten anywhere. My company is SmilePix: We are entirely internet driven so a smooth running database is critical. Our clients are dentist who send us photographs through the web (or email) of their patients that our artists retouch to improve a cosmetic look. Everything is database driven from the dentists placing orders, uploading photos, viewing past orders and making comments on their orders. Presently, I am still using FM 6 Unlimited and publishing to the web with CDML. It works fine and has so for a couple of years now. In the b…

I am developing an online searchable database for my clients. I used CDML creator and then modified the source code. It is very simple: a search page to enter criteria and display a list of found records and a detail page for any selected record. Display only, no updates. I have the basic formats working offline in localhost. But, I can't get them to run online. We have our server hosted offsite. We installed FM6 on the server. However, the Web folder was installed directly to the server folder (not under Filemaker/Filemaker Pro folders)...is this the problem?? (When I take Web out of the FM folders offline, the application does not work in localhost.) I …

I am using Instant Web Publishing on Filemaker Pro 6v4, using Mac OS10.2.8. When a Safari v1.2 running on Mac OS10.3.9 client links to my database, the connection is made but the layout is not rendered. If the page is reloaded, however, everything looks fine. Rendering on all other browsers I have tried seems to work fine. I would like to avoid having my Safari clients go through reloading to see the layout correctly. Any ideas on why this is happening and any easy fixes would be appreciated.

Hi Everyone- I'm having trouble with getting FX.php to work. I've read through a lot of the threads at this site and still am having no luck. When I try to run a php script that uses FX.php I get a blank page. I suspect that the problem could be compatability. FileMaker is running on an Mac apache server and the PHP is running on a windows server with IIS. Does the php have to be on the same server as the FileMaker database? I know this may seem like a stupid question, but I don't know enough about servers to understand why that would or wouldn't be an issue. Thanks in advance.

I'm trying to use a php web page to access a fm7 database hosted on FM7 Advanced Server and I'm confused about how everything needs to be set up to allow this. Here's what I have done so far: Turned on IWP for the db and specified guest access on port 80. Placed the db in the fm7sa database folder and opened it using fm7 server admin. Installed fm7AS on windows xp machine running IIS. Installed PHP 5 on the server. Copied fx.php to the default web directory on the server. All that the php web page is doing is connecting to the db and creating a new record, but when I open the page, I get a 802 can't open file error. The file is already open though.

For some reason, I cannot access any of the files I have published with instant Web publishing. When I run a local check with the address 127...etc the files are shown as published. When I try and access the files from a remote location, I consistently get pager cannot be displayed. The files are open, I am running Internet Explorer version 6. My Internet connection is working fine in all respects. I had a friend publish the same file and could not log onto his file either. Perhaps I am not covering the basics? I have allowed all user access in my settings and I have not restricted IP addresses as yet. Please help. Brad

I want to share my db with colleagues in Brazil. the computer i host the db on starts with 192. and so it is a private/internal ip address that can't be accessed by computers outside of our network. how can i publish this thing on the web through IWP if no one can access my computer?

The FP7 help file states "Pop-up list ... users can always type a different value into a field formatted to display a pop-up list." The help file does not mention that there is an exception for IWP users of the Pop-up list, at least, that's my experience: in IWP the field formatted to display a pop-up list only accepts the pop-up list values. Editing these values or putting other values in the pop-list is impossible (this is mentioned by the "instant_web_pub.pdf"), but editing these values or putting other values in the FIELD appears to be impossible as well. Am I right ?

Hi, I've just started trying to implement a requisition form using IWP. I have some text fields that are lookups to a separate file. When I make a new record directly in FM, the field values lookup properly. When I make a new record via IWP, the lookups don't occur. I'm sure there is something obvious that I'm overlooking, but I need help finding it. Thanks, Carlisle PS I'm also running Tiger (not a choice of operating systems on the FMForums yet). The browser is IE 6 on a Windows machine.

I'm using mac os x panther, fm unlimited 6 and fm server. We are using fm for an ecommerce solution and for security we do not want all our databases to appear on the instant publishing home page. We have seen some documentation that says that this can be done by simply ending the database name with an underscore.. eg: database_.fp5 Sadly, this simple solution does not seem to work... our "databases_.fp5" are still visible on the homepage. Can anyone tell me an easy way to keep selected databases OFF our web publishing home page so that we are not offering up our customer information for anyone who cares to look at it? Is it really as simple as using some s…

I just set everything up on the host computer to publish two databases on the web. as i understand, all that my remote users need to to is put http://<ip address> to find the two dbs that are posted. I tried to access the dbs through iwp on a computer in my office and it worked fine, but when i tried it from home (on my pc that does not have filemaker), it said "cannot find server". is there something else i need to do? how can i share these databases to other computers outside my office? thanks for your help.

Hi, I am using FM Pro 7 on windows 2000 and internet explorer 6. I have published my database through IWP(published database will be used in the intranet only). The end user has to enter his ID and Password to login. I have some problem in this point. I want to make this connection should be secured. 1. So i want to know whether FM Pro 7 supports HTTPS(secured HTTP) and SSL(secure socket layer). 2. If it supports do i need to change any settings in the database/IWP setup. 3. Do i need to install any server software(such as IIS , Apache). 4. If i install server software, how the FM interface with this server software. please help me.

Hi, I am using FM Pro 7 on Windows 2000 and Internet Explorer 6. I have designed a database and published it through IWP. I have included some validation conditions and corresponding error messages in the Validation Part while designing the table. When i do manipulation on the published database, when i do some error entries it shows system generated error messages instead of the messages i defined previously in the database. I want to display my own error message on this published IWP Web Page. Please help me.

Hi, I'm working for a company that is developing a FileMaker 7 database to be served with IWP. We need to have two login types for this database: one is "guest" read-only access while the other will be "administrative" read/write access. I have a script setup that should force the user to go to a login screen (control panel area is hidden and locked). If the user enters a known username/password combination he is taken to an admin screen. If an unknown username/password combo is enterd the user is taken to a read-only layout where only searches can be performed. Now I'm having a problem with this through the IWP. I only had it working for a little while …