WHW

I have successfully published my first CWP Filemaker Database would like to use the contents of a field as a link to an external document. [b]gotoURL3: [/b] [/color] disable-output-escaping="yes">� How do I take the fmrs:resultset and use that content to populate a link? Would it be as simple as creating an href? How could this be done? Thanks,

First time poster here, long-time Filemaker user. We just purchased FMServer 7 Adv and I am wanting to use Custom Web Publishing, but don't know the first thing in setting it up, much less publishing a dbase. I'm currently using IWP, but have found some limitations and I'm wanting to use CWP. I'm assuming there isn't too much in publishing a dbase using CWP? Are they any quick-n-dirty steps to get rolling in this direction? Any Assistance will be greatly appreciated. Best Regards, Jon

Greetings, I have been tasked with creating a new mutual fund profile in a relational dbase format and I have completed about 90% of this project. My last problem is dealing with sorting sector data per mutual fund(as you will see in the attachment) and displaying the top 5 sectors. The issue lies in how the data is exported from Principia (financial software). Each sector (from the raw data) is turned into its own field on import. It would be easier if I could just have a generic sector field and then each type of sector (Energy, Utilities, Telecom . . .) be its own record. Sorting would be a snap then. BUT, I am curious to know if there is a way to sort, or rank, the sectors according to the top 5 WITHIN a single record. This data will be displayed in the join table or Fund Profile. Any suggestions would be greatly appreciated! Jon SectorData Converted.zip

I'll give that a shot. Thanks!

I have 2 fields that are repeating, up to 18 repetitions. One field is <ticker>. The other is <fund>. I have a rel. set up that brings in the <fund> name based on whatever ticker value I specify. However...the repeating fields below <fund> remain blank when I enter in new ticker symbols in the corresponding repeating fields...as if I can't use them in a relationship. I would like to have this relational ability w/ repeating fields in order to avoid creating 18 different fields by which to accomplish the same objective. So...is there a way to use a repeating fields (per individual record)in one-to-one relationships? Anything would help. Thanks, Jon

If the DUP field is a calculation, you will not be able to index it, you will need to create a separate lookup field (DUP_lookup...text, indexed) that brings in the value of DUP. Make sure you turn on the indexing in the field option dialog. Then reference the lookup field in your self-relationship, not the original DUP, and that *should* do the trick. I had a similar problem in a barcode inventory dbase. Let me know if that helps. Jon

Lee, it worked like a charm. Are there any good tutorial files that will further expound on how the PositionFunction works? I'm a little puzzled with it. Thanks again for the response, I appreciate it.

You can set up a script to perform a find or do a manual find (cntrl-F or command-F depending which platform you are using). In the find mode, the <Date> field, you can manually insert the date range desired (i.e. 8/01/04...8/15/03). This will return all the invoices on and between those two dates. You should have a summary field of the Invoice Total-called Sum_Report1, that way, when you do a find with a date range of 15 days, you will then have the Sum of all invoice $$$ for that particular date range. You would approach collecting the Report2 information the same way. I'm not sure how you want to present this information, but I am assuming you want it recorded. I would use the SetField function to place that information from the Sumfield into the field you so choose, such as: Aug_Inv_Rpt1 and Aug_Inv_Rpt2 respectively. You'll have to do this for each month, but it can be automated with a little work.

Can I derive 2 values from the stated range: Expected_S-T [0.085-0.250]? When I use the text functions in separate calc fields, the Right(text, number) gives me problems...please see below.... Here's the problem: Left(Expected_S-T, 5) gives me the value .0850 which is acceptable, However.... Right(Exptected_S-T, 5) gives me the value WITHOUT the decimal point...(85025) and picks up the last 2 digits from the first value. How can I get the value 0.085 in one field and 0.250 in another field--both originating from a single field? Anything would be very helpful! I can upload the file upon request. Thanks, Jon

Figured it out this afternoon after looking looking around. Thanks for looking though. Jon

I have an inventory solution in which I would like to perform a conditional find script based on whatever the info is in the text field <product_id>-in that given record. For Example: In record 3, the value in <product_id>=rsrchlcp. Based on that particular value, I want to find all records based on that criteria alone. OR in record 4, <product_id>=lhexec, I would want to find all records based on that specific criteria. I'm stumped on this one. Can I do this with one script-if so..how? Any suggestions would be greatly appreciated!

Thanks for the reply. I currently have one field labeled "Binder Size" that contains, per client, one of 4 different values. I imported this info direct from Excel and had thought that creating 4 different size fields would be better, but wanted to take a stab at this first. Can I still loop a set of records and pull the different values from one field and place them into the appropriate global fields, i.e. the 4 gSizeCount fields??

Greetings, I'll try to make this as simple as possible. I'm just now breaking into working with loops, or at least realizing that I could use one here. I would like to loop through a set of records to determine the total qty. of 4 different size binders from one field <binder size> among dozens of clients--each client represents a separate record. (i.e. Client A would have 1 2.5" binder; Client B would have 2 1" binders). I plan on sorting by <consultant>, for one consultant has many clients. I think that I should have 4 global fields, 1 for each of the 4 sizes. These fields should be used to paste the result of the loop calc, right? Basically, what would be the best way to do this? Anything would be great!! What would be the simplest way to do this? Thanks, Jon

Thanks Jason, that was what I was initially thinking, but I'm still green in this area. Best Regards, WHW

I will soon be upgrading my Inventory Management System to utilize a barcoding system. I keep track of various printed materials for a medium sized company and want to print Barcode 39 labels to my laser printer instead of purchasing a specialized thermal printer. I will be printing at a very low volume. Does anyone have a recommendation of where to look for barcode labels? Does Avery make them? I will plan on printing from FMPro. Anything will help, thanks!