12 posts in this topic
I am having trouble with Find Operation getting slower and slower each day. There are some design consideration as per some articles i have read recently which i will be doing as well.
I inherited this solution from another developer, Find is based on some Calculation fields which are based further on some other calculation fields (both calculation fields have 'Do not store results' option checked)
I know its not the best of designs, i wanted to ask for any possible improvement to Find process as its getting clumsy now.
I have indexed relevant fields though, data in the table isn't huge, around 2000 records with 50 fields but Find is based on unstored calculation fields mainly.
Can PSOS be used in Find Operation?
Is there any other thing i must do at the beginning.
By Wayne Irvine
I have a FileMaker layout with a portal to another table. The relationship shows all unassigned records (related < 1). On each portal row I have a button which runs a script. The idea is that when you press the button the a value from the main record is copied and pasted into a field in the portal row (and as a result the portal record becomes 'assigned' and is removed from the portal.
I have the button running a script and pasting the value from the main record but it is pasting it in the first portal record, not the one whose button was clicked.
Is there a simple way of having the value pasted into the portal record where the button was clicked or do I have to store the record number (or something) and paste back to that record?
I have two separate questions regarding portals and how they work. Before I start let me describe what I'm doing. I'm constructing DB for local karate club. I have one table/layout with general info about members, I have second table/layout with records about belts (including color of the belt, when & where the belt was obtained, the mentor of the member & sparing partners of the member etc.) and I have 3rd table/layout that shows various activities of each member (there are also several other tables but not important for this topic). All tables are connected via key field (ID number)
I have no problem creating portals on 3rd layout to show me which belts particular member has with all additional info from the second table that go along with it. BUT I don't know how to create a portal that shows all members of the club that had particular member as sparing partner. Thing is that I have 3 separate fields for sparing partner because each member can have up to 3 sparing partners and I simply don't know how to connect them all so I can see the list of all members that have particular member as one of three possible sparing partners.
I know how to place count of related records in filtered portal but I'm not sure how to get a Total of this counts.
Any help is much appreciated!
By Volker Gurtler
The database has table1 with “Sample No” field relating it to table2 with “Sample No” field. Table 2 has a portal on a layout with Table1. Each portal row has the Category field with one of 3 values (MF,BP and CC). There are about 7000 samples. Each sample has from 1-12 portal rows displayed with 1 or more occurrences of the 3 category values one of the values shows the count of each value per sample.
The question is how do I write a script so that every sample has all 3 category values (MF,BP and CC)?
I have the following scripts for when there is only one value/portal - one for each of the 3 values (3 scripts are the same except that “Molecular Function” is substituted for BP or CC and “Molecular Function” = MF):
Perform Find [ Specified Find Requests: Find Records; Criteria: Transcript Database::Regulation: “=test” ]
[ Restore ]
Perform Script [ “Sort by Sample No” ] Go to Record/Request/Page
[ First ]
Go to Portal Row
[ Select; First ]
If [ GO_GOT::Putative Gene Function Category
"Molecular Function" ]
≠ "Molecular Function" ]
≠ If [ GO_GOT::Putative Gene Function Category
Go to Portal Row
[ Select; Next ]
Go to Portal Row
[ Select; Last ]
Set Field [ GO_GOT::Putative Gene Function Category; "Molecular Function" ]
End If End If
Go to Record/Request/Page
[ Next; Exit after last ]
I can not get a script to work on a portal with only 2 categories so that only one of the 3 categories is added per sample.
Transcript Database v05 test.fmp12
I am newbie to filemaker pro but love it Said so, I am struggling a solution that I am building for management of holiday apartments, based on FMSP. I have created a table for bookings, and apartments, and now I am working with another table call Daytariffs that would give the price for each day of the year for each apartment. So far I have being able to show the available apartments for a range of dates, but what I am struggling now is to show the prices for those days. Basically, what I have done on the DayTariffs table is to load 365 days (records) then I have created a field called "Range" and put a calculations that shows "YES" if a date is within the dates I have set on the Booking layout as StartDate and EndDate (this dates are global fields). I have created relationship between Daytariffs and Bookings through ID_DayTariffs (Daytariffs table) = id_daytariffs (Bookings table). Later, I have also created a global field called "BookingDAYS" on Bookings tables and set the field value as "YES", and I have created a new relationship that relates BookingDAYS = Range.
Then I have created a portal based on the the relationship between BookingDAYS=Range, on the Bookings Layout but wont show any records I am stuck here because if I change the Range field to be just text without any calculation and I write "YES" then the portal works, but as soon as I put the calculation back, the related records disappear...
I have checked that calculated result on Range field is set as Text as well as BookinDAYS is a text field... also what have noticed is that the relationship graph for BookingDAYS=Range has this simbol at both sides "|---" when normally would have a three lines (like a folk) when I choose any other filed for that realtionship instead of Range.
I am attaching screenshots of relationship graph, booking layout and DayTariffs Table
Any ideas what I am missing here?
Thanks a lot.