FileMaker Interface Features
-
Hello People! I was wondering if any one has accomplished to use this approach? - Check boxes in a field that has a vartical scroll? Basically, I need to have a multimple selections (in a portal row) for a signle record entry: eg. ------------portal------------------------------------- Worker| Products Used| [Jack] [ glue,tile,saw blades] ------------------------------------------------------ the reason for need of a vertical scroll is because the Products list is quite long (200+ records) any thoughts? Thank you all!
-
- 0 replies
- 830 views
-
-
Hi, I have a FM database and would like to create a value list so that when I click on it I can select a colour, for exmample the field is called Priority, I would like to click on it and select a red or blue box. Is this possible? Thanks in advance. Chris.
-
- 1 reply
- 840 views
-
-
-
i am interested in creating a flash screen for when someone opens their db. however, when fmp is currently opened from being closed (it's usually kept open most of the time) the filemaker pro flash screen comes up, and i don't want users to have to sit thru 2 flash screens if i can make one of them my own, with the company logo etc... does anyone know of a way to turn off the default flash screen? thanks in advance...
-
- 1 reply
- 837 views
-
-
I have a single file called driver_cards. There is one field in the file named "driverName". In one layout I have the field setup for manual entry. In another layout I have the field formatted as a drop-down list pulling from a value list called "Driver Names". The value list is pulling from the field "driverName" without a relationship. The problem is that in the drop-down menu the last entry keeps deleting itself and I have no idea why. Clicking on the last item deletes the value. Here's what I'd like to accomplish. I would like a file that lets me create 'customized' business cards. I would like to add names to a list and then be able to choose a spe…
-
- 1 reply
- 859 views
-
-
Hello Here is some new info from 1 day of trial and error and 2 min FM tech support (I wish they did weekends!): I am trying to validate a portal field using a calculation that sums the value of same field over the number of records created in the portal (using a self-join relationship). SPecifically, I enter a percent in each record, and the sum of all the percents must be 100. The calculation doesn't occur until after the portal record changed or portal exited, so validation doesn't occur properly. FM says only by using a script (hence, an uwieldy button) can I get this to work. I found another ugly workaround: I validate from another porta…
-
- 2 replies
- 754 views
-
-
Hello! I was wondering if it was possible within FileMakerPro 6 to activate a script upon selection of an item from a pulldown list. Thanks!
-
- 5 replies
- 947 views
-
-
Hi, I try to insert data from partent field into Portal row but not working. Setfield["Portal::field1": "Field2"] Anybody knows why ? Thanks Henry
-
- 2 replies
- 677 views
-
-
i know there's a way (and how to do it) to count the total number of rows in a portal. is there a way to actually number the rows, like place the number of the row to the left (or right) of the actual portal? thanks in advance... josh
-
- 3 replies
- 1k views
-
-
Hi all, Does FM support skins? Can i design a look for an app that would completely change the look of FM and even get rid of the FM splash screen? Thanks --Dan
-
- 5 replies
- 1.1k views
-
-
Hi, I have a database called People, with contact info on members of my group. I also have a database called Organizations, with info on orgs. that we works with, such as businesses, churches, etc. Each person in People has a unique ID number, and each Organization in Organizations has a unique ID number. I want to be able to relate People to Organizations. So I have a pop-up list so that the church they attend can be entered. The pop-up list is populated with the Organizations. The problem is if I have different organizations with the same name. For example, we have 4 organizaitons called St. Mary's Church in the Organizations database. I might exp…
-
- 4 replies
- 909 views
-
-
Hello All, Please help.. I just want to make a simple portal in my email DB thats shows the emailaddress field of all found records in my main DB.... I'm just not Getting it... Thx, Erick
-
- 4 replies
- 1.1k views
-
-
Hi All, i think the gremlin says it all!! i need to print out (A3 Landscape) a report layout i have. problem is that it is wider than A3 so what i want to do is print the full lot (width) on several A3 Pages. eg. the width is 3, A3 pages wide but it only prints 1, A3 page wide! it's ok at printing down e.g. prints all records but wont print out all the fields across the report! can soemone please tell me what im doing wrong? thanks in advance
-
- 0 replies
- 687 views
-
-
I am a new user to FileMaker Pro, so please forgive the novice-type question. But I could use help from bigger brains than mine. I'll try to give plenty of details (maybe too much). Background: I built a project tracking database. It relates to "Project Line Items" db which I have placed in a portal window. Since I work on multiple projects each day I move from record to record inputting the time spent on each task for each project. I look up the task description and the hourly rate charges from another database called "Inventory". I probably have 30 or so task items there. Overall everything works great. The Challenge: When a project is completed I ne…
-
- 2 replies
- 745 views
-
-
In one of my db's, the Align option in the Arrangement menu is greyed out. I've checked and re-checked the passwords and groups but have not been able to find the magic step that re-enables it. Anything I'm missing?
-
- 3 replies
- 958 views
-
-
Everyone has been great so far, so lets see if anyone has an answer to this quandry. I am wanting to set a field to display a value list depending on the selection of another list. Example follows: First value list drop down. (List name="cat") (Field name on layout="category") CATEGORY:{1. FIRE CALL, 2. EMS CALL, 3. HAZMAT CALL} Now on selection of that field (field name="catagory") I want it to display one of these value list accordingly in a drop down in the next field (field name="subcategory") List of Value lists to choose from (i.e. If "category"=1. FIRE CALL, then display value list FIRE in field name "subcategory", and so on) FIRE:{101. HOUSE FIRE,…
-
- 2 replies
- 821 views
-
-
Hello People! I need a little help with a value list...and I am sure this was asked before I just didn't know how to format the question. So please forgive me if this is double post. here is what I managed to get to work in the list: ----------- 1 James 2 Smith 3 Rollings ------------ etc... where user can "see" both values drop and only numbers are entered in the field as an actual value. Now, the headacke part came about when I tried to generate another (Measurements) list as shown: 0.0625 ___1/16 0.125 ____1/8 0.25 _____1/4 0.5 ______1/2 1 ________1 I would like users to see the ratios but enter decimals since it (the eneterd numbers)…
-
- 8 replies
- 884 views
-
-
Hi, Is there a way to specify horizontal scroll bar for a portal? If not is there a workaround? What I can do if i need to place in a portal fields which total width exceed the width of the portal? Thank you for the help in advance!
-
- 4 replies
- 989 views
-
-
will the portal (relationship) speed slow down when a certain number of records reside within the parent database? thanks in advance.
-
- 3 replies
- 764 views
-
-
I need to sort a value list in reverse order of one of the displayed (numeric) fields, but there appears to be no native funtion in FM (v5) to do this. Obviously, I could create a calculated field with a *-1 version of the original field and use that, but that field would then have to be displayed (a bit ugly). And as the list is to be used to insert a value into a field, I will then have to re-calc to get the correct value in. Does anyone know of a more elegant solution? Thanks Clem (still [fairly] new to Filemaker - so be gentle with me)
-
- 3 replies
- 1.1k views
-
-
Hi All, i have 3 portals on my layout and when i print they look err not very good!! any one experienced this? any solutions? thanks in advance.
-
- 2 replies
- 763 views
-
-
Coming from the world of web page design, I was wondering if there is a way to make an object on a layout in a filemaker database center to the window size, whether it is in a small window or maximized. This would be a great help on trying to make something work for cross-monitor resolution problems, whethere someone is using 800x600 or 1024x768. If anyone has any answers to this problem, PLEASE let me know.
-
- 3 replies
- 935 views
-
-
Why is it that FMP for Windows will only let me use arial, courier, courier new, ms sans serif, ms serif, and times new roman? On my mac, I have access to all the installed fonts. I understand that there are cross platform issues with using strange fonts, but is there some way of making FMP see all my fonts under windows? The oddball fonts are only going to be used on one layout for printing Thanks
-
- 5 replies
- 1.2k views
-
-
Hi everybody, I would like to know how to link data I enter on a portal in a record with another record with the same fields and portal. For example: The first and second records have same: - 2 portals format with relationships water quality, water quality_1 - 2 Fields (parameter) format with popup menu using same value list (including some parameters like BOD, COD...) - 2 fields (value) using relationship water quality, water quality_1 - 2 fields (unit) using relationship water quality, water quality_1 These fields will distribute into 2 portals: Influent portal Effluent portal parameter value unit parameter value1 un…
-
- 9 replies
- 865 views
-
-
Hi All, i have 3 portals on one of my layouts. each showing 4 portal rows. i have embossed and coloured the fields white and the portal colour is grey. when i print, the first row prints out in grey (on all portals) but shows the embossed effect, but the remaining 3 print out in white (the colour of the field) but the first field (furthest to the left) is half grey and half white and also the 3 remaining fields are overlapping with the colour of the field (WHITE) !! is there a simple way to print layouts with portals on them? to print out how they look on screen? thanks, ricardo
-
- 0 replies
- 598 views
-
-
Hi guys, I have a Parent db and a child db. I created a child portal in the parent db, so that I can see multiple children for one parent. The children have some fields in them, that are calculated fields. Now I'm trying to define a sort in the relationship needed for creating the portal, but the sort should be on a calculated field. For some reason, the sort seems to be random. Do you guys know if a sort on a calculated field is possible inside a portal? Thanks! I know this is a hard one.
-
- 16 replies
- 1.3k views
-
-
Portal Filtering?? I'm loosing my hair rapidly
-
- 2 replies
- 700 views
-
-
I have three source files - Lodging, Dining, and Activities. When a new customer requires a custom travel package I want to select entries from each via a pop-up list and copy the contents of the record(s) to the customer package files. I can effect the pop-up selections but am having trouble building the customer's package db. customer is related to pkg by customerid. Pkg is related to the three sub-files - custlodging etc. - by customerid and pkgid. The field structure in the customer pkg files is identical to the source file structure with additional fields allowing for dates et. al. Any help is much appreciated. Thanks Mike Griffin
-
- 4 replies
- 789 views
-
-
Hi All, I plan to make a value list depend on relationship but it gives me 2 choices to search for value list. Let's me clear it out. I have State and city MA Boston If people type only MA , it shows up MA and all cities in MA and correspondent information , but if they type MA and Boston , it shows only MA and Boston city and correspondent information. With my knowledge, value list depends only one relationship, it does not base on 2 relationships. Anyone has that problem before? Thanks Anh Tran
-
- 14 replies
- 1.3k views
-
-
Hi there, Does somebody know why, on some workstations, a big pop-up-menu is shown as multiple lists next to each other and on another workstation there are up and down arrows at the top or the visible end of the menu's? The OS is NT4, FMPro 5.5 via FMServer. It's really the same database my clients are opening, but the layout of the pop-up-menu differ... Many thanks!
-
- 2 replies
- 656 views
-
-
I have a cabinet shop. I am building a questionaire for my customers. The questions that I ask these people all have "allowable" answers, which we select from a drop down value list. The next question is always a function of the answer to the previous question. For example: We ask if you want painted cabinets or stained natural wood. If you select paint we don't ask any questions that might be attendant to wood grain expectations. Similarly if you select stain grade we don't ask you if you will be brush painting the final coat. Right now each value list drops down for selections. At all times the previous and next question is visible on the question…
-
- 2 replies
- 757 views
-
-
Guys, is there a script step to insert a record into a portal? Here's what I want to do: When one person clicks on an item in a portal on the right, that item should be inserted into the portal on the left. (There are two portals to two different files on my layout) Any ideas?
-
- 2 replies
- 807 views
-
-
Can I use scripts to control the properties and presence/absence of layout elements such as buttons, fields and text? For example say I needed to have "SendReminder" button to appear only when overDue>1. If overDue = 0 the button should not appear the layout. How would I go about that? -ilya
-
- 1 reply
- 732 views
-
-
Hi, I want to create a master file with 2 key fields and related file with the same 2 key fields. For one master record there will be more than one record in the related file. When I add new records in the related file I want to populate the key fields in the related file with the values of the key fields of the master file. I don
-
- 3 replies
- 975 views
-
-
I'm wanting to write a script that will go down each portal row (which btw has only 1 field) and take that information and put it into a text field. For some reason I can't get it to work. Go to Portal Row [First] Loop Insert Calculated Result ["Test", "ActiveMembers::LaosName & "[Paragraph Symbol]"] Go to Portal Row [Exit after last, Next] End Loop What happens is that the content from the field "LaosName" inserted into field "Test" in an endless loop. Any suggestions would be helpful. -Dave
-
- 1 reply
- 872 views
-
-
I have a portal on a layout in my database. When a user clicks a button on the layout, I would like a certain record to be displayed, and a particular row of the portal to be selected. I can do this, no problem. The problem I have is when the user clicks on a field outside the portal after having clicked the button, I would like that portal row to remain selected. Instead, the portal jumps up to the first row. Anyone have any ideas on how I can get around this? Thanks, Spencer
-
- 1 reply
- 672 views
-
-
Hello all, In Mac OS 9 FM 5.5, I had a solution set up to manage my ebay auctions. It used two plug-ins. 1) Dacons mail.it (http://www.dacons.net/fmplugins/mailit/index.html) 2) Waves In Motions "oAzium Portal Filter" (http://wmotion.com/portalfilter.html) QUICK OVERVIEW OF SOLUTION 1) ebay_Items_For_Sale.fp5 - Related Field: ebay_item_number - sample data: 1018045107 2) inbox.fp5 - Related Field: ebay_item_number - sample data: eBay End of Auction - Item # 1018045107 (SCSI 10gb Drive) Simply put, I used "oAzium Portal Filter" to create a relationship between the "ebay_ite…
-
- 5 replies
- 983 views
-
-
Checkboxes are always [X] Value can I make them Value [X] ?
-
- 1 reply
- 719 views
-
-
hey all, i keep getting this error message when trying to relate one file to another: "This lookup uses the field "Company Name" in its definition. Choose another field." I'm trying to make it so that when i choose the name of a company in one file, it reads in the companies info from another file... any ideas? ~lutfi
-
- 0 replies
- 761 views
-
-
Hi, I have been donated a relational database which contains information about all of our staff. Each staff member has a Staff ID. There is a relationship between this database and a database conataining all staff publications. In the latter database, each publication has a list of authors (as a repeating field) with their corresponding staff number (as a repeating field). The relationship exists between the staff numbers. My problem lies in the fact that, on our website, we have a page where a user can pull up the details of a particular staff member, and listed at the bottom of the page, thanks to a portal, is a list of all publications that person was an author (o…
-
- 0 replies
- 704 views
-
-
Hello, After importing some excel files I get a place-name field which is the first three letters of place names; there are about 50 in all. What would be the best way to store a list of the full names, and have them automatically displayed based on the initial three letters, or do I have to lookup an 'If' formula with 50 possibilities?? Glenn
-
- 5 replies
- 943 views
-
-
hello, this is my first week using FileMaker 5.5 at my company. i'm trying to make a database for my company's older/antiquated system. i need a little help with what seems like a simple solution. i have a file about a certain customer that has done busines with our company many times; this customer has specific PO numbers for every job request he has made with us. all PO numbers in our database are to be ordered sequentially (1, 2, 3, etc...). that's easy to do. but how do i do PO numbers sequentially if i have multiple customers who don't necessarily 'take turns' doing business with us; i.e. customerA requests two jobs, then customerB requests one job, then cus…
-
- 0 replies
- 787 views
-
-
I use Geneva 9pt and 10pt as my main text and Verdana for cases where I have limited width (in portals for example) and have some line entries returning a Bold entry. I use a Mac. Is Geneva cross-platform and does it use the same percentage of field space on a Pc and Mac? From some little knowledge of web page design I seem to recall 9points on a PC is about 20% bigger on a PC. Is this correct? Pete
-
- 7 replies
- 1.3k views
-
-
Hi all - i am new to FM so please forgive ... I have three dbs; product, productnotes, notetypes. The product db has two layouts; a product definition and then notes. The notes are dynamic, depending upon which note type is selected, I want to insert a row into the product notes db (i.e. prodno, notetype, notetext). I setup portal to display all available notetypes (selfjoin), and a portal to display the note (product to productnotes). Everything works for the first note selected - the prodno, notetype and notetext get inserted - but if I select another notetype, I am getting, just the prodno, but no typetype to insert? Any help is apreciated - thanks
-
- 0 replies
- 704 views
-
-
> Finally, if you perform relational find (thru portal or not) on more than one > related fields, in other words an AND find, you will get every PARENT record > (if any) with CHILD records that have ALL requested values but not necessarily > in SAME record. If you find this "UNEXPECTED", than you are still thinking > that you were searching for CHILD records. I just found this out the hard way. It really stinks. Why would anyone want it to work like that? Since I'm not using FMP 6 yet, can anyone tell me whether "constrain found set" would help in this situation? Search in a portal field, then search in another portal field on that foun…
-
- 0 replies
- 980 views
-
-
OK, I've tried searching old posts for the answer to my question, and I have now ruined my eyesight. I'm going to try a new post. This should be a cinch - but it's making me crazy. I have a donor database in which I want to enter new donations and have each donation be a separate record in a related database, attached to a unique serial number for each donor. I had it working for a bit - but each record in the donations database was being assigned a new serial number instead of the actual donor's serial number. In an attempt to fix it, I am now getting a message when I try to enter anything into one of the donation fields in the portal "This field cannot be modified …
-
- 1 reply
- 874 views
-
-
I have a portal, that links through to transaction records. If I add a new record to the transactions database directly, (ie withou the portal) then the auto-entry date works fine. But, if I enter the new record within the portal, no auto-enter works. Any clues as to why?
-
- 2 replies
- 814 views
-
-
I'm doing some porting from Q&A 4 to FileMaker Pro 6 and am having trouble duplicating a report in Q&A I have this: Category SubCategory SubSubCategory I a 1 2 b 11 12 II c 21 22 III e 41 f 51 52 In FMP I get Category SubCategory SubSubCategory I a 1 I a 2 I b 11 I b 12 II c 21 II c 22 III e 41 III f 51 III f 52 Will FMP do what Q&A does? I messed with the "report with grouped data" in the report wizard and the resulting subsummary parts, but I can't make it look like I want. Thoughts?
-
- 1 reply
- 726 views
-
-
So, I've been reading and reading and reading all the portal filtering posts. Somewhere along the line I must be missing something and I'm hoping someone can let me know what it is. I've got two files: user.fp5 and jobs.fp5. What I'm trying to do: filter my users by usertype to show only certain classifications of users in certain fields in the job file. I have the users in user.fp5 defined as one of about 5 values in a value list using a pop-up menu: designer, copywriter, etc. The field name is user_type In jobs.fp5 I've created a global field, designer_id that contains designer as its value and a relationship using that global field and user_type. I'…
-
- 11 replies
- 1.1k views
-
-
Hi, this is my problem, I hope someone can help me out. I have the "Customers" database which contains basic info of my customers including "Last Name" and "First Name" and a calculated field "Full name" which is = "First name" & " " & "Last Name". So far no problems. I have other database called "Visits" to record every visit to my customers. In that database I have a field "Customer" and in the form I choose to have a pop up list to select the customer's name from the "Full Name" field in the "Customers" db. Now, here's the problem: from 60 available customers the pop up list only shows 3!!! What am I doing wrong? Please, any help would be very welcome. Tha…
-
- 3 replies
- 861 views
-
-
Same question as before but with simplified example...using two tables. wo_test inv_test ------- -------- techname techname serialnum serialnum stockdate usedate I enter "techname" , "stockdate", and "serialnum" into inv_test. My technicians use wo_test. I only want the technicians to see "serialnum" for their matching "techname" and only when "usedate" is empty. I created a relationship: techname=inv_test:techname which displays only the "serialnum" matching "techname" which if fine - but I need to filter out all "serialnum" records that have a "usedate".
-
- 2 replies
- 749 views
-
-
I have two fields, front and back. I don't have the ability to do duplex printing, so i already know that i'll have to print all the fronts, and then print all the backs, no biggie. Also know that i'll have to swap the left and right sides to make them match. But how do i create this in a layout? Should i use the label cretor, or somethign else? Thanks
-
- 3 replies
- 1.4k views
-
-
I want to create a calc or script that lets me put a number in one field and a corresponding value list of 3 or 4 choices shows up in a second field. For example: I have a field called grade. If grade 1 is picked than the values B5,B6, and B7 come up in a field "Room #" when clicked (drop box). When someone picks or find "Grade 2" then a new value list of B2, B3, B4, and B8 would come up as a choice in "Room#". I have 6 grades and 6 different value list. Thank You Lesterd [email protected]
-
- 3 replies
- 880 views
-
-
Hello, I have a big checkbox list that get's its content from a field in another database. This list refreshes whenever the user clicks anywhere or does anything, and it takes a few seconds for the list to refresh. How can I speed the refresh up? Like only refresh when the database is first opened. It is really annoying waiting a few seconds between each click. Regards, Evan C
-
- 5 replies
- 1.5k views
-
-
i must be a little dense i have tried to figure out by reading a few of the post heres about using global fields to do finds but i just dont seem to get it. I have a portal with a selfrelationship using a calculation field which =1 as a key now everthing works as far as the portal is concered everthing shows up in the portal but when i do a find for a perticular name say john i shows me all of the records including john,bob,querbet, etc i just want to see the records i did a search for what am i doing wrong is it in my relationship or do i need to use this global field that i keep reading about and if so how do i implement it can some help me with some advice than…
-
- 2 replies
- 830 views
-
-
I am an FMP newbie trying to create a database to track inventory and work orders for a group of field techs. I have created two files, inventory and workorder. The inventory file has: "serial number", "stock date", "pull date", "tech name", and "useage date" fields. The workorder file has "tech name", "serial number" and many other fields. I enter equipment into the inventory db once a week, entering "serial number" and "stock date". The techs come into the shop and update the record, entering "tech name" and "pull date" when they stock their trucks. Once they actually install the equipment for a customer, they need to enter workorder info. I want the "serial number" fie…
-
- 0 replies
- 624 views
-
-
When doing a search on certain fields inside a portal, most of the finds take much longer than they should. Finds that would be instantaneous if done directly from the related database take 30-60 seconds, with a lengthy "processing field..." progress bar showing up. And yet other finds in the portal, depending on the fields used and the content of the search, will execute in no time. I've tried indexing all the fields, that was the first thing I tried. Is there anything I can do about it? The portal is in a database of about 7,000 records, with the related database being about 10,000 records (but with much less data per record than the parent database). I have a sepa…
-
- 1 reply
- 714 views
-
-
I defined a value list (valListA) in FileA with the Use values from field: option. The field I chose to populate the list is in a different file (FileB). I also defined a field in FileA that is formatted as a pop-up list and uses valListA to display values. The odd thing is that I am getting some extraneous blank entries in the pop-up list. There are no blank records or fields in FileB. So then, I put a portal on the FileA layout and inserted the same field as valListA into the portal. There are no blank entries in the portal. Needless to say I'm a bit mystified. Why are there extaneous blank entries in the pop-up list? Thanks The Mad Jammer And then..…
-
- 5 replies
- 1.1k views
-
-
Labels usually print the left column and then the right column. How can i reverse this?
-
- 1 reply
- 717 views
-
-
Dear all, I have a problem with the portal now. I want to show the "explanation" of a process from "Process" file on a portal of main file and I also want to show "images" of selected process from "Process" file if I click on the field "process type" with field format is popup menu in a "Main file". Here is the detail of database Main file: 01 Field to select process type to show basic information of the process or to show images of the process 02 Field to select process type to jump to data_input/data_browsing pages for the selected process. Process file: Explanation of each treatment process (Activated sludge, trickling filter...) 01-Process type …
-
- 6 replies
- 844 views
-
-
Hello, I'm new to filemaker and have a problem I can't seem to solve. I have a fairly normalized db using numerical 'IDs' as the primary keys. Specifically, my problem is that I have a file for info about people,i.e., age,sex,haircolor,etc. This is file 'tblpersons'. It has a field 'HairColor_ID'. Then in tblhaircolors is both 'HairColor_ID' and 'HairColor'. So I define a related value list in the layout of 'tblperson' where I need to select the hair color from. I can get the list to display both the HairColor_ID and HairColor such as: 1 black 2 blonde 3 red Problem is that once selected, the field only shows the numb…
-
- 3 replies
- 991 views
-
-
Hello All I would like to find a formula that would allow me to take a value list i.e. "Colors" and get random item from that value list and deliver it to a field. Can someone help me with this? Value list "Colors" RED Orange yellow green Blue Violet Returns the random of the above list. ( "yellow " for example) Value list field, "Colorfield" File - "NewFile" Please can someone show me a fool proof efficent way to set this up. I would have a lot of uses to do this with value lists. Thanks again harty
-
- 36 replies
- 5.7k views
-
-
Can somebody give me a check list of possible problems. I'm a novice but have used portals on seveal other forms and this one is a problem. PackageMain.db5 has Packagedetail.db5 relationship by packagenumber. I've opened a portal in PackageMain to Packagedetail, dragged the fields I want into the portal but when I go to browse mode I click on the portal and can not get into fields. Almost like it they are not there (but the portal is):
-
- 3 replies
- 760 views
-
-
Hi there, Now i am creating a system just a bit same like the example that given by filemaker , which name: relation, is an office management system, which can keep tract of product record and also can create invoice. But i found that the example given got a problem, just in invoice entry screen, i can add in product record in the portal, but if i add in too much record, it will only show the first 20-30 item in printing(preview mode) screen, it will not made it into 2 or more pages. It is quite a big problem because not all invoice only need one page, sometime it also need more than 1 page. So is there got any way to solve this problem ? henry
-
- 1 reply
- 829 views
-
-
Hello, Here is what I have. Serial # db and Purchasing db. Layout in purchasing has a portal that shows me units in stock, units in process, Units out on loan. The info in the portal changes depending on what I select in the pop up global field. Ex: Select "in Process" I see units in process, select "In Stock" I see units in stock. That all works fine. I want to see a count of each different unit in the portal. Ex: MSMP is the beginning of one of our units serial numbers. I have a calc field in the main file which adds a 1 if MSMP is at the beginning of the serial #(I'm using this field to get the sum of MSMP in the Purchasing db). Now if I choose "In Process in the…
-
- 3 replies
- 964 views
-
-
Hello From Brazil, I am developing a database for a gas station. As the clients finish fueling their cars, records are created and information regarding their fueling such as (total price, type of fuel, price per liter, etc..) are shown in a portal. Since customers here only pay after fueling, the gas station employee needs to be able to select one or more records from the portal and send their added amount to the "type of payment" database. After registering the payment for the selected records they should be removed from the portal. Only payment due records should be shown in the portal. any sugestions? Thanks
-
- 4 replies
- 1k views
-
-
Hi All, I always have problems about value list in filemaker which limits to do alot of thing ... I have a list like this DV0101 VD0101 VF0101 I want it sort like this DV0101 VF0101 VD0101 It means I want value list sorting from number 0101 and I don't want it sort by letter first. IS there a way to achieve this filemer expert??? IS there a case that i can see a value list i want when I click it ... the data in that cell is different??? Thanks ALL Anh Tran
-
- 40 replies
- 4.4k views
-
-
Hi, I'm brand new to Filemaker. I've created a couple of db files. 1. SchoolProj which contains printer_name, designer_name, writer_name 2. Vendors which contains Vendor_type, Vendor Name When The user is entering info into the SchoolProj layout - I want to restrict the Value List for printer_name to be the names of the vendors (vendor_name) from the Vendors database - with Vendor_type = 'printer'. Can someone step me thru this process? Does it need to be done via a script? Thanks so much! Cathi G.
-
- 3 replies
- 4.5k views
-
-
I am creating a database for a law company that tracks cases and what awards are won. Because of the variety of awards that can be awarded and the fact that there will be mulitple inputters, I need to make this as simple as possible for the user to figure out where to put the data. For example, in one case there can be the fields medical_award, lost_wages, pain_suffering and punitive while in a different case there could be compensatory_wife, compensatory_child_1, compensatory_child_2, compensatory_child_3 and punitive. For structural reasons, these (and many others) are all in one database and one layout. If I made a different layout for each possible combination of…
-
- 3 replies
- 1.2k views
-
-
A simple little set of 5 portal "looks" I like. Download if you are interested (12k) or need a break. Pete
-
- 1 reply
- 923 views
-
-
I like kiosk mode. Sure, it has it's limitations - but the ability to design databases where I control every pixel appeals to me (as opposed to having to allow for windows task bar, etc which would mean I never know the users actual useable screen space). So far I have always created my databases on a mac for use by mac users only. As I will be expanding into a PC environment as well I would like to maintain my use of kiosk mode. My problem is this: On windows (xp home) kiosk mode has a
-
- 4 replies
- 977 views
-
-
Sorry in advance. I'm new here from old DOS database. Order Form [order_main] has line detail [Order_lines] that looks up inventory based on item#'s [inventory]. Relationships [order_main & Order_lines by Order#] and [Order_lines and Inventory by Item#]. All I want is to have Order_main list 10-15 Order lines that you enter item#, it brings up description and price, you enter quantity then extensions fill and you go to next line. HOWEVER I need to be able to modify the Description that is looked up from INventory so that the modification stays with the order. I'm told don't use repeated fields, I can't get portals to list multiple lines. My text is Schwartz FM Pr…
-
- 1 reply
- 712 views
-
-
I am a relatively new use to filemaker and need some help. I am creating a conference registration form and have created several value lists (ie, one for workshops, one for registration type, one for evening events, etc.) Is there a way to assign a fee for each item in the value list. For example, in my workshops value list I have all of the workshops listed where I can fill them in using a radio button. But, not all of the workshops cost the same amount. Can I assign the amount to each workshop without having to created a seperate field for each one? If yes, how do I do this, and then how do I create the summary file that looks at all the radio buttons checked…
-
- 2 replies
- 922 views
-
-
Hi I'm trying to build a value list based on this structure: CATEGORY {.CATID, .Level, .Category, .FY^CATID} Value List: CatFY {.CATID, .Category} TRANSACTION (.previousCATID, .CATID, .FY, .FY^CATID) Relationship: TRANSACTION.FY^CATID::CATEGORY.FY^CATID Note: FY^CATID is a concatenated calc. On a form in the TRANSACTION db I have placed .previousCATID and .CATID. I've attached the value list to .CATID and would like the list values to vary dynamically according to the .level associated with .previousCATID. Eg in TRANSACTION .CATID = 1 .level = 10 .category = Associate .CATID = 2 .level = 20 .category = Intern .CATID = 3…
-
- 4 replies
- 865 views
-
-
On a Mac, the Go to Field script step does not make a pop-up menu (as opposed to pop-up list) pop-up. As I really want to use a pop-up menu and not a pop-up list I need to assign a script to the arrow part. Is there any workaround anyone knows of? Pete
-
- 4 replies
- 895 views
-
-
New user (sorry) can somebody just direct me to the index topic so that when I type in my item code on a standard order (repeating field) that the values pop up so I can select the right one instead of it being blank until I leave the field and wait to see if the description looks up. I know it must be simple but I cant find it in Wiley bible. Thanks
-
- 3 replies
- 890 views
-
-
The databases I have designed have always been for Macs only and all with 800 x 600 resolution. Now that I want to expand my target users I will have to take into account different platforms and different screen resolutions. I have no problem working out the maximum size each layout can be, however there are some factors I can't control, namely: 1. On a PC, the user may be using Windows classic style or Windows XP style (or others?) which effects the useable height by 8px. 2. In classic style the user may have specified a color scheme that makes the top bar wider. For example color scheme Rose takes 10px off useable height. 3. The user may have the windows task b…
-
- 2 replies
- 1k views
-
-
I have 2db's, customer and contact, I have a portal on my customer db that lists my contacts name and account#, both db's are related by account#, It works great, i select the contact name hit the button and i go to there name in my contact db. when i am finish i press by back button and go back to customer db, but in the portal it changes back to show the first record in that contact db. Is there a way to add more portal on by customer db, so i can select different contact people from my contact db. and when i return from contact db to customer db. the names in the different portals remain unchanged. thanks jim
-
- 1 reply
- 801 views
-
-
I am building a database to make a system of using lots of different things, and putting them all into one solution. Outlook for contacts, Quickbooks, and Excel for some database type info. Right now, the Excel thing works like this: We get a client, when done putting cust info into the DB, we open an Excel template. Each customer has their own workbook. We use 3 worksheets in each workbook. The 3 sheets are all the same, they just represent data from different vendors. We want to stop using the workbooks, and integrate it all into the FM Solution. The problem I am having is this: On the A column, we have Products, in the B column, we have serial #s. …
-
- 2 replies
- 852 views
-
-
I've tried everything--how do I put a button inside a portal row that will insert contents of a field from that portal row (or the related record) into another field? No matter what row I click in, the button always pastes the data from row #1 of the portal.
-
- 5 replies
- 1.5k views
-
-
I have a single file set up with 5 Fields. Each field has a unique value list. I want to set up a script or Calculation so that When i make the desired selection in the 1st Field, then according to the selection, the other 4 Fields are AUTO Entered. I am using FMP 4.0v1. Any help would be very much appreciated Corey.... Jsa and Wms.zip
-
- 4 replies
- 975 views
-
-
Hello, I'm stuck and my head is now hurting. Unfortunately I normally work with traditional RDBMS' and so I'm in that frame of mind. I'm sure FMP can do the business for me but I'm really lost. I have a table (keywords) it has two fields (keywordCategory, keywordEntry). I would like to define a valueList based on a group of documents where the keywordCagtegory field matches. ie: keywordCategory keywordEntry Gender Male Gender Female Status Current Status Archive Status Delete From this i'd li…
-
- 7 replies
- 1.1k views
-
-
Hiya all, I would like to be able to have filemaker not show a border when i am in browse mode, i.e. when the field is selected, i get a black outline, regardless of the bordering of the field... is there a way around this? I want a custom outline around the field (not black nor straight square) thanks, john
-
- 2 replies
- 912 views
-
-
Hi, i just start learning FileMaker Pro, Just want to asking some question. I create a portal in an entry screen and let user key in record, and after that i want all the record to print in out in another layout(this layout also have the portal). I found that if the record contain more than one page, it will only print one page, so some record will now printed. How to set it automatic change to two or more page if the record more than one page.
-
- 2 replies
- 755 views
-
-
I'm not sure I can explain this easily but here goes. I have the following 3 file system for a sports club Membership File (File A) - a list of members Performances File ( File : - a list of performances Competition Info File (File C) - list of venues and dates of competitions etc. The files are related as follows: File A related to File B via MemNo Field (membership number) File B related to File C via CompCode field (Competition Code) Here is what I am looking to do: I want to have a portal in File A (Membership) showing performance information (from File : and also in the same portal where the event took place (from File C) I realise that a port…
-
- 3 replies
- 904 views
-
-
How can I show related records in a report? I have a main database with a portal of related records and I want to display a report of main database record fields in a group and related recordes in a body. I want the body to expand as necessary to show the contents of related records for each main record group. Ideas?
-
- 3 replies
- 686 views
-
-
I have a portal with a couple of field columns of related records. I want to place a related field outside of the portal that shows field data from a related record when the record is selected in the portal. For example, I have a related "notes" field that I don't want on the portal itself because the content is too big. I'd rather have the notes field on the form and have the contents change based on the whatever record I select in the portal. Any clues? Thanks Daryl
-
- 3 replies
- 765 views
-
-
I'm having difficulty with a conditional value list that needs to pull up information from an initial related file, then another file related to that file. Here's the scenario: Database 1: Client Information Database 2: Vendor Information Database 3: Vendor Contact Information (Some Vendors in DB2 have as many as 50 separate contacts). I have a conditional value list set up based upon a relationship between 1 & 2 so that when a Client books at a Property (field populated using a pull down menu from Vendor Information database), I can then view/choose other information about that specific Property in the Client file. Trouble is that all of the contact i…
-
- 1 reply
- 692 views
-
-
To simplify this, I'm going to say there are two DB files: Significant Other, and CY48. The CY48 file generates a report to be sent to the state. Part of the report pulls information from the client's "significant others" (i.e. mother, father, siblings, caretaker, etc.). I need to have a portal showing all the household members, which I just now realized would probably be best to denote with a specific field (Yes/No, checkbox, something). The portal sits on a CY48 layout (obviously), I just need it to filter and show only the sig others that have the household member field flagged. I read something about this in a previous thread about creating a g…
-
- 3 replies
- 812 views
-
-
or: "how many buzzwords can i get into a subject heading?" i'm trying to write a script that when you "delete" a record (thru a scripted button, _not_ thru the records menu), it exports it to another file. this way, we can "delete" records, and still access them later if we need to, but not look at them all the time. (we enter all our phone calls from potential customers, and need to keep track of who's called. the customers who never call back i'd like to keep track of for advertising purposes, and in case they call back, i can show that they called, etc.) anyway, the way i'd like to do it is have a detel record button on the main layout, and when you click that…
-
- 3 replies
- 851 views
-
-
i've noticed that there have been quite a few questions relating to filtering portals lately, my own included. it seems that the answer is pretty simple to those who do get it, and know how to make it work. i was able (usign the solution posted here) to get my problem solved. i'm not sure i fully understand how or why it works, but it filters thru the fields i want and not the fields i don't, so i'm not gonna mess with that anymore. for now. what i (and possibly some others) are interested in (and forgive me if this is the wrong forum) is the how and why the global field filter makes it work. are there any resources about using global fields to their full potentia…
-
- 4 replies
- 680 views
-
-
I know that this topic has been up before, but I can
-
- 1 reply
- 826 views
-
-
Hello List, I am trying to make value lists specific to a certain field. ie, in DB #1, I have Receiver #, and 16 fields for the frequencies programmed into the receiver. In another DB, I want to have the Receiver # field be a pop up list only showing the numbers from "Receiver #" in the first database, and a "Frequency in Use" pop up list consisting of the 16 fields of frequencies from DB #1 related to the Receiver #. Does this make sense? I am in every way a beginner at FMP, but am quickly becoming addicted to it! TIA, Tony
-
- 2 replies
- 910 views
-
-
Hi, folks. I'm new here, and to Filemaker in general, and I need some help. I have a database system that I am working on that is growing in all sorts of directions but the relevant files to my question are Invoice, Line Items, and Inventory. For entering a new order I have set up a layout in the Invoice file that includes a portal to the Line Items file. As each item number is typed into the portal the related info from the Inventory file is looked up and copied into the relevant fields. I then enter in the Qty_Ordered and using a layout in the Line Items file I print out a Picking Ticket for the warehouse help. That all works like a charm, and I couldn't be happier…
-
- 5 replies
- 1.1k views
-
-
I think this question has been answered (probably many times) but I can't manage it. I need to make a filter for a portal & don't seem to be able to get it right. I have 3 dbs - client info, jobs, invoices I want to be able to make invoices that pull only those jobs that are outstanding. I have created a calc field that returns X when the 'paid' field in the jobs file is empty. I have a portal on the invoice to pull the data by client. I want the portal to only show those records with the X. Thanks for all help!
-
- 3 replies
- 780 views
-
-
Hi, I'm adding associated records via a portal - fine. The client has asked for these associated records to be displayed in the main view as a list of checked fields as they like check boxes. These check boxes will be read-only (records created via a layout with a portal, but displayed in another summary layout as checked boxes). I've got a VL of the assoiated fields, but when I insert the assoc record and apply the VL as read-only check boxws I only get one field (obviously). Any ideas how I should be doing this?? If I use a portal - each portal row has the full set of check-boxes with the appropriate one checked. I just need one set of check-boxes with …
-
- 3 replies
- 643 views
-
-
Is it possible to have a field with a value list that is created by the data that is entered into that field? For example, I live in an area that has very unique street names. I do not want to have to enter every single street name in order to "equalize" the way that the information is entered. Can I create a field called "street" that allows me to see a pull down menu of the streets entered or add a new entry (which would then be added to the value list)? This should probably be easy, but I just can't get my head wrapped around this concept.
-
- 1 reply
- 728 views
-
-
I have 2db's, one is customer and the other is contact, I have the standard customer info in my db, but also have fields first oncall -sixth oncall field. I need to be able to place different contacts in the oncall fields, currently it is putting the contact i pick in on six oncall fields, i need to keep contacts for the customer file i am in, i use customer id and contact id in my relationship. If someone could please tell me how to make my value list contacts work the way i would like it to i would be in the debt. thanks
-
- 1 reply
- 895 views
-
-
On a Mac I do not like the window that encases ones layouts. So I prefer Kiosk mode. Ofcourse this takes away the menu bar and keyboard shortcuts. Is there any way to not use Kiosk mode but still to get rid of the unused window edges? Any other alternatives? Peter
-
- 4 replies
- 1.2k views
-
-
Newbie question, I think... I have two fields - one called "Order Status" with a value list containing two values associated to it, and another field called "Resolution" that is just a plain text field. What I *want* to happen is whenever anyone enters the Resolution field and enters text, after they tab out of it, I want the Order Status field to change value from it's default (Open) to a value of Closed. I'm really having a hard time with this, and have tried several calculations (I've tried Choose, LeftWords, and a dozen different variations of the If statement), none of which has worked. If this is so obvious that it hurts, please forgive me. Any help you…
-
- 7 replies
- 967 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online