legal2justice

I am trying to fill web form fields in my IE browser, using the fields from filemaker. Is there a way to populate this data into the ACTUAL fields IN the browser. Once I review them on the screen I will manually post each page and apply a script to populate the subsequent page accordingly. Any ideas....

I am not familiar with PHP, but think I may be able to reverse engineer the solution that I need. I am using IWP for the major part of my web publishing, but I need reports. Started using PDF references in container fields, but this is getting to be a pain with the weekly update of the database. I used the report selection of PHP Site Assistant to create the foundation. I need to limit access to data to the primary log in identifier, which I have done in the privledge set. How do I move that identifier, which is Get(AccountName), to the find screen/criteria to maintain record constrain in the PHP find screen (maintain client only having access to their records). The client will enter the remaining values for which they seek.

In the start of the script that prints the invoices in the 2 different layouts, add an if statement. If(isempty(date field)) Exit Script End if Go to original layout.

when you say a "reminder" what are you looking for as a reminder. You can set up a script that runs when the database is opened that will run a find and presents these records at that time. You can have them displayed as a list, etc. You can have a dialog box pop up indicating there are records that meet the criteria and prompt you to view them or disregard. There are several different options. How do you determine when you no longer need to be reminded, is there a completion date field or something of the sort.

You can write it into your open script on the client side that way whenever the file is opened it will send the e-mails out of the records that have been updated. Then you won't need to do it on the IWP side. Make a field to timestamp when the comments field is modified. Then a field that gets timestamped by the script (last e-mail script step being insert text--calcualtion--get(timestamp))each time the e-mail script sends the e-mail update out. The trigger and filter for the script will be and if statement that anytime the comment timestamp field is greater than the e-mail timestamp field send an e-mail for that record. These two fields will just continue to overwrite themselves as necessary.

There may be other ways depending on what you are trying to accomplish. If you are trying to collect certain data, you can create a layout that would mimic an e-mail and store the data in a record. Then write it into an open script so when someone accesses that database from the client (internally using Filemaker)it uses that person to e-mail that record whereever you want it to go. Would need more specifics if this doesn't solve your issue.

I have a database with a container field in each record that has a reference to a pdf report. I created a layout that will list all the reports available to the user. I am trying to write a script for each button that will go to the appropriate record in the database and activate the file in the container field. I have tried the set field to the container field with the Select/perform option and that did not work. If I show the layout in list form, I can click on the container field and the file will open. I am trying to automate that process in an IWP script. Any suggestions.....

I found that in a list view in IWP that as the user selects a record, when they return to the list, they do so on the next record. You may want to add a script step that returns the user to the first record. If you show the status area you will see more clearly what I am referring to. All of the records remain, however only the ones proceeding the viewed record remain visible. If you change records in the status area they all come back. Hope this helps.