8 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
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.
Adding content to portal
I have a working database that uses a Double Booking system provided by the FMForums commenters (attached). My problem is that I need a way to quickly select multiple rooms and apply them to 1 conference. My goal is to use a one click method on either a button or field to add the room to the list. I also need a visual way to determine if a room is booked or not. I have already experimented with conditional formatting and buttons but this seems to not be the best way to make this work. It would also be nice if the item clicked to assign and the conditional formatting were one item.
I already have the system functional using this example but I cannot seem to figure out a way to quickly and effectively add rooms. Some groups use up to 50 rooms at a time.
If you have any ideas, please let me know.