10 posts in this topic
Relating tables with month and year
I have two tables Claims and Premium
Records on both tables have dates
I want to do an analysis for both tables on monthly and yearly basis with a calculation field
Analysis (Claims::claims + Premium::premium)
my objective is to be able to gather all the records for each month and each year on both tables using that analysis. That is my basic task. There are other fields like Remark, and recommendation but they are based from the result I get from the Analysis. For example, Analysis field is > 120 , Remark shows Excellent..
please how do I achieve this?
FM Relationship Error Message
In my attachment, when I search for "Cutting tools" in the main table. It produces the following message. Is there a way I can get rid of this message. I think I know why because I got my product line through calculation of look up.
"This operation cannot be performed because one or more of the relationships between these tables are invalid. "
Find in progress. Processing query... - going slow for only ONE portal
New to this so not sure what is needed to help me. I have several portals in my database and they all have filter and sort settings. All the settings are the same on each portal (just pulling from different layouts). Each portal has a button with a script in it that has it "go to the related record." All of my portals and go to related things work great and quick an no issues.
Yesterday, I added a new portal and a new go to related and updated my relationships, etc. everything mimics the same settings on all my other portals. BUT for some reason this one portal and go to related are lagging big time and everytime I do anything that affects that portal I get the "find in progress. processing query..." and it takes several minutes to process.
I do not get this my other portals and I'm a bit confused and feeling frustrated that I'm having trouble with JUST the one portal. HELP! What do you all need from me to help me with this?
Portals content in email as table
By Christopher Michael Binks
Hi I'm pretty novice at FileMaker but have as solution pretty much operational internally.
My company is all based on running bookings with external clients and provider all through email.
Currently it's all done manually the admin assistant copies the booking from the booking sheet to a email templat in a table and then sends this out one table to the client, another to the provider of which there can be many.
The bookings are trotted up in a portal on the clients page with a new line for each product. Can I export the portal to a html table to email out generating a new table row for each matching portal row?
I presume I'm not the only one generating lists of items for email but can't get a handle on how to achieve this without a fixed table and substitution line by line have looked through all the documentation I can find
Assistance greatly appreciated
Conditional Value List in Portal with multiple field values
I am trying to create a daily sales call log, for that I have used Portal for which I am using "company" table in which I have "contact 1" to "contact 12" separate fields for each record (company)
Now, on the portal, I was able to fetch contact names dynamically based on chosen company using conditional value list relationship and creating new text field with auto-enter calculation of List(contact1,....,contact12), but how can I fetch contact number for selected contact name for that company? I created a new field to auto-enter calculation of contact numbers like the same way but it seems like I am going in wrong direction
It would be great if anyone can tell me as I am learning FM.
Or is there any other way of doing the same?
Here is my relationship diagram and layout: