jonesy17

Now that works! Brilliant. Now I just have to copy it into my solution without screwing anything up! Thanks, Robert

This solution seems to me to be just another way of accomplishing what I already have (though better, I must admit), and will get me a new serial number starting at 1 each month, but it does have a problem, I think... This September I'll end up with SEP001, SEP002, SEP003, SEP004, etc., but it seems that with this solution NEXT September it will pick up at SEP005, SEP006, SEP007. What I really need it to do is start all over again at SEP001, SEP002, SEP003. Thoughts? Robert P.S. I do appreciate the help so far!

I appreciate your comment, however this system of identification has worked for us for years (decades, actually) on paper. I am simply trying to digitize the process. I don't care if next September I end up with another ZA008SEP as the files associated with the previous ID will have long been deleted. So my questions stands: how do I reset my counter to 001 at the start of each month? Robert

I have a need to have a unique identifier created based on a calculation. A user needs to select a zone, which has a two-digit abbreviation. My calculation will take the zone abbv. and append a three-digit number and the first three letters of the name of the current month. The three-digit number (currently) comes from a serial number field, which increments by 1. E.G. User picks "Zone A", which has abbv. "ZA". This becomes ZA008SEP. However, at the start of each month, I need to reset my serial number counter to 001 so that next month I can have an id like ZA008OCT. What's the best way to accomplish this, preferably automatically? Cheers, Robert

OK, So I'm the only one who cares about this problem since no one even offered a hint or sympathy. Here's the solution, in case anyone else runs into this problem again. On the machine on which FMS8A is installed, turn off, uncheck or otherwise blank out the network preference that points to your network's proxy server. This means that machine won't be able to access the Internet to get updates so you'll have to download those on another machine and then copy them over. Robert

Have recently installed FM Server 8 Advanced, with the Web Publishing engine on the same machine, a G5 running OS X 10.4.6. The web server works, and I can execute an XML query like this: http://localhost/fmi/xml/fmresultset.xml?-db=approves&-lay=DigitalAdvertisers&-findany This returns one record, which I expected, but it is not formatted in any way, which I also expected. I understand that I have to route the results through an XSLT stylesheet to get pretty formatting of the results, so I modified my query like this: http://localhost/fmi/xsl/adresults.xsl?-grammar=fmresultset&-db=approves&-lay=DigitalAdvertisers&-findany This matches EXACTLY the syntax Filemaker provides as examples in its web publishing guide, but instead of giving the desired result I get an error page. The error says: I can't figure this out at all. Can anyone help? Cheers, Robert

This is happening with more than one import script, though both scripts are in the same database. I'm not sure what save time issue you are referring to, here. This database is open 24/7 so any changes should have been saved eons ago. Absolutely! One of the fields is the date time stamp. Another is filename, and the third is member_id (email address). If you could further explain the "save time issue" that might help me out.

Sounds like you need a relationship between the pop-up list field and the same field in your portal DB. Does the portal link to a second FM file or the same one?

Mac or PC? On a Mac you could use Applescript.

I assume you're doing this through CDML? Try: <SELECT NAME=state> <OPTION VALUE="">ALL STATES <OPTION VALUE=GA>Georgia <OPTION VALUE=FL>Florida ... </SELECT>

Situation: FMU under W2K Pro imports ODBC data from MySQL db over TCP/IP via a script in ScriptMaker at five-minute intervals (with Events plug-in). This works great, until I restart FMU. After restart, FMU imports duplicate records, despite the following: 1) The Import Records script step was setup to Update records and Add remaining records, with three fields to match. 2) One of the fields it has to match is defined in FM has having to be Unique (field is a date/time stamp accurate to the second, and there are no two records with exactly the same date/time stamp in the MySQL db). Once I restart FMU the script imports, but duplicates records instead of updating existing and adding remaining. To get around this I have to manually import records, then modify the script until it prompts me to KEEP the import information that already exists for this script or REPLACE with the info currently in use. I hit REPLACE, and then everything is running exactly as I want again... until I restart FMU. I don't restart FMU often (maybe once a month) but this is annoying nevertheless. Suggestions?

Forgot to mention, when using the token tag in your form, the colons should be periods, like so; <INPUT TYPE="HIDDEN" NAME ="-Token.3" VALUE ="[FMP-CurrentToken: 3, HTML]">

From the CDML Reference DB: So in your case: [FMP-CURRENTTOKEN:1] [FMP-CURRENTTOKEN:2] [FMP-CURRENTTOKEN:3]

Cheers, Charles. That's "exact"ly what I was looking for! *Groan*

So how do I run a script after the operator has tabbed out of the Userid field?

I need to ensure that all text entered in field Userid is all lowercase. myuserid = good myUserid = bad myuserID = bad myuSeRiD = really bad ... you get the idea. I've tried validating by calculation Lower(Userid) but that doesn't seem to do anything. I've also tried If ((Lower(Userid), 1, 0) but that got me into real trouble after I made it strict and didn't seem to work anyway. I've also tried searching the forums but I must not be looking for the right thing because I'm coming up with nothing. Can anyone help?

I think you should be able to do this by going into Layout Mode, then selecting Layout Setup from the Layouts menu. I believe you want Print Options.

The time between when you click the button and realize it's the wrong button is called an "ohnosecond".

Check out the Events plug-in for FM at http://wmotion.com/events.html

My point was that my code works with the portal tags inside the table tag, and the extra square brackets were there for design, not function, so the portal row numbers would be displayed like this [ 1 ]. So my code doesn't need any changing whatsoever I posted it as an example of code that does work for someone who was having trouble getting theirs to do the same.

You could try trashing the preferences ~/Library/Preferences/FileMaker Preferences/FileMaker Pro 6.0 Prefs Make a backup copy first, just in case

Here's my code. Note that the "portal" tags are inside the table. <table border=0 cellpadding=0 cellspacing=10> [FMP-Portal: addropFiles] <tr> <td valign=top rowspan=3 colspan=1> <font face="Courier" size=1 color="#99CCCC"> [ [FMP-CurrentPortalRowNumber] ] </font> </td> <td valign=bottom colspan=2> <font face="Courier" size=1> <b>[FMP-Field: addropFiles::UPLOAD_NAME]</b> </font> </td> </tr> <tr> <td valign=bottom colspan=2> <font face="Courier" size=1> <b>Client Name:</b> [FMP-Field: addropFiles::CLIENT_NAME] </font> </td> </tr> <tr> <td valign=bottom> <font face="Courier" size=1> <b>Uploaded:</b> [FMP-Field: addropFiles::UPLOAD_DATE] </font> </td> <td valign=bottom> <font face="Courier" size=1> <b>Sent to:</b> [FMP-Field: addropFiles::PICKUP_SITE_ID] </font> </td> </tr> [/FMP-Portal] </table>

I was having exactly the same problem just yesterday! I don't know why, however. But I eventually deleted my entire table and started over by simpling placing the portal on the web page, but not in a table (just to see if I could get it to show up) and that worked. Then I started to build the table around that, adding the basic <table> structure then more and more rows. If something didn't work I would undo it and try something different. I'm at home right now and don't have my code with me :-( but when I get to work I will post what I came up with.

Just worked for me, again Win XP IE6

Too easy, really. Thanks!