10 posts in this topic
Portal filtering to specific number of records
Hi all.. Can a portal be filtered to a certain number of records it can display.. For example, I have a portal that shows my contacts (100).. I want to filter the portal to show only max of 10..
I have tried removing the scroll bar and limiting portal records to 10 via the portal settings, but I still have the feeling that filemaker actually served all 100 records just that I am being able to see 10..
Reason for my question : I have read that to enhance performance issues and fast loading of data especially via 3G networks, it is advisable to limit the records been served.. Such that only needed ones are served to the user...
I don't know if I have really explained my point.. But I am available in case of any clarifications
Need through relationship
While creating a database that has Products, Suppliers and Lines I have come across the need to calculate a count of the suppliers from the context of a Products record. My relationship is like so:
My question if I want to pull a lot of information about Supplier is should my portal in the Products record be from Suppliers or from Lines? If the best answer is Lines, could I still have a count of related Suppliers by using the primary key from that table in the portal? Is it a bad idea to use fields from a related tables portal other than its own? Thanks
Portal Row additions script
New to the forum but have been using with FM13 & 14 for past 12 months to produce a Recipe Database based on an earlier Template EOS posted (attached).
Tried a number of different fixes but the following have me stopped - any advice would be appreciated.
The main things that have me stumped (and have spent too much time trying to solve) - see attached my modified file of script that adds a selected ingredient from a selection portal to another recipe portal - to allow entry of a quantity. (The script is a modified EOS original - post IngredientsAndSuppliers_eos ORIGINAL.fmp12):
For a recipe I need to add the same ingredients more than once - Eg: Olive oil is used in the Main recipe and added to SauceAdditive 1 and Spiceadditive 2. My problem is I can't get a new line added to the portal as it goes straight to the existing ingredient line whereas I need 3 x entries of Olive oil based on my example? (Think it needs a portal counter but my attempts to change haven't worked) The script does not always go to the same line and field - whereas I would like it to go to the last line and to the quantity field ready for entry on each selection Would still like to keep the error check - as that part is OK.
Portal and body part resizing in List view?
Is it possible to have a Body part as well as a Portal within that body part both resize, dynamically, based upon the number of records within that portal, within certain pre-defined bounds?
I have a table of Foods (in database speak, not in the literal sense). The Foods table has a child table called Ingredients. We show the Ingredients via a portal on the Foods layout. The Foods layout is Browsed in List View. The Body part is, say, 150 pixels tall. Within that, we stuff a little 140-pixel-tall portal showing a few rows. We could define, say, 4 rows. But that would be boring. Not all Food have 4 ingredients. Some might have just 2 ingredients, others might have 20 or 30 ingredients. What if I wanted that Foods layout's body parts and portal within to grow a bit for the "20 ingredients" and shrink a bit for the "2 ingredients" scenarios? Additionally, perhaps, grow and shrink within specific bounds, like, say, "never smaller than 2 portal rows, never bigger than 10 portal rows, scroll the portal if more than 10". Or is that asking for a pie in the sky? Specifically, I need them as portals, which is why I am asking about Portals, because some buttons are going also to live in the portal rows that do other things, which is why I am simply not doing a text concatenation of Ingredients if all I wanted was to only see a neat list of ingredients.