FileMaker Interface Features
-
Hi, I'm switching form MS Access to Filemaker Pro 10 and now I have a problem with my portals. I have two portals in two different forms ans in one of the form I get a new blank row to insert a new record automatic on the other form this doen not happen. I've checked everything but I can't see any difference in the portals. So where do I set the portal to an automatic new line to insert a new record Thanks
-
- 3 replies
- 1.1k views
-
-
Is there a trick or "undocumented feature" to inserting a vertical, hairline rule to visually separate two columns on a page? I'd like it to run the length of the Body section. (Note: the body consists of a list of items, not one big text field. TIA for your help! Rich
-
- 4 replies
- 1.5k views
-
-
Hi, I'm having trouble with sorting my records by a timestamp. I want the newest record to be on top of the portal, but when I sort in the portal by timestamp_creation it will put the newest day at the top but have the times backwards. The oldest time is on the top. Any help would be much appreciated. Thanks, Bryan Anderson
-
- 1 reply
- 1k views
-
-
History 2::Status = "broken" & Contacts::Contacts_TId="2". I sued work if this to condition ate true?
-
- 3 replies
- 1.4k views
-
-
I have a CMS in Filemaker where the fields that remain to be filled in by the user are highlighted in red through conditional formatting. Is there a way to determine which fields on a layout are coloured red, so that when the user tries to exit the record I can check that all the necessary fields have been filled in? Or is there another way to organise this? Many thanks in advance, W.
-
- 4 replies
- 1.4k views
-
-
Sorry.. just using the post to upload a file to link. Database.pdf
-
- 1 reply
- 1.6k views
-
-
hello I need to open a window but I do not want someone to close from it close box, but from the ok button I have. Is there a way to disable the close box button???
-
- 2 replies
- 1.3k views
-
-
Hi all, I presume I would do this with some form of self-join relationship but cannot really get my head around how to go about this. I have a layout with 10 container fields on there. Document1 Document2 Document3 ... I would like to set a button next to each field "VIEW" but I would only want this button to show if there is something to view in the container field. The actual script behind the button is all sorted, I am just struggling working out the button show/hide. Would I put each button into it's own portal which was based on a self join relationship, if so what would the self join relationship be based upon? Many thanks for a…
-
- 2 replies
- 1.2k views
-
-
Hi. I'm trying to create a report, but I can't figure out how to do it properly. Let me start with an overview of my db. This is a basic project management db for a small group. There is a users table, which simply sets a user ID based on login. A Projects table and a tasks table. Tasks are a child of Projects. So I can have projects without tasks, but no tasks without a project. Here's my issue, I want to create a report that lists all Projects and its tasks. If I do this by basing the reports off of the child (tasks) any project without tasks doesn't get listed. I also tried creating a report based on the Projects and using a portal to list task…
-
- 1 reply
- 1k views
-
-
Is there any type of tool that can identify whether or not a layout is in use? I need to clean up the database and would like to remove unused layouts but not break anything in the process. The DDR provides this type of information for scripts (used in layout, used in script), but not for layouts. Is there an easier way to do this than digging though the database piece by piece?
-
- 9 replies
- 1.7k views
-
-
I have something weird going on. I have a drop down menu that refers to a drop down list. First field contains 3 char initals :FMP second field contains Name: Filemaker. "Intial" is selected from left side window, right side has "Name", both of these fields are on a separate layout with two columns with multiple rows. "Include all values" is selected, and "show all values" is checked. OK NOW MY ISSUE I have this field placed in my footer along with some other less essential fields, in this position it works well with other drop downs and i can do combination searches to narrow down my results. If I duplicate this field and place it…
-
- 0 replies
- 1k views
-
-
Hello Mavens, is there a way to prevent the automatic tabbing to the next field when the user enters a date into a field via the drop-down calendar feature (FMP10)? I created a sham field with a trigger to commit records upon entry to the field which tabs after the date entry field but I'm wondering if there is another solution.
-
- 2 replies
- 1.4k views
-
-
I have a problem that's come up at the end of several steps. Here goes: Table One is called "topics". This table has two fields "topic ID" and "topic Name". Table Two is called "locations". This table has a field with a check box style value list. The value list is generated from the other table's "topics ID" and "topic Name". This all works great. It displays all the records in "topics" table with the id and name showing. So, what I want to do now, is display the checked values on a report. If I put the check box field on the report as a standard edit box, it only displays the data under "topic ID". I'm assuming this is because that's how the relatio…
-
- 5 replies
- 1.2k views
-
-
I know how to make objects transparent but there is no "transparent" setting for text within a field that I am aware of. I would like to have the capability to layer a selection field like ID Number that is formatted to display a drop down list of Names over the field that displays the related names so a user can select from a list of names, change the ID number transparently, then see only the resulting name selected. At present I have set the ID field to transparent including all borders, etc and formatted it with a drop down list based on the ID number and Name with only Name to show in the drop down list. Then I layered the field over the related Name field (using …
-
- 9 replies
- 2.1k views
-
-
Folks We have a 75 user site license and are in the process of upgrading those folks to 10 advanced from 9 advanced. The users and I have noticed that list views and portals scroll about 4 times slower in 10 than they do in 9. We have conducted side by side tests. Is this suppose to be this way? The folks aren't happy and I am confused (I am the only one with a Mac and haven't noticed any change between 9 and 10 on that platform) XP Pro sp3
-
- 1 reply
- 1.2k views
-
-
-
I am creating a report that contains both text and lists to be embedded within the text. I would like the output to look similar to this: ------------------------------------------ The following is able to work this weekend: John Mary Sam Joey - maybe ------------------------------------------ In my database I have the following radio boxes- Bobby yes no maybe john yes no maybe jim yes no maybe Mary yes no maybe Sam yes no maybe Joey yes no maybe Lisa yes no maybe I would like if the radio box = yes for it to show the field name (i.e Bobby, John...) = no not to show …
-
- 4 replies
- 1.2k views
-
-
I have created a simple data base for my wife, and for reporting I have imported a word file that I need to circle 1 of 4 in a list. Since the text is there, I would like to format an oval to be black or white if conditions are met. I know that you can do this with a field, but can it be done with an object?
-
- 2 replies
- 1.5k views
-
-
This is my first time using a container field. I have a layout where our technicians enter the results of a certain test, most of the time they enter text but every once in a while they need to show a picture of the result by the text they entered. Is there a way for me to have text and pictures in the same field? Thank you ahead of time for your help.
-
- 1 reply
- 1.3k views
-
-
I'm putting together a Invoice layout. The layout is based on Line Items table. I've got a Description of the line item and the number of Hours spent on it both on a Body part, shown in List view. Below the two fields is a line object. The Description sometimes is too long to fit on one line. I'd like to have the Description text wrap when necessary, but the Hours field (which is always a single line) to always snap to the bottom of the part. I can't figure out how to set up the sliding. Any ideas?
-
- 1 reply
- 1.2k views
-
-
Hello, I'm wondering if there is a way in FMP10 to accomplish that a dialog box button display the entire word "Dispensation" instead of "ispensatio"?
-
- 1 reply
- 1.2k views
-
-
Hi, I have a invoice database set up in which I'd like to control whether or not certain objects print through a script. The reason for this is that I either print an invoice onto headed notepaper or export it to pdf. If I'm exporting it to pdf I like it to have the company logo/details included in the pdf but when I print it I want these omitted (as they're already on the notepaper). At the moment I have added the logo/details in a layout and then manually set them to print or not print depending on whether I'm exporting to pdf or printing. What I'd like to be able to achieve is a button which runs a script setting the state of the logo/details to pri…
-
- 5 replies
- 1.4k views
-
-
I'm trying to display a simple jpeg in a web viewer on IWP. Everything is fine in FMP, however in IWP the web viewer renders with a 2 pixel border on top and left, even though I have set the borders OFF. I can overlay an invisible box with 2 pixel border to overcome buy this is a real cludge. Also, if the web viewer is set to have a fill colour, and my jpeg is smaller than the web viewer the FMP renders wrongly, bit IWP renders correctly. And another thing, the image is displayed a few pixels right and a few pixels lower. Any ideas?
-
- 0 replies
- 1.5k views
-
-
Hi How can avoid screen refresh in FM Client, when IWP users make changes at the same time ? My solutions calendar page has a lot of portals. Every time an IWP user changes something in his view, the Client screen refreshes also. Is there a way to avoid that ?
-
- 1 reply
- 1.1k views
-
-
Is there a an upper limit to the number of fields you can have in table view? When I create a new field it doesn't appear in browse mode straight away. I seem to have to drag and drop it in layout mode to a few different locations before it will appear as the extreme right hand field in browse mode. I'm hoping the number of fields I can create in this way is infinite. Any thoughts most welcome.
-
- 2 replies
- 1.1k views
-
-
Hi All. I am working in a Windows environment and I have layout where clicking on a certain field opens a new smaller window for additional input. If the user clicks outside the new window it hides behind the original window. Is there a way to keep the new window on top until it is closed?
-
- 4 replies
- 4k views
-
-
I've been asking myself this question for a while. It's about the visibility of the ID. I have a value list calling my contacts from a different table. The first field is the ID and the second is a related field calling the cFullName. Everything is basic and works fine. My question is: Is it standard to call a contact only from the ID ? Is it normal in a database to SEE that ID all over the place? I just think it's ugly , it has no other use (even if a very important one) than to relate the tables. But try to explain it to user. I'd rather have just a field showing the name of the contact and somehow hide the ID without confusing the user. Any meaningful thought …
-
- 8 replies
- 2.2k views
-
-
Greetings everyone, I am trying to push my boss into using filemaker as a solution for our ill's (It's a small startup). I've tried seraching the layout forum without luck. My question is, when displaying a columnar report of say, 100 records via IWP, the list is limited to displaying 25 items max for a page. I have to use the navigation panel to see the rest of the list. So,.. 1. Is this a hard limitation of 25 per page or can I change it to a list of say, 50+ entries? 2. If I cannot list all results on a single page in a columnar, is there a NEXT PAGE/LAST PAGE command I can script instead of using the navigation panel to the right of th…
-
- 2 replies
- 1.9k views
-
-
Greetings. Is there way to group portal rows? ie instead of showing a value for each item, show the sum of each category's value? Does anybody know how to do that? Greg
-
- 2 replies
- 3.9k views
-
-
I am trying to do a report. I want to show all the information I got on somebody. But I don't want the fields that I don't have to appear, or to occupy space. It is something like the following. __________________ student 1 adress 1 adress 2 adress 3 __________________ student 2 adress 1 __________________ student 3 Mail phone __________________ Thanks a million
-
- 3 replies
- 1.2k views
-
-
How can I tell FMP to Load a Local .html file into the webviewer? I could have sworn I saw a tutorial on this somewhere on the web or in a book, but I can't seem to figure this out. Thanks Ben
-
- 5 replies
- 3.6k views
-
-
Is there a way to select a subset of the field names in layout view and have them alphabetized automatically? Or must that be done manually? Thanks.
-
- 7 replies
- 1.6k views
-
-
Hi, I'm still learning sub-summaries and just created one. It seems that sometimes, when I navigate to the layout with the subsummary, it will show the sub-summary in browse mode and other times it won't...can somebody explain to me how I get it to show the sub-summaries in browse mode. Of course, it always shows up in layout mode. thanks.
-
- 1 reply
- 1.4k views
-
-
I have read about ways to achieve a crosstab presentation for calculated fields. But, what about if the body is text? eg, I have a table of the following fields: week ending date city actorname role I want the end result to have the week ending dates going down the left, the roles going across the top, with the actor names in the body. I can achieve this via Excel by using vlookup function on my source data, but I would like to generate it from Filemaker. The only 'solution' I can think of is to restructure my database, so that the fields are: week ending date city actorname role1 role2 role3 role4 role5 Suggestions? …
-
-
- 36 replies
- 7.6k views
-
-
Quick question. I copied a background from an old DB and moved it to a new DB but now it stretches with the screen as in auto resizes? I'm curious what did I do to trigger this and how do I get it fixed.
-
- 2 replies
- 1.4k views
-
-
I'm inserting a picture onto a layout, storing the reference only. How/where is this reference stored (relative, absolute)? How do I view what the stored reference is?
-
- 1 reply
- 1.2k views
-
-
I am looking the count the content of value list fields. There are 8 value list fields on the table that I would like to know the content count for. The value list field contains one of 10 choices and there are 8 fields that a user can populate. What I would like to find and list is the value and how many times it comes up in those 8 fields. So I am looking for it to show on a report like this. ValueOne = 30 ValueTwo = 20 ValueThree =2 5 etc. Thanks in advance for any help. I am developing this in FM 10 Adv and my users are on FM 10.
-
- 3 replies
- 1.2k views
-
-
I've perused the forums for an answer to this question and there are some great ideas and suggestions but I was wondering if there is a way to lock a specific Tab at the User Privileges level? I have a layout with 5 Tabs but I want to lock users out of viewing the contents of one specific one. Can this be done when setting up account privileges or perhaps this is more complex? The info on the Tab is a portal showing data we would like only certain associates the ability to view. Thanks in advance!!
-
- 1 reply
- 1.9k views
-
-
Not sure if thats the proper way to describe what I;ve been pulling my hair out trying to do, but I'll do my best to explain. I have been trying to figure out a way to autogenerate a report with merge fields pulling data from the filemaker database. I understand how to make that work, except for one part. There are actually 3 sections that get pulled into a single document to make the finished report. The first 2 where fairly straight foreward as the data is static once entered into the database. My issue lies with having setup an interface to make entering the repetative parts of writing the report a little easier. In this section, the student would hav…
-
- 13 replies
- 2.5k views
-
-
The Setup: Field Called "Prepared_For" Value list from table "Prepared_For" I know how to make a simple pull down list and I know how to make a script that adds a new entry to the table called "Prepared_For". What I want to do is combine this into one -- Let me explain. When you click on the field "Prepared_For" it brings up the list that you can choose from -- this works. Now if the name does not appear on this list then I would like to just be able to type the new name into the field "Prepared_For" and have it added to the table "Prepared_For" as a new entry. Can this be done with a script on the cell and what would it look like? Thank …
-
- 4 replies
- 1.3k views
-
-
Hi All, I need to create resumes for several designers from a database with 4 tables (imported from a MySQL database, used to do the same thing, but online). The data for our resumes is contained in multiple tables: designer_data designer_education credits_shows credits_other Each table has drastically different data, but links each contains a unique field, "designer_id" which corresponds to their "designer_data." What I need to do is create a layout that has the following parts: 1. Displays fields from "designer_data" where "designer_id" = <> 2. Displays fields from "designer_education" where "designer_id" = <> 3. Displays fi…
-
- 8 replies
- 2k views
-
-
Sometime... i am coming from developing or working with FM9.. open close etc.. do different functions in my app.. And then I will get this error window usually starting FM9-advance version ...saying 'Other users are running a FM session.. " I can hammer error dialog.. bring up my application and continue on... everything works... until i get into another privilege situation, opening another file, or other places in my app.. Like something is not closed? It only happens sometimes? If i exit back to desktop.. starting FM again, my app says same thing... ONLY if I reboot will it fix it.. Think it because maybe I didn't close something correct…
-
- 0 replies
- 1k views
-
-
I use a certain font type and size as standard throughout my solution. Users have permission to cut and past text from other fields and other sources (eg: web sites, Word documents...) into my solution's fields. I want all the text to look the same. Is there a way to force the field to retain the font characteristics I want despite the formating of the text being pasted in? I tried, via FM preferences, font locking, etc... but without success. The only other way I see as a solution is have have an "Enter" button that is scripted to format the text. As this would entail a lot of extra scripting (for all the fields involved) I would prefer not to do this but if …
-
- 2 replies
- 2.2k views
-
-
Hi. I'm new to FMForums so please forgive me if this post doesn't end up in the right place and advise me how to proceed. Thanks. I want to duplicate (or copy/paste) an object existing in one layout to many other (similar) layouts but I want that duplicated object to be in exactly the same position on each layout, not 6 pixels down and right as when you duplicate (or copy/paste) an object within the same layout. There must be an easy way but I can't for the life of me work it out. Any advice very welcome. Mart
-
- 6 replies
- 1.5k views
-
-
My FMP file is connected to on online store shopping cart that I have, which is a MySQL DB. One of the MySQL tables is the category names, and I'm trying to use the name field there for a value list in Filemaker. But of coarse I can't pick that table. There are two category tables on the MySQL side - the categories, and the category names (the first is the main table, the names are separate to allow for other languages - long story, don't ask) anyway, I have join table in FMP for these two, and a calculation field that equals the category name (plus dashes if it's not a top level category.) And that calculation field is what I would like to use for the value list…
-
- 2 replies
- 1.2k views
-
-
I'm a bit confused about how best to implement repetitive values. My scenario is I have a "Person" table and each "Person" has a "Role". There will be a limited number of roles. In a "Person_View" layout I want to implement a filed which allows me to choose a "Role". Question is: should the "Roles" be a linked table or just a value list. I would want the interface to show the actual role, NOT just a role id, and I want the user to be able to add a new role. Currently I have this implemented as linked tables but I'm not getting how I have the popup display the role name after selection rather than the role id. Plus, I don't see how I add a new entry to …
-
- 3 replies
- 3k views
-
-
I have a layout with a webviewer and I want users to be able to highlight text within the webviewer which is copied to the clipboard by a script. The first line of the script is "Copy[]" This works fine if the script is run from the scripts menu. I would ideally like the script to be triggered from pressing a button, however when the button is pressed, the webviewer is no longer selected and the highlighted text is lost. I'm not sure if the button method is possible but thought it would be worth an ask! ANy help hugely welcome.....
-
- 5 replies
- 2.7k views
-
-
Hi all, I use Filemaker for quite a while but I am new to this forum. I am stuck with a problem and i don't know if it is solvable, but I think Filemaker should be able to deal with this. I want to create a (graphical) table in which the items are all costs. Each row stands for a person and each column for a specification. I want to pick the data from a (filemaker)table that holds the following fields: eventdescription person cost description (of cost) At each event one person will have more sorts of costs and I want to see all these costs on one line with the person. When using a portal I get all the records for one person with the different s…
-
- 6 replies
- 1.6k views
-
-
I created a report for a database that contains 31 records. When I view the report in preview layout, it shows results for only 16 of the records. If I go to the browse layout, I can scroll through the report one record at a time but all 31 records are there. Is there something I can do to make all of the records appear in the report while in the preview layout?
-
- 3 replies
- 1.3k views
-
-
I want to create a drop down list of organization names obtained from a field in a table hosted on an Oracle server. Making the ODBC link to the Oracle server is no problem and I can then see the entire table and all its fields in FMP. Using the x relational operator I can then create a portal showing all the organization names in FMP. However, when I try to "Use values from Field:" when creating the value list, the "Specify field" button grays out the ODBC-linked Organization table so I can't select the field I need. Is there a way to make a live duplicate of the ODBC-linked table in FMP so the necessary field will be selectable for a value list? Alternatively, …
-
- 4 replies
- 1.8k views
-
-
Hi - my apologies if this is long winded. I'm creating an employee management system to keep track of conversations and issues that arise. I'm using a portal which has a drop down menu allowing the manager to choose what if any action was taken regarding an issue: ie, verbal, written warnings, final notice, suspension termination etc. I've got a line of text (outside the portal) at the top of the page which will allow the view to quickly identify if the employee's issue record was flanged with the above action. This text pulls it's information from the 'Action' field in the table. The conditional formatting works great when the specified value is met d…
-
- 5 replies
- 1.8k views
-
-
I have a rather newbish question about value list relationships, specifically when using "only related values starting from...". If I have the value list on a layout that uses the same table as the value list's relationship is starting from, it works fine. But if I put the value list on a different layout/table, the value list shows no values. So I end up having to create many redundant value lists for each non-related tables and layout. I must be doing something wrong. My example is this: I want a value list of only those Contacts who are marked as "Vendor". TABLE: Contact1 NOTABLE FIELDS: * isVendor - a boolean field that has the value "1" for any …
-
- 3 replies
- 5k views
-
-
hi everyone. it is possible to retrieve data from webviewer? i would like to do next: 1. user type in id field number 6 2. we use user number and go to site whatever?id=6 3. we show result in webviewer .. this can be name "john" 4. we use name "john" in another script or can i retrieve data in some other way over the internet? without odbc. tnx in advance!
-
- 8 replies
- 2k views
-
-
I have a 'Membership Form' layout showing customer details which I print blank for new customers to fill out. Problem is, I also merge some organization data onto the layout from global fields in a settings table e.g. branch, area etc. That works fine for the merge fields in the header, but those in the body print blank (of course) when I 'Print Blank'. Is there a way around this or can I not have my cake and eat it too?
-
- 0 replies
- 1.2k views
-
-
I have a MySQL online store for antique radio parts, and an FMP file that interfaces wtih it. I have one layout in FMP where I want a drop down menu showing all the product categories. But here's the problem. In the MySQL DB each category has it's category ID, a parent category ID, and a sort order. What happens is, any top level category (Parts, Tools, Supplies) has a parent ID of 0. If you have a sub category (under Parts you would have Capacitors, Resistors, etc), then it's parent ID would be the categroy above it. So the parent ID for Capacitors would be the category ID for parts. I also have a 3rd level of categories, so Capacitors might have 2 sub categories i…
-
- 0 replies
- 1.2k views
-
-
I am trying to setup my own version of a barcode scanner to be used in conjuntion with FM. I have it working but when I scan the barcode i get the characters to show up however it doesnt tab once entered like excel. 1. How can i get it to auto tab once a specific number of characters are entered. I am using 3of9 barcodes and will need alpha numeric setup. 2. Can I set to to know that if the first three(3) characters are alpha and the rest numeric then it enters and if its doesn't have alpha characters for first Three(3) then its null and doesn't do anything.
-
- 4 replies
- 1.9k views
-
-
Hello, I remember seeing someone mention this in passing, but I can't seem to find where that was (it might have been on a different site). So, my question is, when you're in list mode, is there a way to hide the little indicator of the current record? I'm using conditional formatting to show the active record and a global field to determine which record to work with, so I feel that the little black bar on the left is distracting and somewhat unprofessional Of course, I could just be displaying my data in a less than ideal way. I've thought about using a portal, but I don't think it would work very well, as I'm showing the results of a find.
-
- 2 replies
- 1.5k views
-
-
Hello, I've created a tab field in the records and every time I push "new record", the cursor jumps to the last tab written (they are 3 tabs)...how can I change it so that when I press "new record" the cursor goes to the first tab?
-
- 10 replies
- 1.5k views
-
-
Hi All. I have a script that returns to the portal row it originated from but the selected row is showing as the last visible row in the portal. Is there some way to make the selected row appear as the first visible row in the portal? Thanks for any help.
-
- 3 replies
- 1.3k views
-
-
By giving my web viewer an object name, I have sucessfully pulled the HTML from it for the first HTML page that loads. My web viewer is loading based on a field -- where the URL is typed in. I use the following functions: to get HTML: GetLayoutObjectAttribute ( "dataviewer" ; "content" ) to get the URL of the current page: GetLayoutObjectAttribute ( "dataviewer" ; "source" ) Here's the wierd part though. if I load my first page A.html and then run the two functions above, it works perfectly. I can extract the HTML and the URL and store it in a field. however, if I navigate …
-
- 3 replies
- 1.6k views
-
-
Hi, Is it possible to create a calculation field or number field that will display the number of entries in a value list? Thanks in advance.
-
- 16 replies
- 3.2k views
-
-
Hello all, I'm having trouble with record creation via portals and was hoping someone may be able to lend some pointers. There are Contacts, Companies, and then many things that each can have and share such as Phone Numbers, Addresses, Fax Numbers, etc. Contacts should also be able to relate to Companies as well. I've created a large join table called Lookup that can hold all the foreign keys of each related primary key in the other tables. I want new records in Lookup created to tie them together, which works 'half way'. If I add a Phone Number from the Contact layout in the Phone number portal, a new record should be created in Lookup with the two ID's. When…
-
- 3 replies
- 1.4k views
-
-
I am using a letter in FM and use <> <> in a form letter that allows it to dynamically alter the size and spacing. I then used a portal to bring data from another database and when using the same form letter the first and last are not seen on this letter. The fields are <::first> and <::Last>. Is there a way to include this information in the form letter in the database that the information is being portaled into. Thanks in advance for any assistance.
-
- 4 replies
- 1.1k views
-
-
I have a several identical buttons (Jobs, Vehicles, Tasks, etc.) that I'm using for navigation among layouts. All of this works OK, but here's what I'm wondering: If I give each button an object name that corresponds to a layout name, can I use conditional formatting to give that button a different formatting when that particular layout is active? In other words, if I assign the Jobs button the name JobsDetail, can I change the formatting of the Jobs button when the JobsDetail active is active? I generally know how to use conditional formatting but don't know how to set up this particular formula. Thanks for any help. James www.james-mc.com
-
- 4 replies
- 1.9k views
-
-
Hello all, I posted on another thread with no luck so I thought I would start a topic to see if I could get the answer I was looking for. I am trying to sort a portal with header buttons that sort ascending when clicked and descending when shift clicked. I have the ascending part working with a global field and a calculation field. I have set up a global that sets to 1 or 0 depending on click or shift click. Now I am stuck. The instructions I am working with are lacking in detail at this point and I can't figure out how to tie it all together. Does anyone have a link to some detailed instructions on this method? I would like to mention up front that I…
-
- 3 replies
- 1.2k views
-
-
Not sure if this post should be here or under the Relationships forum, but here goes: I have a system that records the payments I make to vendors based on their work on projects. When I create a new payment, it has line items for multiple project line items that a vendor might have worked on. Here are some key tables and relationship fields (note: foreign keys begin with "F_"): Payment (F_vendorID) PaymentLine (F_projectID) Project (isActive.boolean) ProjectLine (F_vendorID) Vendor Here are some key ERD points: Payment has one Vendor Payment has many PaymentLine PaymentLine has one ProjectLine Project has many ProjectLine ProjectLine has…
-
- 3 replies
- 1.4k views
-
-
Anyone else seeing changes in container graphics resolution in FM 10? Please note these illustrations. These are container fields with a reference link to a PDF file. So you are looking at the file icon in the container field that indicates the linked document. Not the end of the world, but looks bad. System: Win XP
-
- 0 replies
- 1.1k views
-
-
I have printed labels numerous times for databases before but how do I print 1 labels numerous times on a 2 column 20 label layout sheet?
-
- 2 replies
- 1.1k views
-
-
Hi Folks, We have a database of vendors who work all around the world. My users wish to see what time it is in the vendor's location without having to do the math in their heads. I have a value list of time zones that are already in use (prior developer), but doesn't have the +1, +5, +/-GMT in the list. Also, the concern with doing a calc of Get (CurrentTime) + TimeZone is that it won't take into account daylight savings. Are there any plugins or pre-made value lists that could help remedy this? Thanks!
-
- 0 replies
- 1.4k views
-
-
I have a text box that I want to go to and set a variable's value to the value of the text in an edit box. When I step through the code the variable does not retrieve the value and has a '?' when viewed with the data viewer. Also when the goto object code is executed, the value of the text is framed with a dark rectangular box. I created a new text box with all the characteristic of the first text box (that I could think of) and this text box will let me set the variable value to the value of the text box. Also when the goto object code is executed, the text box acts like it will let you change the value (no dark rectangular box. I have searched high and low to …
-
- 7 replies
- 1.6k views
-
-
I have a database in FMP9A which stores records for individuals and a related table which stores incidents. In the table for individuals, I have a GUID field which holds 20 repetitions to store the unique identifiers assigned to each individual. A portal is used to create related records in the incident table. Incidents are logged by GUID. Since one individual can be associated with multiple GUIDs, I currently have a value list created from the GUID field, but this list contains all the GUIDs for each individual in the database and gets cumbersome to navigate. I don't need to see all the other GUIDs that aren't associated with the individual when logging an incident…
-
- 2 replies
- 1.7k views
-
-
Hello all... I have a layout with a portal that shows all sales data for a system I have. The portal only shows about 15 records and there can be many more records. I would like to setup a second portal that only shows the last record created with the portal row highlighted. So Portal A shows all records and Portal B right below it will show only the last record created and highlight the portal row. Any ideas on how best to set this up.
-
- 3 replies
- 1.6k views
-
-
i have a four tab panel set up placed the web view on tab 3 looks fine in edit layout but when i go to form view the web view is on all 4 tabs how do i correct this please thanks [color:purple] thanks for the help but got it on my own hahaha
-
- 3 replies
- 2k views
-
-
Hello, I'm pretty new at filemaker and could use some help. I'm keeping track of "submissions" in my main table. In each of those "submissions" there are "fundings" that I manage in a portal on the main "submissions" page. Each of these "fundings" also has forein keys from "Authorities" and "Area". So: Subs -> Fundings One to many Auth -> Fundings One to many Area -> Fundings : One to many Everything works fine up to this point, the trouble comes when I try to add in a new element to the mix, "positions". Each "funding" can have 1 or 0 "positions", which I"ve done as: Fundings -> Positions : one-to-one (the fact that I have a o…
-
- 4 replies
- 1.2k views
-
-
I know this is a simple one, but I'm not quite getting it -- instead of labelling a field using text above the field box, I'd like to have the field name *in* the box, and have it disappear if there is a value entered in the field (in which case the purpose of the field won't need labelling). In the olden days we did this with a calculation field, but I know there's a simpler way now with conditional formatting. So, have typed the label the same color as the background, and set the formatting to use a darker color if the Field IsEmpty" -- but of course, now the label becomes visible as clutter because the value entered in the field is black and the backgound color…
-
- 1 reply
- 1.5k views
-
-
Is there a way in FM10 (or 9), windows platform to move between tab panels with a keystroke. Thanks!
-
- 2 replies
- 2.1k views
-
-
Folks: am running a button/script off a portal row to bring up a mini-window to allow more editing room in one of the fields. But I keep getting this prompt: "This record cannot be modified in this window because it is already being modified in a different window" Any insight into how to resolve?
-
- 2 replies
- 1.1k views
-
-
Hello. It is nice that the question I asked a while ago about youtube working in the web browser is still getting answers. I want to ask something similar. I am interested in finding a way to display an [color:brown]Exact [color:black]rectangle within a web page in a web browser. Most web sites have a header that is always in the same location and or named the same object within a web page. I would like to find a way to display an exact location or rectangle within the web browser. I am loading an exact example. the file "page is the whole page " and I would like the webviewer to locate and frame the graphic part of that page called by the file "Specific" . Maybe I am as…
-
- 10 replies
- 2.4k views
-
-
Hi everyone, I'm working on the Client Database at a homeless shelter, and we need a lot of assistance. We've got two important fields, Admission Date and Departure Date. They are displayed in two portals each. At the top of the form they are side by side and are used for simple entry. At the bottom of the form they are in larger font and are for display in a table, showing a history and being used for calculations. The operations staff at our organisation decided that it would be best for them if both sets of dates were listed descending, with the most recent dates at the top of the list. So there are two problems: 1. The new portal rows still sh…
-
- 1 reply
- 1.3k views
-
-
I'm preparing a custom report, with columns and groups. How do I tell a field that, if the contents of the field doesn't fit in the designated width, that the field should grow in height (ie, take up additional rows). Thank you Marion
-
- 2 replies
- 1.3k views
-
-
Howdy all, I created a value list from my table of Product Types. One of the Types was used in the past but now we use different classifications to describe products of that nature. I need to leave the record of the old type in the table because I don't want to change history. However, when my user is entering data I don't want to give them the option of the old type. Basically, I have a table of 12 records and I want the value list to show only 11 of them. I'm thinking some sort of Relational Value list but I'm not sure how to pull that off since the criteria for exclusion does not exist in another table. Anyone have an idea?
-
- 1 reply
- 1.5k views
-
-
I have a number of layouts that you reach via buttons that run scripts to choose records, sort, etc. and then goes to layout. On the layout in browse mode I give the user two buttons (unprintable), one to Print and the other to go back to the menu where they came. I have a report that uses 2 subsummaries and one body line. In browse the report is meaningless. It has to be seen in Preview mode. However, I don't know how to give the user the ability via 2 buttons to either print the report or return to the menu. Is there any way to do this in a preview?
-
- 3 replies
- 1.1k views
-
-
I am trying to use the webviewer to view stored documents (pdfs and jpgs) by using the filepath and filename stored in a field ( appropriately modified to give me a "//drive/folder/filename" format. The pdfs and jpgs are stored in a folder in the same folder that the FM7 files is stored and I use Get (FilePath) and Get (Filename) to get me the path to the documents. It works fine for documents held on my hard drive but when I try to refer to the path for documents held on my iDisk (OSX 10.5) the webviewer reports that the document is not found. Has anyone experienced the same or found a solution? Regards Jim
-
- 0 replies
- 1.3k views
-
-
Hello, I created a subsummary report that lists all of my company’s documents broken out by type. Using list view, the report looks something like this in Browse mode: Document Type 1: Happy Sad Angry Document Type 2: Red Orange Green But when I navigate to this report (with a script that sorts by Document type) my Web Brower shows me this: Happy Sad Angry Red Orange Green Does anyone have any ideas how to view my (static) report using IWP?
-
- 0 replies
- 1.1k views
-
-
Hi In the Filemaker 10 Advanced, is there a way to apply one of the new templates to existing layouts? John
-
- 1 reply
- 1k views
-
-
Hi ! I'm wrestling with my database and now I'm stuck with this problem: There are invoices in one table. They have Status: "not ready", "waiting for approval" and "approved". The accounting can choose which invoices are shown in the portal. The problem is how to present the Total of each sub group, when portal data is changed. Now it shows only "Grand total" of all sub groups (i.e. even though the invoice is not "approved" yet, it's sum is added to "total") I hope you understood... ???
-
- 3 replies
- 1.3k views
-
-
I have 5 different "fact" fields that I am outputting in a merge field. The challenge I have is when one of the fact fields is blank, I get a orphaned bullet point with no content. Is there a way to build conditionality into the merge field so that bullets are omitted if the following field is blank?
-
- 3 replies
- 2.8k views
-
-
(not sure if this belongs here or in Reports). Is there a way to save the page setup savings with a layout? ie, I created 2 layouts. I want one to be portrait letter, and the other is legal landscape. Do I need to create a script for this, or remember to change the setting or what? Thanks Marion
-
- 1 reply
- 1.1k views
-
-
Hello I am trying to create a table in Filemaker. To wrap my head around the structure, I set it up in Excel. But I'm not experienced enough with Filemaker to understand how to create the layout, or if it's possible. I know it's the Columnar Report Layout, but I'm all tangled with the sub-totals and what not.... I've attached my Excel file, the cvs data as well as the Filemaker table... Can you look at it and sort me out? Please excuse me if this is too much to ask for. I have a feeling though, that it will be ridiculously simple for any of you pros, and, once I see what you've done, it will all make more sense to me. Thank you- Marion…
-
- 6 replies
- 1.9k views
-
-
I have a user account, call it Designer, that has the privilege to modify all layouts. however, when she is in the Layout mode, Duplicate Layout is grayed out. I have looked everywhere and can't figure where to change this setting. Thanks
-
- 2 replies
- 1.4k views
-
-
Has anyone else had the experience of fields and items you put into a tab showing fine in layout mode, but when you go to browse mode, the items are on all tabs or scattered and mushed about the tab space? I've spent like 20 minutes trying to fix it but no matter where I place it in the tab, it show on every layout. Thanks
-
- 8 replies
- 3.2k views
-
-
Hi, I'm not sure whether this is the right forum for this so apologies if not. I have been designing a database for a while now and it's fairly complex but since I am self taught, I am sure that I am using bad techniques. I have one table which lists all my financial transactions. Fields include: Financial Year, Account ID, description, amount. To work out how much i have left in each acount I do the following. Run a script to identify how many accounts are presently used For each account (loop) load a layout showing transactions against that account so that I can get the total amount. Add total amount to a running total End loop S…
-
- 1 reply
- 1.1k views
-
-
This is probably dead easy but I can't get my head round the best way to do it! I have a table called calender (A list of dates and activities) which I want to display as a portal on the frontpage of my application. That bit is easy. However, I want to only display future tasks. If I wasn't using a portal I would probably just perorm a find on the calender layout and just display future dates. Am I able to perform a find on a portal so that it only displays future tasks? The way I would probably do this normally is to write a script which did the following: show all records sort by date goto record nearest current date set orderfield as 1 go …
-
- 2 replies
- 1.2k views
-
-
Hey everyone, I am pretty new to database design, so I used illustrator to mock up what I wanted the layout to look like. Is there anyway to get some of the vector elements from illustrator to the layout of FM Pro 8.5 or 10? Thanks for any help.
-
- 2 replies
- 2.2k views
-
-
HI If I create a portal and place field in it they show up and work perfectly. If I decide that I want a colour fill (say white)in the portal then the fields will not show or come to the front of the portal. Any of the templates do this and it works and I cannot work out what I am doing wrong. Can anybody help? Glenda
-
- 6 replies
- 1.5k views
-
-
I am working on a POS solution. I have a table for products, brands and of course sales, amongst other tables. The product table is a list of generic items for retail (shoes, shirts, jewelry, etc.). When setting up a brand, I have a checkbox field that lists all of the products based on a value list of all products, so the store owner can select which products they carry for each brand. During the making of a sale and after entering a brand, only the checked items for that brand show up in a product drop-down list via a brand-product relationship I set up for this purpose. So far so good. Here is the problem. If a brand is set to say have "shoes" selected, and t…
-
- 9 replies
- 1.8k views
-
-
Is it possible to have my custom menu set be available while I am in layout mode? I have a few scripts that I have under a custom menu, it would be nice to view that custom menu under layout mode. I guess I can always check "include in menu" in Scriptmaker, but I would prefer not to show those script to ordinary users while in browse mode. Any suggestions?
-
- 1 reply
- 1.6k views
-
-
Hi, I hope this question makes sense! For each record of a certain table I have 2 value lists. ValueList2 is populated based on what I've selected in ValueList1. Normally I've been creating a new record manually, selecting a value in ValueList1 and then selecting the 1st value in ValueList2, then duplicating the record and selecting the 2nd value in ValueList2 etc etc If ValueList2 eg has 10 values, is it possible for me to create a new record manually, like I've been doing but then duplicate the remaining 9 records using a script? (So that when I look at the 10 records, ValueList1 has been given the same value, but ValueList2 has 10 different ones?)
-
- 12 replies
- 1.9k views
-
-
I'm a new FM user. I have two tables: TblContacts ( ContactID, Contact, DOB, City) and TblRegister (RegisterID,Contact, Date,Obs), my problem is when I add a contact to the TblRegister using a drop-down-list to the Contact and its not registered yet how to jump to the Contacts layout and add all the informatiom about the specific Contact that hasn't been registered? ,like the event in the MSAccess ˜'fNotInList'.
-
- 12 replies
- 2.1k views
-
-
Hi, Q1: How would you code a FMP9 drill down UI for layouts that presents a state with the county boundary lines as level one, and county townships and cities as layout level two? The user would drill down from state layout to county layout to a township layout displaying the details. The user would click on the county; click on the township, and view the township detail. Q2: Can FMP 9 present hierarchal lists to users on layouts for selecting items, and presenting related drill down information?
-
- 2 replies
- 1.7k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online