lakeside

I see. That's a good start. Thank you very much.

Post deleted by lakeside

I still don't get it. I'm looking for an example, and I can't make the example given in the Help documents work. The examples start out: ScriptParameter = "a = 5; b = 10" I wish I could do that like I can in PHP, but I don't see how. Are "a" and "b" fields? I don't think so, because I tried that. So they're variables, and I don't see how to set them. Can you give me an example? I'd like to start out bu setting them via UI device. Thank you.

I'm working through the examples of the Let() and Evaluate() functions. I understand the simple examples, but not the ones with the ScriptParameters. How do I specify the ScriptParameters? Do I need to run a script and capture those parameters first, or what? Thanks.

I got it. I remembered some help I'd gotten previously to a similar problem. The correct formula is: date = date(9,9,2009)

I have a date field, and want to set validation. One of the dates they can enter is 9/9/2009. I set validate by calculation to "date = 9/9/2009" but I always get the validation error message no matter how I enter the date. Where am I going wrong? Thanks.

sweet.

I see that we will still have to resize the columns in the Define Fields window every time we open it. Does anyone know if we can open the Define Fields window on a live database, or do we have to close everyone out of it like we do now? Oh, and does FileMaker still open every database (or table) that is referenced by a relationship or calculation like it does now?

Just curious -- how many concurrent users access your databases? I looked through the server statistics thread and the largest number of guests I saw was 73. My curiosity is sparked, in part, by a thread I read on another forum that had many people saying MS Access only handles up to 5 concurrent users before its performance tanks. So I'm wondering how many users FM can handle, realistically. M.

Just got home and looked this over again and saw an error in the script. Here's the corrected version. Sorry (again). Guess today wasn't my day. M.

That's what I'm trying to do, but I do need to know the date, and to know the date, I need to know the number in the date9 (for instance) box. I can get the month and year easily enough, but like I say, date9 will be 8 if we're in Septembet and 6 if we're in October, so I need to be able to capture the number in that field to complete the date to GTRR.

Yes, I see your point. I totally misinterpreted what you were after. I've emailed you the file with modifications to your script. And you'll need to change the Quarterly Report Compare field to a global (text) field. Sorry for the confusion. edit: Got DropStuff installed, so here's the attachment in FM6 (sorry).

I have a calendar in which the dates of the days of the week are calculated based on the month and year, which means there are 31 date boxes (date1, date2, date3, etc). So, for instance, if we're in Sept 2003, date9 = 8 (because it's Monday, Sept 8). If we go to Oct 2003, date9 = 6 (Monday, Oct 6). Now I wish to create a script in which a user can click on the date and see a detailed view of events for that date, but how can I determine the date they've clicked on, short of creating 31 scripts? I've tried GetField(Status(CurrentFieldContents)) and similar, so that when they click on date9, it'll get an 8 if we're in Sept and a 6 if we're in Oct, but that doesn't work. Thanks. M.

Enter data in the cat0, cat1, etc fields. They're set to auto-enter, but they only do it to new records. For existing records, you need to put the values in there Also, your relationships should be catX = ::BCHD Unit # M.

I woudn't use a script, I'd use relationships. Make fields cat0, cat1, cat2, cat3, cat4, cat5, cat6 with the auto-enter data 0, 1, 2, 3, 4, 5, 6 respectively (or use global fields). Then create relationships cat0 --> cat0 = BCHD Unit# cat1 --> cat1 = BCHD Unit# etc Finally, create calculation fields: count_cat0 = Count(cat0::BHCD Unit#) count_cat1 = Count(cat1::BHCD Unit#) then just put those calculation fields on their own layout and you have realtime info. If you need to separate by quarter, you can adjust the relationships and the calculation fields to reflect that. I can't post my revisions to your file, because I don't have stuffit here, but if you'd like, I can email it to you -- but I had to convert it to FM6. HTH. M.