FileMaker Interface Features
-
hello again... i have a portal showing 100s of records for 100s of patients. but i only want to show the last two records for each patient. i don't want to keep these records in DB aswell [except the last 2 for each patient]. so i want to know how can i delete these records from db, leaving only the last two records for each patient. i was thinking whether looping through records for each patient and delete them one by one will be a possibility? or is there some other easy way to achieve it? i only want the last/latest two records and nothing of the rest. PS: records are being displayed in a portal. thanx.
-
- 2 replies
- 1.3k views
-
-
-
Hi All, basically i was wondering whether there is a way to get FileMaker Pro 9 to actually return the 'Mode' it is in? My client has a Search Button in various places throughout a database, but i'd like to make it so that if the database is in Browse Mode, then the button make FMP enter Find Mode..... but if FMP is already in Find Mode, then the same button actually performs the find. Anyone got any ideas?
-
- 39 replies
- 6.7k views
-
-
I want the responses to radio buttons on a layout to read "yes" or "no" but enter "1" or "2", like you can do with an http radio button. Is this possible in FM? Thanks
-
- 7 replies
- 2.8k views
-
-
hello i need some help/assistance to retrieve values in a value list. i know i can use valuelistitems function to get all the values at once. but what i want to do is to get 1 item at a time [using a loop] n then add it to a filed in a table. then get the 2nd item and add it to another field in a 2nd table and so on. for now i have around 50 items in the list and want to get each item individually and then add it to approperiate field in a table. [all this through a loop to add items to corresponding fields in different tables] thanx in advance for the help.
-
- 2 replies
- 1.4k views
-
-
hi again. i would like to ask if the following is possible in filemaker and how to do it. i have a field called studies. i also have a value list of about 100 types of studies (eg. MA, PhD, BA, etc) what i want to do is to when i click the "studies" field, i get a drop down or pop up or checkbox of the value list i have, and to be able to check one or two or more values from the list then they are listed on the field, separated by a comma. like: studies: HS, Coll, MA, BA, BA1, PhD Thanks.
-
- 9 replies
- 1.8k views
- 1 follower
-
-
Hi, Im pretty new to FileMaker and need to import a table from another FM database. I need to print out the table layouts from both FM databases to ensure I import the correct fields. How can I produce a table layout...its easy in MS Access ?
-
- 7 replies
- 1.8k views
-
-
;) I am attempting to create a new table and have it display in a portal. Problem is, the field entry areas do not display when placed into browse mode. I have even attempted to copy an existing portal and have same issue. If I create the table/fields and add them to a layout without a portal, same thing happens. When I look at the relationships graph, table looks like the rest of those that do work, but it doesn't display. I am probably not understanding some small item, but it's become really frustrating. Help is appreciated! :P
-
- 4 replies
- 1.2k views
-
-
I have a 450 row portal that prints out over 11 pages. After a few pages, the printout mangles the names at the bottom and/or top of the pages. I know I can do a summary report instead, but wanted to do the portal if it was possible. Any way to get a portal to break properly over multiple pages? Thanks Peter
-
-
- 6 replies
- 4.5k views
-
-
Has anyone run across the issue of invisible buttons behaving awkwardly in IWP on Internet Explorer? Our solution has a series of radio buttons that, when selected, perform a script. The scripts are triggered by invisible buttons placed over the radio selections, unfortunately in IWP on I.E. 6.0 (XPsp2) the buttons are to the far left and far right of the scripted buttons and are not over the intended area, i.e., directly over the radio button itself!?! It's as if the radio buttons are in the foreground but they're not. We're running FM Server Advanced 9 on Mac OSX 10.5.1 and our clients are accessing the database using IWP via I.E. Anyone else experienced …
-
- 0 replies
- 1k views
-
-
I have a portal from an Follow-Up Table that is tracking attempted call dates for a record in my main table. The portal record field is called "Attemept date". I also have a summary field in the follow-up table called "Total Attempts" which is a count of attempt date. Each entry will have multiple attempts. I want to create a report that will list all of the entries that had an attempted call on a certain date - which I have done. However, the "total attempts" is not showing the total number of entries in the list (for instance, I'll do a search for today's date and will come up with a list of about 40 entries -- some have today's date showing in the "attempt d…
-
- 3 replies
- 1.6k views
-
-
I have a Relationship between two tables. I created a portal. In this portal I need a calculation field that will count Only fields in it that do not have the word "pilgrim" It can show in the portal but not be counted. Then I have another field that if that field has something in it. It will be counted. Example Class date pilgram "This Record would not Count" class Speech date Class Date The next two would be counted, the speech field would need to be counted when ever something is in the field. 2 classes 1 Speech. If I had more speeches then it would count them to. The Total would be displayed on the …
-
- 1 reply
- 1.1k views
-
-
The icons under "Functions" work on the Mac. However they are blurred and have a blurred white border around them in Instant Web Publishing. The icons under "Buttons" work on both. Am I doing something wrong? Are their any other icon packages that anyone can recommend?
-
- 0 replies
- 1.2k views
-
-
When I try to create a tab using Filemaker Pro 8.0v2 on my Mac (OS version 10.4.11), it displays correctly in "edit" mode. But when I enter data-entry mode, FM "sees through" the tab - and displays all fields (from all the tabs) stacked on top of one another. Clicking the other tabs, I see the same thing - all fields stacked. Worth noting: one of the tabs contains a large table. The *first* time I created the tabs, I dragged all the fields into the proper place and went into data-entry mode. It worked properly. I then went back into edit mode and moved the tab window slightly, changed the color of the two tabs to make the display more aesthetic. *Then* it stopped wo…
-
- 16 replies
- 1.9k views
-
-
I am trying to create a report that shows line items from numerous tables. I have a layout with portals for each table showing the records I want to display, however I cannot get the portals to shrink down when displaying the layout in Preview mode. This leaves me with large blank spaces on my report. Also, is there a way to make graphic objects such as lines used above "Total" fields, to not print if the "Total" field is empty. Thank you
-
- 2 replies
- 1.7k views
-
-
Hi I have a layout with three Tab panels. What I would like to achieve is: the cursor entering a field located on the next (second)Tab panel when I Tab out of the previous field, which is on the first Tab panel. For data entry into the fields I have set the Tab order so that after entering data into the tenth field the cursor should enter the next (eleventh) field which is located on the second Tab panel. However the cursor always returns to the first field which is on the first Tab panel. This is I think a similar problem to “jump to a tab” http://fmforums.com/forum/showtopic.php?tid/195066/ The advice suggested is to run a script: Go to Field…
-
- 2 replies
- 2.9k views
-
-
hi.. i have two layouts(reports) than use the same fields but differen order.... one report use first in subsummary "customer" and another subsummary "product".... and another layout the same but inverse ... when i watch the report i have to go to order registry and change the order .. if i go to the other registry i have to do the same?... is there some way to block the order for each layout? is like they were conect...... thanks for your help
-
- 1 reply
- 944 views
-
-
I'm sure there is a simple answer to this one, but can't figure it out. I have three tables - a person table, an activity table & an activity occurrence. I made the activity occurrence table because I want to relate people to activities, but several people can be doing the same activity & and people can do one or many activities. Using the activity occurrence table, I have a portal showing a list of all the people. Working my way through the activities I select each person involved with the activity via a portal. The portal shows all the people via a cartesian (x) relationship. First a new record is created in the activity occurrence table. The ac…
-
- 2 replies
- 1.3k views
-
-
I have a solution converted from FM 5.5 to FM8. I am working on tweaking all scripts, etc. The solution has a dozen files. Like in FM 5.5, navigation is from file to file via buttons that call scripts from another file. The issue is that when I move from one file to another via scripts (it looks like a typical tabbed folder system), I briefly see a "ghost" of the files. Example - I am in one file and click a tab to move to another. While it changes, I see a flash of the other files behind the current window. The window is maximized, but the ones I see are shrunk - as if I had resized them. They appear to be where they were many sessions ago (I ha…
-
- 0 replies
- 1.1k views
-
-
-
Hello All, I'm fairly new to FM. Have a question: Is there any way to validate a currency field so if the user makes a mistake and types two decimals fields i.e., one for the comma and one for the cents...have some error that just says "invalid format" or something? Also, same thing with commas. The field is already a currency field with two commas..so some extra validation is what I'm looking for. Thanks
-
- 4 replies
- 1.2k views
-
-
Greetings! I am trying to figure out how to get a field to 'auto-commit' (automatically move to the next field) without having to hit the TAB/ENTER/RETURN keys. I want my users to be able to enter a single digit in a field and have it auto move to the next field. Thank you ;)
-
- 3 replies
- 1.1k views
-
-
I have a list of 99 records, and they all have different Dates for the next 3 weeks. What i want to create is a report that will show me this week in 1 page, next week in another page, and the 3rd week in the last page. I have the following Fields. Customer Item Number Qty Print Date I want to be able to create this report so i can see what customers are printing this week, and so on. This is driving me nuts. Thanks in advance.
-
- 3 replies
- 909 views
-
-
I have a script that waits for user input, and the user can either click a button, or press the enter key on the number pad to resume the script. Is there any simple way to let them press either enter key to resume the script? Also, keep in mind that i'm using windows, cause i'll bet it's different on a mac.
-
- 5 replies
- 2.2k views
-
-
I have a field for an insurance number that contain up to eleven digits, but may be less. I would like create 11 little boxes in the data entry layout so that the person entering data can see that they have entered the correct amount of digits. Something like this, except 11 boxes: (sorry my drawing will not "cut and paste") (for now lets assume I do not want to use the “define database” field validation options) Also each time a digit is entered the cursor moves to the next box. I have tried using the drawing tools and the field control setup but I cannot seem to achieve a neat result. Any ideas please?
-
- 7 replies
- 1.4k views
-
-
Is there a way to force a sub-summary part to display at the top of each page if sorted data spans more that one page? Ex: I have a list of sales, sorted by employee one employee has 100 sales I want their name at the top of each of page(kind of like "NAME cont"). I don't want a page break after each employee because there are a lot of employees with 1 or less sales.
-
- 1 reply
- 1k views
-
-
Hi, all. I'm trying to draw a graphical grid over a portal. For some reason, when I do this some of my vertical grid lines disappear when I switch to browse mode. 'Very annoying. Please give me some helpful advice if you can. Thank you.
-
- 5 replies
- 1.7k views
-
-
Hi everyone, A couple of questions. First of all, is there any way to edit a layout object's attributes (eg. width or distance from left of screen) using a calculation/script? Second, is there anyway to 'freeze' objects, as you can do to cells in microsoft excel? I need fields on the leftmost part of the screen to scroll when the screen scrolls. (eg. i want fields on the left of the screen to do what fields in a header in list view do). Thanks in advance, Chris
-
- 1 reply
- 1.5k views
-
-
Anyone know why fonts that normally have additional marks in Thai in MS Word for instance don't have them in a FileMaker field? Thanks, Lee
-
- 0 replies
- 1.4k views
-
-
I have a State layout form which displays State records. I would like to create a 2nd form layout that displays records for Cities. The Cities need to display for the current State record that is displayed on the State layout form. Any help will be appreciated.
-
- 3 replies
- 1.3k views
-
-
I have a portal in my database and I would like (if possible) to have a field that will capture the total value for certain fields. My portal is set-up similar to this: Job Number PO Number Type Invoice Number Invoice Amount I have 2 different types of entries - CONTRACT or AWO. I would like to have TOTAL AWO and TOTAL CONTRACT fields set-up, so that if TYPE = AWO then it gives a total of the invoice amount for only those entries, and same thing for TYPE = CONTRACT. Does anyone know how to do this?
-
- 2 replies
- 1.2k views
-
-
In FMP 8.5, I have two globals - Company and Department (to use in a portal filter). I have a pop up Value list of Companies on the gCompany field, and want only the Departments from the selected Company to appear in the gDepartment Pop up value list. I made a relationship gCompany Filter, with gCompany to Company and have the value list defined to include values from gCompany Filter::Department. In a portal :gCompany Filter, the list of Departments change with each gCompany selected, but the value list does not change. What am I not doing right? Thanks Stublito
-
- 1 reply
- 1.6k views
-
-
I can see how the web viewer can open a url and center a youtube video. But is there any way to call that youtube video to become full screen automatically while it is playing? This is a tall order I know. But just asking Thanks Dave
-
- 3 replies
- 1.7k views
-
-
Ok on my database I made 10 records. I added a button for deleting the current record only. If I delete record 10 then 9 and then 8, it deletes ALL the records! If I right click and delete doing the same process, the same thing happens. Any advice on how to make it only delete one at a time??
-
- 11 replies
- 1.8k views
-
-
Hello there. I was wondering how I can create a floating control box that will allow a user to navigate and execute scripts on the layout beneath the float. So far I've got a button called "Show Controls" that performs the following script: Adjust Window [Resize to Fit] New Window [Name: "Controls"; Height: 396; Width: 408; Top: 150; Left: 300] Set Zoom Level [150%] Show/Hide Status Area [Hide] Got to Layout ["ControlBox" (Patient_Information)] The control box looks real snazzy! The trouble is that the scripts associated with the buttons I've put in the control box don't operate on the layout below. Thanks for any help you can offer.
-
- 3 replies
- 1.3k views
-
-
hi .... can i print mailing labels ordered horizontal and not vertical? i have a field with customers name and i want to be printed this way: 1 2 3 4 5 6 7 8 9 the standard template print like this 1 4 7 2 5 8 3 6 9 thanks for your help
-
- 1 reply
- 2.7k views
-
-
I need to do a social networking table/layout for our membership database. The concept is who know who? I've done a cheezy one based on a join table and a portal from Name 1 to Name 2 that gets me the all the friends of one friend, but there are duplicates in the results and it isn't very elegant. I think I'm going to need a recursive script that "follows the branches of the tree". Has anyone done this? Thanks Peter
-
- 1 reply
- 1.2k views
-
-
I am new to this site and asking for help on line, please excuse any errors I might make. Is there a way to make sure that a field has data in it before leaving that field by tabbing, changing layouts, clicking, quiting, or anything else? In this case I want them to put in a quantity before doing anything else. I have tried the valadition "not empty" and some "If" calculations, nothing I have tried is totally fool proof. Thank you for any advice.
-
- 3 replies
- 1.4k views
-
-
hi .. i had try different ways to get a right report this is how my portal look .. what i want is a report that shows me how much i sell from each reference ... from all customer ... i have try subsumary report but when i run it... it doesnt show anything ... what i am doing wrong?? thank for your help
-
- 5 replies
- 1.3k views
-
-
Hello Everybody, In Filemaker 9 Advanced I want to customize a menu item that add to the shortcut menu item. Shortcut menus display when right-clicks (Windows) an object or an area, and customize the behavior performed by the shortcut menu item. Is there a way to do this?
-
- 0 replies
- 1.5k views
-
-
I have 2 tables that have a relationship. It is essentially goods(inventory) and buyer (cashier). Is there a way to have the portal in cashier only show the items (invoices) not paid. I am sure its easier than i making it, but for the life of me i cant get my head around it.
-
- 1 reply
- 1.1k views
-
-
Hi, I am an FP ubernoob and trying to set up a stock management system for a warehouse with FP9 but am running into a bit of a nuissance regarding a pair of dropdowns. The drop downs contain a 'Product Name' field and a 'Product Code' field. What I am aiming to do is to choose a Product Name from the drop down, and the matching Product Code would automatically be selected and vice versa. This way, either field can be used and the other automatically is updated to match. Both drop downs using related valuelists based on a records in a 'Product Range' table. Gurgle.
-
- 1 reply
- 2k views
-
-
Can I change the layout type after it's already created? From standard to list or table view? Thanks
-
- 2 replies
- 1.3k views
-
-
I have been using a dropdown list. All of a sudden it stopped dropping down. I went in to check it, and the message "This value list will not work because the field "ID code" cannot be indexed". What could change to create the inability to be indexed when it was before. Thanks The Tramp
-
- 9 replies
- 1.5k views
-
-
i have two tables that are linked [relatipnship] and i'm showing their data on two different layouts. on one layout user can enter the data but on 2nd layout i'm using two portals to display entered data from the two tables. however, portal is showing a blank row at the bottom for new record but i want to hide/remove it. the relationship between the two tables is to allow addition/creation of new records but thats only for layout 1 where user can add a new customer thus adding info to related table as well. but in portals [layout two] i don't want to have new record blank row. i know i can do that by removing the option through relationship but then that will not all…
-
- 4 replies
- 2.4k views
-
-
Happy VD everybody! Wait, that didn't come out right... In the solution I'm working on I've assigned a custom menu for each account name, but I'm stuck in trying to create a custom menu for one group where I don't want them to have access to any menu, navigation or otherwise. (What functions they'll need will be driven by scripts.) When I created an empty custom menu in the Edit Menu Set windoid and tried it, FileMaker had its way by presenting a default set of menus. The nerve! Any suggestions for outfoxing FileMaker in this regard will be greatly appreciated. Thanks!
-
- 1 reply
- 1.7k views
-
-
I understand you can block a individual field in a record in the table field outline. But, can you leave it open in the table outling and block minipulation in the layout to protect the information in normal data entry, but have it open to editing or adding to in another field? Thanks The Tramp
-
- 5 replies
- 1.3k views
-
-
Not sure if this is the right location for this question, but here goes. I am not sure when FileMaker made the change, but it is starting to cause some problems for me. If a user is in a field and selects another window, that record is still active, which locks the record from being changed by others users. Before, when you changed windows, the field/record was exited. Is there a way to change it to exit the field/record when another window is selected? Using FM 8.5/9 on Mac OSX. Thanks for any help Shawn
-
- 0 replies
- 1k views
-
-
Hi, I understand the thinking behind a coditional value list. I want to do this but slightly different. Rather than the choices coming from individual records I want to show from the same record but different fields So I have Table1 Called Choices Withing choices, record 1: Manufacturer: Ford Model1: Mustang Model2: Focus Model3: Fiesta Model4: Mondeo Model5: Ka Then I have table2 Selection I want to be able to select the manufacturer so in this example Ford Then have... Selection 1 - contains a list of the different models Selection 2 - contains a list of the different models hopefully without the one already selected in s…
-
- 5 replies
- 1.6k views
-
-
Hi, my new receptionist wants a larger interface (zoomed to 150, clicking the "big mountain" icon on all windows as they open), but the other one likes it as it is. Is there a simple way to zoom all windows at once? I know I can script each file as it opens but hoped there may be an easier way, maybe running a single script on all open windows. Thanks.
-
- 6 replies
- 2.4k views
-
-
I have a Dymo 400 with 99012 labels and am trying to create a layout so that I can print out labels from my database. I have tried using both creating a new layout and choosing labels and also just creating a box and moving it around until it happens to line up. Has anyone had any experience successfully getting labels out. Any help would be appreciated
-
- 0 replies
- 1.2k views
-
-
hello all i have a portal showing results of drug tests. it works fine except that it show tests which do not have any results [clinic visits]. so when i load the layout, it shows patient info [parent layout and table], related tests [in portal one] and related results [in portal two]. i want to show all the tests in portal one [working fine] but i only want to show results of the tests which have anything but clinic visit in tests. how can i omit/filter out "clinic visit" result-rows from the portal. for example PATIENT ID : 7 ============== TEST PORTAL [shows these records] =============== CLINIC-VISIT,DATE,ETC CLINIC-VISIT,DATE,ETC HEARING,DA…
-
- 2 replies
- 1.5k views
-
-
When I select a record from the portal I would like the appropriate set of photos from the LogEntries table to load in the tabs. But I don't know why it doesn't load them. Can someone give me some pointers? Also, how do increase my canvas / form areas width?
-
- 5 replies
- 1.4k views
-
-
Hi all, am hoping you can help me, and i've tried to search for a solution already, but finding it hard as i'm not really sure of how to describe what I want to do easily! Hehe Basically, i've developed a database which utilises it's own 'built in' users and groups section (rather than the FMP Accounts and Groups - for 'client' reasons rather than my own...) Obviously i've scripted the 'Users' section / layouts so they can only be accessed by members of the Management group. All is working well... Then I had the idea of creating a checkbox set, detailing the 6 or 7 seperate sections, so that depending on who is 'logged in', a script can cross reference the …
-
- 5 replies
- 1.8k views
-
-
Hi there... I want to use the Web Viewer to point to our images on a shared network volume: it's a lot faster then to work with container fields. I get this to work and the , mostly, hires tiff show up. However, due to their "hires" nature, they are too big to fit in the web viewer window. Is there a way to "make them fit" into the web viewer? thx.
-
- 9 replies
- 3.7k views
-
-
I am using Filemaker 9 and 7 I need to display a number in scientific notation to one decimal place For example, if I create two number fields, A and B and a calculation field A:B ratio, and: Field A = 1 Field B = 654321 A:B Ratio = 0.000001528301858 I want the A:B ratio to display as 1.5e-6 If I use “General format” for the ratio field, it displays 1.528301858e-6 Is there a way to truncate the number of decimals in the display of the calculated result? Any suggestions most gratefully received…
-
- 2 replies
- 2.8k views
-
-
New guy (still). I would like to create drop down fields for, say colors. There are 3 colors; red, white and blue which I presume I will store in a value list. Ok, let's say there are 5 sizes: S,M,L,XL, and XXL, also in a drop down field. Red only comes in M and XL, so when I select Red in the first drop down list (in browse mode), the only sizes I want to see in the Size field are the ones exclusive to Red (M and XL). I should be able to choose either of those sizes, but I don't even want to SEE the other sizes. Maybe this isn't the easiest way to do this, but this is basically what I want to accomplish. When one parameter is selected, the next selection will only have t…
-
- 2 replies
- 1.3k views
-
-
I am trying to make the LayoutNames function work without success. I calculated the following (see attached screen shots) from Define Database. It creates an empty field; indexing brings up the index list box containing nothing; the database contains nearly 100 layouts. Thanks in advance for wisdom and assistance.
-
- 12 replies
- 2.2k views
-
-
It has been a while since I have done FM development. So I could use some help with HOW to think about this. I have a table listing products. I have a second table listing Images for those products. The key is an item #. An Item may have several pictures. Using a portal I can see the list of images for that Item. That's great BUT I need to put each picture path into a separate field along with the item data to export to an Excel report. Therefor: Item # 4, Name "Red Car", Image1 "outside", Image2 "inside", --- and so on. The number of images varies from 1 to 5 so I need 5 image fields. I can see them in the portal but how do I get them in…
-
- 2 replies
- 1.2k views
-
-
I am working on creating an contract and inventory database. When I select under category I created a drop box showing new, upgrade or maintenance. If they select the first two I would like the maintenance term, maintenance beginning and maintenance end dates to 'grey' out if possible. Only if they select maintenance should those fields be adjustable. On a separate thing, is there a way to force entry into a field that shows purchase amount to have standard currency settings (in other words a dollar sign, a comma and a decimal point)?
-
- 2 replies
- 1.1k views
-
-
I am in need of creating a report which summarizes Test scores by Job (not by person). Each person does a particular job and is tested for it. Those people pass the "job test" by a Weak, Moderate, or Strong amount. There are ranges for that which are calculated and I am getting those to work just fine. The problem is, I cannot print a report that shows this by Job. When I choose a sub-summary by Job, I get EACH person's score. I want to just show the total for each job i.e. Total Weak, Total Moderate, and Total strong. I have "total" fields created however it displays multiple times. Why are they showing up as many times as there are records? I don't ge…
-
- 3 replies
- 1.1k views
-
-
First, let me apologize if I've chosen the wrong forum to list this under. Those in the know will probably move it soon...thank you for that. I checked the knowledge base first and nothing came up for Xerces Panic Error. Here's the problem. I'm having trouble copying portions of one layout to another. When I highlight what I want to copy and press Ctrl+c or the Copy button at the top of the window, I get the following error: [color:red]Xerces Panic Error...Could not load a transcoding service. When I click OK, FileMaker shuts down. Is anyone familiar with this error and what causes it, or better yet, how to fix it? I would appreciate any feedback. …
-
- 3 replies
- 2.1k views
-
-
If a layout (that serves one table) controles a tab (That serves another table) and the tab controles the portal (That serves another table), Is there any way to create a new document in a tab without creating a new document in the tab controler, but not in the main layout (or main table)? Thanks The Tramp
-
- 3 replies
- 2.1k views
-
-
I'm trying to setup a value list that uses values from a field, but when I click the "use values from field" checkbox and the "specify fields for value list" form appears, everything on it is disabled. Does anyone know what circumstances prevent you from setting up a field to use for a value list? Just in case this might have something to do with it, I'm using a MySQL database and trying to use filemaker as an interface. All of the tables used are Mysql tables. Cheers.
-
- 2 replies
- 1.1k views
-
-
hi i m using list view where some coloumn are used to show list grid.now i want to know how i color selected row at run time thanks in advance
-
- 1 reply
- 1.5k views
-
-
This should be simple?? Whenever I create a new layout, its size is limited by the print setup page size. For a layout that I don't want to print from I want to have an unlimited size if possible (at leat so I can fill the whole screen? Any suggestions? Thanks
-
- 3 replies
- 8.6k views
-
-
Based on a drop-down value list selection on the same layout, I would like to select a specific tab. Is that possible? Thanks.
-
- 2 replies
- 2k views
-
-
I am having an issue with Layouts that I don't understand. Lets say you have just finished entering a new record with all the data in the tabs as well. You go to hit the "New Record" button and accidently hit the "Duplicat Record" button instead. So needless to say you hit the "Delete Record" button. Well, when you delete the new duplicate record it also delets the origional file and all the data in the underlying related tables as well. Why, and How do you stop it. I can logicly explain why it would delete underlying related records but why would it jump to another record by the same ID number and delete it as well. Thanks The Tramp
-
- 4 replies
- 1.3k views
-
-
I hope I dont post to much. Let me know if I do! I try to figure out how to copy one fields value to a different field in a portal and clear the second field value. portal_copy.fp7.zip
-
- 6 replies
- 1.7k views
-
-
Hey Forum, this is ridicoulous...I cant get my bottom margin to work right. I have a brandnew layout and am testing printing "to the bottom of an A4 page". I put one big Text item on the layout filled with "test test test " about 10000 of them. All in all it goes over the bottom of the page onto the next page (561x904 pixels just for info). I then print page 1. The Margin it leaves at the bottom is EXACTLY 21mm. Thats much to much for what I want. But I have an example of an old old old FM Printout clearly showing that a margin of just 10mm was achived a long time back. In Printsetup I correctly choose A4 Format. I have tried to play…
-
- 3 replies
- 1.3k views
-
-
At the moment in my Table View Layout all fields run across the top and all records run along the left is there any way of changing this around so that records can run along the top and fields to the left?
-
- 1 reply
- 908 views
-
-
Hey there - just a quick question I have a customer who wants to have different tables be sorted differently upon startup, but it sounds like Filemaker always sorts by creation date no matter what. Is there any way to work around this and define a new default sort order? I thought about setting a script to run on login, but he wants different sorts for different tables. Any ideas?
-
- 1 reply
- 1.6k views
-
-
I have a layout with check entry record fields in the top section and check distribution record fields in the bottom section. The purpose of this form is to enter check entry information and the 1st check distribution information. The two records are joined by a relationship. Entry in the layout is fine except that the dropdowns fail to populate their respective name fields the check entry record (see next paragraph). They work fine in the check distribution section. Example of the failure: The check entry section has a Vendor ID field and a Vendor Name field. The Vendor ID is the dropdown field and this field works fine. The Vendor Name field fails to appear (it has…
-
- 1 reply
- 924 views
-
-
I am trying to create a calculation field which displays ValueListItems derived from a found set of foreign key fields called "ws.f" with different parents. It works fine when there is one parent in the list but not with two or more.
-
- 0 replies
- 1.1k views
-
-
I've just run into a portal problem after converting to FM8.5 from 6. I have a portal whose visibility is determined by a calculation - if certain criteria aren't met, it "covers up" fields to stop data entry. This has been defined as a button to "Exit Script" if clicked outside the field entry, I think to stop the portal from staying highlighted (it's been years since I last looked at this). In FM6 I could still click on the fields and gain entry to them however now in FM8.5 if there is any button definition attached at all it stops entry into the fields - if the button "Does Nothing", then the portal stays highlighted if clicked on outside the fields. I ha…
-
- 2 replies
- 1.2k views
-
-
I have an invoicing solution and need to put a summary of all outstanding balances on the invoice layout that I send to the client. I send the invoices out monthly and do a find to print all the current invoices for that month. The problem is that when i do that find, it doesn't let me show a summary of each clients outstanding balances. Only shows for the current month. Thanks
-
- 1 reply
- 951 views
-
-
Hi all I am new to FileMaker and Databases in General. My first small project is to create a pricelist for a small store with 20 articles. === The Setting === I have two databases which are not directly related: db_articles db_groups Plus, there is a value list vl_groups which is defined to contain the entries from db_groups::article_group the field db_articles::group has the following options set: Validation: Always, Do *not* Allow to override, Not emtpy, Member of value list: vl_groups. The field db_groups::article_group is defined to only contain unique entries, and not to allow user override. In the layout, the field setup…
-
- 4 replies
- 1.4k views
-
-
Hi there, i was looking for some help, maybe some of you guys can help me. I've developed a relational database using FMpro 9 (i started with 7 and then move up all the way to 9 throughout the years) to manage an archaeological project in south america. So far the database is doing great and it works. I recently run into Bento and I liked the way the "Source" Menu works, making it easy to jump into different layouts and grouping things in the Itunes way. So the question might be a little challenging, I havent got the time to really look into how this menu works from the point of view of a relational database, in the next days i'll try to "disect" it, but i was wondering i…
-
- 2 replies
- 1.7k views
-
-
Hello everyone Is it possible to insert a left frame in the layout, like the one for example when you browse a database using http? It should be a frame with butons and links, always available on the left, indipendent on the scrolling of the page. Thank you
-
- 2 replies
- 1.3k views
-
-
Hi there. I'd like to know how to put an svg graphic into my header. Please tell me if there's a way to do this; I see only options for jpg, bitmaps, png, etc. Thank you.
-
- 2 replies
- 1.2k views
-
-
I created a layout and then later went back and moved some fields around. Now when a user is in the data entry form and uses tab,enter or return to go to the next field, Filemaker goes to the field that was originally in that same place but is now in a different spot on the layout. Do I have to re-create the layout and add the fields in the order that I want them to be tabbed to?? There has got to be a way to avoid this and set the go to next field in Field Behavior to what you want... Any info is greatly appreciated. Thanks!
-
- 2 replies
- 1.2k views
-
-
When I want to print an envelope I must change the printer setup options. Then it stays that default for all my layouts How do I save the layout (such as an envelope) with those printer options
-
- 2 replies
- 902 views
-
-
Dear Professionals, I'm making invoicing solution for my company. My colleague wants an interface that could narrow down selection of value list based on other selected value list. Selections 1st: the Company Name 2nd: the Division Name (by selecting the pop-up above, this 2nd pop-up shows only the divisions that refers to this company) 3rd: the People Name (then this 3rd pop-up shows only the people that refers to this company & division) I think this is not so difficult, but I am not really used to the relationships (TO). I've looked around many site and found something similar but they were not I needed. Can somebody help me get out of thi…
-
- 3 replies
- 1.6k views
-
-
I do have a portal with 8 rows. When I click on one of them, then the "Detail-Infos for Person XYZ" appear above the Portal. This works like a charme, but ... The Portal jumped back to the first position in the portal list. So if the user scrolled a lot and want to get some infos of the person, he has always scroll again all the stuff only to get to the last few persons. And maybe he also forget in which position he was after that magical jump? Is there a way to keep the position in the portal? Maybee fetching the status which position or row I clicked in the portal, and then jumping to the calculated positin instead of the normal first position?…
-
- 35 replies
- 9.3k views
-
-
I have a portal in which I click on the client's name and it bring up the clients profile on the same layout. However, the portal then resets to the top each time where as I would like it to stay where it is. The portal is sorted by the client's last names. For instance, when I click on John Smith, my portal goes all the back to A's instead of staying in the S's. My portal is set up through a self-join relationship Clients Profile to Client List. I then use GTRR to get from the portal to the profile. Any ideas on how to keep the portal still? Thanks for any comments.
-
- 6 replies
- 2.7k views
-
-
Has anyone tried using Get(PortalRowNumber) in a Conditional Formatting calculation? I'm using a text box to fill the same color as the background if it's not the first portal row. The formula Get(PortalRowNumber) > 1 does not work. The formula items|TRANSACTIONS::_p Transaction ID ≠ GetNthRecord(items|TRANSACTIONS::_p Transaction ID;1) does. ITEMS is the table for the layout and items|TRANSACTIONS the related table. The second formula does the job, but is not as pretty as the first. Can anyone confirm that Get(PortalRowNumber) doesn't work with Conditional Formatting? And know why not?
-
- 2 replies
- 2k views
-
-
How do I create what I call a related value list? An example would be: You have a "State" value list and a "City" related value list. When you choose a "State" you want the "City" choices to include only the cities for that state.
-
- 5 replies
- 1.7k views
-
-
Order entry description, on occasion, can be really long. Our products are remanufactured, and sometimes the description of what is being sold is, well, a short novel. How can I conditionally display, say, on an invoice, the detail behind the line item? Most line items are under 30 characters, and fit fine, but the occasional one either needs to support a really long description, or the attachment of a descriptive note. The other alternative, which poses a similar problem, is the invoicing of the top line of a bill of materials, with the bill of materials displayed below it. I'm thinking that a sub-summary report might solve both issues, but other ideas …
-
- 4 replies
- 980 views
-
-
I'm using a script to set the Web Viewer to "callto://" & $phone. This gets me to Skype Out just fine. I'm looking to add the ability to add pauses and send DTMF tones. Does anyone know how to do this?
-
- 0 replies
- 1.4k views
-
-
hi there, i'm new to filemaker and setting up a database to organize the 2000+ photos being used in a documentary film. i have a field called "category", in which each photo is assigned to one or more themes (e.g. france, refugees, united states, etc). so any given record might have anywhere from 1 to several themes listed. (i created the database by importing an excel spreadsheet, in which each category entry is separated by a comma). my question is this: i've created a value list for the category field and converted it to a checkbox field. what i now see is a checkbox field that shows me every possible category in my database. that's great, because if the edi…
-
- 8 replies
- 10k views
-
-
Is there a way to bring up a window and NOT allow the user to resize it? I want a fixed window for data input but I dont want the user to be able to resize it at all?
-
- 0 replies
- 1k views
-
-
Hello: I have a portal that displays various amounts on each portal row say $50, $25, $100 etc. And I have a summary field that is outside the portal on the layout that totals the 3 records so the summary field will have $175 in my example. When I add a line - I do this thru a new window with a field that allows the user to enter an amount. After exiting that window the line appears in the portal -- fine BUT the summary field does not update. I use a Refresh Window command but the summary field will still not update. If, however, I click anywhere on the layout the summary field then updates to the correct amount. Is there a way to refresh that field without hav…
-
- 2 replies
- 1.2k views
-
-
I have a old fm file that I changed to english but the system format in the file displays german, euro signs, index and so on. Is there one global setting to switch to english? I checked prefs and doc setting but I cannot fine anything.
-
- 2 replies
- 1.1k views
-
-
How do you change the text label on a button after it has been created?
-
- 4 replies
- 1.3k views
-
-
Hi, I asked a similar question to this before but now I have an example. I have two portals, one is behaving the way I want and one isn't. When a portal row has no data, I don't want the static elements (in this case some boxes, slashes and the word Staff) to appear in the first empty row. What controls this? I have attached a picture of the two portals. Thanks, Matt
-
- 2 replies
- 1.1k views
-
-
I would like to display a set of application buttons on every layout along the left hand side of each layout (without copying them on every layout). Is this possible? If so, how?
-
- 4 replies
- 1.1k views
-
-
Hi I'm working with multiple tables in one filemaker file. I have different layouts for the different tables, and sometimes need to have two windows open at a time, reflecting different tables. Is there a way to assign a windowname to a layout? The scripts I've created for navigation depend on the windowname, and being able to assign a windowname to a specific layout at all times reduces the risk of error for my scripts. Thank you!
-
- 4 replies
- 1.1k views
-
-
Value list not updated until leaving portal - any way to do this?? I think it is a COMMIT RECORD, but how to automagically implement so the user does not have to click button?? 1st TO - Company 2nd TO - Business Card (All the typical field from a business card, used to collect multiple contacts at a single company) 2nd TO BizCard::fk_Company_ID related to TO COMPANY::Company_ID; allow create on from COMPANY 3rd TO BizCard MATCHFIELD (Source TO BizCard), where NAME is related to 1st TO COMPANY::MATCHPERSON; allow create on from COMPANY Portal on COMPANY layout 3rd TO BizCard MATCHFIELD, no scroll bar Value List NAME, from 2nd TO, related to 1st T…
-
- 4 replies
- 1.3k views
-
-
Hello, is there any way to duplicate a record without duplicating certain fields? Thanks, Samuel
-
- 3 replies
- 932 views
-
-
Gday all! This is a bit of a strange one, so I wasn't sure which section to put this under... OK - I have two layouts that are both 'showing records from' "VEHICLE DATABASE". On one layout is a "PAYMENTS" portal and on the other is an "INVOICES" portal. Essentially when ANY payment is made by a customer is gets added to the PAYMENTS portal. Maybe half of all payments need to be referenced to an invoice, so I have a drop down list in the payments portal so people call select the invoice number. What I want to know is - Is there a way whereby when somebody selects an invoice in the PAYMENT portal, there's a way of updating the INVOICE with the payment …
-
- 0 replies
- 997 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online