FileMaker Interface Features
-
Help!! I need to create a contact log. For each contact. But I don't want the other contacts with that same table to see it. How do I do that!!!
-
- 3 replies
- 721 views
-
-
I want to create a new record in a database, using a portal, then add to that record using the related data. I was just doing GOTO last portal row, then GOTO specific field, then instert field x into field1, and then insert field w into field2, etc. But every time I do this it either updates the very first record in the portal list, or, if I play around with a goto portal row command, starts creating new records for each value. I'm sure I'm missing some basic element here.
-
- 3 replies
- 798 views
-
-
Can somebody help me to design interface (interface is attached with the message) in File Maker Pro 8 under window xp platform? Kindly help me as soon as possible. please go on this link to see interface. http://www.maclane.com/ubbthreads/downloads//503066-clientinterface.JPG Thanks & Regards, Barbara Smith
-
- 6 replies
- 1.2k views
-
-
I try FM8 and… hummmm Goto Layout A Goto Tab A or B, or C … or C It is possible scripting that?
-
- 30 replies
- 6.4k views
-
-
Hi, I'm trying to learn how to set color attributes in value lists. I have a field called "Actions" that uses a 5 item list: (Out, Resend, Accept, Revise, Withdraw). Right now I'm setting text attributes manually. I'd like to know if I can auto-format the color of the value list items. Via a calculation? Note: I'm not a total newbie but I still have a very limited understanding of calculation and summary fields. I can't seem to follow the syntax...
-
- 6 replies
- 931 views
-
-
Hi All, I have a layout that has a portal with another database in it. I'm having trouble in creating a new record in the Portal without exiting the layout and going to the layout of the record in the portal. There does not seem to be a 'script' for creating a new record in the portal. Can anyone help or am I missing something? Guy
-
- 3 replies
- 853 views
-
-
I created a Value List based on the values in a field (say "color"). FM8 sorts this list in alphabetical order (blue, green, orange, red, violet, yellow). Since I want the Value List in rainbow order, I added an "order" field and manually assigned numbers to each color. Then I changed the Value List to use both fields, order + color, and specified "Sort by first field." That works fine, except I don't want to see the numbers in the menu that uses the Value List (1 red, 2 orange, 3 yellow, ...). So I checked the "Show values only from second field" option. That seems like it would do exactly what I want. HOWEVER, checking that option (1) changes the sort…
-
- 2 replies
- 1.1k views
-
-
I have a text field that is used across multiple layouts which needs to have lines parallel to the text. The records have varying page numbers so a line of exact length will not do. The text field can't be expanded with the use of margins due to it affecting other layouts (an idea from another thread). Someome mentioned merging the line with the field for sliding, but I read that this can't be done. Any ideas how I could have my parallel lines ?
-
- 4 replies
- 943 views
-
-
Hello All, I have an application where it would be easiest to have my records showing up in a grid pattern instead of a list format. Is there a good solution for doing this out there? I have toyed with doing it via several side by side portals, but have not had any luck so far. In addition, this portals solution may eventually work but in practice, it's not very pretty. Any suggestions appreciated. Thanks, R
-
- 0 replies
- 755 views
-
-
Ok so it is great to have a start at this interface but it's just a frustrating teaser to me so far. We need to be able to size the tabs independently of the names and not even have to give the tab a name. Make the tabs buttons (or not) so we can assign scripts, be able to use fields/scripts/parameters to name the tabs. Set permissions for tabs like we can with layouts, fields, scripts, etc. Over lay container fields with graphics for buttons on the tabs and assign scripts and disable the built in tab navigation. Easily identify the tab(s) and fields on the tabs from within ScriptMaker. GoToLayout(layoutName,tab), Get(tabName),etc. We also need to be ab…
-
- 3 replies
- 1.7k views
-
-
Is there a way to 'count' the number of records within a portal? For example say you have a portal and next to it is a box with the total number of records (as you switch records, the 'Count Total' adjusts accordingly).
-
- 3 replies
- 656 views
-
-
Hi guys, I've created my calc ok to calc the current age of the bill (get(currentdate) - billdate) What I want to do is have a portal set up for each "age" i.e 0 - 29 days, 30+ (30 - 59), 60+ (60 - 89) and 90+ (90 +) So i've then created a calc (joinage) If(Paid = "unpaid"; Case(CurrentDate - InvoiceDate < 30; "0"; CurrentDate - InvoiceDate > 29 and CurrentDate - InvoiceDate < 60; "30"; CurrentDate - InvoiceDate > 59 and CurrentDate - InvoiceDate < 90; "60"; "90");"") I created several join fields (tried unstored calc, and global): JoinCurrent = 0 Join30 = 30 Join60 = 60 Join90 = 90 Joined them all u…
-
- 2 replies
- 777 views
-
-
I love portals -- especially since I have got them to have popup lists that depend from other popups in the portal lines via value lists and lookups from the realtionship. I was just wondering if FM lets you take it a step farther. Let's say that the first field in the portal line is a popup of category choices (by some sort of calc) that represent different tables such that by choosing one a relationship is defined to the table of choice? Then if that was possible, would it be possible to define subsequent fields by a calc of some sort that see the relationship defined by the category choice and then would allow these fields to be then populated by lookups acc…
-
- 5 replies
- 820 views
-
-
I'm a new user trying out techniques I'd like to use later. I read that it is cleaner to edit portal contents in nearby fields instead of in the portal. The way I understand this idea is that you transfer the record that you'd like to edit to the'platform' by copying the data into a 'global record' in another table. The fields on the 'platform' are actually fields from a seperate table and will then be copied back. See Vendor_Item_Platform layout 1. How do you make the portal non-editable or display only? Is this actually just the regular portal with a script attached to the rows? How do you get rid of the edit lines around each box. 2. Is the glo…
-
- 0 replies
- 721 views
-
-
Is there a way to keep text from printing on a conditional basis? I'm refering to text objects, not text within a field. For example, if Field1 is empty I'd like to not print the field lable "field1:". Basically, this would be the automated equivalent of selecting "Do not print the selected objects" in the Sliding/Printing dialog box.
-
- 2 replies
- 879 views
-
-
I have created a FM7 runtime that has one database with 22 tables. Everything seemed to be fine during testing but I have had it reported that when the database is heavily populated with data the portal rows in various layouts merge and become unusable. I know this is not alot of information to go on but if anyone has any pointers why this could happen I would appreciate the feedback. Many thanks
-
- 0 replies
- 712 views
-
-
Attached is a file of what I need my end product to look like. (I have removed or renamed some client specific information.) I have 2 tables in the same file from which I need to create a report that resembles the one attached. Currently the guy working with this report runs a script that exports fields from both tables and puts them into an excel document. The rows with numbers in column A are from one table and the rows with OPI in column A are from the second table. He has to format all of the colors, strikeouts and add some text. He want's to be able to do all of this in FileMaker. Is it possible to do without portals? I don't have a problem wit…
-
- 6 replies
- 1k views
-
-
I wasn't quite sure where to put this so just hear me out first...I'm ok with general relation database theory but i have real problems when it comes to reporting certain information... Righto Lets say i have two tables: Table 1 - ID 1 (Unique) - Date Field 1 Table 2 - ID 2 - Date Field 2 The relationship is structured as such: ID 1 = ID 2 & Date Field 1 <= Date Field 2 So basically i want to filter out all the records that don't meet the criteria of the relation ship... and present a report laid out something as such: ID 1 (Record 1) ID 2 Date Field 2 ID 2 Date Field 2 ID 1 (Record 2) ID 2 …
-
- 4 replies
- 859 views
-
-
I have a specific layout that I need to use. My problem is how to go about doing it. I need to be able to use the button "Add New Order Part" to be able to clear the fields for the previous order part (While maintaining the information in the database) and add a new Order Part to the original order. I am trying to use Portals but I don't want the previous order part to show along with the new part order. I want it to look like a totaly new order...with the company name and original order information kept in tack... Any Suggestion? I have attached a couple of screen shots to help you understand what I need. Thank you
-
- 1 reply
- 749 views
-
-
Here is my problem: I have a field based VL. How can I set it up in such way that once a value has been chosen, it is no longer available for the next record. For example I have a coaches table and a players table. Once players have been associated to a coach their names should no longer appear in the value list when I want to associate other names to another coach. This way the list becomes shorter and shorter as assignments are completed. This is to prevent a player's name to be linked to 2 different coaches. Thanks for any suggestion.
-
- 1 reply
- 765 views
-
-
According to new millenium menu magoc page you can disable the close widget button? How can you do this in v8? Or do you have to do it using scripts? Any one know of this???
-
- 2 replies
- 1.7k views
-
-
The company I am working for has been using a scheduling app I created several years ago (FM5). They like using it, but have decided to go with a large manual (magnetic) schedule board- possibly in conjunctrion with FM.They want to have the ability to move around the magnet pieces to help determine schedule and daily work load (which they aare already doing on their small monitors)..they are a visual group. I am trying to convince them to purchase a Smart Board and use it as a digital "magnet" schedule board and use the exsiting structure to store and view the data the data. Has anyone created a layout in which one could drag and drop fields in a job board t…
-
- 1 reply
- 822 views
-
-
I have a perfectly working lookup for field2 that comes from related table based on values for field1. Now it turns out field1 that defines the realtionship for this lookup needs to be field1:: table2. This breaks the lookup. So, I have created calcfield1 (results in text that gets the value from the field1::table2) and that calc works just fine. But when I try to build the lookup on a relationship with calcfield1, but the lookup won't work. I noticed that a relationship based on a calcfield1 won't allow indexing; so, I tried to use textfield1 with a calculated result (which can be indexed) based on the calcfield1 value but no values show up in text…
-
- 3 replies
- 762 views
-
-
I don't quite know where to post this but I'll try here first. I have an inventory file that holds the details of products sold: item number, description, upc/barcode, retail price, wholesale price, etc. When a wholesale customer comes into the store, he picks out the items he wants and indicate to our sales associates how many pieces of each he wants. I would like to create a solution to scan in each upc/barcode to do a find in the present file, have the choice set into a portal, which would then pull up the price for the items via the relationship in the portal, and we can indicate how many pieces are desired. If the customer picks out 30 items, at the end of the se…
-
- 0 replies
- 701 views
-
-
As one who works more in dynamic web design, I often return to Filemaker expecting to find in the Filemaker interface some of the dynamic layout features of, say, PHP include (or even a frameset). What I miss is being able to make, say, a menu bar of buttons with their links and have them appear in a number of other layouts. When I change one page, all pages should reflet that change automatically. I have experimented with convoluted merge values for buttons and their labels - but found them all wanting. As I embark on a big new upgrade of a 4-year-old database, I am ever more conscious of the need for elegance (in the economic sense). Has anyone any b…
-
- 1 reply
- 895 views
-
-
I wanted to call this a question of ontology, but figured that wouldn't get much attention... As I understand it, FM7 uses the context of a table occurrence to determine the recordset to view in a given layout. However, it is not clear to me what happens to the context when a user or script changes the layout in the window. Specifically, if I am viewing a client record in my database window, and I click on a button that changes the layout to view the client's invoice records in the ClientInvoices layout--a layout that is based on a TO that is linked to the original client TO--how does FM respond? The ClientInvoices TO is supposed to be based on a link by client…
-
- 9 replies
- 936 views
-
-
Hi, In single space view the data is fine- in double space data gets cut off- there is a note that says page 1 ends at line 44 and page 2 at 88- but I don't see how to adjust page breaks in layout view or know what to do to make it so all the data can be scrolled to in browse mode. Any tips appreciated- Om
-
- 2 replies
- 925 views
-
-
I am a novice and have the following scenario: Parent table with following fields: Invoice number (primary key), Customer, Project Code, Expense Total (calculated field: sum of Amount field in child table) Child Table: Inv Nbr (foreign key), Expense type (by value list), Expense Amount Relationship: Inv nrb in parent table = inv nbr in child table A project may have one expense-invoice to a dozen+ of invoices. My problem is as follows: I want to be able to total invoices (eg total of Expense Total field in Parent table) by project code to show a cost per project. In other words, I need a list that shows invoices grouped and totaled by project num…
-
- 3 replies
- 827 views
-
-
Is there a way to make the records listed in a filtered portal into a found set?
-
- 4 replies
- 1.2k views
-
-
Hi, I can't find out where I'm going wrong here ... I'm sure it's quite simple. I have a self-relationship. I want to be able to change the sort order of a Portal, via scripts. To this end I've made a calc field, based on a global set-field and the sort order is from the calc field. The fields and scripts all work as they should, both when inside and outside the portal. BUT ... the calc doesn't refresh, so the sort isn't effected. Opening and closing the calc field's definition in Define Database, forces it to refresh ... so I *know* the logic is okay, but I can't find any script steps, to make it work. I'm working in FM8 Advanced and don't rea…
-
- 4 replies
- 1.1k views
-
-
I have a database of various types of media (VHS, CD, DVD, MiniDV etc..) I am creating a script that will print out custom labels based on what type of media is selected. The script is something like: IF AssetType = MiniDV Go to layout MINIDV_Label Enter Preview mode Print Else if AssetType = VHS Go to layout VHS etc... The problem is, when I switch layouts the correct record is showing, but when I enter preview mode, it jumps to the first record in the table. Any ideas on how I can keep the record I am working with the record that prints out??
-
- 7 replies
- 940 views
-
-
Can anybody help me ? Is it possible in FM Dev. 7 to create a script to open the layout assistant ? Thanks
-
- 7 replies
- 889 views
-
-
I was just wondering if anyone else experienced this problem in 8. When you use a field from a different table for the second field in a value list (even if the relationship works great), fm 8 gets hung up and crashes as soon as you go use the value list. This didn't seem to happen in 7. I am shying away from using a value list with values from more than one table . Instead, i create an indexable field in the main table to show instead. This seems like a step back. Anyone experience this quirky behavior?
-
- 1 reply
- 960 views
-
-
I have a database of author names that is sorted alphabetically by last name. In a related table, i would like to do a lookup on the value of an author field for a similar name in the Authors database and have a portal that shows the nearest match and the surrounding 10 records. is this possible? I can get the nearest match to show up, but do not know how to show the surrounding 10 records (previous 5, next 5) Thanks for any help
-
- 1 reply
- 751 views
-
-
Hi everyone.. I have finish my file and i did not know from when and nowhere comes this dotted line in between it. it is kind of similar to the body/footer dotted line but is not. I cannot click on it and no info shown there when I roll over it. Problem is when I go to preview, it never shows me all the stuffs that is under that line. and when I print it just like what the preview shown, my stuffs not there... Help! Thanks a lot..
-
- 13 replies
- 1.3k views
-
-
I read all about them.. I never used them before and have no one around me who knows FM. I'm all alone.LOL....but a bit frustrated. I do not know how to post it, so i made a file with notes of what I would like to do. If you have a chance and a creative mind to interpret my words, please look at this file and help if you can. Thanks. portal.zip
-
- 4 replies
- 916 views
-
-
I'm sure this is stupid, but why can't I set a field button in a table view to go to the related record in another layout? This is very easy to do in any other layout, but for some reason the table view doesn't like buttons.
-
- 6 replies
- 1.3k views
-
-
I don't know where to place this question. I have a layout with a date field from a related table. The relationship is one client (current file) to many (related table) service dates. The relationship is sorted in reverse chronological order, so the latest date is the one that displays on screen, showing me the last scheduled date of service for each client. Now for the wierdness. I want to be able to search for people with a particular last service date. When I put in a single date, the search works pretty well. However, if you use the Filemaker range feature (11/15/2005..11/30/2005), the software returns every client with a date later than the first date. I'm …
-
- 3 replies
- 764 views
-
-
Hi all, I'm looking for a really lean technique to highlight the current active record in a list view. I want a good strong color change so that the active record is just plain stupid obvious. I did it with a hidden button and a calculated container but it feels clunky and unnatural. I want it to be smooth and automatic so that no matter where a user "is", the active record already contains the highlight without any funny button business.
-
- 2 replies
- 882 views
-
-
Hello, I am in health care, and am setting up a confidential database of factors for a certain type of disease, and the correlations will be analyzed by researchers. I have added the variables into FMP. However, the fields are too close together. Is there a way that I change the spacing between fields, all at once? Thanks! Alisun
-
- 2 replies
- 779 views
-
-
I am using both radio buttons and checkboxes. At first everything displayed correctly, but now the text of the lists is now showing up without the buttons and boxes! I can see see my options, but they cannot be selected. The same fields used in a different layout are still ok. Does anyone know why this is happening? I would be very grateful. I've been using Filemaker for years and have never had this problem. Thank you.
-
- 5 replies
- 876 views
-
-
all conditional value lists i have done have been baseed off one other field....how can i set it up that when two different fields equal a certian criteria a thrid feild is populated
-
- 1 reply
- 740 views
-
-
-
Hi, I have a table of line items (invoices). What I want to do is produce a report with the items sorted in (amongst other things) date order. I wanted to create a subsummary of the month so I created a field which was month(date) Obviously this is based on the number of the month, rather than the name so as to sort correctly This works a treat. The problem is if there is April 2004 and April 2005, it doesn't differentiate. Obviously I can't just add the year to the month because if there is for example August 2004, and January 2005, as a calc number august 2004 (2012) is larger than january 2005 (2006). So, the question. How can I sort my rep…
-
- 3 replies
- 990 views
-
-
I have a portal to another set of records and am trying to place the data from the portal to a text file (various positions in the single text file depending on the cursor position selected). This works only at the end of the text file with the use of a set field script and a button on the portal. I have tried insert calculated result but this for some reason does not work with portals(it works with drop down lists).By selecting the drop down lists and placing a button script with a insert calculated result-- I can place text into the file any place the cursor is located. Any one else had this problem?
-
- 8 replies
- 1k views
-
-
I want to be able to insert text into a field using a button! I also want this text to be inserted were the cursor is currently blicking. No problem here I know how to do that, but as soon as I place the button in a Portal it only inserts the text at the end of the field, and not were the cursor was before. It is like it leaves the field when you click inside a Portal. Is there anything simple I missed? How do I get the inserted text were I want with my button in the Portal? Thanks for your help!!!
-
- 9 replies
- 1.6k views
-
-
Hi all I'm having a bit of trouble manipulating a portal. I want to only display 20 lines in a portal (without a scroll bar) at one time, and have buttons 'move' the records on to the next set of 20. I thought I could simply use the "Go To Portal Row" script step to accomplish this. However, although Filemaker is going to the desired portal row, it won't 'scroll' through the portal to bring this row to the top, with the result that it effectively does not go to the portal row. Does anyone have any thoughts?
-
- 4 replies
- 941 views
-
-
Here's what I want to do: For each record, I want a field in which I enter a number. I want a second field on the layout to keep a sum of all the numbers entered in the first field. I do not want this sum displayed across every record in the file...I want each record to have its own separate sum. I know this one has to be easy. Thanks in advance.
-
- 8 replies
- 1.2k views
-
-
I have defined a field as a radio button using a value list with the option checked "allow other..." I am trying to see if I can have the text entered into the "other" pop-up window display in another field. I can't seem to get it to work. I have made a temp solution but would prefer to have it work differently. See attached file for problem and my work-around so far. Radio_Button_Test.zip
-
- 2 replies
- 708 views
-
-
Ive made a test file with 2 valuelist... One with a Company Name and one with The State of the companys location. I have 2 company names in my test app Kmart and Sears. Kmart has 0 locations in my test and Sears has 3 NY NJ and FL. Heres my issue... Lets say I pick Sears as the company and Pick Location NJ. Then I pick Kmart (which has no location) NJ is still picked in the valuelist.. Is there a way to somehow clear the Location value list if the company changes? I attached a file too. Thanks alot. locationstest_2.fp7.zip
-
- 9 replies
- 1.2k views
-
-
What's the simplest way to set up and view the modification history of a record?
-
- 1 reply
- 871 views
-
-
Need someone to take following file and show me how to seperate it into 4 tables all on same page. I want it seperated by 10 days 30 days 60 days and 90 days. Thanks for the help Tony D. Careful_eval.zip
-
- 6 replies
- 1.1k views
-
-
How do I display a graphic as the result of a calculation? For instance, if the data in Field One is "Dog", I want to display a graphic of a dog in Field Two. If the data is "Cat", I want to display a graphic of a cat. If Field One is empty, then I don't want to display anything. Thanks.
-
- 2 replies
- 1k views
-
-
Hi, I have a sendmail script that needs to pull information from a value list and output the data into the sendmail messagebody. In this case, we will say the db is named "myDB" and the value list is named "myVL" and the values are "1st class" , "3rd class" , "Airmail" , "No Mail" I have a mail field that uses the checkbox format. Using the code I have, let's say the user selects "1st class" and "Airmail" In the message body using the sendmail feature, how do I pull "the checked data (in this case 1st class and Airmail") and post it into the message body. This is all I have so far. I spent too much time on this and am stumped. Thank: Trim…
-
- 2 replies
- 715 views
-
-
Again, im a newbee with FileMaker, but I do have some basic programming skills. What I'd like to do is: - I have a to-do-list in which when you've completed a task you click on a checkbox. - When the checkbox is clicked I would like the background to turn to grey. How would I create the code for this to happen? I assume that I would create a script then link the checkbox to the script, but I'm not exactly sure what I should be doing with the script...
-
- 10 replies
- 1.3k views
-
-
Hello, i am runnin FM 6.0, i am want to use conditional value list base on to list, they are Location and Year, the other field involve id call Program Name. The two DB are Students and Program. Basically, when a user choose the location, year, i want this other List to show all the program name base on that. example. if i have Austin, 2006, i want to see all the program name base on those. i got to work when i choose the city it show me all the program name base on that city, i need to break it down now by the year also. thank you. victor
-
- 1 reply
- 783 views
-
-
I have a scrolling text input field that has no limits placed on the amount of text the user can enter. I need to place the field on a report and specify that the field stretch vertically to accommodate the amount of text the user has entered so that nothing is clipped off in the printed report. Instructions I've read say to make the field as big as the largest amount of text the field may hold, but I don't know the largest amount. Could conceivably go for pages (users will be cutting/pasting into the field). Does FM8 have some sort of "auto-stretch" feature? Is there some sort of workaround to deal with cases like this? Thx.
-
- 3 replies
- 1.1k views
-
-
I want to elminate the Menu Bar. Is there posible with Customs Menú? I know Dacons Menú do it, but i´m not interested to buy a lot of licences of Menu Control only for that.
-
- 3 replies
- 1.6k views
-
-
I have an invoicing file with several fields (item number, description, unit price, extended price) in a portal. It can be automatically sorted by setting the "sort related records" in the portal relationship. But I want to set buttons above each heading, so that I can click on whichever heading, and the fields in the portal will be sorted by that heading, just like in table view. For example, clicking on the button for "item number" will cause the fields in the portal to be sorted according to item number. Likewise, clicking on the "description" button will cause the fields in the portal to be sorted by description. Does anyone know of a non-complicated way to d…
-
- 8 replies
- 1.1k views
-
-
I am a new user to filemaker and have used MS access extensively. I have a primary key of a table Called Dealer as a FK in a table called staff. Now, in Access you can have a FK in a table that can be a drop down (listing all the pk's from another table, but the value displayed to the user is another field from the fk's table), but when they make a selection from that field the matching pk from the same table should be selected in the background. I haven't found any help with this in the instructions that come with filemaker, the help is useless for this. I am wondering how I can do this in Filemaker, or is it even possible? There is no point in even having a…
-
- 4 replies
- 728 views
-
-
Im currently setting up a management system in which I enter in all my client information. I have setup different pages/tables for different information, Example: 'Project Info' / 'Task List' / 'Invoice' / Etc.. Now, at the top of each page i want to display the clients name which is entered in a field on the 'Project Info' page/table. How do i display that field on all the other pages/tables? I have actually got this to work, by using this code: <> EXAMPLE: <> This works fine, until i enter a new record on another page/table - Once i enter in a new record the Client name at the top of the page disappears. How can i make this work…
-
- 8 replies
- 837 views
-
-
OK, this may be impossible, but here goes. I have a layout where the user selects a radio button on a graphical layout to evaluate a student. The radio buttons are quite far apart, to fit into the pretty table design (See example here if the image doesn't show below) I originally managed to get the spacing of the radio buttons by putting a lot of spaces in the value list-- i.e., the value list looks like "1....","2.....", "3........", etc. (where the "...."s are actually spaces). Works fine, spreads the radio buttons out as needed to fit the layout. My problem comes when I try to import data into this file. The source file has the values of "1", "2",…
-
- 7 replies
- 2.4k views
-
-
I have two different layouts that I print just the records that have a tax amount. One tax amount is for one person and the other for another. When I go to print it shows that I have 244 records out of 1066 that have tax. I print that out and close the file. The other file has 99 records out of 1066 that has a tax amount. Now the problem is when I go to to my Full Inventory layout and click on the button, instead of showing me all 1066 records, it shows me 244 records out of the 1066 or 99 out of 1066,depending which tax file I just printed out. Here is the script I run for the tax file: Go to layout [Tax amount by seller" (rifles)] Perform Find [Restore…
-
- 12 replies
- 1k views
-
-
Hi, I am thinking of setting up value list based on field values, but I am not sure my procedure is correct, or even recommended. I do not like to allow users modification of standard FM value lists. My thoughts are: 1.- Create a ValueListNames (VLN) table. This table would hold the value list names. 2.- Create a ValueListData (VLD) table. This table would hold the values associated to the ValueListNames table. 3.- Link both tables using the VLN key, to allow me to create records in VLD linked to VLN. 4.- Create a layout in VLN with 2 portals. The first (portal1) one would be a self relationship to show all records in VLD. The second one (portal2) wou…
-
- 1 reply
- 741 views
-
-
Hi I'm wondering! Is it possible to delete a record in a portal if the contents of one of it's fields are deleted. I know how to do it via a script, but in this particular instance it would be much neater to do it via a calc. Flook
-
- 4 replies
- 742 views
-
-
Please assist: I have a few fields in the 'contacts' table: firstname lastname title phone number email I am not sure if i need a portal or just a layout function to do this. I would like to have a certain size window (with a scrollbar set at 700 pixels wide by 400 pixels high) to show the contacts associated with the particular company. I would like to be able to delete contacts and create new contacts as needed. i need it to display however many contacts are in the 'contacts' table. So if there are 20 records in the contacts table it needs to show the fields for all 20 records in this "window" (portal or layout). If there is only 1 recor…
-
- 2 replies
- 1.1k views
-
-
[color:red]Records from the ASA table are descriptions of required changes that our clients have given to us to change in each project. [color:blue]Records from the OPI table are descriptions of changes that our project managers have found and would like to implement into the project I am creating a layout in the ASA table and would like to also show records from the OPI table. I have tried creating a portal but I can not view it like I want to. I basically need to be able to see the ASA records in a LIST followed by the OPI records in a LIST. When viewed as Form...I can see one ASA record and all OPI records via a portal. When viewed as List...I can se…
-
- 2 replies
- 709 views
-
-
Ok Guys and Girls, Simple question. How do I show the First entry (the oldest) of a portal? IE: Date of Entry Description 1-2-05 Documents 1-5-04 Addendums What I want just to show up in a sept date field is 1-5-04. For reports. Oh, I do not want to resort the portal. Thank you, Joseph
-
- 5 replies
- 769 views
-
-
-
I'm sure this is simple, but it seems I haven't had enough coffee to see it.... On the main layout of a report form I have a Value List named TimeOfIncident for various school time periods-- value list values are Period 1, Period 2, etc. On a report layout I want to have a listing of how many records there are for each time period; I have a field defined for each period called Period1Count, Period2Count, etc. The report would show Period 1: 7 records Period 2: 2 records ...etc... - where the number shown is the value of Period1Count, etc. In English, the value of Period1Count equals the number of records where TimeOfIncident = "Period…
-
- 1 reply
- 763 views
-
-
Hello, I realize that my title seems a bit odd, but I don't know how else to describe the screen redraw problem I'm having on Windows (I develop on a Mac, which seems immune to this particular problem). I'm using FMP 8.0v1 Advanced. One example where this weird screen redraw occurs is deleting a portal row. I do the following when you click on a trash can icon in a portal row: 1) Call a delete script with the primary key as the script parameter. 2) Go to a behind-the-scenes layout and set a global key field to the script parameter. 3) Go to the actual record to delete via a GTRR step (using the global key field above) 4) Delete the record and…
-
- 7 replies
- 814 views
-
-
I've got a field formatted as a radio button which indicates which day of the week a student is registered for a class. Each class is registered separately in its own record. I'm trying to find to show all of the days a student has registered for a class. This database has a class table, student table and a separate table to hold registration records. Any help would be appreciated!
-
- 4 replies
- 674 views
-
-
Hello all, I really apreciate all the help I can get... Every database I am working with, I end up in the same problem and here is one of them ... I cannot get the description displayed from the invoice file... what am i doing wrong? thank you in advance :... 1.zip
-
- 5 replies
- 996 views
-
-
I have a table of patients that has a 1:many relationship to many tables. each patient has many medications, many lab values , many visits etc. I have a layout for each of these and the data is displayed in a single portal for each. This works great for entering data and viewing data. I would like to print a summary sheet for each patient with limited data. for example patient name at the top and below it show only active medications, last month of lab values (or last 4 values), and last month of visits. I can isolate the data by relationships (limit meds to active, limit labs to current date-30 etc) and put 3 or 4 portals on the summary sheet but this is no…
-
- 0 replies
- 828 views
-
-
In case anyone is interested, Dacons just released version 3.0, which is compatible with Filemaker 8.0. Steve
-
- 10 replies
- 2.6k views
-
-
Is there a way to freeze the portal so you can exit, do a script, and then return the same spot you were in previously? I have scripted it so that I can leave the portal and then return to the previously selected record, but the record always shows up at the bottom of the list and the user has to reorient themselves to the data. Is there a better way?
-
- 6 replies
- 1.5k views
-
-
Hi, anyway to display a value list in a custom menu, where there selection runs a script based on the selection? Thanks, Andrew
-
- 2 replies
- 1.4k views
-
-
Is there any way that you can implement a timetable into a database, for example there are Cust. Details, Lesson Details tables and i want to show the name of the customer and the time the lesson starts anf finish on a weekly timetable sheet then can be printed off??? also can you put buttons into table views? any help will be greatly appreciated!
-
- 2 replies
- 845 views
-
-
I have a database of several hundred names (local) and need get addresses. I expect that most names can be found in on-line directores such as anywho.com or whitepages.com. Is there any way I can query directories like that and pull down matching addresses? And if so, how? Thanks!
-
- 2 replies
- 1k views
-
-
Hi, I have a portal that displays all the shirts owned by a customer. I'd like to add some filtering controls above the portal display; for example, a "color dropdown" -- if the user selects "red" and presses the "filter" button, the poral will only show his red shirts. This is easy enough when the color filter is populated, but when it is empty I want filemaker to essentially ignore the shirt color part of the relationship. Right now, if it is empty it will only display records with an empty shirt color. This is something that would normally done through a record list outside of a portal, unfortunately we have to display a lot of data on this page so it…
-
- 7 replies
- 1.1k views
-
-
I am selecting one of four named products through four buttons on a layout in the "Selection" file. Selecting a product using one of the buttons creates a record in the "Items-Ordered" file. These records are then displayed via a portal in the Selection file layout. The Items-Ordered records contain option fields which are effected by check boxes that appear in the portal on the entry layout of the Selection file. (The numerical values in these fields are the actual costs of the options selected) Each record of the Items-Ordered file has a calculation field, called Cost, that is the sum of numerical values in the various option fields. And there a…
-
- 5 replies
- 892 views
-
-
I imagine there's a way to build a printable layout that has one set of data in the first page header and footer, but different data on subsequent pages. I have a sign-in sheet that is constructed weekly for multiple locations at a time. The basic data works out well, but I cannot figure out how to get overall stuff (Date, location, total number of names) to display on the first sheet, and column headings ("Name", "Expiration", "Signature") to display on all pages (both the first and subsequent pages) I was thinking about trying to create a set of fields that use some sort of calculation like: if[get(PageNumber) < 2; MyField;""] (I am using <2 becau…
-
- 1 reply
- 674 views
-
-
Hi all, For this project I'm working with Filemaker6 I have a text field that I use as password field. Users type their password and when they press enter a new lines comes up in the text field. I would like to get that if they press enter it run a script or move to a button, is it possible? Regards
-
- 1 reply
- 701 views
-
-
Hi all. Please be gentle...this is my first post... First of all, I apologize if this isn't the right place for this question, but I couldn't find a more suitable place. But let me (try to) explain: I have all my classical music cd's in filemaker. I make a record for each piece that a cd contains and I give a number to each CD. Example: CD nº200 has 3 pieces: no.1, no.2 and no.3. The CD also has a name: example: "Mozart - complete piano sonatas". In that way, I have a record for piece No.1 (with several details like tracks, date, durations, etc) and another for piece no.2, no.3 and so on. Now...I want to produce a report that is able to recognize th…
-
- 2 replies
- 782 views
-
-
I know this has been answered before but I could not find it in my searching. I create a portal and I place a button in the portal. How do I prevent a blank portal row with just the button?
-
- 2 replies
- 690 views
-
-
I have a valuelist that u choose a value from and then push a button that triggers a script. Then later in the script I copy that value from the field but then the valuelist drops down again and that takes time, can I avoid that in some way? Regards Jocke
-
- 1 reply
- 653 views
-
-
How do I make 1 value list based on the results of 2 portals?
-
- 11 replies
- 1.3k views
-
-
Hi, I thought I had this tucked under my belt but seem to be having a problem! I have a layout based on tbl_Quote and when I input a company code I want to be able to choose a Job No which is related to that company. I've attached my relationship diagram and the value list dialogue box. Incidentally, I'm using a trial upgrade to Pro 8 until the CD arrives - just can't wait. Many thanks in advance. Quote_Job_No.pdf Quote_Relationship.pdf
-
- 6 replies
- 1.1k views
-
-
OK, this has been driving me a little nuts; I think I have uncovered a bug in FileMaker 7. I am working on a Time Tracking module, and several of my scripts use the Go to Portal Row script step. Some of my scripts use the steps in creating a new related record (by going to the last portal row), and some simply go to the first or last portal row and modify or clear a time. Sometimes, for no obvious reason, FileMaker fails to enter the portal, and inserting a Custom Dialog check after it should be on the correct portal row results in the Get(CurrentPortalRow) = 0. Has anyone else run into this? I can't think of anything I'm doing wrong; the file I'm working…
-
- 2 replies
- 801 views
-
-
I have inserted the "date symbol" into a layout and have formatted the date to be of the "November 1, 2005" format. In preview and browse modes, and when I print the date appears as "November *, ****" Where the asteriks are really rectangular boxes. The text field is plenty big to show the whole date. Has anybody else had this problem or know how to fix it? Thanks
-
- 1 reply
- 722 views
-
-
I have set up a conditional value list for the attached file. There are three fields, Country, State and City. When users select a value in Country, the available values in State will show up, and when users select a value in State, the available values in City will show up. This works for countries containing values for all three fields. But problems exist for countries with no value for State. For example, when users select France in Country, no value shows up in State and in City as well. But I want cities of France to show up in City. Is there a way to do that? Thanks in advance for any input. test.zip
-
- 3 replies
- 991 views
-
-
Hello fellow filemakers, Is it possible to omit a portal row record? I tried the omit option and it omitted my entire invoice. The issue is some customers we bill are on different payment plans. Some we bill only once every 3 months, some we bill only twice a year, and some we bill every month. The problem is that only some of the line items on an invoice will be billed later, and I'm not sure how to do this. Any ideas?:)
-
- 6 replies
- 1.3k views
-
-
I have three relationships built into my file to three different databases but I need them to pull the customer from the first file if not there then pull the customer from the second file and if not there then the third file. How do I define the field in my original file to look in all three places accordingly?
-
- 1 reply
- 599 views
-
-
I am building an image catalog and I have an image view layout. I also have an artist view layout with artist info a portal to the image table displaying all images by that artist. The artist information and the Image information are separate tables. I would like to be able to click on a particular image in the portal in the artist layout, and be taken to the record for that image from the image table in the image layout. Please advice on how to do this or any alternative ideas. Thanks
-
- 6 replies
- 1.1k views
-
-
Hello, Here's the situation (fmp6). 3 tables: [color:blue]orders,products and product_lines. In product_lines I have a field [color:blue]number (=nr of products sold) Products has a calculated field [color:blue]nr_sold which sums the field [color:blue]number in product_lines where id_product=foreign key product in product_lines. In the table [color:blue]orders I need a portal which will show me the top-10 of sold products. Tried showing the products with [color:blue]nr_sold in descending order but the portal shows all records of products (of course) and takes to much time to load. I know this would be an easy one in fmp7 (or 8) but how do I solv…
-
- 2 replies
- 912 views
-
-
Im currently creating my own database and want to copy the layout of the standard 'to do list' layout. Now, im guessing there's no way of just copying it straight across, so im re-creating the whole thing in my own way. THIS IS WHERE I GET STUCK.. I want to copy the way you add a new record.. So when you click on a new record it appears with the new record below the current record, and each time you click on a new record it appears under the current record, so it creates a list of tasks. So it looks like this: --------- Record 1 --------- Record 2 --------- Record 3 --------- Etc.. --------- I have no idea how to do this, im sure i…
-
- 1 reply
- 671 views
-
-
Maybe a silly question, but I'm just a beginner. How do you simply filter through a portal? Let me give you an example. I have 60 employees whose job changes each month. In the month of July, I need only 2 people to "wash cars". How do I create a portal with the following results: search all 60 employees and return only the names of those who "wash cars" in the month of July? In this same month, I need 6 people "painting the fence". So I want to create another portal, but this time search all 60 employees and return just those names of employees who are "painting the fence". Make sense? Any help is appreciated! jz
-
- 2 replies
- 773 views
-
-
OK, so I have read most of the posts regarding the new tab control panel in FileMaker 8 and I agree that it is currently lacking some of the finer things in development life. Most of those things have work arounds which, though solve the issue, are not the way most developers want to solve any issue. I seem to have stumbled upon something that hasn't been mentioned yet, at least not that I have seen.... I have a single layout with a tab control panel that has two tabs. On tab one is a single field I will call, "Text1". On tab two is the same field in a portal. In essence, I am giving my users the ability to view single related records(Tab 1) or all relat…
-
- 12 replies
- 2.2k views
-
-
Ok, this is a tough one (at least, for me). I currently have a "menu bar" which is actually a portal with a record for each task/layout I want to access. The rows are buttoned such that clicking on the row in question will activate a multiscript with the parameter defined by the related record. That part works fine. Now, I would like to add tool tips to the menu, and this is where things get sticky. As far as I know, there is no equivalent of "MouseOver" in Filemaker, and of course I can't just put Menu::ToolTip in the tooltip calc because I haven't actually SELECTED the record in question yet. Is there anything I can do to get this to work? Thanks muchly! …
-
- 3 replies
- 1.8k views
-
-
I know how to filter a portal list based on multiple fields. My question is, How do you filter a portal if you only want one value from one of the multiple fields? For example: I have a table called Cards with four fields. Call them 1,2,3,and 4. I have another table called Collection with one field. Call the field "style" What I want is to create a portal in the collection table that will show all the records from the cards table that matches the value in the style field. For example, if I typed creature in the style field in the collection table, I want the portal to show any record in the cards table with the word creature is in fields 1,2,3, or 4. I can…
-
- 3 replies
- 736 views
-
Recently Browsing 0
- No registered users viewing this page.