8 posts in this topic
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:
Crashing with filter formula
Since upgrading to FM14 we've experienced crashing (errors 1000 and 1026 in the error log). I thought perhaps it was to do with version 14 or .net or my scriptmaster plugin.
However it appears to be to do with a filter that I had in place for a portal. It was probably just a coincidence that I had so many records that it was referring to by the time I did the FM14 upgrade.
I can probably do without the portal altogether really, but was just curious as to what the problem might have been.
The filter formula was: Cases Closed::Closed_TimeStamp > (Get(CurrentDate) - 30)
The Cases Closed table has around 22,000 records.
Any ideas what's wrong with this?
Portal exported to excel spreadsheet only contains one related field once, other fields are empty
Sorry if the title is a bit confusing, I wasn't sure how to explain it.
Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)
the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.
I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.
I hope this makes sense and thanks in advance for any help.