8 posts in this topic
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.
I'm very new to FileMaker design, so I may be missing something very basic, but I cannot figure out how to make this work. I've got a working portal set up, showing the correct records. I can add new records using the blank line in the portal, and those records then show in the portal window. However, if I go look at the actual table that the portal links to, the new records are not being added there. Are they going somewhere else instead? I need to actually create new records, not just display them!
Hi, I’m really Stuck , any suggestions would be most appreciated.
I need to replicate a particular behavior of the PopOver that is inside a Portal.
When inserting or editing portal Rows via popOvers, the data updates in the portal before “committing”.
Trying to replicate this behavior according to this rules:
-. Using Transactions and Data modeling.
.- Data not updated at the portal before committing (refreshing portal by trigger or exiting a field doesn't work).
.- Data not updated at the portal as inserts or edits are been made (same as above).
.- Inserts or Edits are made outside the portal in the same layout (no modals, Using SlideControl).
.- Not using PopOvers inside portal.
.- Portal is not accesible by user it only shows the list of items been inserted or updated.
I have tried different approaches but no solution yet, trying to replicate behavior has been very frustrating.
Filtered Single Line portals and Magic Key with different Techniques and different relationship approaches, I have not tried Globals via Scripts which I presume could be a solution but don’t have much to start with!!!.
For the record:
A few months ago I started implementing “Selector Conector and Transactions”, I´m not so sure I have correctly implemented this.
I have prepared a Sample file (is not the actual solution) with very simple use of Transactions and Data Modeling, it shows different approaches I have tried. Used some technics learned here at this forum which have been very helpful.
Approaches number 1 and number 2 from the Sample file are not the preferred, but merely show the behavior I´m trying to replicate.
A script at start creates small window that shows records are been created in child's table even tough it won’t update the portal before commiting when using technics 3 and 4 from the Sample file.
Hope my explanation makes any sense.
Thanks in advance, and cheers to all
PS.: Check the green Framed Portal at the right hand side of the layout´s Sample file for a cool technique that I designed, it uses “Hide Object when”, and a combination of formatting the Button and portal row (Padding), which makes the illusion of an X circle appearing on the right side when Hovering portal rows, mostly used for deleting. Hope any one has a use for it.