jjsaldana

I’ve been struggled with this simple problem and I am sure (or I hope) someone out there has a simple solution. What I try to do is to remove the space and carriage in the last line of text. I know how to use substitute to remove carriage return, but I have a note field that carriage return is ok unless it is the last line of text. The note field need to convert to html format and the last carriage return (returns) is a pain to deal with. Thank you for your help. -JJ

I am working for a PBS station and currently I am working on putting our pledge activities in a database. For our TV pledges, I created a program table, a scheduling table and a program_premium table (a table between premium item and program). I join program table to program_premium table, then join program to scheduling table. The data entry works great. All you need to do is add a program record and add in the pledge breaks in a scheduling portal, then select the premium offer in the program_premium portal. The problem is when I try to run a report to see what was offering and the date and time of pledge. I pull the records from program table. I use tow portals one for break and the other for premium offer. The break portal is fine since the data is simple, but when come to the premium offer. We need the pledge amount, premium code, short title (description) of the premium and description (long) field. I use merge fields for all the fields and slid up everything in the report. Problem is portal does not slid with field content. It will reduce the rows if there are no record but not the size of the portal. In other word, if the portal is set at four inches tall and the content of the text only requires two inches, the report still show as four inches high. In order to fit in all the description I need to make the portal large enough, but if I make the portal too big, I get a lot of white space with one portal row per page. Does anyone have a better way to do this? If I don’t use portal then I can only see the first row of the portal.

Thanks a lot. It only took me a few minutes to re-write my script and it works great. My users will love you for this and I discover the wonder world of variables.

I need to export graphic image with a specific name for a project that we are require to upload images to a web site that host on-line auction for us. We have the product ID to show different auction item and the image name have to somehow reflect the product id. I created a field to use as file name in the database, but I don’t know how to make the export file name using the field I set up in the database. Any idea?

I am working for a PBS station and currently I am working on putting our pledge activities in a database. We have both radio and TV pledges. What we do in radio pledge is that we solicit donor for challenge grant and bonus gift (usually are in-kind) to offer our listeners. We do offer premium, but it’s only a handful of program over the weekend. The structure I set up works really well for radio pledge. I basically set up a solicited item table and scheduling table to track one solicit item can be scheduled in different pledge break. I am trying to look ahead for our TV pledge that should be happening in a few months. TV pledge is program driven. We offer premium for each pledge break. The premium offer can get complicate. We offer different combination of premium package depending on the pledge level. I come out with an idea the other day to track TV pledge form program. I created a program table, a scheduling table and a program_premium table (a table between solicited item and program). I join program table to program_premium table, then join program to scheduling table. The data entry works great. All you need to do is add a program record and add in the pledge breaks in a scheduling portal, then select the premium offer in the program_premium portal. The problem is when I try to run a report to see all our pledge break and what we offer in each pledge break for a specific date. I pull the records from scheduling table. I have one summary parts group by program and the body of the report is the break and time then premiums that are offered. The problem is that the only way I can show all the premiums is to use a portal to show the multiple items that are offered to a specific program. If I don’t use a portal, I only get the first record and I hate to use portal in my reporting. It is hard to control to mike the report looks nice. I was just wondering if there is any other object that can be used to bring out the many records in the program_premium table. I know the problem is that the scheduling table does not link to the program_premium table, but if I want the program_premium link to break, there are just too many redundant data entries. Thank you for your help.

I am working on creating an imaging store for our design department. One of the requirements they want is to automatically import fie height, width, dpi, and pixel information you see in photoshop or even in the window properties into the database fields in FMP. When I use the import folder function, I could not find such details in the import option. Does anyone know if there is a plug-ins that I can use to do this?

I tried to import imaging files from a folder and every file made it to the contain field except .eps file. It simply shows as blank. If I used insert picture, I can insert the file in the container file. Dose anyone knows why and how to fix this problem. I am using developer 7. Thank you.