Search results for query: *

Does anyone have a good solution for creating charts, or know of a good plugin/program to create them. I have tried Fusion Charts, but it does not seem to work on our server. I currently are doing them by exporting to excel, but that is not dynamic and a real time consuming process to...

AHHH Got it!!! had my end if in the wrong spot. thanks for your help.

it does not seem to prevent the FileMaker Access Denied screen to show up before the script runs for some reason.

I want to know how to allow the user to go back to the last page or a home page if they go to a layout that they don't have access to.

The Problem is that the @ symbol means one character in a find in FM. If you enter find mode and click on the symbols tab in the left you will notice the types of symbols and what there meaning is. You need to use quotes before and after the @ symbol to make it a literal search on the @...

when I do a find in a email field and type "@" it pulls all the records with a email address.

perfect, you rock

This is great. Is there away that I can set it up so that I don't have a check box field, but have that field already have 1 2 3 4 5 6 7 in it, so the user won't have to check them. but it solved my problem pulling duplicate bookings for me. Thanks so much for all your help with all my...

Yes, Filemaker 9 Advanced

Thanks, I figured it out. It made more sense once I got into it. I was trying to make things more difficult then they needed to be.

I have never set up a custom function, could you give me a example of how I might set one up with the example of needing the date ranges described above?

TStriker, thanks for responding. Yes I want the actual dates not just the number of days between the start and end dates. I need to get the dates to check for conflicts in double booking rooms and equipment. Tim

Is there away to get the dates in between a Date Start and a Date End fields?

I am trying to figure out the best way to set up a reservation system for items in inventory. I have a table with the items in it and I have a table to reserve those items. I want to be able to just pull down from a list say 20 of the items and have them be assigned to a project for the days...

if its allowed you could send me a copy of the file and I could take a look at. If you portal is correct and you have the two tables linked together by the key field which should be status or something like that. Then that should be right. Your calculation should be a case statement with the...

Yes my portal is filtered by month and status. It then calculates all the invoices that meets those requirements. so say I have July and Billed. It totals up all my July invoices that have been billed. Is your portal showing the correct data?

your calc field needs to be in the table you have your portal on. It needs to reference the table occurance. Your relationship for the two tables needs to be on the key field that you setup. I assume it would be "Status".

dodjah, Yes I did. I was being stupid and had it calculating from the wrong table occurance. You need to set up a calc field in the table you have the portal set up on. Then set your calc using the information from the related table. for example mine was trying to filter a portal based on if a...

Thanks, Its amazing what a weekend away from it will do for you. I figured my error in the code. thanks

Not sure what you mean by that. My goal would be for the calc field to change depending on what the user selects. Is this even possible?