FileMaker Interface Features
-
I am trying to build a building space tracking system. My eventual goal is to have a view that shows all the active leases for 2 buildings per month. The attached file will open to a layout that has 2 portals.. one which shows the leases related to the "date" field. and the 2nd portal is meant to show the leases related to the "date_plus_one_month" field. The 2nd portal is not working.. could someone tell me why ? Also... in general, if anyone can comment on the way i'm approaching this problem, I'd love to hear any feedback anyone has for me. I'd eventually like to show not only the booked leases per date, but also a numerical count of the offi…
-
- 11 replies
- 1.2k views
-
-
I've got a conditional value list that is currently working. It is set up through a relationship to show only the products that are part of a specific category. Basic schema is this: product_id description category However we are now getting to the point where there are many old products that no longer are valid. I don't want them to be deleted from the database, as they may be needed for reporting purposes so I have added a field to the product database to mark them as inactive. The revised schema is like this: product_id description category inactive My question is this, is there a way of creating a value list that only pulls items tha…
-
- 4 replies
- 862 views
-
-
I am currently trying to adapt the Registrations template that comes built into Filemaker 7. I would like to add a payment piece to it to track multiple payments specific to the contact and to the event. So I would like the payments to show up in the registrations portal and the events portal. To print payment reports for each individual contact and each event. I understand linking and portals and relationships but am having a hard time figuring out the relationship already built into this template. Could anyone guide me through the best way to set this up? I appreciate your time and help very much!!! -Melody
-
- 0 replies
- 708 views
-
-
How would one go about alterring the appearance of the default vertical scroll bars included in Filemaker Pro 7. In my opinion the defaults look a little grainy and are unnecessarily different from the scroll bars used in almost all standard applications that basic users are now familiar with. Thank you for any help on this matter. ~Chris P.S. I just realized that this post wasn't really specific enough. The scroll bar I am referring to is the one that appears for individual text fields in a layout that are too large to be displayed within their given space, not the scrollbar for scrolling down a layout that does not appear on the screen all at once.
-
- 1 reply
- 897 views
-
-
I'm in the midst of upgrading/converting a FileMaker database that has lived through ver 2.1 all the way to 4.1... and now I'm taking it to ver 8. It has a lot of layouts and it's certain there are a number of them that are no longer used. Is there any method or tool I could use that would help me find what layouts are not referred to by any buttons, scripts, or triggers? Thanks
-
- 1 reply
- 679 views
-
-
Hi, I just discovered that I can display field data by simply using the text tool and typing: <> onto the layout and it will display the data for that record, it even works in IWP. What is this function called? I attached a sample file for anyone interested. It looks like it could be a great way to securly display data on the internet. thanks! barckettest.zip
-
- 4 replies
- 1.2k views
-
-
I have a call center database. There are 2 tables: CALLS & PRODUCTS. Each call that comes into the center gets a new call record. Each CALL record is related to a PRODUCT record. Each PRODUCT can be related to many CALLS but each CALL can only be related to one PRODUCT. I have been asked to produce a report that shows the top [variable] PRODUCTS that have had the most calls occuring from [variable] thru [variable]. (the user will enter the variables when prompted) For example; the user would want to see the 5 products that had the greatest number of calls between January 1st and March 31st this year. I'm having trouble with the "Top N" portion …
-
- 2 replies
- 826 views
-
-
Does anyone know if there's a way to change the column titles for the table layout view? I'm trying FM for the first time, and I've done simple websites with PHP/MySQL. I tried adding labels, and I've poked around for an hour now. Thanks in advance!
-
- 4 replies
- 1.3k views
-
-
I wonder how can i do some text or number layout, like this... I got a telephone number, and i have it in this way at the DB 4086943652 but when i want it to display it at the layout i wanna it to show like this: (408) 964-3452 thx u for ur help.
-
- 3 replies
- 864 views
-
-
Is there a simple way to have one field automatically updated whenever another field has data added to it? I have two fields, a text field and a number field side by side. The second one is often blank, but whenever it has data added it means that the first field needs to be changed too: Field one has a text value list such as "Cancelled", "Waiting", "Possible", and "Submission Number". Field two is a number field whose sole purpose is to describe which "Submission Number" is being referred to, so that whenever it has a "1" or "2" or "1b" in it, the first field should always be changed to "Submission Number". I've tried to make this happen automatically thr…
-
- 3 replies
- 730 views
-
-
I'm developing an employee training registration file. I have a portal listing all [color:blue]classes selected by an employee, and a portal listing all [color:red]available classes. My question: How do I remove the [color:blue]classes already selected from the [color:red]available classes portal. After all you can not register for a class that you have already registered for, so I do want them to be able to see it in the available classes portal.
-
- 2 replies
- 771 views
-
-
I've tried changing everything I can think of (and have searched Forums and read FM Help) and my little date calendar won't show in Browse like it does in all the pictures I've seen, even when adding it to new date fields (see attached). It shows in Layout Mode but disappears in Browse. Am I the only one with this problem or am I missing something? I assume it's something very simple. Or can someone give me an FM file where it works so I can see if it displays on my system or try pasting that field into my FM to find out how it is formatted? I might just be due for another break. UPDATE: Oh, Effects is engraved, pen color is black (opaque) and 1 px width.
-
- 4 replies
- 877 views
-
-
Hi, I am trying to create a conditional value list. I have a crew table(among others)and a line item table. the crew table has a crew type field. This is either labor, admin or management. In the line item table i want to have a portal for labor, admin and management and have the pop up list only show those crew types. I created three global calc fields with the word labor, admin and management and related them to the crew type (three relationships crew_lab, crew_admin and crew_mgt). The value list for labor I have tried, value from field, crew name, only related values from crew_lab. nothing pops up. I have tried starting from crew_lab and only related to crew. noth…
-
- 1 reply
- 685 views
-
-
Hi, I've just separated data in my files, from *all* info in Contacts to 'most' info in Contacts and 'some' info in Company addresses. It seemed like a good idea to have a separate company table, so that any change in a company's details is easily replicated across all associated Contacts. However ... as it happens I *only* use Portals to view my records and now I find that some of my portal/sorting/finding methods have fallen apart, because now I have some of the info required for the relationship in one table and other info in a different table. Question : Is it possible (I think it is, but I'm having trouble grasping it) to have a single Portal (Rel…
-
- 1 reply
- 694 views
-
-
My signature is correct in the layout and browse mode but in preview mode my signature is below where I placed it and prints that way. Hope this makes sense...please help! I am in over my head! Also...I am unable to get a summaries by catagory report in the donations received file...does anyone know how to do this? Thanks so much.
-
- 1 reply
- 710 views
-
-
Attached is an example of "floating text" in portals that occurs on my layouts whenever an individual field contains multiple lines. I've tried various combinations of Format > Align Text and the paragraph line spacing parameters -- and have even tried different fonts. The solution I came up with is less than optimal since it spaces the text out vertically whenever the field is selected. I would prefer it to stay in its compact form (of single-spaced lines). Any suggestions of a better solution will be appreciated. TextProblem.fp7.ZIP
-
- 5 replies
- 874 views
-
-
Anyone willing to share a little code that would make a tooltip popup change each time the cursor went over it? I'm told that a "Simple LET" and a few variables will do this but I can't crack the nut on it. I've seen this in action so I know it works. Stephen
-
- 9 replies
- 2.2k views
-
-
I have a database for acting talent with check boxes for various skills. How can I display in a report, perhaps on one line or a number of consecutive lines, (without line gaps) just the attributes they have selected.
-
- 1 reply
- 608 views
-
-
hi all. i have a portal where each row contains several fields for a given year. how would i show the year in the portal so that it is already populated when a user creates a record. For instance the portal would look like this before a user enters any data into the portal: |_1998___|_________|_________| |_1999___|_________|_________| I hope that makes sense. Basically i want to do a similar thing with date that "@@" does with portal row number. Thanks. any help is appreciated
-
- 1 reply
- 603 views
-
-
I am using 8Pro Advanced and trying to send emails that would contain data from portal records. When writing the email script all non-portal fields are going into the email body just perfectly - but, of course, getting all portal records is not. Only the first or last portal record is coming out. how do I get all portal records into that email body? (FYI: has to go into body as text since it will be read by text messagers and a PDF , for example, will not work.) Thanks. Paul
-
- 3 replies
- 661 views
-
-
I had two database and i tried to use the relationship on them. I got confused on the relationship so I deleted the relation and the tables on the relationship (define window). When I tried to see the layout, every field said: . I see the defined fields although it won't display on the fields. please see the atachment (hopefully it's is viewable)
-
- 1 reply
- 744 views
-
-
Hi, Somewhat new to FM, but have been doing relational database stuff for years. I've got one table, "people" w/PK peopleID, and related table "people new clients referred", with a FK field 'peopleID'. Allow new records is checked in the relationship definition, but when the layout is used, the portal will only allow one record. Clicking on the second row only hihglights the entire row, but won't allow me to enter data in the 2nd record! Anyone seen this behavior? There are two screenshots attached - one of the relationships view, and one of the portal showing the 2nd row highlighted. Thanks! Matt
-
- 2 replies
- 651 views
-
-
Hi everyone When I push a button within a portal is it possible by script to test if I am on the last row where the 'new' related records are entered TIA Phil
-
- 1 reply
- 624 views
-
-
Hi there, Hopefully this will be an easy one for you 'Gurus'. I have a two tables that have a related ID no. Table1 has a portal to enter data into Table2. The problem is that a new record will only be created in Table2 if I enter something into the portal. What I want is whenever a record is created in Table1, a record is also created in Table2 (with the same ID). Hope this makes some kind of sense! Regards Martin
-
- 2 replies
- 739 views
-
-
I once saw a post that explained how to create a top row portal entry solutions. I can't find it anymore. Anyone know where or have an example or explanation.
-
- 4 replies
- 1.2k views
-
-
The following issue has me stumped: I'd like to design a comments feature which has a field for entering the text of the comment on one side of the page, with a portal on the other side of the page which displays all of the comments associated with a record (with no blank row for entry). Here's how I envision it working - after the user types a comment into the "commentsEntry" field and clicks the submit button, the "commentsEntry" field is cleared and the comment is posted in the portal. The portal is not editable. I'm thinking I need two tables - one for the entry field and another for the portal (where commentsDescription in table 2 is a lookup value …
-
- 12 replies
- 2.3k views
-
-
Hi i am new to Filemaker so this question may seem easy to some I have a databse with two layouts, say A and B. When i enter a record/data in A it also appears in B how can I avoid this, so the record for A only appears in A and so on for B Thanks a lot in advance Reza
-
- 3 replies
- 933 views
-
-
I've run across an odd little kink that I can't seem to work out. I've created a db with four value lists in a pop-up menu format. Three of these are just run-of-the-mill text lists. The fourth is a dynamic list based on a referenced field from another file. The problem: I can't seem to get any of the pop-up menus to work in browse mode. I've double-checked the field definitions, value lists and field formats and can't figure out what's wrong. I've got two other db's that use value lists in the pop-up menu format, and I haven't encountered any problems with those. Any help would be greatly appreciated!
-
- 5 replies
- 772 views
-
-
For my runtime solution, I use a custom menu that consists of an absolute minimum set of functions, but that includes ALL spell check options: I included Correct Word, but it displays "grayed out" in the runtime. Likewise when a user right clicks to get spelling tools for a misspelled word, the Ignore-Learn-Spelling options are disabled. It appears I'm close, since they are in the runtime's menus; they're just not active. Does anyone know how to activate just these WITHOUT turning on a lot of other functions (that I don't want)? (I've attached a screen example, but I don't know how to cause it to display as part of my post.)
-
- 0 replies
- 1.1k views
-
-
Has anyone used the Movie Library template in FM Pro 7? I was wondering if the "notes" section of it is expandable somehow. I'd like to make it larger so I can see all of the text inside that section without scrolling.
-
- 3 replies
- 800 views
-
-
I have a customer and I have a portal showing the contacts associated with the customer. The portal works on a relationship based on customer id. The portal is scrollable as there are many contacts. The relationship is set to allow creation of new contacts in the portal. Everthing fine so far. I have a 'use' button in each portal row. The purpose of this button is to set a field in the main record with the contact name from the portal. That is not a problem as long as the contact exists. A simple Setfield(main::contact;portal::contactname) does the trick. I hit problems however if the contact is a new one. If I do not leave the…
-
- 0 replies
- 881 views
-
-
I have a login script that includes a Install Menu Set. The selected Menu Set does not include any menus. When I run it from a copy of FM Pro on Windows XP, the Install Menu Set script step does not change the menu. When I run this same script step on FMP 8 Advanced the menu set does change. The copy of FM Pro that this is occuring on was installed as an Assisted Install with the ability to create files disabled. I don't know if this matters. Thanks in advance for any ideas.
-
- 0 replies
- 1.1k views
-
-
I'm listing Expense detail table in a portal and the Check Table, as a list, in the list layout. When a check is choosen, in list table, the detail of the expenses shows in the portal. Works well unless the portal needs to be scrolled. When scrolled the detail become corrupted. FMPro 7 Developer Steve
-
- 6 replies
- 1k views
-
-
In an application that will run from Server8 Advanced, I have a table that is (among other things) used to populate a value list. I want to restrict which values from the table appear in the list, based on the privilege set assigned to the current user. (Some users will see all values, some will see just one or two, others will see most but not all, etc.) I've tried a couple of approaches, but then realized that they will fall apart as soon as there are two concurrent users. The only solution that I've thought of that will work in multiple concurrent users is to have multiple versions of the list (for each privilege set)used on multiple versions of the l…
-
- 3 replies
- 755 views
-
-
I'm new to filemaker and am curious if it is a good idea to use an image for the layout of the application. Instead of using filemakers built in tools to draw the boundaries of the app I laid out an image that I can change and insert into a duplicated layout when I need a new layout. Think tabs. There is a certain look I'm going for that I can't get with the built in layout tools. Any gotchas, tips or unforseen consequences? thanks in advance
-
- 2 replies
- 827 views
-
-
I have a field that is defined as a checkbox set for a particular value list. You can check the first two boxes but that is it. The list has 6 items in it. I have checked the privilege sets, and they seem fine, but the strange thing is that you can check all boxes when logged in as an administrator. Any ideas? Thanks for your help.
-
- 0 replies
- 884 views
-
-
Hello. I have been browsing the current topics, looking for a solution to my dilema, and have not found one. Maybe I am searching the wrong topic? Here's my issue: I have created a Comments table, related to Jobs, and would like to display all related comment records in a large concatenated text field. It will allow user to view entire comment and timestamp vs using a portal (since length of comment is unknown). However, I would like to sort descending, based on the timestamp, so the most current comment is always at the top of the list. What I have so far seems to function, but I cannot figure out how to reverse sort the value list. Any help would be appreci…
-
- 2 replies
- 1.3k views
-
-
Hi, First, sorry for my english... I hope I can make my self clear. I'm developping a FM layout for a lowyer firm and they are using Time Slice for time spent in jobs. But the data have to be exported to FM, because its where they have the relative data, so that they can input time spent v client costs. I have tried to find a way to make the clock work in FM but no success... It's suposed to have a button to start, another to pause and another to stop. Do you have any sugestions, either with FM or with another program that works with FM. Thanks in advance.
-
- 2 replies
- 808 views
-
-
I am putting the finishing touches to my first Filemaker Pro database which is documenting various artefacts I have been researching for my PhD. The database is relatively simple with one main table and two related tables. The link between the three tables is the Record_ID which is just an auto-entry running number series. Record_ID is the foreign key in the two related tables. I have 3 layouts (Object, Provance and References) based on the three tables and Record_ID appears in all three so I know at a glance that the correct data has been entered for any given object record. I would like the Record_ID data which auto-enters on the layout related to the main table (O…
-
- 1 reply
- 768 views
-
-
Hi - I have timesheet history table which stores hours, by staff position (eg: Coordinator, Manager, etc.) againts Projects. Each record also stores the Project ID along with other information. There are multiple records for each project. My problem is that I want to have a portal in my Project table which shows the position and total hours from the history file (I think through a combined Project ID_Position ID relationship). I can get the subtotals for hours to work but how do I limit the # of times a Position appears in a portal. The Coordinator may have 10 records with a total of 50 hours recorded. I want only one line to appear in the portal for each …
-
- 2 replies
- 732 views
-
-
Hi Folks, Is there any easy way to set up a checkbox to decrease(or increase) the number in a related DB's field when it is selected, and revert when it is unselected? Thanks in advance, j
-
- 0 replies
- 1.1k views
-
-
I am a novice at designing layouts and recently started my own company and am trying to develop a FMP layout close to what I am used to seeing at my previous job. We had a "company info," "work site info" with a button that would create a record in a seperate window from the "work site info" page. I can not get the seperate windows to communicate with related fields. Please help.I dont know how to do scripts so hopefully there is a simple way to do this. Thanks!
-
- 1 reply
- 734 views
-
-
Making a small database to webpublish so people in the building can get product ETAs. I've given my buyer full access to edit records, and the sales people have generally restricted access as they only need to view the records. I did make a comment field, that I want to grant the sales guys guest access to be able to edit. To do this, I have to use a Boolean calculation to give access to only this one record. I don't actually need to calculate anything. I simply want to give this privilage set [guest], access to this one specific record [comments]. What do I enter in the calculation field to allow the field called "comments" to be edited. (return a value of not…
-
- 0 replies
- 614 views
-
-
hello, anyone know's how i can disable the status panel to the right of my layout in iwp. I don't want people to switch between the layout with that panel they have to use my buttons. thx in advance
-
- 6 replies
- 1.1k views
-
-
Sorry for such a stupid question, but... I can't get my default text color, style, size, etc to stay at want I want. I want the text to be a certain font, 12, Plain, Black, etc every time I drag a field from the tool bar or click the text button. I haven't been able to locate the answer to this in the Forums. I have done what I found in the FM Help, and it works for that session, but it switches back to Red, Bold, etc when I quit and come back to the app. I know the answer is simple, but I can't seem to locate it!
-
- 2 replies
- 890 views
-
-
Hello...I want to avoid my portal showing the line for the next record that has not yet been created. My search in the forum shows that not allowing creation of records via the portal relationship will do that but that I need to create the new portal records with a script. How do I do that? If I have my script go to the line items layout and create a new record, it won't be related to my Order record.
-
- 5 replies
- 873 views
-
-
On my FM 5.5 I have this merged field on my layout that shows the following Record 1 of 6533 Found 533 It comes from 3 Calculated fields Status(CurrentRecordNumber) Status(CurrentRecordCount) Status(CurrentFoundCount) I am trying to do this on a layout in FM 8 with no sucess Thank you in advance Dave
-
- 5 replies
- 1.2k views
-
-
Hi, I've built a new system based entirely on relationships so I'm never actually working directly on a record ... it's always via relationships. I've come across what is probably a design problem ... and I'm far far down the road with my files, so HELP! I have a Contacts file in which I view lists on the right side of my monitor via a Portal (I have about 6 portals, 1 each in a Tabbed window) then on the left side, I have fields based on a different relationship from the portals and I use a global 'setField' (set by a script on the portal row) so that I see the data on the left, related to the portal row on the right when I click on the portal row. This work…
-
- 4 replies
- 920 views
-
-
I have a field, which is formatted as a Checkbox Set. Simple enough, right? Well, I'm trying to figure out how to get rid of the border that appears around the field when I put a check into the checkbox (from the Browse Mode). Any thoughts? I'm pretty sure it's not a Field/Control>Borders issue, I've played around in there, and it still appears. Thanks in advance for any thoughts on this.
-
- 5 replies
- 2k views
-
-
Hi, I'd like to create a field that can show data from other fields from other records. The other records are all in the same file. But, I'd like it to be contigent on a series of matching data. So, "record 1" has "field A" and it should show data from "record 2, field X, field Y, field Z" on one line and "record 3, field X, field Y, field Z" on the next line. I've been able to achieve this using a portal and setting up a relationship with the file to itself. But, I'd like to have "record 1" only do this if "record 1, field M, and field N" matches "record 2, field M, and field N". Hope this makes sense, and any suggestions would be greatly appreciated…
-
- 3 replies
- 756 views
-
-
In Filemaker 7, OS 10.4.5, on an Imac, the Geneva 10pt font displays poorly, scrunched up, spaced out, etc. impossible to type correctly, but on other Imacs, powerbook, it displays just fine? Looks good in MS Word, etc. What's up?
-
- 0 replies
- 882 views
-
-
Is there any way to reference the previous record in a calculation? I need to compare the text in one field to the text in the same field in the previous record where the order of records changes with each new find and sort. I've been doing it by running a script to bring the previous value forward and comparing that way, but I'm guessing there's a simpler solution. Thanks for any help.
-
- 2 replies
- 710 views
-
-
Hello, I want a portal that shows our most recent 5 orders. The problem is, it takes forever to sort all 20,000 orders by the sort criteria I have on the portal. My portal only shows five rows and doesn't have a scroll bar... any faster way to do this? Thanks, Andrew Sorry if this has been covered before -- I didn't see it anywhere.
-
- 3 replies
- 815 views
-
-
Hello all I have created radio buttons to toggle between "active" and "inactive" clients. I am trying to find a way to change the background color of the entry depending on which is selected. So "active" clients will have a white background and "inactive" clients will have a gray background. I have no experience with scripting or any advanced FM techniques, so I am at a complete loss in trying to figure out how to achieve this. Any help would be greatly appreciated. Thanks.
-
- 7 replies
- 2.9k views
-
-
I have a value list based on a key number that displays a second field which is a part number, a combination of texts and numbers. I have created a new field for sorting the part number by its internal numerical value, but how can I display the complet part number and have the VL sorted by its numerical value?
-
- 3 replies
- 943 views
-
-
I am having difficulty wrapping my head around a script that will sort a portal in my document. Basically I would like to create button for each one of the column headers above my portal so that it will sort like Table View. I understand that this is done by telling the portal to sort by a special field that is recalculated by the script, but I'm not sure how to set up the script to change that field for each record. Can someone show me an example of how this is done? Also, can it be done using one script and different parameters, or do I need a new script for every single button? Thanks. Ethan
-
- 7 replies
- 946 views
-
-
I have a field "PathToMacVolume" in a database which contains a information on the path to a volume. When this field is added to the "Model" field it creates a full reference to a jpeg file for viewing which is then displayed in a calculation field "PathForMacUsers" the result being a container. I needed a field which contains a single reference to each of the individual "PathToMacVolume" fields. This field is used by an Applescript to mount those volumes and allow the MacIntosh User to copy the Hi-Res Images. So I created a global field "MacVolumes" to contain this information in the form of a Value List. My questions are: 1. How do I make sure …
-
- 0 replies
- 945 views
-
-
Among my layouts are letters (text boxes?) built using the "insert merge field" function to bring data from those fields into the letters. These include dollar amounts, name and address info, dates, etc. I have always been unable to format these merge fields when they are numbers or dates. For instance when the merge field has been a dollar amount drawn from the database, I have not been able to format the number as a dollar amount. I have had to place a typed "$" before the place where the merged field inserts the dollar amount into the lettter text and cannot even get Filemaker to place a comma into the number. So in the merged document they end up looking li…
-
- 7 replies
- 2.5k views
-
-
Again, I am familiar with Access and new to FileMaker. In Access, I would want to make a Form, and add it as a Sub-form to another form and do it iteratively. So for example I could create a form where I could enter a country, a sub-form to enter counties in that country, which would have a sub-form for the towns in that county. I know that FileMaker uses portals, but don't see how I could create a portal, from another layout (which would allow me to do as I've described above).
-
- 2 replies
- 857 views
-
-
In a portal, I want to add a field that displays the row number. I tried Get(PortalRowNumber), but it displays the selected row, and not the row number. What fuction shall I use ?
-
- 3 replies
- 896 views
-
-
Well, i've decided to jump into this FileMaker app for the first time. I am an avid PHP, MySQL programmer but i cant get a handle on this app. I would like to convert my previous app designed in pure HTML and PHP to the FileMaker app but i have no idea on how to do my first step. Which is, say i have a Clients Table Database filled with clients and then i have an Invoice Table Database, and i wouldlike to browse the clients and once i find one i am looking for i would like to click a button to port me over the the Invoice Layout with the Clients ID and information already there? How is this done? In PHP and MySQL i creat a dead form with Queries to the …
-
- 1 reply
- 778 views
-
-
How do I write a calculation to be used in the script step "Go to Portal Row (By calculation)" that would take me to the portal row with the highest ID number? My portal is sorted by a text field (Company), so when I add a new portal row, depending on the name of the new company, the new portal row may be row #2 or #5 or...you get the idea (meaning I can't have the script go to the first, last or next row. It must be a calculation). Since the ID#'s are generated automatically and are unique, I need to find a way, via calculation, of going to the portal row with the highest ID#, which would be the new one just added. Thanks for any help!
-
- 0 replies
- 745 views
-
-
Hello, I have a database that tracks items on an invoice using a portal. I can total charges on the invoice using a Sum ( store::price ) calculation. How can I calculate total charges for a subcategory of charges? I want to do something like: if (category == "taxable") Sum ( store::price ) That might work in Python or C, but I'm not sure how to do it in Filemaker. Any ideas? Brandon
-
- 0 replies
- 627 views
-
-
Question for the gallery: I have an inventory system in which i have a list of materials. These materials can be run through production but if all the m aterial is not fully produced we return that material to stock and capture the reason. The return to stock information is stored in another related table. As so i have an interface from the inventory perspective looking into a return to stock portal. my problem is with a calcualtion for the new weight. which is the origonal weight minus the used weight. I want to be able to designate the last available new weight a different color. i have tried to relate the rts info to itself to no avail and then also t…
-
- 3 replies
- 837 views
-
-
Is there any way to add multiple colours to a value list. I am trying to create a list shoing project status (Active, Pending, Inactive, Prospect) and would like to have the colours Green, Yellow, Red and Purple respectively. To date I have overlaid coloured text over the list but depending on the operating system I have seen it shift plus it would be cleaner if I could do it without the overlay. I appreciate any help you can provide and am very appreciative that a forum like this exists as I've been using FM from back in the Claris days of version 1 and am now migrating (from scratch) to 8 ... ugghhh
-
- 3 replies
- 966 views
-
-
I have a double tab layout. One large tabbed control with each tab containing another tabbed control. This works great. However when I place a field (a global, but I don't think that's pertinent) using a drop-down list on a tab of the main tab control and select a value and the zoom level does not show the entire sub-tab control, the layout 'jumps' so that the top of the sub-tab control moves to the top of the window. Zooming out so that the entire tab control is visible prevents this from happening. Anyone else seen this? Server 8 on 2003 server, developing on Adv 8 on XP SP2
-
- 1 reply
- 16.2k views
-
-
I know the new tabs in FMP8 are not for layout navigation, but I tried anyway! They look great across the top of a layout, especially with embossing, etc., and with the "body" reduced to a strip where you could insert secondary navigation buttons under the main tabs. So my idea was to overlay transparent scripted navigation buttons over the tabs. It works, but only on the second click! I don't seem to be able to bring forward the overlaid button above the tab to put it at the top of the stack. The first click is still on the tab then the second on my navigation button. Can anyone see a way round this?
-
- 2 replies
- 1.2k views
-
-
Hi - I have a timesheet data entry screen where I'm using a portal to a timesheet history file. In the portal I have a value list where I want to show the Client ID and Client Name. I'm using the option of showing the second value only showing (easier on the users) and it works great - populates the Client ID and then captures Client Name. The problem I'm having is that I would prefer not to have the Client ID stay showing. I want to the Client Name to appear in that area. I've tried making the Client ID transparent and laying the Client Name field over the top but I keep getting both images when in browse mode. I could just make the value list based on Client Name …
-
- 3 replies
- 737 views
-
-
Good Morning! I was looking for assistance in creating a layout for reporting in a FM8 database I created. I need to be able to get a report of the number of calls, money received, results for associates. Is there a way to do this so FM can automatically update and give Grand Totals?
-
- 1 reply
- 702 views
-
-
Hi If some one could help me with this.. What I wanting to do is add record directly into the portal. Is this posable? Please see attached FHP file for the layout view with portal - this where I am wanting to add record directly into Kind regards hacky print_specs_Clone.fp7.zip
-
- 2 replies
- 675 views
-
-
Does anybody know of a plug-in or workaround to add Tool Tip Formatting to Filemaker Pro 8? Thanks. Ethan
-
- 4 replies
- 1.6k views
-
-
I'm not sure if this is a value list question or a script question, so I thought I would start here. Is there a way to compell a record to be committed after a selection from a value list? Can you script a dialog box to show up that will take you to or presents a value list? Are there any plug ins that could do this? Any ideas? Jarvis
-
- 0 replies
- 716 views
-
-
Hi - I'm brand new to FM Forums and hope that this question isn't too ridiculous. I've built a system to track timesheets. I've designed a weekly report which provides each employee's hours (one page per employee). I wanted to take advantage of the Alternate Background Fill in the BODY part set-up but it's not working. The manual said that even numbered records use the fill background but it doesn't seem to use the actual RECORD NUMBER field. Any suggestions would be appreciated. Thanks Debra
-
- 5 replies
- 1.7k views
-
-
I'm trying to slide my data in my portal for printing. It isn't refelcting in my preview. Can this be done in a portal?
-
- 3 replies
- 660 views
-
-
I have a portal showing LAST NAME, FIRST NAME The relationship is dynamic in that the user can choose via clicking a button, to show only last names starting with A or B or C etc. They can also type in and see all names starting with JONES, SMITH (or any partial letters). All of this works perfectly. However, the portal doesn't always sort correctly. I have tried sorting at the relationship level (LAST NAME, FIRST NAME) I tried sorting at the portal in the layout in the same way. I've tried with both on or one or the other on. Every time - it usually sorts. However, when I click in the portal, then click on the letter choices outside the p…
-
- 10 replies
- 999 views
-
-
Hope that I can describe this problem. I have a check book with a starting balance of 300.00 dollars. I want to use the portal as a general on going balance sheet. I have not found a way to add a expense or a deposit and automatically calculate a on going balance as the new protal record is created. This is what I have done so far. Global start balance = $300.00 Protal layout Example indexID, Expense,Deposit,balance 1 , 10 , 0 , 290 2 , 20 , 0 , 270 3 , 0 , 200 , 470 -------------------------------- 4 ,0 , 0 , 470 this record has not been calculate yet I want each new record t…
-
- 1 reply
- 725 views
-
-
I am designing a template to use on all layouts in a template I am creating in fmp 5.5. This template will be used by many different users/different machines/os. I am creating, buttons, graphics in Photoshop. Are there any standards I should consider regarding use of jpegs, color type constraints (web colours). Should I assume a display resolution of 800x600? I have read about Win/OSX issues related to font size (recommended 11 Arial/Verdana) Is there a function I put into a script that checks display resolution to display a message. Any help is much appreciated as always.
-
- 24 replies
- 2k views
-
-
I understand that FileMaker 8 only shows five records at a time in list view on the web. If the status area is showing, you can click the "book" and it jumps the list forward to the next five records. How do I build a button that does the same thing? I want to hide the status area, but any button I make only moves to the next record, not to the next page. Any help would be much appreciated.
-
- 12 replies
- 1.6k views
-
-
Hi everyone, I am pretty much familiar with FM. I have been using a home-grown solution that started in 2 [?] and has grown over the years and has served me very well. Now, I want to automate some of the tedium, and need some help. The relevant tables are proposal, invoice, and tasks [a simple flat list with the usual taks-list fields]. My invoice is attached, in layout form, and the relevant area is highlighted. What I want is: I want all tasks for the project to appear in the portal. I want to scroll the portal, and assign the curent invoice number to tasks as appropriate. Then, I want the resulting list to be sorted by date completed. It sound…
-
- 0 replies
- 719 views
-
-
This is the shortcut to my controlling tabs technique. http://fmforums.com/forum/showtopic.php?fid/24/tid/173566/pid/192164/post/192164/#192164
-
- 0 replies
- 1.1k views
-
-
Hi. When I select a field in layout mode, go to Field Control/Field Behavior and click on Select entire contents of field upon entry, it doesn't work. No matter what I do, still doesn't work. Even with new fields. Any suggestions? Thanks in advance! Terri
-
- 3 replies
- 890 views
-
-
Hi all, I don't even know whether this is the right place to post this topic. Anyhow, the drop-down menu of Window on the menu bar has an item that says "Show window" along with a right pointing arrow which is supposed to trigger another submenu on FM Pro 8 Advanced, however, my copy of FM Pro 8 Advanced does not show anything at all, I am just wondering what is it for? Or am I the only one having this problem with FM Pro 8 Advanced Ver 2? Appreciate any feedback. Thanks a lot. NotPro
-
- 3 replies
- 1.2k views
-
-
Hello I have a situation where I have a database made for other people. They have a value list which they have to change once a year. they will always have to do a find for the FIRST value of the value list. Is there a way to automate this? For example this year the first value of the value list is "greystone" and next year the first value might be "rusty" but I would like to know if it is possible to do a find for the first value in a value list. Thanks very much
-
- 3 replies
- 749 views
-
-
Hello, How can I display (in my table CUSTOMER) a list of repeated lookup field field (out of a separate table PRODUCT) according to categories with a nice lay-out? Thanks in advance Christophe
-
- 0 replies
- 732 views
-
-
Hi all, I apologize of this is in the wrong forum (I could not tell whether it belonged in portals or value-lists). I have a simple database with three tables: ActorsTable (ActorID, ActorName) JoinTable (ActorID, SkitID) SkitTable (SkitID, SkitName) with a Portal (JoinTable::ActorID)(ActorsTable::ActorName) I am using a value-list based on the fields ActorID and ActorName (from the ActorsTable), to add the actors to the portal on the skit table. The problem I have is that I can add an actor multiple times in the portal. Is there some way to filter a value-list to exclude actors that have already been added to the portal (but will …
-
- 3 replies
- 793 views
-
-
So, here's the deal. The pieces: 1: "Quote" database (where my company stores quotes to customers for parts to be sold, etc) 2: "QuoteElements" database (where the individual line-items for the quotes are stored, each as a record) I have 2 portals in my main layout of the Quote database. One portal shows the items available via a standard one-to-many relationship, based on the Quote's UID. The items in the portal are the line items for THAT quote. Tab to the next record, it adds a new line item, happy happy. What I'd like the second portal to do, (but it doesn't) is for it to show what I call "common items" that we can simply click and have added to the cu…
-
- 1 reply
- 838 views
-
-
Hi All, I'm creating a patient database for multiple clinics ("Locations"). So, I've created two tables Patients and Locations. In the Patients layout, I have a pulldown menu that displays all of the available Locations. When a Location is chosen, Locations::Key field is tied to the Patient record by Patient::KeyLocation field. Here is my problem. In the Location layout, I want to show a list of all patients whose Patient::KeyLocation matches that particular Locations::Key. Here was what I thought would do this: I created an equality relationship between Patient::KeyLocation and Location::Key. I then created a portal in the Location layout to display P…
-
- 1 reply
- 676 views
-
-
Hi, all - I'm putting together a layout for a report. The reported information includes some fields in other records, which I'm displaying through a portal. In any given report, there may be only a few related records, or a couple hundred. I'm trying to figure out the best way to represent this in the layout. Should I just make a "worst-case" guess for the largest number of records any report might have, and then put the slider on it? It seems like sort of a sloppy way to do it, but I can't think of another. Thanks...
-
- 10 replies
- 1.2k views
-
-
I have an INPUT layout with a checkbox value list. The 9 values begin numerically ( "1)", "2)",...). In a PRINT layout I have a merge field of the same field/value list as a means to list only items that were checked. The problem is that in the PRINT layout the value list items appear in the order in which they were selected, not in the numerical order in which they were named. Is there any way to correct this?
-
- 3 replies
- 843 views
-
-
I recently made the switch from FileMaker 6 to FileMaker 8. In my 6 database, I was able to display a found set as a table in a web browser and then when you clicked on one of the records, it would change to Form View. Now, in version 8, it no longer wants to do that. Is it still possible? How is it done? Displaying in List View is not much help, as version 8 only displays five records at a time. Anyone know a way around that? Thanks!
-
- 0 replies
- 716 views
-
-
Hi, I must be doing some thing wrong with my Portal and relationship tables as I not getting data showing on my portals does any one have any tip attached are some screen dumps regards Hacky ;)
-
- 9 replies
- 859 views
-
-
I have a table with several fields, each of which is a sub-category of the other. Here's a simple example of these types of fields: Country, State, City I've successfully created several conditional value lists, each of which pulls its values from related records in this table. So, when the user selects a Country from a drop-down list, the next field's value list is filtered to include only related values (i.e, only the states that exist in that country). When the user next selects a value from the State drop-down list, the City field filters its values the same way, only showing relevant cities. In this way, I've used a single table and implemented se…
-
- 7 replies
- 1.4k views
-
-
I have a row of buttons used in multiple layouts, and I have put individual tool tips on each of them. Trouble is, I have labelled the buttons with a repeating field of names. The tool tips only appear if the cursor is over the edges of the buttons, not in the centre where the repeating field and names lie. Not the easiest for users! Has anyone found a way around this without sacrificing the editing flexibility of naming with a repeating field?
-
- 4 replies
- 1.5k views
-
-
I have a table full of event data that I can easily show on a layout using a found set by the date of the events. I would like to create a layout that has the found set of a requested date listed and then right next to it show the following dates events listed. Using portals and a self-related table, I can't get this to work. And I haven't had any luck finding a previous post related to this topic. Maybe someone has tried this before or can point out a previous post that addresses this topic. Thanks, Jon
-
- 2 replies
- 813 views
-
-
Hi everyone, I have a question regarding strange field behaviour that I've seen a couple of times. I'm quite sure that it's a result of one of the many gaps in my filemaker knowledge and I won't go into detail because I'm certain someone will recognise the symptom... Basically, I when I fill out a field in a portal row it seems to fill out for *all* records, depending on which table occurence the field is directed to. Or just fills out the one field but where that record should show up in another portal (via a relationship based on the problematic field containing that value), a different record appears instead of the one that should. I'm a little shaky on…
-
- 3 replies
- 815 views
-
-
I'm stuck on two issues. See my attached sample database. Go to the "Songs" layout - it should open on this layout. Read the "Notes" section on each of the seven records in the "Songs" layout. Issue #1 - I think this will be fairly easy for a FM genius to solve. Issue #2 - I wondering if it's possible. - maybe LaRetta, Lee, Comment or some other FM genius can figure this out :P Songs.fp7.zip
-
- 9 replies
- 1.1k views
-
-
I have FM 8, but all of my solutions are still running on 6. and one big issue for us is having more than one portal on a layout. Is this now possible in FM8? [our invoices need to have data from our reimbursables, as well as billing information]. Thanks!
-
- 2 replies
- 684 views
-
-
I'm trying to set up reports for items that are in production, shipped or in graphics on a 7 day, 30 day and 60 day sheet. I'm also having issues seperating the products, like small bags that are shipped on a 7, 30, 60 day report. Same with Large bags, totes, purses ect. Any and all help would be appericated.
-
- 0 replies
- 767 views
-
-
I have a portal which shows transactions, in descending date value. I would like the users to be able to add records using the portal. The issue is that the fields where you may add a record appear at the end of what can be a long list. Is there a way to make the area for adding a record show up at the top of the list rather than at the bottom? Thank you, Linda Markarian
-
- 0 replies
- 702 views
-
-
Pleae Help!!! I have 4 fields. The first field is called record status and it is a radio button with 3 values: Entered, Missing, and Not Applicable. The other 3 fields are called ps1, ps2, and ps3 and they are all radio buttons with the following values: 1, 2, 3, -89, and -99 QUESTION: Where do i code and how do code so that if record status is checked Not Applicable then ps1, ps2, and ps3 will have the -99 radio button checked for all 3 fields?
-
- 7 replies
- 1.1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online