jon2004

i've published an iwp database and the returned results are displayed in "table view", which i can change to form view by clicking on the link, however when i choose table view to return to the table it seems to revert to some other design. how can i control the table view given to me by my search? ultimately i would like to customise the table view with the categories similar to the client - is this possible?? Version: v6.x Platform: Windows 2000

i take it the lack of response indicates its not possible???

another dumb question... i want to create a report with several documents displayed based on a date selection - i've got the iwp search (actually i created a URL to kick the search off) to return a list of documents for the date which is fine, however it displays them in a table view, whereas I want to recreate the report view i see on the client?? is this possible?? Version: v6.x Platform: Windows 2000

i have a document that has several date related child documents, using a doc id as a key, the parent document is created say on the 10th, child documents are created on the 11th and 12th, i would like to make a report of the parent document, and all documents on a given date, say the 12th..., but not all the child documents. how do i do this, its driving me nuts!

yes, but in this case filemaker would be the email app, so is it scriptable to receive an email, sent to it via a pop3 server?

thats an excellent solution, however can i stop FM sorting the value list in alpha order? can i have it returned in the order the child docs were created, sorted by an id or creation time etc??

i have a master record, which has several smaller workhistory records associated with it. so far so good, a parent and child relationship is fine, allready set up in fact. on each day i want to produce a report of all the work done for a day along with various bits of data from the master record. i underatand a lookup could return the field i want from the most recent record, but i want all the work records for that day, and i want to concatenate those fields into one string field. is a portal the only solution or could i get a script or calculation for retrieve the data??

i have a simple portal in a document which fm can use to create a document in a related database. this doesn't seem to work using the IWP - is there a workaround?:?

pants

i think the problem was in the keepreplace bit which kept data from some other sort info from the purchase order sample file i "borrowed" the code from. i couldn't find any documentation on that so just "kept" the original data. its a bit "left-field" to keep context data in that format, it really is a fine example of what happens when data and interface are so thoroughly mingled (or mixed up).

thanks Lee that works a treat, any time your in London, UK drop by for a free drink.... :-)

ahhh ha... if this works you're up for a drink......

ok, further investigation reveals... if i try and sort from the icon on the toolbar i get the following message "Some fields in the sort order are invalid or cannot be sorted. You must remove these fields" i'm then presented with the sort dialog box with the legend "Field Missing" in the sort order, which i replace with a valid field, click on sort and done and it sorts. However if i then click again on the sort icon on the toolbar it happens all over again........... arrgghhhh...... is something somewhere else re-inserting an invalid sort field??

The complete script is... Go to Layout ["Report"] Show All Records Sort[Restore, No dialog] what sort of change to the script , field or file?

just to confirm: if i use instant web publishing, there's no way i can add html in "pass-through" mode ie i can put some html or javascript onto a layout and have that served to the browser? if i want to do that i have to start from scratch, and use the CDML tags in html files and build everything from new?? theres no way to supplement what's allready produced by the instant web publisher thingy?

in my database i'm constantly getting this error message: The previous script step, "Sort", could not be completed because it restores an invalid request. Do you wish to continue with this script?" when i run the following script line: Sort[Restore, No dialog] is there some global or application setting or preference i need to set? what causes this message to appear?

thanks - i sort of worked it out from the blurb... sounds like the sort of thing i can use, providing it meets a few requirements

errr..... i've just read the blurb with the above product, and it uses the word "send" a lot, not "receive" at all, just to clarify: i have a 3rd party program that sends emails out, i want my database to RECEIVE the email and then create a record based on that email, i don't want my database to send anything out! (god, what i'd give for a Lotus Domino server....)

so i can effectively send an email to a filemaker database and then parse the body and subject fields of that email and create a record automatically? hooray!

how can i get filemaker pro developer to be the recipient of an email (i can set up an exchange account for it) and when an email is sent, to create a record based on the details of that email? is this feasible, achieveable, doable or any other ...ables??

but now i'm stuck.... i want one of the smart "sortable headers" that's visible on the List page of the purchase orders database. now i've added the fields HiliteLibrary, global container repeating; HiliteSortedBy global, text, HiliteOrderID with the calculation copied from the Purchase Order sample. i've imported the three scripts Sort by order id, Sort by order ascending, Sort by order id, descending renamed them and replaced all the values it missed out when it created them... i've also imported the start script and applied it to the document, which it does including the clear sort field script. on debug it stops at the line Sort Restore No dialog and gives the error prompt: "The prevous script step, "Sort", could not be completed because it restores an invalid request. Do you wish to continue with this script?" whyyyyyyyyyyyyyyyyyyy?? i seem to be missing the up and down graphics (from the repeating global field?) however i don't see the field on the Purchase order database and i've no idea how they're populated. what have i got wrong in this instance, its driving me mad and holding up my database.... have i missed out a vital element or not set something that is set on the Purchase Order sample.

OK - one last question now my db is taking shape... in filemaker i have some pop up menus with the ability to add other items. i'm using Fields (Update) generated from the CDML Tool to display my value lists, which is fine, but i want to add another value to that list from the web - is it possible?? how do i translate that feature to the web?

the concept of format files still puzzles me. a url request: FMPro?-db=Employes.fp5&-lay=FormView&-format=results.htm&-findall this will query the employees database and return the fields on the layout FormView and format them using the results.htm page? is that correct? i seem to misunderstand the relationship between the layout file and the format file? If i'm querying and will return an undetermined amount of records how do i create a format file for every possible combination? is it correct that all html pages in a dynamic filemaker database will be displayed using "format" files?

thanks!

hmmm... yes i get that.... but i'd much prefer it to be like javascript and blur and onfocus etc.