FileMaker Interface Features
-
Just asking a general question about portal behavior. I have a portal and i had put an "X" to delete records but this was put in my Orders table. The portal was based on my Line Items table So this is what i noticed. If i use the icon from the orders table this is the effect: What i did was create a new field in my lineitems table to lookup the orders trash "X". and i get this: I would like to know why i get the undesired repeating field when i think it shouldnt matter? thanks
-
- 8 replies
- 1.6k views
-
-
Hi all, This has got to be a simple issue. I'm creating some new layouts for an existing database. It's hosted on FM server. Each time I open the database, and go to my "TEMP" layouts that I'm working on, I end up going to the View menu to un-check Page Margins, then View | Show | and un-check Buttons and Field Boundaries. Finally, in the Inspector, under position, I click the inch indicator twice to change it to px. Then, with all that done, I feel like I'm ready to work. But, if I close the database, and re-open it, I have to do all of that all over again. How can I make it keep those options? Thanks in advance.
-
- 2 replies
- 977 views
-
-
For whatever reason, the past two layouts that I have created do not how the actual checkboxes for a field when I enter a value set and choose "checkboxes." It has never done this in the past, and has always shown the checkboxes even when empty. does anyone know why this suddenly changed? is this a glitch? also, when i add any lines into the layout, they also do not appear....
-
- 4 replies
- 1.2k views
-
-
Dear All, I am working on a layout and I want to disable the right menu bar, which is visible after clicking the right button of the mouse. The menu is like this ----------------------------------------------------------- Copy Record ______________________ New Record Duplicate Record Delete Record... ______________________ Sort Records... ______________________ Save/Send Record As ______________________ Send Mail... ----------------------------------------------------------- I just want this menu unwanted menu to be removed from the layout in Browse mode.
-
- 2 replies
- 924 views
-
-
I have a value list displaying names in a repeating field. My problem is that with the list containing, for example: Bill Wyman, Keith Richard, Mick Jagger, Charlie Watts and Brian Jones, no matter who I highlight, I always get Charlie Watts (who, you've probably guessed, lives in repetition 1). Why am I able to see and highlight content that I can't use? Am I asking too much of repeating fields? Or, am I overlooking something?
-
- 2 replies
- 983 views
-
-
Being a newbie, I encounter these dumb problems but I know someone always has the simple answer. I am figuring something is locked or a field is stopping me from adjusting the layout. I copied info into a new layout and needed to format it so I can print the data on an 8.5 x11 sheet of paper. i have a header area, a body area and a total area. My problem is I cannot adjust the body area. I want to reduce the space it takes up. Ultimately I want it to slide up and down based on the number of fields I have filled in within what will be a portal I am figuring. I have included the layout for reference. Any help appreciated. Thanks in advance.
-
- 6 replies
- 1.3k views
-
-
Breaking my brain here... I have a company table and a person table. Records from the company table need to show up in a value list in the person layout, so a company can be selected for a specific person. This is easy and works. Now, what I thought was also easy does not work. I have a field in the company table which makes a company active or not (1 or 0). So what I want is that the value list only shows the active companies (1). I made a global number field in the person table with value 1 and made a new relationship with the company table, linking the 2 fields. Supposedly when they're both 1 there's a link... But not. Please suggest.
-
-
- 5 replies
- 1.3k views
-
-
I have a layout that contains a portal to another table. When I view the records in the main table in browse mode/table view I see all the fields OUTSIDE of the portal from the main layout, but the fields from INSIDE the portal only show the first record. For every one record of the main layout I get one record from the portal, even though there are many records in the portal for each record of the main layout. It was suggested to try a new layout of the main table to show the fields I need from the portal, so that they are main fields in their own layout instead of a portal. I tried but this still only gives me the first record in the portal. How can I view all the…
-
-
- 35 replies
- 5.9k views
-
-
Is there a way to create a value list that can incorporate both a checker box and text format? For instance, there are four options for a particular field: normal, unknown, abnormal (explain), and other (explain). I'd like to incorporate these values as checker box options, and if either the abnormal box or other box is checked, then a text explanation is necessary.
-
- 1 reply
- 849 views
-
-
how can i stop the filemaker pro alerts.....? Please see the attachment of the alert. I have to stop this alert generated by filemaker.. Please reply soon.
-
- 10 replies
- 2.1k views
-
-
Hope I'm in the right place here... I have a person and company table. Within the person layout I have a portal which displays the persons that are related to that company, clickable to easily edit that person without changing layouts. Very nice btw. But it also displays the current record (which is logical). What I want is all related persons within the company of the selected person, minus the current record. Suggestions welcome.
-
- 4 replies
- 1k views
-
-
HI everyone, I am thinking of creating a new database which will generate the maintenance schedule automatically based on the frequency per year.Currently,I have 2 tables: 'Machine Information' and 'Maintenance Records' in the same file On the top will be the machine information(Model and Serial No etc) and the Portal below will display the schedule generated.The fields on the top and those in the portal belong to different tables with the Model and Serial No being the link(common fields). I have attached a picture of the layout for a clearer description. Questions I wish to just create a new record on this 'Machine InformationTable' and it will automatically cr…
-
- 2 replies
- 1k views
-
-
This has to be something simple, but I'm a newbie. : / When I'm editing my layout everything looks as it should, but when I 'Exit Layout' and enter 'Browse' mode, Everything in my layout changes sizes. When I zoom to 300 everything is proportional the way it should be, but when zooming out to 100, some items shrink and some get larger. I can't fix it, because when I edit the Layout everything is okay. Weird. Everything seemed fine until I was curious how my Layout would look printed. I clicked 'Open PDF in Preview' in the print dialog box, and when I went back to work on my Layout, this happened. Please help! Thank you. Two screen sh…
-
- 3 replies
- 1.6k views
-
-
I have a portal field that is a popup type. In addition to letting the user choose a value for the field, I would like a script to run when the user clicks on this field. I have tried the following without success: 1) If I give this popup field button capabilities in order to run a script, the script will run but the popup function no longer works. 2) If I try to use script triggers for this popup field, no matter what event(s) I choose, the popup function works but the script never runs. Any ideas?
-
-
- 4 replies
- 1.1k views
-
-
Hi Guys: I have a portal that holds a value list that it populates from another table. I would like to have the list to filtered if the value has been selected in the portal, so it doesn't repeat itself. For example If I have Machine 1, Machine 2, etc... and select Machine 2 in my first record in the portal when I create the second record it will take Machine 2 from the value list. My relationship is as follows. Shift Table kp_shift_id ..... Machine table kp_machine_id ...... Transactions table kf_shift_id kf_machine_id .... Shift and machine table are already related to my transactions table in the relationship graph. My val…
-
-
- 2 replies
- 1.7k views
-
-
This is a troubleshooting question: In one of my files there is a Company table and a Contact table. Each table has it's own form-type layout. The table occurrence group for the Company form also contains an instance of the Contact table in a one-to-many relationship. The Company layout contains a portal to the instance of the Contact table in it's TOG. As well as fields from the Contact table, the Contact portal contains a button that, when clicked, runs a script which accepts a parameter indicating the child entity (in this case, Contact). When the user clicks on the button in one of the Contact portal records, this script uses the Go to Related Record scrip…
-
- 12 replies
- 1.6k views
-
-
When setting up a value list is it possible to set it up so that it only includes values from certain records within a table. For example I have a table with authorisation passes in that have an expiry date. I have a calculation field set to display either 'Valid' or 'Expired' dependent on the expiry date in relation to the current date. I would like the value list to display only values from records that meet the 'Valid' criteria. Does that mean that I have to create another table that only contains 'Valid' authorisation passes or is there a way to do it from the table that contains both 'Valid' and 'Expired' passes? Thanks in advance.
-
- 6 replies
- 1.8k views
-
-
This should be easy but I can't find how to handle it: On any layout, If you click anywhere outside of the fields (any empty space) FM triggers a validation. It could be something like ''please enter customer number'' or whatever. I find it very frustrating as I would like to see nothing happen if you are not actually clicking into a field or trying to exit a record. My fields already carry the validations I need. Is there a way to turn this behavior off? I'm on FM 11 Advanced
-
- 1 reply
- 2k views
-
-
Hi there out there, I just want to rearrange an existing starter solution database layout. • When I go to layout mode, I shift around elements but when I go to browse mode what I have adjusted is messed all up? • I am assuming there is some default over ride somewhere that is causing this but I cannot figure where. • Items that I have moved and set up to align left are now moving to the middle. • Field widths that I have adjusted are now all different. Any help would be appreciated. Also when i go to print the page that I am on it goes to a totally different page, forcing me to do a find only the page I want. Go to the layout I want, find it again (new …
-
- 4 replies
- 871 views
-
-
I'm using merge fields to display a series of data in one line. Ideally, I would like to separate each field with a comma. However, when there is no data in a given record, I don't want a bunch of ",,,,,,,". Even using spaces can look a bit odd, if there are five spaces before the first item in one record. I'm hoping there's an easy fix? Many thanks
-
- 7 replies
- 1.5k views
-
-
I know this has already been answered on here, but the conditional value list threads I keep findings seem to be asking slightly different questions from what I am after. I have a field of interest [status] on a table called "Checklist" with many possible responses in its value list. I am ultimately trying to create a running list that shows the last names on each record where [status] is any value other than "Complete" (others include "Need to request", "In Progress", etc.") I decided to create a second field [status Incomplete] on the same table ("Checklist") with a single value (*Yes") so I can perform a much simpler find for all records where [status Incom…
-
- 6 replies
- 2.7k views
-
-
I think what I need is a portal, but there may be a way to accomplish my objective with a find script. Please see my 'About Me' section for a description of the project I'm referring to. This might help describe it as well: [TABLE]Field 1- [isolation Points]Component, Description, Position, Notes 2- [Equipment]Name, Description, System, Notes 3- [Equip_IsoPnts] Equipment:Name, Isolation Points:Component The 3rd table relates the first field in tables 1 & 2. On my layout, there's a dropdown that allows the user to select a value from the Equipment:Name field. Below that, in the layout, I would like to insert a table that lists all r…
-
-
- 3 replies
- 1.9k views
-
-
I have a layout that (in Browse Mode) has dropdown lists that display data from another table. I would like the new record created when filling out the layout to log the date/time the value was selected and display that on the layout, adjacent to the selection that was made. This is a form that, on paper would have several people sign and date it. The dropdown would be from a table of personnel. I would like there to be a field on the layout next to each persons name that autofills with the timestamp when they select their name. There will be several occurrences of this, and will not be at the same time, so an overall time stamp for the layout/record won't work. It …
-
-
- 3 replies
- 2k views
-
-
Anyone know a keyboard shortcut to engage the Format Painter?
-
- 3 replies
- 3k views
-
-
I used the layout wizard to create an envelope layout. It looks alright in preview mode but when I print I get two pages (I'm using paper cut to the size of the envelope to save money while testing) for each record . On the first page I can see the right half of the address block against the left side of the page. The second page is blank. Any suggestions?
-
- 8 replies
- 3k views
-
-
I am trying to create a payment solution for my existing database. I have everything else working right now, but no way to keep track of payments. As it appears from my searching on Google, I need to create a join table as I have a many to many relationship. So this is what I have now. Invoices:ID_Invoice ---<Invoice_Payments:id_invoice Invoice_Payments:id_payment>---Payments:ID_Payment Inside my join table, I have a field for Payment_Portion. This way I can designate how much of the payment will go to each invoice. Sometimes I get a payment for one invoice. Sometimes its for a couple. Sometimes its like a down-payment or something on that order. …
-
-
- 11 replies
- 5.1k views
-
-
Hi guys, please give me a solution for a problem: How can i use checkbox as radio button in portal rows ? I have some records in portals, I want to make only one of the records gets checked. it's urgent.
-
- 1 reply
- 927 views
-
-
Dear All, I have three columns in my portal. I am passing some web address in one of the column of the portal, and in every row the the web address is different. For example, in first row I want to open google.com, in second one Rediff.com and in third one yahoo.com. here I am using set web viewer script and I have assigned 'web' as name of the web viewer. Please help in achieving this task. Thanks in advance.
-
- 0 replies
- 1.4k views
-
-
Hi: I'm a Novice user of Filemaker 11 getting trouble finding a solution to link 2 tables from a set of values located in a Value List. The first table Products:Product_ID holds the list of products The second one Products_to_Products is used to show in a portal the products that have the same specs and that can be considered as "similar" or "compatibles". I need to create the link between this two tables using a Value List. Example: 4 products has been selected and the value list contains the Product_ID for each one separated by a CR: myValueList 1 2 3 4 Now, based on this list, I need to create in the table Products_to_Products the …
-
- 4 replies
- 4.1k views
-
-
I am trying to update our database and create more space. When it was originally developed, the bottom half of the screen was split into two separate tab panels and information has been stored that way for years. I would like to merge all tabs into one large tab panel. Is this possible?
-
- 3 replies
- 3k views
-
-
Hello, I'll build a database for a simple order system. On the first layout i'll have a drop down menu in a portal. Now i want to disable users to type text in this drop down menu how can i do this. I only want that they can choose values from this list and no typing at all. Thanks already,
-
- 5 replies
- 1.7k views
-
-
I have a value list set to use the value of the first field and to display the value of a second field. If I use a pop up menu, both values get entered into the field. If I use a drop down list it works as it should and only enters the first value. Am I missing something obvious?
-
- 2 replies
- 1k views
-
-
I've created a bucket on my main database layout to hold documents, in this bucket I put .pdf files between 1 and 10 pages long. Without then re-exporting the pdf's to my desktop and viewing them there, how can i display/view then within filemaker? Thanks, Matt
-
- 3 replies
- 1.2k views
-
-
Our main database used 8-inch layouts. It is based on a Filemaker template from 2005. It's ready for a makeover. I see that the Filemaker 11 templates have a 12-inch width. That extra screen real estate would be nice. Just wondering what size some of you are making your databases.
-
- 3 replies
- 1.2k views
-
-
As shown in my attached screenshot, I'm trying to print a list of records from a found set, but only those records where the value in the LEDGER::total summary field is equal to zero. Currently, the layout is showing all records, not just the records where the total field is equal to zero. I thought I could use Conditional Formatting to accomplish this. If the field's value is not equal to zero, I want to "skip" these records by changing the text colour of each the fields to white. But, I'm not getting the desired results (the result is that it white's out all records). I thought using Getsummary function in the formula would help, but no. Any ideas? Thank you from…
-
- 3 replies
- 1.5k views
-
-
Hello Everyone; I am on my third attempt at a user interface design which i think would work better for my current project. However, i am unsure if i should use a portal to show the sub category or should i just show / hide repeating fields . I have attached my sample file (proof of concept) to see if i am on the right track and how i should go about doing this. The top of the file when selected will show / hide the subcat( cakes, pullaparts, suites) options below and then the tab object will be selected based on a script. Options i would like to do are possibly; portal conditional formatting i hope this is clear but you will see…
-
- 6 replies
- 2.6k views
-
-
I have a set of custom menus installed where I wanted to use the three layout view buttons to switch between three different layouts, one form view and two list views. I've added a script to each button change to the appropriate layout, so that form view is on the form button, list1 is on the list button and list2 is on the table button I had to leave the Based on Existing Command checkbox active on each of the items, so that the buttons remain active. However this means that they also assume their default layout switching behaviour, so when I have selected list2 by clicking the table button, list1 can't be selected because list2 is a list layout so inactivates the …
-
- 0 replies
- 1.6k views
-
-
Hi, I have 2 related questions. I have a portal in my invoice. It is followed by a closing paragraph which slides up to where the portal ends. I am producing a pdf to mail to the user. The portal may grow to 25 lines which would take it across the page break. Q1. How do I get the break in the portal to respect the page margins? It seems to print the first line on the second page half cut off by the top of the page. Q2. If the portal is only a few lines is there any way to eliminate the blank page 2 of the pdf?
-
- 2 replies
- 1.8k views
-
-
Hi all, I would like to use a value list for summarizing part of the data in my database. My database is a linguistic on - the main table is 'Sentences' in which sentences are stored, then there is a table 'Morphemes' which stores information on words from these sentences (I enter data into Morphemes through a portal in Sentences). I want to make a list with the unique values present based on two combined fields from the table 'Morphemes' individually for each language, and also have Filemaker count the unique items on that list (so I basically know how many morphemes of one type each language has). I created a new table, called ‘Analysis’, in which I created a …
-
- 1 reply
- 940 views
-
-
More than once I've been looking for a way to make a single navigation header for use on all layouts. Working daily with PHP and HTML, I'm used to making a 'header.php' for example, having all the navigation buttons in a single file (either static or dynamic data), including a link to the file on each page. No matter where you are, or when buttons change, you are dealing with or loading a single file. In Filemaker you would wait until the database is almost finished, then make a navigation header in one layout and copy-paste it to all other layouts. But if changes occur, or if you use different images to highlight tabs when a layout is active you're in for qui…
-
- 11 replies
- 8k views
-
-
I have estimate table and there is portal which is coming from estmate line item. i want to copy the record of portal and create new record
-
- 4 replies
- 1.6k views
-
-
I've had a bit of a think on this and can't come up with an idea for a solution. I have a portal that will list employees. I want the user to mark a field next to one of the records in the portal to indicate they were in charge of the job. Anyone point me in the right direction so that the user is limited to having one record marked as "in charge" only?
-
- 8 replies
- 1.2k views
-
-
Hi Gurus, When a user is to add items to a Purchase Order, I run a script that takes them to a new window in the raw materials table, does a find based on the supplier ID, and shows them only the raw materials we get from that supplier. They are then able to select multiple items, they want to add and this then is scripted to add those items to the PO. Some suppliers, may only have a few raw materials and others may have hundreds. I need to be able to give further filter finds within the found set, based on the default supplier ID, so that the user can narrow down what they are looking for. I have already created qualifiers for the raw materials (within …
-
- 1 reply
- 1.3k views
-
-
Not sure which forum Tabs, Scripts or Portals is best but I think here.... I'm using a tab panel with tabs A and B Tab A is a form view for the records Tab B is a portal of those same records .. which in essence gives me a list view I'd like to click on portal row, say 6 for this example, and go to object tab A record #6, click on portal row 4 and go to object tab A record #4, etc..... I started with: Go to Portal Row [select; No Dialog; Get ( ActivePortalRowNumber )] Go to Object tab A ..... easy enough Then what ?? Or am I totally off base?
-
- 13 replies
- 2.2k views
-
-
I have been trying to figure the "BEST WAY" to do the following: when placing an ORDER in my system, Still in the design process to make sure i am not going to go in circles. if user selects products i have the following relations> products »» class_products »» class»attributes»products so if products = char_suite, suite was selected and the have to enter the following classes have to be entered : class»»products : cake & cupcakes & stand then they have to select from class»attributes»products: cake : flavor, filling,style, image cupcakes: flavor(s), colors, topping stand:(sel…
-
- 0 replies
- 1.3k views
-
-
I am a novice at layouts and filemaker language, So this is what I am trying to do and I thank anyone who helps me figure out how to get this completed. I am trying to create a database search filter that will be able to return any and all records that fit the filter but can have an unlimited number of search criteria that are based on "and"/ "or" strings. I'm not sure if using a portal can solve this but this is what I'm talking about. example, search: first name="" , and, age<"" , and, height<>"", + or last name="" , and, team="" , and, record>"", + + The plus signs are buttons I would like to have to automatically add to the s…
-
- 2 replies
- 2.2k views
-
-
Is there any way to force the sort order of what appears in a drop down list when using values from a field? eg: Low-Medium-High, not High-Low-Medium (a simple example, others are more complex). Because I need control over list content to be restricted to one admin account, I am creating the lists from restricted access layout fields, rather than editable custom values. I don't want a second item in the list, but I also don't want items in alphabetical order. I want them in the sort order of the records/fields the list is compiled from. (I'm trying to match what the client currently gets in an Access database. If I can't sort it, they'll just …
-
- 7 replies
- 1.9k views
-
-
I've recently started working on a database that was started by someone else but never finished so i'm trying to finish it. The database has one to many relationships and i am trying to setup a filtered portal based on a field and am having a little bit of difficulty. So far there are 3 tables involved all of which are linked by a field called recipe_id: Recipes Recipe_LineItems Production On the Recipe table / layout i have a recipe name field there is a portal that is linked to Recipe_LineItem table which allows the user to enter each ingredient for that recipe. That part is working great. The problem i am having is with the productio…
-
- 6 replies
- 1.6k views
-
-
I have an emergency situation! I need to migrate the old database to the new database on Saturday and I can't until I can solve this problem. Any help is greatly appreciated! Table jobinformation Table Billabletime - Table Billabletimeselected is an occurance of table Billable time Table Codes - Table CodeType is an occurance of table Codes - Table CodeType is an occurance of Table Codes - Table CodeCode is an occurance of Table Codes Table occurance billabletimeselected has a field job id and a field billableid Table Job Information has a field job id and a global field billableIDselected. The relationship between the two i…
-
- 1 reply
- 993 views
-
-
I have a file I call Instruments (as in psychological ones, not musical!) which has two tables: scales (for the names of scales) and stems (for the text of each scale stem). I have another file I call Assessments, which is where the data field resides for all responses to any of the scales. I envision creating a script which would call up in one portal the assigned scale, showing all of its stems. In another portal, I would like to show the required number of rows for the data which would correspond to each stem. The challenge is that each stem can have quite different answer sets, e.g. one might be the 'strongly agree - strongly disagree' type while another could…
-
- 0 replies
- 1.1k views
-
-
Am i that insane that i just dont understand why this is happening. I checked forums all over and the net, no answer. Can someone tell me why this is happening. All of my fields are not editable such as changing the number to display currency,etc, here is a screenshot:
-
- 5 replies
- 7.1k views
-
-
I have 2 related databases. Contacts and Jobs. A relationship is set up on urn fields, with create/delete records via relationship enabled on the Jobs side. Contacts contains details of clients, contractors and suppliers and will remain ‘on site’. Jobs, whilst also on-site, will be copied onto laptops and used off-site. Some of the contact details needs to be held in the Jobs database and I’ve set this up to work using lookups. The lookup fields successfully update via a relookup script but, when new records have been created in Contacts, relookup does not create new records in the Jobs database. Should they? Am I looking for an error in the way I have set th…
-
- 2 replies
- 1k views
-
-
Is there a number of fields that when placed on a layout that will degrade the performance when viewing that layout. I have a layout with 240 fields on it. It draws from 4 tables. When the script I use switches to this layout, the hourglass or the spinner in win7 keeps spinning for 10 to 15 seconds and it happens when I scroll down from the top part of the report. After the report/layout has been populated, all appears fine. Also when I switch to preview mode, it spends some time calculating. I have attached a pdf of the report. Untitled.pdf
-
- 3 replies
- 935 views
-
-
Hello, Any help on this would be greatly appreciated as I am a bit out of my depth. Basically I have 2 tab panels, 1 with a suppliers address on and 1 with a clients address on, you will look up the address via a drop down list. The user will only be able to choose a client address or a supplier address but not both. Is it possible to restrict the user so if he chooses a client address on tab 1 he won't be able to choose a supplier address on tab 2? Is it possible to make the tab with the address on always appear at the front? Any pointers would be fantastic Thanks James
-
- 16 replies
- 4.1k views
-
-
When I turned me computer off Friday, the text of my layouts and the layouts themselves were all aligned http://imageshack.us...es/97/fmp2.png/ I turned the computer on this morning, loaded filemaker and as you can see in the pic below every field has been distorted. http://imageshack.us...508/2222jp.png/ I reverted to my backup filemaker file and the layouts are still distorted!! Please help! Thanks Matt
-
- 5 replies
- 1.4k views
-
-
I've got a database that keeps track of classes teachers take. Many are unique, many are classes that several teachers take. When the class is a duplicate, it's assigned a group number. I use the group number for portals to display staff that have taken the same class. I'm trying to create a set of portals on a layout where the user to see just group class names, select a class, then see the members. If I create a portal based on records that are identified as a group class, all records show, thus the name is repeated. I'm looking for a way so the name of the class just shows once. Then the the user could select the name (globals would set with the group id number)…
-
- 2 replies
- 2.2k views
-
-
I've put a database together with a few fields using ITC Zapf Dingbats, forgetting that that version comes with Adobe's CS suite and I should have used the Zapf Dingbats.ttf font supplied with the OS. (The client only has system fonts). I'm using triangular arrows plus a freehand-style tick and cross. All are put in either by auto-enter or by script. Switching to the .ttf version, loses the characters in the fields. My ideal solution would be to discover why FM won't accept the .ttf font (it works fine in other apps tried, eg: TextEdit, iWorks). I've spotted others with the same problem on the web, but not spotted a resolution. Any thoughts? If I can't fix it,…
-
- 2 replies
- 2.4k views
-
-
File 1 is how I'd like it to look as I've set it up in layout mode. However File 2 is how it looks in browse mode. I've played with the page size dimensions and that worked to an extent however I just want this layout to look like this, I have multiple other layouts that need to stay the same regular letter page size. Many thanks,fmp1.tifffmp2.tiff
-
- 6 replies
- 1.3k views
-
-
how can we resize the button in the same layout through the script
-
- 12 replies
- 2.1k views
-
-
Need to print a product Cataloug, but only using the records who have image in the container. I Can not find the solution to sort the records. Any solutions? Regards Glenn P.
-
- 4 replies
- 1.3k views
-
-
I would like to use a portal to open external files. I have a portal that contains related records from another table. Each record has a related video file associated with it. In a field within that table I have a file path that leads to the external file. To back up a bit, I am hosting this database on FM Server Advanced. I want the user to click on a portal row and open the associated video file in a separate window. I can do this locally by using the Send Event to open the file and this works. However, external users cannot open the videos. Is there a way to accomplish this using another function or event? Any feedback would be helpful. Thanks
-
- 0 replies
- 1.1k views
-
-
Hello all, Recently I downloaded a version of Filemaker Pro 11 and now after a few days of playing around and looking for answers and solutions I am stuck. I created three tables, first a companies table (only company names), second a user table (only user information with a valuelist showing company names in a drop down). Third table is a projects table where the company name is a valuelist showing the company names in a drop down). The last field is where I want to select a user with a dropdown, however I only want to show users in the dropdown that relate to the 'already' selected 'company name'. * note, tables as described are simplified to the fields…
-
- 1 reply
- 882 views
-
-
I have a startup script where I want to set the company logo which is in a container field and which I'm storing (NOT AS A REFERENCE) to a global $$ merge variable. I then want to use that global merge variable on various other layouts in the DB. First, can you set a picture file to a global merge variable? I'm not getting any image to appear on my form. If I can't do it this way can someone recommend a "best practices". Thanks. Dom
-
- 3 replies
- 1.7k views
-
-
I recently converted a FileMaker 6 solution to FileMaker 11. Every layout used the Arial font in various sizes and styles. I used the Arial Narrow font when needed; I never used FileMaker's "Condense" font style. I have always designed on the Mac and had been in the habit of "shrink-wrapping" the fonts to make the element as small as possible, paying little heed to what it would look like on Windows (the Mac snob in me, I guess). The problem was, upon conversion, that the difference between the Mac and Windows version of the Arial font has appeared to grow to a greater level (i.e. white gaps above the characters), and this difference even caused some data to disa…
-
- 4 replies
- 11.6k views
-
-
Hi All, I'm trying to work out if this is possible at all, so any tips or points would be great! I have a task table as part of a bigger procurement system. Within this tast table, tasks are assigned to usernames of the various logins to the system so Admin, Dan, Rachel etc. I have used my own custom menu set, which has a item called 'Tasks' which when clicked pops up the task manager layout in a new window. What I now want to do is change the item's label from 'Tasks' to 'Tasks (5)' where the 5 figure is actually a count of how many matching records for that loged in user are found in the tasks table. So firstly is this possible (and how)? A…
-
- 1 reply
- 2.1k views
-
-
I have returned to Filemaker after some time and have forgotten how to insure that a field retains the font formatting when you paste from a copied source outside of Filemaker. Much faster and sometimes more accurate to paste, rather than retype, but every time I do this the field shows the font style from the source. Thanks in advance.
-
-
- 5 replies
- 2.1k views
-
-
Hi all, I have a three table situation. 1. Tablename "Begraafplaatsen" 2. Tablename "Graven" 3. Tablename "Reserveringen" In "Begraafplaatsen" is a pKey field begraafplaatsen::id. In "Graven" is a fKey field id_begraafplaatsen. This fKey field exist in "Reserveringen as well. There is a one-to-many relationship between begraafplaatsen::id and graven::id_begraafplaatsen to show only the relatedvalues of a specific record in "begraafplaatsen". This works fine. In Table "Graven" Is a field "Rij naam". The values in this field exist more than once because for every "Rij naam" more then one position is available. The sum of the positions is stored…
-
- 8 replies
- 1.4k views
-
-
I need to be able to create 4 records with a single script, and go to the first of the set made. Filemaker flashes up a message asking which record I want to go to, giving the total number of records in the found set, eg: 25. In that circumstance, I'd want to go to 22, but I don't want the end-user having to work that out every time. The message overrides a script step stating that I want to go to '22' (using a calculation based on the contents of a unique no. field). How do I stop that message appearing? (I've tried ErrorCapture but can't find a relevant error number).
-
- 4 replies
- 1k views
-
-
Hello, I am new on File Maker. I'm using FM11 Pro. I want to learn how will I colour same date with conditional formatting? Thanks.
-
- 9 replies
- 2.8k views
-
-
Dear Forum, I am building a quoting database using the separation model. I am dragging a number (a value) from one window to another window, right into the last row of a portal into a field that is the field that needs this number. However, I only want to permit this drag and drop of the number into that field IF this portal for fills certain conditions. I can easily limit the drag and drop with the FM 11 script triggers IF i am in the portal field (the on object enter). However when dragging I never enter the object (since I drag- obviously). I tried to set the field options to check for the certain condition and to use only the valu…
-
- 0 replies
- 1.3k views
-
-
HI I am a novice and need some help on a few quite simple questions. I have racked my brain but unsuccessful as yet with a perfect solution. I am trying to emulate a similar database to the MYOB accounting (mow Mamut software). My "List" layout has a header at the top with buttons reading "Customer", "Supplier", "Employee"' and "All". (See att) Underneath, in List view, I have the 25 or so Records with fields such as Name, Telephone and email. (no records imported yet in the attachment) I want to be able to click on each of the buttons in the header (customer, supplier etc) to show the related records in the list below. What do I need to do to show this? …
-
- 2 replies
- 883 views
-
-
I hope I have the right place - I consider it to be layout issue. My mind has gone blank - I normally figure these thing out my self given tiime. I run a filemaker database, tables include Students, Subjects and Results. (obviously tables contain relevant fields). All related and it works. Heaps of scripting and display options etc. Management wants me to use a simple spreadsheet with check boxes so they can view results etc. (Hey, that is the extent of their computer literacy) Table view in filemaker does not help me that I can see. It displays all my subjects vertically and horizontally from the far left column is the data for each student …
-
- 12 replies
- 2.1k views
-
-
I'm using a portal in a report, to display multiple records in a sub-table related to the main table. There can be 1 or more instances of the records in the portal. At the moment, I have the portal set to display 10 records. However, if there are only two records, it shows 8 empty lines. Is there a way to have the portal automatically contract or expand to display all the records and no blank lines?
-
- 10 replies
- 2k views
-
-
Sorry if this isn't quite the right forum for it, but is there any way to specify a custom zoom value? 300% is just a little too big, and 200% is a little too small, so 250 or 275 would be great, but there doesn't seem to be an obvious way of doing this.
-
-
- 9 replies
- 3.8k views
-
-
Hello all, i have a question that maybe someone can help me with. I am trying to come up with a system that when user chooses a product from a drop down list in a portal, it is added. The only issue i need is that If the user chooses a cake ( i need to ask for the flavor, filling, message,etc ) then take those variables & add to the order but not the portal. 1st - is this possible 2nd - any other way to get this behavior. thank you -imoree
-
- 4 replies
- 1.1k views
-
-
I'm breaking my brains here, I must be over thinking this... I have a Repeating field (3) in which I enter the R, G and B value of an RGB color for use with Filemaker code: RGB ( red ; green ; blue ) The color it generates I want to be able to use for, for example, field backgrounds. Is this possible at all? It must be... Conditional formatting only allows the designer to pick the color, not the end user of the database.
-
- 5 replies
- 5.2k views
-
-
I made a nice IE9 dynamic tab header for view on all layouts, works flawless. Only thing... it jumps to the right a couple of pixels when going from a form-view layout to a list-view layout. This sucks big time, extremely annoying. Anyway, how can I turn off the couple of pixels on the left in list-view? (its the space Filemaker uses to let you see in which record you are). Check the picture, this gotta be doable...
-
- 3 replies
- 1.7k views
-
-
I am using Filemaker Pro 10 to track registration for a "Monday school" that offers classes to homeschooled kids. We run for 5 hours, and kids take 5 classes (one per hour). I'm having trouble figuring out how to create a way to get FM to create roster lists. I am a novice at database relationships--I last used FM about 20 years ago when relationships weren't part of the picture, and so this is all new to me. So here's where I'm at: I have a table called "studentinfo" where I have student names and IDs, ages, addresses, etc. This also has a "schedule" area where I put down students' classes by hour (these fields are called "Hour 1", "Hour 2", and so on). …
-
- 1 reply
- 927 views
-
-
Anyone know of a way that I can display a number of related records in an html <table> using webviewer. I need a page displayed in a format as shown in the attached picture... I'm just trying to figure out a way to display the "Guest List" portion of the data with the Guest ID, Name, Response, Date Received fields. This data is kept in a separate table (Guest List) from the Event table. untitled.bmp
-
- 4 replies
- 2.6k views
-
-
Hi I'm not sure this is the correct place to post this. If there's a better place, please let me know. I have a list of items that I need to categorize. I have a table called Category which has two text fields defined. "CategoryName" and "ItemNames". So each row of the Category table contains a category name and a list of items. The list of items is a carriage return separated list of item names. So there are no "Value Lists" involved, but the list of items is kind of like a Value List, I suppose. I have a script that extracts the item properties for all the items in the related set and then builds up a string to send to a web viewer using a U…
-
- 20 replies
- 7k views
-
-
Hi, I have a text field (OutcomeVariable) in a table, that is displayed on a layout. I want the user to enter a value in that field based on a value list. I have two different value lists that can be used for this field. If User 1 enters the layout, I want the layout to display ValueList 1. If User 2 enters the layout, I want the layout to display ValueList 2. Three items that are in ValueList 1 are not in ValueList 2. Could you comment on the following: 1. Is it possible to set it up such that User 1 sees ValueList 1 and User 2 sees ValueList 2? If yes, how? 2. Should I just have two different tables, one for User 1 and the other for User 2?…
-
- 1 reply
- 949 views
-
-
I have a field in the header that presents the layout name as a page title. It works great, but when in Find mode it disappears. Is there anyway around this? It does this both with a merge field as well as with an edit box. The field is an unstored calculation: Substitute ( Get ( LayoutName ) ; "_" ; " " ) thanks,
-
- 5 replies
- 2.6k views
-
-
Is there a way to know when the loading of the Web Viewer page is complete?
-
- 3 replies
- 1.6k views
-
-
This has to be basic... I am building a db that has eight portals, so far. An example of seven of them… 2 related tables, ‘List Manager’ and ‘Staff’. Relationship based on auto-enter ‘ID’ field (=1). ‘Staff’ has 2 fields which are also in a portal in ‘List Manager’. Create a record in List View ‘Staff’ and a portal row is created in List Manager’s single record. Fill the fields in the List Manager-based portal and as you would expect, the related record is filled (and vice versa). The eighth… 2 related tables, ‘Invoices’ and ‘Invoice Forms’. Relationship based on auto-enter ‘ID’ field (=1). ‘Invoices’ has 5 fields which are also in a portal i…
-
- 8 replies
- 1.6k views
-
-
I have a Supplier Pop up list in a Quote table. When you move into the Supplier ID field a list of all Suppliers pops up. If you type a 't' the system jumps ahead to the 't's. If you type a 'b' it jumps back to the 'b' suppliers. This works fine on Windows. We have introduced a brand new Mac which runs the database just fine in other respects. But when you type a letter with this pop up list showing the system just beeps and does not move to a new part of the list. Is anyone else experiencing this? Any solutions?
-
- 12 replies
- 1.6k views
-
-
Hi all, I've created in my solution a portal for navigation purposes (see attached images). For the user it is clear on wich record they are when the portal row is highlighted. And beside that it is visually atractive. This kind of highlligting do we see on websites all the time. For this highlighting I'm using conditional formatting. The formula is: If ( Table::id = TablePortal::id ; RGB ( 204 ; 204 ; 153 ) ; Self ) where TablePortal is a TO from table with a cartesian relationship. A strange behavior occur. When I enter a number in the displayed field on the details area the row stays highlighted in the portal when i click another record. …
-
- 2 replies
- 2.3k views
-
-
Hi there, I have a portal on my layout showing related records. Lets call the (portal)table Items. (I have to translate some because the names I used are in Dutch.) Items is a child file of Branches wich is a child file of (lets say) Headquarter. Each branch can make their own Itemlist. The items are identified by the user by using a identifier, for example "RES10". It is very likely that the other branches uses the same identifier as well, with different parameters such as description and price. The identifier may be several times in the Items table but only one time for each branch. So a validation by Unique value in Define Database is not working (it check…
-
- 28 replies
- 3.3k views
-
-
FMPro 11 FMServer 11 Advanced running on Windows server r2 Platforms used: PC & Mac I'm a newbie when it comes to custom menus. I have created a custom menu for a layout in one of our databases. We have several priv. sets. If we log in with full access, the custom menu works. If we log in without full access, the menu items are grayed out. This is true regardless of platform. Any suggestions? Thanks.
-
- 3 replies
- 2.2k views
-
-
Hello, Band new here and brand new to Fm and databases. In short... I know nothing, but I know that everything is possible. I am trying to set up a very detailed inventory and invoice DB for my little business. I need to get my head around the some of the basics. In order to do this I need some help to understand a very simple invoice, line item and products DB and the relationships. The tables and fields are as follows: Products: ProductID, Type, Item, Price Line Item: LineItemID, ProductID, InvoiceID, Type, Item, Price Invoice: InvoiceID, Total So far copying from a template I found I have set up an invoice with a portal. Using a list o…
-
- 7 replies
- 1.6k views
-
-
I have a value-list field that contains values from another field in a related table. In the table the records show up as 2 5 4 3 6 8 1 10 7 In the value list, however, it sorts them 1 2 3 4 5 6 7 8 9 10 How can I set the value list to mimic the order they actually are in the table? Seems like it would be such an easy thing to do but I cant figure it out. Im using FMP10 if that matters. Thanks
-
- 2 replies
- 1.2k views
-
-
Greets: The title says it all--I've tried using the Inspector and going to Data > Data Formatting > Format > 12.25.2003 as well as setting up the same formatting style in Custom in the same drop-down menu. The formatting choice works fine in Date fields, but apparently not in timestamp fields...or am I missing something? I'd hate to go the long way using a calc in a text field [Month( date ) & "." & ...] TIA for your replies!
-
- 1 reply
- 794 views
-
-
I am attempting to limit selection of calendar days to only use "Friday" and only in the future and not in the past. Is it possible to do this with Filemaker's built-in calendar drop down using conditional formatting? If so, can someone help me with how the calculation might look? If not, can you share your thoughts? Thanks
-
- 3 replies
- 3.8k views
-
-
Hi Gurus, Struggling with this one. I have a raw materials table, suppliers table and a join table between them of rawmtrlsupplier. While in raw materials table, user can add one or more suppliers for a particular raw material, and see this in a related portal. I have that working fine. In the portal of suppliers I have a field "rawmtrls_RAWMTRLSUPPLIER:: _MainSupplierID" with a checkbox set that has a value list of "1". It also has a button applied to it as shown below: Scripts: Set Default Supplier Set Error Capture [ On ] Set Field [ RawMtrls::_kf_DefaultSupplierID; rawmtrls_rawmtrlsupplier_SUPPLIER::__kp_SupplierID ] Refresh W…
-
- 2 replies
- 1.3k views
-
-
I'm trying to move data from several portal rows of 4 fields into a printable invoice layout. Using the portal in the invoice layout doesn't work, because Print Sliding is too limited. So I thought why not collect the data in one large field using tabs. But Is it possible to place a tab command in a calculation? Collecting data from 4 fields and placing a space or a line-end twixt each is easy, but I'd really like to have the collected data on one line at specified distances apart. (I can set up the tab positions.) I have tried typing opt+tab between quote marks in the calc field, but all I get is highlightable blocks of nothing. If I can't d…
-
- 3 replies
- 911 views
-
-
hi, I'm working on a donor/donations tracking application for my son's K-5 school and could use some advice. I have a Donors table that holds donor records including address information (address, city/state/zip). There are also a Parents table that holds records of parents of students at the school including address information and a Families table that holds records of families including address info. The Donors table has foreign keys ParentID, and FamilyID pointing to the Parents and Families table respectively. In the Donors layout, there are the fields FamilyID and ParentID; and either or both can be populated. The behavior that I w…
-
- 3 replies
- 2.5k views
-
-
I have a Clients Table + a Jobs Table. I have a Relationship of Jobs to Jobs where (IDclient and the Year Job was created Match) Because I want to create a unique job number that identifies the year it was created + order in which is was requested by the client. I have set a portal in the Jobs Layout to display Jobs related by id +year. Sorted in descending order. This portal is displaying a unique job number utilizing... The last 2 year digits (date_year) The client code (client_code) and the portal row number via Case( Clients::IDClient; Get( RecordNumber)) ex. 11-ME001 11-ME002 11-ME003 The example above is my jo…
-
- 6 replies
- 3.8k views
-
-
I've just finished my 1st data/table that consists of 100 records each record shows my company's threat, how to resolve it, recommendations, actions, what the threat is about, and the start and end dates of when we started or finished solving the threat. NOW I need to make a 2nd data table. This new data will be a score card for EACH of the 100 records. This score card will have "whats done", "where are we now", "Prioritization", and etc. What I want to do is make two tabs. One tab is the 1st data (the one I've just finished) and the other tab will be the 2nd data which is the score card. So far I added two tab controls to my existing data already and was wond…
-
- 8 replies
- 10.6k views
-
-
Here is what I am doing from an excel spreadsheet Record 1 Program XXX Staffing Requirements Jan Feb Marc Apr May June Jul Aug Sep Oct Nov Dec 1.2 1.2 1.2 1.2 1,0 1,1 1,1 .9 .9 .9 .8 .7 Staffing .7 .4 .5 .5 .9 .8 .9 .5 .5 .5 .6 .5 Employee 111 .5 .8 .7 .7 .1 1.1 .2 .4 .4 .4 .2 .2 Employee 222 So it adds up to the requirements. I then want to pull an employee report that shows all the programs and total hours they are needed for. Woudl also like to pull program reports Can somebody get me…
-
- 1 reply
- 1.8k views
-
-
Hi All, I want to create an input layout as I am fed up of getting blank records in the database but am somewhat stumped how to do this. The database is a standard invoice system with with four tables linked, Invoice, Clients, Products and Line_Items. While it would be easy enough to put a Commit button on the invoice and if the record is not committed, delete the record and reset the Invoice number sequence but what about the line_items which will still persist and resetting the line_items record numbers. Any pointers or reading material you could direct me to would be appreciated.
-
- 10 replies
- 1.4k views
-
-
I am working on one table that has 100 records. The data consists of the types of threats we have at our company, the priority of the threats, and full summaries/paragraphs of what actions we need to take, whats our status, and our recommendations. So each record has data that is about a paragraph or so long and when I preview it on browse mode displaying it as one record it only shows the first sentence of the paragraph, NOT the entire paragraph. This goes the same when I use find mode and to preview it. My boss needs to see it all without having to click on it to view the entire paragraph. Is there a way that I can edit the table where the entire data will show wit…
-
- 2 replies
- 800 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online