FileMaker Interface Features
-
Hello Gang, I am perplexed and bummed. I am revamping my product and was going to use a web viewer to display content, but am now having second thoughts now. Please view my quicktime movie, so you can witness the odd behavior: http://www.dwdatacon...s.com/error.mov If you have any comments or feedback, I would sure appreciate it. Thanks! Don PS - I tried to attach the video to this post but got an PHP Error ;-(
-
- 9 replies
- 2.1k views
-
-
Hello, I am setting up a licensing table/layout for my music processing and licensing database. Currently, the flow of information runs like so: Music Owners > Scores > Tracks > Edits One Music Owner owns many Scores, and each score contains a number of Tracks. Each track may contain a number of Edits from that track. I am now creating a licensing table and layout and I need to create a portal that displays tracks as typed into the search field above it (see attached image). I want to be able to type in part of a track title and have it display all of the Track titles that contain the word(s) typed into the Search field. I've been trying diffe…
-
- 2 replies
- 1.6k views
-
-
Hi, I saw an online image of a Filemaker layout that displays a list of names on one side of the layout, which when clicked upon, will display all the information associated with the selected name on the other side. I wanted to make such a layout but have limited knowledge on how to achieve it. The image in question: I would also like to allow the users to create new records in the same layout and filter the names like in the image. I would really appreciate if anyone can give me some advice, or point me to an example/tutorial so I can learn and mimick. Many thanks in advance for your help. The MacGuffin
-
-
- 8 replies
- 2.4k views
-
-
When setting the Tab order in a Layout with a Tab Panel Control, I have discovered that Fields in table layers other than the front one cannot be included in the Tab sequence -- or, they can, but in practice those fields are ignored when the user tabs through the fields. Is there a best practice workaround for this, so that, for instance, a user may Tab from the last field on the 1st Tab Layer to the first field on the 2nd Tab layer, etc.? I'd think this is a common need . . .?
-
- 3 replies
- 1.7k views
-
-
(I wasn't sure if this topic should be posted in the Scripts forum or here, so I apologize if I got it wrong. [How come when there's a 50/50 chance at something I get it wrong 90% of the time?]) Is there a script command to clear a Custom value list from a field? I couldn't find one. In use, when I create updated master files, I don't want to include Custom value list entries after making a clone of the previous version's file. However, I want to leave Indexing on for the for field(s) (for the end user) but just want the stored/indexed choices cleared out before they're given a copy of the updated file. As always, TIA for your help!
-
- 2 replies
- 1.3k views
-
-
Okay, I've dived in and am trying to go ahead and use the new theme-based layout tools and am running into a couple questions. 1) I understand that 12 has done away with the stock"Emboss" and "Engrave" options, and my impression is that such effects can be achieved more beautifully in 12 . . . if you know how? But I don't! So lets say I have a coup of 7 fields and I want to put them on what looks like an engraved or embossed platform. How do I do that? I've dawn a box around them . . . and I see how to play with the corner radius . . . but what else do I apply in order to get that kind of effect? 2) One thing that's driving me nuts is that when you select t…
-
- 3 replies
- 5.2k views
-
-
Is it possible to make the fields in a portal view elastic so as they expand down the page depending on the amount of data in them. Im trying to create a layout for the iPhone.
-
- 0 replies
- 1k views
-
-
Hi, in short I'm trying to do the following: -there's a Table "Letters" -and a Table "People" -In the layout for Letters I want to select the recipient through clicking on a line of a portal. So far, I'm stuck with two things: 1st Issue: If I set the relationship: Letter::kf_ID_recipient = People::k_ID, then the portal is empty, but the assignment of one recipient to one letter works as expected. If I set the relationship: Letter::kf_ID_recipient X People::k_ID, then the portal is populated correctly (I can do nice searches/filtering), but I don't see how the assignment would possibly work then. 2nd Issue: how do I actually …
-
- 2 replies
- 1.3k views
-
-
Why wouldn't Filemaker have a Master Template that you deisgn your buttons, shapes and layout positioning and then other layouts are based on this? Something along the lines of Powerpoint's / Dreamweaver's 'Master Template'. So time-comsuming going through 20 layouts to move your button 3 pixels on each layout. Do it once on the Master Template and all layouts based on it are changed. Voila! Surely it can't be that hard???
-
- 1 reply
- 1.5k views
-
-
I basically have a very wordy legend. It lists over 31 locations and descriptions of the location. With both the location and the description the legend takes up 2 inches of my screen (in the footer part). I want to reduce the size of the legend by having the description text appear only when I roll the mouse over the location text. The legend is simply a text box in the footer, it is not a field or anything special. Does anyone know if there is a rollover function or maybe a better idea of how to have a legend that takes up less room?
-
- 3 replies
- 2.7k views
-
-
Hi, Just starting to learn FM, and I'm stumped by the below. I know what it does, it is a button to perform an action. Question is, what kind of button is it? I tried to manually do this by putting a portal, and placing a button in the first row of the portal just like how the fields are, but it does not work, the button stays only in the first row. Is this some kind of special button? May i know how can i do it? Now, i just copy and paste from samples.. , but i like to understand what i am using. Thanks!
-
-
- 11 replies
- 1.4k views
-
-
Hi All After helping someone adjust a portal sort technique they were trying to add to thier file and due to the fact that i am working on a solution that will need multiple instances of a portal sort technique myself, I was inspired to work up the current technique I use and expand it and make it dynamic so that the same script can be used for multiple portals throughout a file. I also felt that many of the options available out there were overly complicated in thier use of custom functions and other complicated coding. I am proud to say that I believe I have come up with something quite nice that is simple to add to an existing file. It uses four calc fields and p…
-
- 12 replies
- 2.2k views
-
-
I have a table with over 300 records containing the data of individual regions. Each region belongs to one of only ten provinces. I want to select a record for work by using a drop down list, but it makes sense for this to be a conditional list using the filter of the province to show only those regions in that particular province. I have created a conditional value list by following the instructions in the filemaker manual, but this gives me a separate table and creates a whole load of new records, which I don't want or need. Can anyone please help? I attach a simplified version of what I am trying to achieve - simply selecting a region's record by province …
-
- 3 replies
- 2.3k views
-
-
I am using FM 12 Advanced. I have 2 tables: Members and Dues On Members I have a portal based on Dues. All I want is a summary field (in the upper right corner) that shows the total of the over/under amount field. I tried a summary field. Nope. I tried a calculated field. Nope Surely there is a simple way to do this. It seems like it should be quick and simple but I am stumped. Can someone 'turn on the light' for me? (No, I can't use a sub-summary report. I just want to total a field in a portal) Thanks The solution is to put the Sum calculated field in the Members Table... Not Dues... Which makes perfect sense since the…
-
- 0 replies
- 941 views
-
-
I have noticed on some of the new solution that some of the header fields/object move based on the screen sizing and not locked into a fixed location. But ever time I put in a field it is locked to a specific location. How do I get that field to move left or right based on the widith of the window? Thanks Larry
-
-
- 2 replies
- 884 views
-
-
We have given the object name for webviwer for get some value from webviwer object with the below calculation function working well in desktop application, that means we are getting some value from the url (which we have done in the php script.) via webviwer. GetLayoutObjectAttribute ( objectName ; attributeName {; repetitionNumber ; portalRowNumber} ) but the same case not working properly When we go for Ipad. Could anyone please share your comments if you met the problem before.. Note: This issue found only on fm 12 advanced.. bcoz we already done this same in fm 11 advanced
-
- 0 replies
- 1.5k views
-
-
I have a table called "Bids". Each Bid is for one customer's job, but I want to give them options, so I have a portal called "Quotes". If I'm on bid 137, the Bid ID is 137, and the Quote ID is 137, but I want a field called Bid Number that is a serial number: 1, 2, 3, etc. Then on the next Bid, I want the serial number to reset. The goal is to be able to save a PDF of the record, and the filename will use the Bid Number (ie. Customer Name Bid 1.pdf, Customer Name Bid 2.pdf, etc.) The problem is the bid number keeps going, so on my 4th customer bid, it's says Bid Number 45 or something, even though it's the first bid I'm sending. Thanks all...
-
- 3 replies
- 930 views
-
-
I have a number of fields in a data entry layout which are set up as Drop-Down Lists with the "Include Arrow to Show/Hide" list box checked, but for some reason the arrows are no longer visible. There is a small white space where the arrows used to be and if you click on that small space the list works like the drop-down list it is supposed to be. But the arrows are invisible. Anyone else seeing this problem in FMP 12? thanks
-
- 3 replies
- 2.4k views
-
-
When I set a script trigger to OnObjectExit to navigate to a field it just goes to the next field instead of the desired field. Here is what I have: If [CLOCKS::status = "Complete"] Go to Field [CLOCKS::clock_out] End If This script works if I run the script from the menu. It just doesn't work with the script trigger. I have a similar script that goes to a layout and it works fine. Does anyone have a solution? Thank you
-
- 1 reply
- 1.3k views
-
-
I've built a Runtime solution for a user (not Admin) where the status bar is hdden and locked in the startup script. Later on, when the user goes to print, the Status bar is Shown again for him to navigate the pages in preview mode. However. All the Status bar buttons (except for forward and Back page Navigation) are greyed out and disabled. Why? On that note. if the user presses the exit preview mode, I have at the moment a Layout OnEnter scriptrigger to hide (& Lock) the status bar again. Is there any other way to do this except for a layout script trigger? Thanks so much and have yourself a magnificent day.
-
- 2 replies
- 3.3k views
-
-
I have a strict validation set up a that tells the user he cannot change that field. However, the Validation message comes up wiht two buttons - 'Revert Field' and 'OK'. 'OK' does nothing and only the 'Revert Field' should be visible and selectable. Is there any way to get rid of the 'OK' button? Thanks so much and have a great day!
-
- 4 replies
- 870 views
-
-
I have created a solution that uses a specific font that I provide to the client along with the FM file to install. If the user doesn't install the font, can I set the FM file to use E.g. Comic Sans font rather than using the computers default font (Often arial or verdana)? Thanks so much. Have a fabulous day.
-
- 2 replies
- 1k views
-
-
Hey everyone I'm in the process of updating a database solution so all main layouts have a "quick jump" feature. The quick jump is a pop-up menu that has all major layouts listed so the user can quickly jump to and from certain layouts. As I have never implemented such a feature, I have currently created a script that sets a variable based on the selection, and then created IF statements to take the user to the correct layout (or perform the correct script if necessary). Set Variable [$quick_jump ; value:quick jump] IF [$quick_jump = "Main Menu"] Go To Layout "Main Menu" (or Perform Script) The script is very basic at this moment in time as I have only …
-
-
- 2 replies
- 1.2k views
-
-
hi, i have a problem regarding formatting of my product fields. the default parameters are: arial, 11size, plain, black etc. my native language is latvian and when i am typing characters like: ā, ē, ī etc., then the font changes to HEITI SC light. is there a way to fix this issue? i would like that all fields are ALWAYS formatted like this: arial, 11size, plain, black etc. and when i copy some text from webpages into my product description it also copies the formatting. it would be great if it would also have the default formatting. sincerely, raitis
-
- 4 replies
- 1.2k views
-
-
I am creating a database to produce Teaching materials for the classroom (flashcards, Pictionary boards etc.) I notice that the default printer margins for me are; 0.28cm for top and left Margins 0.32cm for Bottom and Right Margins I will produce this as a runtime version and the flashcards need to fit perfectly on all Printer margins for a number fo users. Do all modern day printers have the same margins? Is there a margin width I can leave that ensures that no matter which the user/printer, the flashcards will fit perfectly? I would be interested to know what Printer Margins you have as default on your machines? Thanks so much for all the…
-
- 0 replies
- 917 views
-
-
Not sure where to put this question. It's about printing but it is also about layouts. It might also involve portals. I have a task list for managing activities in my cabinet shop. Each cabinet has about 100 processes which is way more records than will fit on a single page. I would like to manage them in a list format but I want all the items to fit onto a single page. The end result would look similar to the attached jpeg. Is there a way to show columns like this on a single layout?
-
- 3 replies
- 862 views
-
-
I'm obessed with trying to make my database to function like a touch (click button) screen cash register. I'm using the Invoice Starter Solution, with no changes to their fields and relationships. I've tried for hours and hours different methods to accomplish the following : How do I create the following? Starter Solution for Invoices "Invoice lay-out:" object is a (picture of a apple) button to select the field "product ID". I have written many scripts but to no luck. If anyone can help me, this is a time senstive matter otherwise I would love to fiqure it out myself. Thanks!
-
- 1 reply
- 1.7k views
-
-
In FM12, I have a field called City and State. When the user enters the city field I want "Brooklyn" to be a default unless the user changes it. Same with "NY" for state. Is there a way to do this without doing it in view database fileds and making that happen as a default there. Then it will happen all the time. Maybe I only want it to happen in certain layouts. Mike
-
- 5 replies
- 957 views
-
-
Hold your hats! I'm finally trying to move from 9 to 12 - slowly. Anyway, my question is as follows. I'm trying to combine separate files into one file with separate tables. So I have a file called parents and one called students. I copied the database and fields from students to parents. So far so good. Now the problem. I would very much like to get the student layouts into the new table in the parents file. No idea how. Can I? Should I chuck the whole idea now? Mike I failed to mention the original parents and student files are in fm9, my new file is fm12. Thanks. Mike
-
- 4 replies
- 1.6k views
-
-
Hello everyone, I'd like to be able to use a checkbox or radio button set to specify a "default" entry in a portal. For example, I have a membership database, and in a member record, I show a portal of his/her addresses. Since each member can have multiple addresses, I'd like the user to check a box/radio button to specify which of the addresses shown in the portal is the default address for that member. Easy enough to add a checkbox field... However, I'd like this checkbox to act like radio button sets, where you can only have one checked at a time. The problem is that the context of a radio button set is a record and I want it to be the portal, so I can have o…
-
- 7 replies
- 2.9k views
-
-
Hi, I am trying to create a value list based on related values. I am using 2 concatenated text fields in the same table for either side of the realtionship. On the left, I have GetAsText(Date) & "_" & GetAsText(ID)& "_1". On the right, I have GetAsText(Date) & "_" & GetAsText(ID)& "_" & FirstRecord where FirstRecord always equals 1 if it has a value. I can see the records listed in a portal on the layout when on any record with the correct Date and ID, but they only show up in the value list when I am on one of the records that has a value of 1 in FirstRecord. I have used these types of relationships for value lists thousands of times in FM6 …
-
- 1 reply
- 830 views
-
-
I have two questions. First, when you create a field and drag that field to be larger than one line, you can see dotted lines until you save the layout. I would like those lines to stay visible so that when I print they are there on the printed copy. Second, when printing, for some reason my footer prints on the first page and then the second page prints and has no footer. Thanks for the help. :)
-
- 2 replies
- 785 views
-
-
Is there any way to Restore Custom Menu Set 1 to a database? I duplicated the Custom Menu Set 1 and then modified some of the commands, such as File Copy, not realizing that I was modifying the command both in my new Custom Menu Set and in the default Custom Menu Set 1. Now I need to get back a menu command and I can't figure out how to do it. Help please. Thanks
-
- 0 replies
- 1.5k views
-
-
I created a freeware membership application and 'released it on the world' . (Since I am in the USA it reflects USA postal and phone standards) ha I am getting requests from through the world for 'versions' for different contries. (UK postal codes are like nothing I have ever imagined) Question:"Is it best to make different versions for different countries (ie, UKMembership and CANADAMembership etc) knowing that this method is an update nightmare... Or, is there a way to ask the user which country / version he wants to use and then just jumping to appropriate layouts. I suppose the 'choice' would be stored in a global field and this field would be 'looked a…
-
- 0 replies
- 711 views
-
-
Just converted my FM11 files to FM12 using the trial version of FM Pro 12. I have 'hidden' portals on many screens. Up through FM11 I was able to hide the scroll bars through line transparency, but they all show on the converted FM12 layouts. It looks like I'm going to have to go through all my layouts (hundreds of them) and hide all the scroll bars again. Don't know yet, but will I have the same problem with fill on fields and other objects where I had used the transparency option in FM11 (this would be especially painful for updating conditional formatting)? Am I missing something?
-
-
- 3 replies
- 5.2k views
-
-
Am I correct that in v12 the only way to set up the default font/size etc for new fields is via the theme?
-
- 3 replies
- 1.9k views
-
-
I am trying to develop a chart of tasks for my cabinet shop. This chart has three fields: Account , Task, Code I would like to constrain the printout (or layout) to only include the ACCOUNT description for each record just one time in the printed or viewed list. I want the effect of turning this value into a chart heading so that this value does not repeat itself for each record on the form. Is this possible to do?
-
- 2 replies
- 944 views
-
-
Hi I am not sure if this forum is the best to post this query. I have what I think is a very basic question. I have a dialog box with a pop up menu. The user selects a value I then have a calculation which goes something like: " If choice 1 or choice 2 or choice 3 then do this OR if choice 4 or choice 5 then do another. I have done this in the context of a case function. This seems inelegant. Is there a neater way to determine which calculation to perform based on the user choice without all the "or's" Joseph
-
- 6 replies
- 1.1k views
-
-
I have an items table and a related cost table. I want to create a report with a list of items and their costs. I also want the total costs. I’ve created the report on a list table layout. I’ve tried placing a summary field of costs in a subsummary part or a trailing grand summary, but the total costs are incorrect. Any suggestions?
-
- 0 replies
- 683 views
-
-
I'm not sure if this is possible, but I currently have a script that replaces field contents of several records when I run it. I view these records as a list and I'd like the fields whose data has changed as a result of this script to highlight...but I only want the fields to stay highlighted until I run another script (or add a condition?) to remove the highlight. It's just a method of keeping track and double-checking the fields whose data has changed whenever I run this script.
-
- 2 replies
- 1.9k views
-
-
can i create a database that has a portal that records all the new record of the database ? even when i put create new record i doesn't change and put the new record.... something like filemaker 12 has in the task database. please let me know thank you
-
- 5 replies
- 1.1k views
-
-
I'm new to Filemaker in general and am creating a database for organizing footage into categories . Basically, I need a drop down field in which you select one category then it brings you to another category and so on, yet I have no idea the correct way to go about this. Which is the most efficient to make this work? Example: Animals -birds -dogs -lab -pitpull Transportation -cars -trains -planes -Air force one -military Also, after I create this table is there a way in which I can use it within another table? Thanks a ton!
-
- 1 reply
- 934 views
-
-
I have the uneasy feeling that you guys are going to embarrass me by pointing a simple and obvious solution to my problem. Long sigh..........here goes: I have a layout with a single field on it. The UI is set up to open a new window and go to this layout upon clicking a button. The script opens the window and goes to that field. I don't want the user to be able to exit the field by clicking into the background so I thought I would use an OnObjectExit script trigger to run a script that simply goes to that field using the Go To Field or Go To Object script step. I found that I need either an Exit Script[0] or Halt Script step following the Go To F…
-
- 5 replies
- 1.8k views
-
-
Hello. Is there a field or anything in Filemaker which is like a global field in that the data in it can be viewed across all the records at all times BUT can be viewed and edited at anytime by any person logged onto Filemaker on a network? Oh, and the solution can't be too complicated either! I'm an old novice.
-
- 4 replies
- 988 views
-
-
Hello Forum, In my file I have a table for letters and a table of persons. Each letter has one recipient and is related to one project. I read, that this anchor buoy thing is all the rage. So I followed that, as best I could. I use a value list in in a pop up menu to have the user select the recipient. The first field is the kf_ID of that person. The Second field (only this one is displayed) is the Name. That is very smooth, since it is automatically sorted alphabetically. As for the project I couldn't quite figure out things yet. I set up a field that calculates a string which is used as a second field (number & ": " & "project_name"). In…
-
- 1 reply
- 865 views
-
-
Ah the fun part. Describing my db and my problem. Well here goes... We print calendars with advertising on them. As the image below shows, i have a pretty typical invoice type solution although it has grown to be a monster, so in the screenshots I erased all the irrelivant tables. Note: Although my actual TOs don't have underscores in the names I used underscores in the write up below for ease of reading. The task; Create a report that shows a summary of all the invoices ( tickets in my db ) that were paid after the calendar was printed. Also show percentages of total tickets and total amounts. So far; I pulled the job FK from tickets into a f…
-
- 0 replies
- 801 views
-
-
On a busy layout that doesn't have room for a portal, can a portal be created to pop up in a certain part of your screen via a trigger of some sort? Would you create a portal on another seperate layout and then resize the layout to the size of the portal?
-
- 7 replies
- 3k views
-
-
Every single time I move a folder full of layouts in the Manage Layouts dialog, FM is making it a subfolder of what is directly above it. I can't get it to stop. Can anyone give me pointers? I want: Level 1 SubA SubB SubC And I'm getting this when I try to move C to be above A: Level 1 SubC SubA SubB I am not able to get A or B out of C unless I move them above C...which then puts all below into the just moved folder. Very frustrating!! Well that didn't show up correctly. See attached. The folders with red dots should be in the same outermost level.
-
- 4 replies
- 1.3k views
-
-
Hello, What im trying to do is straightforward, but i cant seem to figure out how to go about doing it. Referring to the images, i am trying to add a class to a user. A very simple method of choosing from a dropdown, click add class and presto its linked to the user. I would also like to make sure that the class is not added twice. However i have no idea how i can just fill up that dropbox without it being a part of the table, just referencing from another table (Classes.class Name). After which when its linked, the linkage would be registered in the "Classes Joined" table.. linking the user id to the class id. I got a minor idea to use a calculation fie…
-
- 0 replies
- 858 views
-
-
Is it possible to slide a container field/text field left so that if there is nothing in the container field the text field to the right will slide left ignoring the empty container field?
-
- 5 replies
- 1.9k views
-
-
OK, can someone tell me the trick to printing in columns. I have it selected in the layout setup dialog and all my fields are set far to the left with plenty of room for 2 columns. As I was putting the layout together and testing, it did show up in 2 columns in preview maode at one point. Then i did some more tweeking and changes and it has not shown in 2 columns in preview mode since then. I've tried unselecting and reselecting but I just can't get it to display in columns. What is the trick?
-
- 2 replies
- 867 views
-
-
Hi, I need a Black or White choice, only one can be selected. They are in the same Layout but not in the same field. Black is in the left side of the Layout and White is in the right side. I tried using Radio Button but could not figure out how to separate the two choices from the same field. In Check box I don't know how to make only one of the two fields be selected. Cheers.
-
- 2 replies
- 1.1k views
-
-
Ok, to give you some background, my database has these tables: 1. Properties 2. Jobs 3. Customers 4. Quotes I want a Layout called "Dashboard", that basically has 4 columns, each titled the table names. Then I want it to say what "red flags" or "warnings" I have. For example, some of my warnings would be "A quote that is still open and it's been 7 days and I haven't followed up". Right now, I don't need to be able to pull/link to the exact record, but I would like it to say in the "Quotes" column: "You have X number of Quotes that haven't been followed up on in 7 days" Under the "Properties" column, it might say: "You have X number of Prop…
-
-
- 5 replies
- 1.4k views
-
-
As a new user to FM, I'm not sure what the best Template would be for my situation. I want to create a database for Young Student Drivers. It would include names, start date of course, entries for 9 road lessons and 1 entry for road test. I'd like to be able to quickly check on what students are nearing their road test. Are there options of having an alarm or notification pop up within a week of their road test? Sorry for my ignorance here. I just want to get started on the right foot and the right Template. Thanks.
-
- 5 replies
- 2.2k views
-
-
If the contents of a field is too long to display I want it to simply get cut off without wrapping to the next line. I have tried adjusting the line spacing to try and push the wrapped text down low enough to where it's not visible but this prevents the first line from being displayed so that it is vertically centered. Does anyone have a trick for doing this? I wish FileMaker would add a simple "truncate text" checkbox to the field inspector options so I would not have to resort to writing multiple truncate calculations to get my layout to display how I want it.
-
- 4 replies
- 2.5k views
-
-
Hello Forum, this has probably become second nature to you all, but I was trying to find a document, where syntax rules for the Layouts are listed. (e.g.: <<Name>> is replaced with the content of the "Name" field) I don't even know how that is called in filemaker. Layout Markup? Can it do some rudimentary logical evaluation? (use "company" if "name" is empty) thanks for helping out!
-
- 2 replies
- 886 views
-
-
Hi, is there a possibility to draw something and then to store the image in the database? The same way like GoDraw 1.0 for FM Go. And could someone explain me why GoDraw works in FM Go but not in FM Pro Thx ChiSao
-
- 0 replies
- 1.4k views
-
-
Here, i am developing ipad app, in which i have to create a database using filemaker pro ( v.12), just i have designed form for an ipad, now i don't know how could i integrate/call my designed database into my iPad application. I am very new to this, Can anyone please suggest me with ur valuable ideas.
-
- 0 replies
- 650 views
-
-
I've wondered about this for years, but never really needed to answer it before now. I'm preparing a database to help the library register people for programs. There are about fifty programs per month. Most have room for eight or ten people; some are one-on-one sessions; some movies and presentations have room for 35; some outdoor events have room for 50. So I plan to reserve a field (called some shorthand for Number_Of_Spaces) where the organizer will manually enter the number of spots for registrants, and I need a solution that works for every variable from 1 to 50. What I want is for the number of blank spaces on the roster to equal the number in that fi…
-
- 4 replies
- 878 views
-
-
FileMaker provides clear instructions for creating a custom theme: http://www.filemaker...ustom.23.9.html ... but nothing on CSS and on modifying themes for FMP12 (nothing that I've found, so far). Other than "learn CSS", can someone familiar with CSS provide a few tips to help us get a toehold. I've attached a screen capture of a simple FMP12 text field with scroll bar (from the Cool theme). If someone can point out which CSS statements specify the three aspects (as marked) of the display field, I think I can be on my way to making a few needed changes. I've tried what I thought would be the simplest of all: increasing the width of a text field scroll bar…
-
- 4 replies
- 3k views
-
-
Is there a function I could use to track layout access: layout name, when used, by whom? This would be useful to clean up a legacy database that has a lot of old (probably unused) layouts.
-
- 6 replies
- 2.6k views
-
-
Hi I Have some dificulty trying to understand on my file why its not possible to related 2 different tables and do the calculations on the other table As you can see on my file attached i have a very simple file with 2 layouts only 1 Is the input layout 1 Is the lines layout And Im trying to get the result board on the input layout to give me the result of the other two inclued layouts but for some reason i only get part of the result on the first line off the Resul Board If anybody can give some help It would be a great help Thank you P.s. Account : Admin Computer Shop.fp7.zip
-
-
- 18 replies
- 2.7k views
-
-
i made a layout i dont have another pc to check the file , is it adjusted to all screens correctly . can anyone plz rectify if it isnt laid correctly UI-check.zip
-
-
- 11 replies
- 2.2k views
-
-
The new GUI design tools in FM12 are awsome. Has anyone figured out how to design custom themes or modify the existing ones?
-
- 9 replies
- 8.7k views
-
-
If I export data that includes a Checkbox or Radio Button, where one or more values have been selected for that field, I get a very strange separator character between each value. It won't even paste here, but it looks like an arrow pointing upwards. I've never seen a character like it and it's not recognised by any program I've tried importing to. Can we change the separator character used on export ?
-
- 4 replies
- 2.4k views
-
-
i made 2 files.html and jquery i want to use it in my database so that it can work on any computer can any one help me how to do it
-
- 1 reply
- 2.4k views
-
-
Hello, I'm trying to create a conditional value list. I've read through what I can find on this topic... and there's a lot. Still not able to equate a solution to my example. Can someone advise please advise how to proceed? _EMPLOYEES ID_EMP.pk Name Status (active or inactive) _PROJECTS ID_PRO.pk ID_EMP.fk Team Leader My link between the two tables is _EMPLOYEES::ID_EMP.pk to _PROJECT::ID_EMP.fk To simplify this example I have just two records in the employees table: Name Ben Status Active Name Sally Status Inactive The Team Leader value list field in the _PROJECTS table should only produce those reco…
-
- 13 replies
- 2.3k views
-
-
the below image the junk checkbox is ticked and in the field text chicken is beside milk instead below the milk i need enter command here tried triggermodifiers but didnt understand it plz help plz tell any better alternative for below script triggers or scripting final list Copy.zip
-
-
- 22 replies
- 3k views
-
-
Dear All - Please Help. I have a file with four Custom Menu Sets. In the Custom Menus dialog, at the bottom, I have [standard Filemaker Menus] specified as the default for the file. On my layouts, I have [File Default] specified as the Menu Set. But Filemaker STILL keeps switching the menus when I move from one layout to another. Is there any way round this bug? I am in FM Pro Advanced 11.0v1. Many many thanks in advance, W.
-
- 6 replies
- 2.1k views
-
-
I have FM 11 Adv (and won't get FM12 until they speed it up) I have a portal table that consists of: MembershipType MM Dues (Yes/No) Assmt (Yes/No) PM Dues (Yes/No) This table is in a portal and it works. But, when a user adds a new row to the portal and after they exit the MembershipType field, the portal sorts itself so that my 'new' record that was at the top is now 6th (for example). Question: "Is there a way to do a Perform Find in a portal and after a successful 'find, use get(activePortalRow) to get the portal row where the find was successful? (I want the user, after typing in a new MembershipType, to continue in the same portal row to …
-
- 6 replies
- 1.6k views
-
-
Usually, when I enter Layout Mode the whole screen (I have a widescreen display) has a white background with page and gridlines, etc displayed over the width (and depth) of the screen and I can utilse the whole of the screen to insert and manipulate fields/objects etc. However, on one particular dbase file, in L/O mode, the layout seems to restrict to just the parts and the rest of the screen background is blank grey - with no gridlines etc. Objects and fields do appear in this grey screen area (to the right of the L/O parts) but they cannot be dragged or dropped, only manipulated using the keyboard (see top picture attached). Draft versions of this file display…
-
- 2 replies
- 911 views
-
-
Hi Everyone, This is my first post here I need your help.. I have attached the sample file that I am working on. What I am trying to achieve is to have two related lists which when an item is selected from the first list the second one is updated accordingly. I have made two portals in layout "models" which I will be using mainly. Actually it is functioning now but with slight glitches : 1- when I select an item from the first list my hilte gets lost 2- since the record is changed every time when I make a selection the first list is scrolled back to top. Thank you for your suggestions, Koray Birand models_test.fp7.zip
-
- 2 replies
- 1.2k views
-
-
I have a table of Companies, operating in differing Regions (defined in a Regions table), stored in a repeating Regions field for each company. For my Items table (located in a different file) would like to store Companies in a repeating field in a similar matter, and be able to set Regions for each item via a value list based on the Regions defined in each Company. If: Company A have Regions 1, 2, 3 Company B have Regions 2, 4 and I select Company A for the first repetition of the Items Company field and B for the second repetition, I would like the value list for the items Region first repetition to show 1, 2, 3, and the second repetition to show 2,4.…
-
-
- 5 replies
- 1.3k views
-
-
I used "Other Symbol" to return "Current Date" and then in Inspector I choose custom date format. Without any understandable reason I got back date format in Serbian language. I'm from Serbia but my FileMaker 12 Advanced is set to English as default language as well as my Windows7 Ultimate. I want date to see in English, no matter from where I'm watching at it. Does anyone know is there some solution to make Inspector returning date in English or I just found a bug? Best Regards
-
-
- 2 replies
- 1.5k views
-
-
Hello! My name is Jon, I started learning FileMaker about 8 months ago when I got hired for an ophthalmology specific EMR company. I was trained under FM11 Pro Advanced, but am still very new to database development in general. I've been working on a specialized appointment scheduler module for our program, but have found that my initial approach was unsatisfactory on a network. My Calendar layout was 8 portals of related calculation fields, where each line was a record corresponding to a time (ie, 8:00am, 8:10am.) There were over 1,000,000 of these "time" records stored in this table. When booking appointments Filemaker would perform finds on these records fo…
-
- 3 replies
- 5.6k views
-
-
I've attached a copy of my database file. I'm trying to create a conditional value list that populates in a portal with two fields that contain value list. I tried to follow the setup of a an example I found online. It appears I did something wrong. I can't find it. Any chance I can get someone to take a look and see if you can tell what I'm doing wrong? Also, I've got something funky going on with the portal. When I add a portal record it seems to add two rows.. when I try to delete the portal row--it doesn't. Any suggestions would be most greatly appreciated. Thank... mp ConditionalPortalValuesProblem.zip
-
- 2 replies
- 985 views
-
-
I have a value list based on two fields: A record ID field, and a "display name" field based on a concatenated First-Last name. This appears in a pop-up menu which filters the portal below it to display the related contact information for the contact selected in the pop-up menu. Everything works correctly for data entry on a new customer record. My problem is that the pup-up menu on each existing record currently shows the Record ID number for the contact, and not the display name. The portal below does not show any information. To update this, I have to manually select the pop-up menu and re-select my choice for the primary contact. Is there any way to autom…
-
- 3 replies
- 1.3k views
-
-
I have tinkered with field borders in the past without much success but would like to revisit this again. I have a layout that is an assessment report with the following fields that I would like to present as a table with lines (field borders): (Question No) (Question) (Answer) (Competent/Not Yet Competent)->This is a text box Firstly, the depth of the (Question) and (Answer) fields is quite large to accomodate the varying contents. If I set the fields to slide up and reduce the enclosing part is there a way to get the two fields with the least text to only slide up as far as the field with the most text? This way the bottom field borders will remain in …
-
- 4 replies
- 1.1k views
-
-
I have a portal on a layout listing ID number (that can't be changed) and other fields that I can change whilst viewing each customer. Is it possible to select a line in the portal to display addition information in another portal on the same layout
-
- 11 replies
- 1.8k views
-
-
Hi All, I've been an Apple IT consultant for over 20 years. Ever since MYOB/AccountEdge introduced their Time Billing module way back whenever that was, I've been using it for on-site, off-site, phone support, etc. billing and time tracking. To be honest my business is simple enough that that is the only function of MYOB/AccountEdge that I have ever used. Way over kill for such a simple task, I know. Over the years I have looked at dozens of TimeBilling apps, none even come close the the simplicity and brilliance of it's implementation in MYOB/AccountEdge. FileMaker 12 has been released. I've been checking it out and running it through it's paces with a few conv…
-
- 2 replies
- 3.1k views
-
-
I have a script that copies data from a text field that is setup as a checkbox. The checkbox pulls values from another table. However, when the script copies the data from the field is not only copies the checked data but any data that is currently in the field and previous data. For example: X Choice 1 X Choice 2 O Choice 3 The script will copy not just the 2 items checked but all 3. It then also copies any choices that may no longer be in the database. Running FMP 11 Advanced Any help is appreciated. Thanks
-
- 3 replies
- 964 views
-
-
Hi. If I create a custom menu in fm pro advance. Will it display / work in filemaker pro as well? thanks.
-
- 2 replies
- 1.8k views
-
-
Hi, Im new to filemaker, and I have a problem with the size of the description on the line items. Basically, after I enter the data, then I click the print mode, I want all of the contents of the product item displayed. For example, this is what I have at the moment. - But on the first item there are more details that need to be displayed like this but I want the list to move down when more content are added so all of the description is shown. Sorry Im just beginner I hope I could explain myself. Thanks
-
- 13 replies
- 1.7k views
-
-
Have just noticed my Dropdown's dont work anymore. It seems that Valuelists defind from fields only work if you define a relationship with "Include only related values starting from". The "Include all Values" doesnt work on my old Database files. If I create a new Database and do the same ("Inlcude all Values") and it works fine. Also, FM12 is very sluggish!!! At least 20-30% slower! Havent tested any new feautures yet but I like the fact you can have larger scroll bars on portals now! Yipee! Have you guys noticed any slow donws using the new corner radius tool?
-
- 4 replies
- 3.2k views
-
-
Hi, A customer wants a script to generate a "mail merge" from a small found set of People, creating a separate document for each letter. He wants to be able to open them in MS Word for additional editing, before printing them. I can define a layout with merge fields, no problem, but I have no idea how to write it (preserving the text stylings) to a file that can be read by Word. A long time ago I tried doing this the other way around, getting MS Word to do a mail-merge by accessing Filemaker, but it flopped horribly - finally turned out there were some known bugs in Word's ability to talk to FM. :-/ Is there any way to get FM10 to convert an all-text…
-
- 5 replies
- 2.1k views
-
-
weird.fp7.zip hope you guys enjoy the file. -ian
-
- 0 replies
- 1.5k views
-
-
Hello all! I have a database with a number of fields. I have designed a print layout and I used merged fields. Here's an example: Title1<<field1>>, Author: <<field2>> <<field3>>, is happy with <<field4>>... and so on. Which is great, I can format the fields as I like, I don't care if a field contains 3 words or 3 paragraphs, because everything is so flexible. But there are times that a field like field2 is empty. Then the output becomes Jason makes a new friend Author: Jason, is happy with his new friend... Yeah, I know, stupid example, but you see where I am goi…
-
- 3 replies
- 2.5k views
-
-
I have been looking round and can't seem to find this feature. Does anyone know if it is possible to display multiple records on one layout. I know I can do this in list view, however I need to be able to style the page and place fields in specific places on the page. To maybe give you a little better idea of what I am looking to do. I want to be able to view 2 existing records each in a column on the left side of the layout. There will be some design elements in the middle of the page and a third column(record) on the right side of the page. Does this sound possible?
-
- 4 replies
- 4.3k views
-
-
Two particular deal-breakers: One, Most of our layouts contain many hundreds of stacked objects. When in layout mode we can no longer click in the center of transparent objects to get to objects underneath. We can only select the frontmost object, transparent or not. I can't imagine what this will do do our productivity. Two, We use conditional formatting extensively. In one case we highlight a portal row, passing the record id as a parameter from a button calling a navigation script. We conditionally format the highlight on that particular record. In v. 11, this takes about .33 second, even with loaded portals. In v 12, we clocked this same script at j…
-
- 1 reply
- 2.1k views
-
-
I would like to add my custom icons to the stats toolbar in FM 11 Advanced. Is this possible?
-
- 8 replies
- 2.6k views
-
-
Under Custom Menus, I've added a Menu Item to the File Menu that runs a Script. From Mac or PC, you can select this Menu Item, and it will successfully run the Script. But I added a Keyboard Shortcut ( Control + I, that's the letter i) and the Keyboard Shortcut only works from a Mac not a PC. Any ideas why? Under "Include on Platform", both Mac and PC are checked. Using Script Debugger, I can see the script does run activate at all.
-
- 3 replies
- 1.7k views
-
-
Hi, is it possible to have 2 tables in one layout, one showing table view and one form view? Thanks
-
- 9 replies
- 1.8k views
-
-
Hi, I hope this is the right place to post. I've got a database for storage details of drawings which we produce for individual projects and various related tables which allow details of revisions to be stored together with when sets of drawings are issued to clients and other members of the design team. The tables are basically as follows: Projects > Drawings > Drawing Revisions Projects> Issue Sheets > Issued drawings (Based on the Drawing Revisions) Drawings Issued to > Issue Sheets This all works fine and allows me to produce individual drawing issue sheets which lists the drawings I have issued to a set of clients on a par…
-
- 3 replies
- 2.1k views
-
-
I am able to find a number of examples on how to create conditional values list... but none with same type of relationships I need in my solution. I have a total of five tables and two TO in my database. _PROGRAMS (parent table to all) Events.PROGRAMS (TO of _PROGRAMS creating the relationship to generate the EventsONLYPrograms vl) Services.PROGRAMS (TO of _PROGRAMS creating the relationship to generate the ServicesONLYPrograms vl ) _PROGRAMS_2_EVENTS (a join table) _EVENTS (child table and layout where I need the EventsONLYPrograms value list to display) _PROGRAMS_2_SERVICES (a join table) _SERVICES (child table and layout where I need…
-
- 15 replies
- 1.7k views
-
-
Can someone give me some advice on how to carry out the following. I run a self-employed service company and the database I created years ago still works great, It consists of two tables: Customers and Jobs. I can see a customer and a list of jobs done for that customer. Its just that when I created the jobs table, I only created two 'date' fields; one for 'date booked', the other for 'date completed'. This is ok if the date booked is the call out date and the date completed is the finished date, but some calls require more than two visits and work carried out on those visits needs to be recorded. I'm not sure how to approach this, whether I need to cr…
-
- 2 replies
- 1.1k views
-
-
Despite the current performance issue there are some great improvements with FM12. One thing that I really appreciate is that portal scrolling works great now on both Windows and Mac. You no longer have to click on a portal to give it focus. Simply hovering over them and scrolling your mouse wheel now works.
-
- 1 reply
- 1.1k views
-
-
Hi All, Seems FileMaker 12 list view will only show field formatting of the currently selected record. Very disappointing! I Hope it is a glitch and will be fixed soon or even better I hope I have got this wrong and there is another way to do it? Any thoughts? David Lee
-
- 2 replies
- 2.8k views
-
-
I've opened my FM11 file in FM12 and am noticing odd or different behavior between the two versions that I don't understand. In a portal, I have a value list that is based on a field. This values are the children of the parent item in the particular record being shown on each portal line. In FM12, the values from the first line item is just repeated in every record below regardless of the parent, UNTIL I actually click on the field, and then the displayed values changes to the appropriate values for that particular record...as soon as I click out, the display reverts to showing the values from the first record. If I am not explaining this sufficiently, I can try to …
-
- 0 replies
- 1.1k views
-
-
I want to sort a list using a custom order based on a value list. The field in question is a calculation field. For some reason i cant get the field to sort in either the custom order or in alphabetical order. Has it got something to do with the fact that the field is a calculation field? Please help. Very stuck. Not sure where to from here.
-
- 9 replies
- 1.7k views
-
-
Recently Browsing 0
- No registered users viewing this page.