FileMaker Interface Features
-
I have a main database of workshop participants and the portal lists all the workshops each has registered for. If I want to find all the participants of a particular workshop, I can perform a find on the workshopcode and it will list all the participants in that particular workshop (the portal also lists all the other workshops those participants have registered for which is not a problem). I would then like to go to another layout and list the participants for the found set only. It does that plus "other" workshops of the first record. Also How can I get the title of that workshop to appear in the header of the list? Thanks for you help.
-
- 2 replies
- 845 views
-
-
Hi, I'm selecting from a pop-up list which originates from a Value list (first and secondary fields). The fields are not vast, however, the second field is not fully displayed in the list - it is cropped out of view - making it difficult to choose the right value. How can I ensure the pop-up list displays my data (the value list) correctly. take care, J.
-
- 5 replies
- 1.1k views
-
-
OK,... How are all of you coming up with those custom 3D buttons? Is it all in creation, or are there plugins & downloads?
-
- 3 replies
- 1.2k views
-
-
Does anybody know as placing a portal in the horizontal?
-
- 4 replies
- 896 views
-
-
i have 3 files. 1. clients -each client=1 record. 2. subs -each sub=1 record 3. referrals/jobs -each referral/job=one record with one client and one sub. on jobs that require two subs, two records are reated for the same client on the same day. i currently have a portal in the client file that tells me which sub has worked for them before, but it tells me each and every time they worked. ie. if they worked for the client 10 times, i see their name there 10 times before the next sub. i would like to only see each sub's name once. i'm thinking i need to somehow count the records when a sub works for a record, and the portal would only grab the first time a sub …
-
- 8 replies
- 781 views
-
-
I have a basic understanding of filemaker and was told this forum is the best to recieve help from. We hav a saleperson field with a list of collegues in there and this saves fine but when you change the saleperson as he or she has left then this in turn changes to the new collegues name as they have taken over. We need help so we can keep previous booking with saleperson that made it as historic records and not being changed by adding the new collegues name in. Any suggestions? please help Sat
-
- 3 replies
- 861 views
-
-
I'm presently using FMPro Unlimited 5.0 v3 to host a solution on a Mac Server running os 9.1. I have one db (main.fp5) that contains several thousand records and another db (subs.fp5) that contains over 100 records. In main.fp5 I have a portal that shows the subscriber's id (Field: SUBSCRIBERID) when the field MAKE in main.fp5 matches the field MAKES in subs.fp5. The field MAKES is a calculation that consists of the name of each make of automobile selected by the subscriber. The portal in main.fp5 works as expected and shows all of the subscriber IDs associated with a particular make. The only problem is that when a Find is performed on main.fp5 with a subs…
-
- 0 replies
- 746 views
-
-
My standard db is 240kb. I have a 20kb graphic to insert. I am using a global container and from browse mode using the insert, picture to insert my graphic. So then why is my db blowing out to 1.4mb when i am inserting a 20kb graphic into a global??? I understand that it may be a bit more than 20kb to deal with the graphic, but 1+mb seems a bit ridiculous. Any ideas?
-
- 4 replies
- 899 views
-
-
This is probably obvious but... I have a global field so that when a user clicks on a button it filters the portal based on this global field. I am trying to create a button so that the portal will show records in which a particular filed is empty. I have a relationship between field A and the global field. when field A is empty I cannot figure out how to translate that to the global thus filtering the portal to show when the global is empty. I have tried set filed to "" that doesn't seem to work
-
- 3 replies
- 940 views
-
-
Hi All, I am a newbie to Filemaker, only really know the basics. I am trying to do the following, but i do not know what the calculation is, if any: A database with two fields: Field 1 = Number Field 2 = Name I have a value list of 18 names. When a number form 1 to 18 is eneted into field 1 (number) I need filemaker to automaticly enter a name from the value list into field 2. Does anyone have any ideas? This is killing me. Thanks All
-
- 1 reply
- 838 views
-
-
For the solution I'm working on, there are fields that need to have codes in them that I want to have the user chose by value list, but the codes themselves are not very descriptive. for example, lets say I have a field that can take the codes A, B, or C I want a pop up menu that will be something like A - foo B - bar C - goo and then have ONLY the letter go in the field So far, I've been using two fields. One for the value list with the description, and another for the actual code that is a calculation field that sets the appropraite code based on the value selected in the other field is there a more elegant way of doing this?
-
- 2 replies
- 761 views
-
-
I want to disable the close/minimize/restore boxes in the upper right corner of the window so users can't close or exit the database. Is there a plug in that will do that or another solution?
-
- 2 replies
- 844 views
-
-
It seems that if there is not data to summarize in a report I get question marks. How can I suppress those question marks?
-
- 8 replies
- 1.4k views
-
-
Hello All, I am a newbie with FileMaker Dev (about 1 month) and making progress fast thanks to this forum. I'm stuck on a problem though, and hoping you guys can help. I am developing a Timecards module for our company. Basically a user records time against various job weekly. I created an entry form with the various fields to fill in at the top, and at the bottom of the form I have a portal. The purpose of the portal is to show time entries for the current user for the current week only with a total hours field. The portal is using a self relationship, back to the same file relating the username. I am stumped on how to make fields, and set up a relati…
-
- 4 replies
- 791 views
-
-
i've seen several examples of how to make a new status area, which enables the use of all that empty space under the status area, but i'm having a problem. i set a calc field to status(currentfoundcount), and it works, but it only shows the first counted set. after i do more than one find, the same number hsows up, no matter how many found records there are. is there a way to turn the restore find request off for currentfoundcount? i can't seem to find one. thanks! oh, and any other advice anyone has on how to make "my" status area look more like fmp's status area would be greatly appreciated. there's all that primo gray real estate looking to be developed. …
-
- 5 replies
- 1.2k views
-
-
Not certain if this is the best forum but the issue is directly related to portals so here goes... Is there a way to clear a portal filter automatically (via validation/calculations/etc.) if the user does a next/previous record? I believe the answer is no but wanted to verify. Assuming the answer is no, then I'm looking for suggestions for an alternate implementation of the following portal filtering structure... There are 3 files (project, phase, test cycles). Relationships are defined from project->phase (off projectID), phase->test cycles (off phaseID), and project->test cycles (off of a currentPhaseID which is a calculated value in projects). …
-
- 7 replies
- 1.5k views
-
-
How do I make a portal show only records with something in them, not empty rows? I've gotten as far as making a calculation field that shows a 1 if the record has something in it, but cannot make that 1 translate into showing only those records in the portal.
-
- 8 replies
- 878 views
-
-
hello - i have a file that is in the form of a SSN,Scholarship_code each line contains 1 ssn and 1 scholarship code.. if a student has 2 scholarships he has 2 lines.. each w/ different code (D,E,M,I etc etc) 555-55-5555,A 555-55-5555,C 666-66-6666,A 777-77-7777,M how can i get the checkbox field to populate with multiple checks?? there are 18 different scholarships avail. and i created a single checkbox field with the 18 different possible values.. if i import the file, and match columns, i only get the first 555-55-5555,A checkbox.. what do i need to do to have it check through each line and thus check multiple boxes?? than…
-
- 1 reply
- 846 views
-
-
Hi everyone. I have a question. I work in an small non-profit office where we recruit students for higher education opportunities. I have an internal database written in UniQuery that has about 200 (name, address, GPA, High school attended, etc...)fields for every student. The database is complicated to use for many of my employees and I need to develop an easy to use (point and click) interface to view maybe 50 of the 200 fields. My question is, if I develped a FMP interface and download this data on a daily basis, what is the most efficent way to download the info? My main database can download into Excel and DBF. I was thinking for ease of use to downl…
-
- 6 replies
- 772 views
-
-
Could anyone tell me how a could transfer more that one selected choice from a portal to a field. I have a database setup that will track the appications that are installed on each station. I did get the data from the portal to auto-enter into a field, but if I choose and applcation from the portal, it fills in the field like it should. But what I am trying to do is to make the field auto fill with different selections instead of over writting the first one. For example with the set field option used if I select Outlook from my portal it auto fills in my software field with the selection "Outlook" but when it select Internet Explorer from the portal if over writes th…
-
- 3 replies
- 751 views
-
-
I have a portal in the header section of my layout. I am using the body for line items and the portal to see the information from another database that the line items relate to. Problem is I have a value list in the portal and I'm not able to use it. Is this because it's in the header? The value list is for tax purpose and I want to be able to select yes or no per item in the portal for the tax. Is there anyway I can make this work?
-
- 2 replies
- 765 views
-
-
Dear All, I Have a portal with date and ID Date ID 2003-01-01 1 2003-02-01 2 2003-03-01 3 But the condition is if Date > 2003-02-01 then the portal shows up only 2003-03-01 3 else does not shows any thing and calculation for Sum based on what portal shows up? Is there a way to do it? Thanks Anh Phu
-
- 4 replies
- 717 views
-
-
hi all I have several text fields, some of which are displayed on more than one layout. These fields have different font sizes on the different layouts. No problem so far. A user has changed the font size within the text fields for some records, so now both layouts display those records in that same font size. How do I remove all user-modified font formatting & return each layout to using its own defined font size? Have tried formatting field on the layout, removing & re-adding the field... no joy! Perhaps I have Mondayitis, but I cannot yet see a solution. thanks!
-
- 2 replies
- 823 views
-
-
Either i'm totally missing this, or i'm just confused, but how in the world do you change a background in a layout (i'm not talking about putting an image in, but like if you used one of the ready-made ones and wanted to change it) Thanks
-
- 2 replies
- 888 views
-
-
I have two db's. project.db and earner.db Project db is the main editing screen where you enter the project, you then select the fee earner from the relationship to earner.db who worked on that project. The issue is this. I need it to be a checkbox type list so you could select 1, or 2 or more people from earner.db. However, I need the values from earner.db to 1) update for new records but 2) remain as-is for old projects - rather like a lookup.
-
- 1 reply
- 737 views
-
-
i have a file with 3 fields id, name and category (can be A of :. now i need a value list (to use in another file) with all the names with category set to "A" pieter
-
- 10 replies
- 1.1k views
-
-
This is probably something simple, but I cant fix it. On my Mac (OS9.2 FM5.5), the value list items seem to be positioned high in their spot on the list. It cuts off the top part of the letters. Not really a big deal, but I would like to fix it. I have tried to adjust the Line Spacing in the paragraph section of Text Format, but it doesnt seem to affect it. I might post a screenshot of it later if I get back to my Mac today. Thanks, Ken
-
- 11 replies
- 1k views
-
-
does anyone know of a way to set the tab order on one layout to jumo to another layout? for example: layout1 has field1, field2, field3. layout2 has field4, field5, field6. during data entry, i want to start in field 1, tab thru until i'm at field6. i know i can just make another ("data entry") layout, but i'm trying not to do that if i can manage. thanks in advance! josh
-
- 1 reply
- 733 views
-
-
Hello once again, I have 2 db's set up. the structures are as follows Db 1 Name Total Db2 Name Sign off limit. I want to create a pop uplist in db1 for name that lists all the names in Db2 providing the total amount in db1 is less than or equal to the sign off amount in db2. Is this possible guys. Thanks for all your previous replies, the FileMaker community really rocks!!!
-
- 2 replies
- 652 views
-
-
Here's what I got: User database Product database In the User db, I have a product portal in the main layout, that pulls all products sold to that user. However, in the products db, I have Field XYZ which contains multiple values. I would like to create a second layout in the user database that only pulls portal records for which Field XYZ matches a particular field in User database. I'm guessing this involves setting up some additional or alternative relationship but I'm not sure what that relationship should be. Is it possible to define a relationship to match both the User ID *and* the second XYZ field and then use that relationship for the second…
-
- 2 replies
- 768 views
-
-
Well, I have a db called Client. Then I designed all the pretty layouts, etc. I added all the fields, the StatusBar calcs, Layouts: Menu, Lists, Portals, finds, global containers for buttons, etc. and I was getting ready to add my 'wish' items such as Undo features, User Preferences to eliminate deletes, Log tracking field by field. But wait ... I want consistency through my system. I want these things in EVERY db that Users will interact with. Geez, I was getting tired just thinking about repeating this process through the next 11 dbs (not to mention 5-20 layouts each. My question is: Is it acceptable practice it built it backwards (so to speak)? Maybe cr…
-
- 7 replies
- 1.6k views
-
-
I have a portal that shows related records fine. And I can create a new related record in the empty row. The problem is navigating from field to field. Most fields are populated from choices on a pulldown menu but not all fields are tabbed. When a choice is made, the field is filled and the cursor moves to the next tabbed field. When the last tabbed field or one of the non-tabbed fields is filled, the new row is treated as complete and the cursor moves somewhere, maybe always to a new empty row. The last tabbed field on the entire layout is in this portal. How can I make the cursor stay on the portal row being created until the user finishes entering all data, i…
-
- 2 replies
- 782 views
-
-
Hi everyone, I've been racking my brains over this one, so hopefully some kind soul can help. My database contains many columns of mixed data. E.G. Date, Number, Percentage etc. I duplicated it in order to create a relationship. (It was all previously done on excel spreadsheet). My question is this..... Is there a way to do a search with the option of Equals Date, Does Not Equal Date, Is greater than date etc as in an auto-filter search as in excel. If so could someone explain it as I am lost. Incidentally, I would like to be able to have three or so different filters going at once. E.G. greater than or equal to 1/1/2003 AND g…
-
- 3 replies
- 792 views
-
-
-
I have a field with a value list and check boxes to select multiple values from this list. if I export the file with this field to a tab delimited text file, I get all the selection within that field seperated with a "space". Is it possible to get a "comma' and a "space" there. that would make things a lot more understandable. i hope this is clear... thx
-
- 2 replies
- 715 views
-
-
Hi all , Question: I have a list view Each record in that list view has a portal in it. Each portal has 7 rows Each row in the portal has 5 fields all these field are radiobuttons (yes-no) and each record in the portal row has also 5 date fields On this radiobuttons I put a button (script ) containing the following (I have 5 of them): if field (portal::radiobutton) = "yes" set field (portal::radiobutton) = no set (field) (portal::date) = current date else set field (portal::radiobutton)no set field (portal::date) = "" No the script works just fine exept it always 'refreshes' the window. So it takes like 2 seconds. Is ther…
-
- 2 replies
- 817 views
-
-
Hello, I was wondering if someone can help with me. I have database which list Business Referral. i create a portal where people can put first name, last name of referrals which is a link to another database call Referrals. i want the data entry to happen Business Referral and be display at Referral database. I dont know if my relationship is not working, i am doing the relation base on Company Id for the Business Referral database and Referral_id for Referrals Thanks, SolarPunk
-
- 5 replies
- 665 views
-
-
Hi all, is there a possibility to have a value list with the date of tomorrow, today and yesterday displayed? At the moment I am using a value list with text (tomorrow, today, yesterday) as a pop-up and dependent on the selection I insert the date via a formula in another field. But I would rather like to have the actual date displayed in the pop-up. tnx for your help
-
- 3 replies
- 869 views
-
-
Does anyone know how I might be able to set up alternating row colors? i.e. white, gray, white, gray and so on. Also on how to highlight a particular row when you click on them? Thanks.
-
- 1 reply
- 811 views
-
-
I have 2 fields - (Fa) and (Fb) (Fa) has a pop up menu containing 3 choices (C1, C2, C3) Each choice needs to cause one of 3 ValueLists to appear in (Fb) pop up style. So.... C1 should yield Value List 1, C2 yields Value List 2 and C3 yields Value List 3. I have been building the calculation a little at a time and right now it's working like this: Case (Fa = "Choice 1" , "ValueList 1" , Fa = "Choice 2", "Value List 2" , Fa = "Choice 3" , "Value List 3") Of course right now, the actual words (Choice 1, Choice 2 and Choice 3) appear (Fb). What I cannot figure out, is how to get the actual value list to pop up in (Fb). Incidenty, the 3 Value Lists a…
-
- 4 replies
- 1.2k views
-
-
Hello, I was wondering if someone can help me. i am developing a referral database. I have layout which have a portal and field where personal info is being input of the person who is making the referral. i create one to one relationship with the portal using ID. The problem that i am having is that the id get mess up when create new record. here is example of what is happening. i do one record and type the person information and the referrals this person has on the portal when i go to create a new record instead of getting Id number 2, i get id number 9 and i am wondering if it has to do with the way i set up the portal relationship to itself. Do i need to create a…
-
- 2 replies
- 739 views
-
-
How do I increase the vertical spacing for a set of radio buttons. I'm trying to get 3 radio buttons evenly spaced inside of a box that I have drawn in my layout. I was able to align them vertically, but they appear one right under the other and I have not been able to modify their spacing. Thanks!
-
- 3 replies
- 940 views
-
-
What i'm trying to do here (if its possible), is to create a hierarchical value-list (selecting the 1st-level releated to 2nd-level etc.) that when a you select the top level value-list, then the 2nd-level which is related to the selection made in the 1st-level value-list, should appear on the current layout. The rest of the value-lists not matching should be hidden from the layout. Is this possible to do? Thanks
-
- 6 replies
- 931 views
-
-
I'm new to portals (obviously! This must be SIMPLE!!). Database "Report" has a portal showing records in database "Line Items." Relationship is specified in Report database, relating to Line Item database using a Volume Number field, which is identical in both databases. Sorted by a sort field in Line Items database. In testing, I have 3 records in the Line items database with the same Volume Number value. Only the one with the lowest sort value appears in the portal of the Reports database, but it is repeated for a total of 4 lines!! After banging my head against the wall, I still can't figure it out!!
-
- 3 replies
- 768 views
-
-
Hello, I'm scracthing my head trying to figure out how to create a value list within a portal that will display values based on a second value list within the same portal. Any ideas? Thanks for your help, Peter [color:"black"]
-
- 7 replies
- 1.1k views
-
-
is it possible to insert a pdf into a container field ? how do you do that? Thanks in advance...
-
- 4 replies
- 1.1k views
-
-
Hello, I was wondering how to do multiple selection from pop-pop menu. This is the script i have right now, it work fine but i want to do multiple selection while holding the shift key. This is the Script, i have which fine: Set Error Capture [On] Allow User Abort [On] Enter Find Mode [] Set Field ["Locations","Locations_list"] Set Field ["Status","Status_list"] Set Field ["Class","Class_list""] Set Field [Year","Year_list] Peform Find [] If ["Status(CurrentError) = 401"] Show Message ["There were no records matching the criteria you selected"] Find All Else Go to Layout ["Summ…
-
- 2 replies
- 826 views
-
-
I have a value list that pulls related values from another database based on IDCustomer. If I want to display the same value in every list, regardless of IDCustomer, how can I do it? Sort of creating a general value that all customers can choose. Example: Customer 1 Related Value List: Red Blue Green (this value would be in every customer's list) Customer 2 Related Value List: Orange Yellow Green ((this value would be in every customer's list) Thanks for the help!
-
- 16 replies
- 1.7k views
-
-
Hello, I was wondering if someone can help me. Basically, i am trying to do a find using a drop down menus. i have 4 separate drown down menu where the user will chose from. I am trying to figure out what what values have being selected from the 4 different menus.Than i want the user to click on Find button and they will go to layout call summary which will only show the records that containt the values selected from the drop down menus. i have included fm file to give you idea. The one i am refering to is the one in the yellow box area in the fm file. I dont know where to start, i am newbie. i just now the basic of FM. Thanks, SolarPunk multi-find.zi…
-
- 2 replies
- 809 views
-
-
I have designed an invoice layout with the line items included in a portal. It prints the portal records I have data in, plus an empty last record. Is there any way to stop the empty record from printing also? (Yes, it is empty, it just shows the checkbox data field, but nothing is checked)
-
- 3 replies
- 659 views
-
-
Is it possible to make the value list in a second pop-up list dependent on the value chosen in a first pop-up list? For example, the first pop-up list offers a list of chapters, the second offers a list of subsections. If the user selects chapter 1, the second value list is populated with a list of subsections for chapter 1. If the user selects chapter 2 from the first list, the second value list is populated with a list of subsections from chapter 2. Thanks Scott
-
- 5 replies
- 934 views
-
-
Can anyone suggest a good web cam (sub $100) that can be used in a Filemaker application. Take an employee's picture and add picture to employee file and then display back again in a FM database. Thanks.
-
- 1 reply
- 785 views
-
-
Is it possible to add a down arrow to the pop-up list field so that it looks like other pop-up lists rather than an empty field? Thanks Scott
-
- 6 replies
- 856 views
-
-
Is it possible to attached two separate value list to a single field. Example when field "product" = Pipe then value list pipe would appear in the Thickness field when field "product" = Plate then value list plate would appear in the thickness field I know this can be done with custom values but this would not be feasible because the values would total in the hundreds and the values are already in two separate database. thanks lionel
-
- 6 replies
- 780 views
-
-
Hi All, I have a database that needs to lookup values via calculations from one of three other databases. The dilemma is in dictating which relationship to use to lookup the required values. I use a value list to show which other database the required data is in but am not sure how to set the calculation to use the right relationship depending on the value selected from the value list. Does anyone have some ideas for me? Thanks in advance JB
-
- 3 replies
- 827 views
-
-
I am new to portals but I've seen someone do what I am trying. The idea is a portal with multiple rows within which are fields which the user will enter data, ie. Quantity, Price, etc... Once one row has been completed the portal will add another row of editable fields. I've experimented with this but while I can get the portal to use editable fields, I can't get the auto insertion of a new row once the first is complete. Any ideas?
-
- 1 reply
- 616 views
-
-
OK, I'm finally switching from repeating fields to portals. Here's one newbie problem I can't seem to solve. The old file contained student demographics and multiple class site names. The class sites were in the dreaded repeating fields. I created two new related files, one called Demographics and one called Class Sites. The Class Site fields show up in a portal in Demographics and create new records as they should. So far so good. Problem: I need to import from the old file into the new Demographics file so that -demographic data goes into fields in the Demographics file -class site data goes into the Class Site portal fields in the Demographics file (…
-
- 6 replies
- 795 views
-
-
There is a way to select a value from a value list and activate a script from the selection. My problem is that currently this is not working for me. I have done this before but for some reason my value list is not working correctly. The [text field] "payment_type" is linked to the [valuelist] "payment_type" and I have specified the field to perform my script. In the [valuelist] "payment_type" is a listing of values: CASH, DEBIT, VISA, MASTERCARD, DISCOVER and OTHER. I have two other fields that are involved in this script. [number_field] "payment" and [number_field] "credit_card" Below is how I have my script written. Go to Field "payment_type" if ["payment_ty…
-
- 3 replies
- 899 views
-
-
Dear everybody, I am new with filemaker and I want to solve my problem. I want to make a popup list in a field in a master file. This list includes some fieldnames from another related file. I cannot make a link between its items and related fields from another file. I want to make it appear the content of the related field from another file when I click on each item of the value list. For example, my master file is Main menu file including these fields: Activated sludge, Trickling filter, RBC ... In activated sludge field, I make a popup list (custom list) with fieldnames from another related file (Activated sludge file) such as process description, design parameters…
-
- 9 replies
- 1.1k views
-
-
What I have: One DB One field for "manufacturer and car model" The same in separated fields "manufacturer" and "car models" by calculation from first. Conditional value list based in "manufacturer" and "car models" If I select "BMW" in the first pop-up, the second sorts "318, 225, 525, etc" What I need: I need to select "BMW" and sort the related values in one portal alphabeticaly and omit repeated values. Now I see "525, 318i, 320, 318i (again), etc" Is that possible? Thank you
-
- 1 reply
- 753 views
-
-
I have a payment database that has 2 fields 1-(Value List)Payment Type 2-(Number Field)Payment The value list and the Number Field repeats 8 times so that you can choose the payment type and payment 8 different times. For example if a customer purchases an item and chooses to pay a partial payment with Visa for $15 and comes back again with Master Card paying $25 and comes back again with Visa paying 25 and back again with Master Card for 50. You now have 4 payments: 2- Visa, 2- Mastercard total payments is 115; but Visa's total was 40 and Master Card's total was 75. Is There a way to group the Visa and Master Card purchases together and come back with a t…
-
- 2 replies
- 749 views
-
-
Can anyone tell me if this is even possible, before I keep banging my head against the wall? I have 4 related files with a LOT going on, but a very simplified description follows... BACKGROUND: Master file with records that use Date as a primary key. Related file (Line Items) contains records (key is primaryTask + subTask) which include financial data. A portal in the master file lists all Line Items (i.e. tasks) for a given day, and gives a single summary of financial data for that day. (No problems here.) PROBLEM: Is it possible to create a view - not a report - that shows summaries by primaryTask on a given date (i.e. primaryTask1:summary, primaryTask2:sum…
-
- 2 replies
- 832 views
-
-
Dear everybody, Here is another file. It's related file. Thanks Snow Activated Sludge.zip
-
- 0 replies
- 662 views
-
-
Dear everybody, Here are my attached files so that I can make my question clear. They are zip files. Hope to get your help soon. Thanks Snow Activated Sludge.zip
-
- 0 replies
- 732 views
-
-
I am having a problem with a portal and page breaks. I have a portal that has over 100 records and I need to print landscape. Is there any way to cleanly create a page break within a portal? Almost all the time a row will get separated between pages.
-
- 3 replies
- 865 views
-
-
I hope this hasn't been answered 100 times, but I haven't been able to find a relevant post. I have 2 simple related files: Ticket Holders and Tickets. Ticket Holders has personal information about people who bought tickets to an event. Tickets has information about the tickets: seat numbers, etc. I'm trying to use a value list in Ticket Holders to assign tickets to people. I have a repeating field setup to hold the ticket id's and have assigned a value list to the field. However, I can't figure out how to have a ticket removed from the list once it's assigned to a person. I've tried a huge number of things: calculations, script, tips and tricks from d…
-
- 1 reply
- 660 views
-
-
I have this search string in a global field: '9/1/2002...9/1/2003' I need to enter the find mode and set a date field to that string so it will find a range. Yet the script 'set field' enters it as '12/22/2497'
-
- 2 replies
- 855 views
-
-
I have just completed my first portal data base and everything is working great EXCEPT I have multiple records equal to the number of records showing in my portal. Example: One person has attended four workshops - my portal lists all four workshops but I also have four records showing the same thing. I don't even know where to start to look. Can someone get me going in the right direction?
-
- 4 replies
- 828 views
-
-
Hi All, I am trying to migrate a 260 field ONE FILE DB to a newly designed db with many related files. I want to write a script to migrate the data and create the appropriate related records. THE EASIEST way would be to use a script step that created portal records. But it seems to me like i need to run an external script for each related file which sucks big time. Am i missing something? Can i create portal records from a parent file script?? I am trying to avoid using multiple globals and external scripts for every single related record. Basically i want to create new Portal record, set portal fields.. from the parent.. rw
-
- 1 reply
- 722 views
-
-
I need to be able to pick up the content of a specific portal row into a calculation - sort of using the portals as variables arrays. I would like something like this: calcfield is made equal to: GetportalContent(relationship,portal_row_number,related_field_name) Does a function exist to do this?
-
- 1 reply
- 673 views
-
-
Here is a strange one. In my solution I have a simple list view. When login with full access (fm build in security) the list displays quick and normal. But when user login with restricted password (can't: design layouts, or edit scripts) the list takes a very long time. I have only two passwords, master and user. No groups or layout restrictions. I found the calc that is causing the grief: If(Mod(Status(CurrentRecordNumber), 2) = 1, GetRepetition(acVar:_icon, 2), "") I am highlighting alternate rows in a list view. This has always worked fine because I usually get the graphic from a global field in the same file. Except this time…
-
- 0 replies
- 724 views
-
-
Can someone help? I have a simple checkbox value list of personnel... Selected are those in attendance... I would like to show a total of attendees on the working record... Can this be done? [color:"#666666"]
-
- 2 replies
- 784 views
-
-
I've created a FMP repository database to track information about Quicktime movies. My Question is: Does anyone know a way of retrieving information from the "Get Movie Properties" in a quicktime movie and display it in the FMP database? I would like to display information about the Quicktime movie such as: Format, Frame Rate, General etc. Can this be done by using a script or calculation?
-
- 1 reply
- 917 views
-
-
OK, I've looked through all 25 pages of "portal" posts all the way back to year 2000 but haven't found the answer to my question. Basically it's this: I have a portal in one db that pulls from several fields in another db and I end up with 6 to 8 or so rows of data. It all looks very good on screen. However, I need to put that data into a "stable" field (like a text field) where each row of the portal would be on a seperate line of the text field. The information from this field will be taken via an applescript to a layout in an InDesign template (The template has to pull the data from a single field in order to make this thing work). The question is: can …
-
- 7 replies
- 962 views
-
-
I am creating some simple reports for a client but as usual I have it a snag. Part of the questionnaire has a section for the callers behaviour. This is a checkbox field and it can have multiple checks. So the caller could be calm, or calm/frieghtened along with various other choices. The report is a subSum on Behaviour but how can I break a multi checked field into individual counts. Although it is one record I need a count for each behaviour check. I am thinking that it will have to be some kind of a portal or even a CDML solution but thought I should check with the FM-borg, to see if I can keep it a report solution.
-
- 4 replies
- 1.4k views
-
-
I spend too much time in the scripting forum and have tried to use scripts to solve a problem that a portal would solve.. However, I don't understand portals very well and the docs from FM stink... I have a collection of records which are input by several users. The final user's job is to review these records and add additional info . Currently, the final user clicks on each of these records (which contain multiple fields such as job #, company, due dates, equipment etc.) and adds info to the fiieds which are assigned to him. Would it be appropriate to have these records with multiple fields be contained in a portal so that I could have a layout in which the fi…
-
- 3 replies
- 798 views
-
-
I have a script that changes data in related records. These related records are shown in a portal. However, after the script have changed the data, the portal records doesn't update autmoatically. I have to click inside the portal on each record changed to see changes. Is there any way to automatically update the portal's content ? Thanks in advance. Paolo.
-
- 1 reply
- 604 views
-
-
What I'm trying to do is create a layout, where all clients are listed and when a client is clicked, all the proposals appear on a portal . I want to be able to click in the portal so that it will bring up a proposal form where they can make changes. My problem is that when the portal is placed in the body, only one record client is shown and then the proposal portal. But when I put the portal to a footer instead, all clients are shown but I cannot click in the portal cause it is in the footer. Is there a way to display all the clients and all proposals in one layout where each record is clickable.
-
- 3 replies
- 791 views
-
-
I'm using a portal to view information about engraved cylinders. One of the fields within the portal is a container that contains an Adobe Acrobat .pdf drawing of the engraved pattern. I only want user to be able to view the pdf, by double-clicking the field. However, to give them this access, they can also delete the pdf which I don't want. Any way to give them access to double-click but not to delete or edit the field? We're running FM 5 Server with FM 5.0 clients all on Windows.
-
- 2 replies
- 654 views
-
-
Is it possible to have a value list not attached to a field. Example: value list with only two selection Pipe Plate would make a selection of either one and have another value list popup but would not like to have "Pipe or Plate" enter into the field but the information in the second value list. Pipe or Plate is just to decide what value list to use I hope this makes sense Lionel
-
- 2 replies
- 811 views
-
-
is it possible to change the default window size and position of a shared file (w/FMserver), accessing it remotely? or i do have to stop sharing, open it locally, changing window s/p...? I hate to do that every time!!: thank you
-
- 3 replies
- 1.3k views
-
-
I already seen a scripted method but I'm quite sure there is a clac for this. I want a field to hold the values not choosen from a value list. Say a field with checkbox with A, B,C,D,E Field t_choice = A C E Field t_nonchoosen = B D Am I dreaming ?
-
- 9 replies
- 926 views
-
-
I have a value list where the users should only choose data from the value list. If the user enters data by typing this should not be permitted. How can I prevent user from entering data other than the option in the value list ?
-
- 4 replies
- 962 views
-
-
I have a very strange problem, I have a multi related DB which is hosted on one machine with a master file and many related files, there are portals throughout the DB that link to the other files, with buttons inside the portals that perform actions. When testing on the host machine, everything works fine. Now we come to network the solution, we find that on a client machine, a button in a portal behaves very strangely. When you click the button, as normal, it is highlighted, but then stays highlighted when you release the mouse button, it stays this way forever until you click the button again. You have to double click the button?! (But normal double clic…
-
- 3 replies
- 740 views
-
-
does anyone know if it is possible to use a value list on an input field in a custom dialog under FMP6? Cheers Hal.
-
- 1 reply
- 848 views
-
-
Hi, I'm working on a solution for a medical office. I have a calendar system in it and a line-item DB holds the userfiles (doctors, nurses etc). The main DB holds all appointments, and a selfrelated portal is setup. A calc field calculates the date selected + the ID of the user (01-01-2003 G1, where G1 is the ID). When clicked on a date it will set the selected date in the calcfield but until a user is selected (providing the ID) the portal will stay empty. However, I would like to see the portal showing all appointments for that dat for all users. Only after selecting a user it should filter. Is there a way to enter a wildcard or something that the relationship…
-
- 6 replies
- 929 views
-
-
Is there a way for a Container or Calc field to display a picture based on a URL source of the a picture? For example, if I have field with the URL that comes form an XML source, for example: http://www.napaonline.com/images_products/full_sized/101055.jpg and I want it to be displayed in a field.
-
- 2 replies
- 752 views
-
-
A lot of computer programs allow us to access labels when building templates. The label definitions are for Avery. In my old FM for Win3.1, I'd have to build the label spefifications manually, a very time-consuming and not accurate process no matter how much fine-tuning done. I believe this is now automated (or I misunderstood a post from a year or so ago in a newsgroup). Trouble is, can't find references to this. I know that I might be asking wrong questions in help and in google searches, but was hoping someone could point me in right direction. As I said, I'm not even sure if this can be done yet, but am hoping. FMP6 is what I have. Tx!
-
- 1 reply
- 758 views
-
-
Hi guys, I'm working on my new invoice layout and something strange is driving me mad! I have a number of labels on the screen formatted to size 9, font Verdana. When I click in the label to make a change, then exit the label, the font size changes to 8!! Every time! I've been changing it back by selecting the object and changing the font size back to 9. I suppose I can live with this, but oh boy what a pain... anybody know what's going on?
-
- 4 replies
- 999 views
-
-
I have a db that has morethan 600 records and it has a field=name. I made a form called list that will list all the names in ascending alphabetical order from a~z. My question is? how can I make a clickable alphabets in the Form:List like A~F, G~L, M~R, S~X and Y~Z. When a user click this link it list only the names with beginning character of A~F (as example) and the rest of the alphabeth category. I'd appreciate if somebody can help on how I can write the script on this matter. TY
-
- 2 replies
- 890 views
-
-
Hi, I've got a submissions database where I use a value list to sort items, (e.g. out, resend, accepted, rejected, revise). In order to keep track of the records, I use colors to distinguish the values in the list. I'm manually setting the colors for each different value in the list. I'd like to know if there's a way to automatically set the color when I choose any item in the list. I am a total novice when it comes FM scripting, and my first attempts were a total failure, so if possible I need an explanation that will walk me through from the beginning. Thanks so much Charles Carroll
-
- 2 replies
- 767 views
-
-
I have 2 db: 1. Products with dates for different products (hotel room) two layouts list view and form view. 2. Price file have prices for different dates, different years, different rooms. Products and prices are related with a field called room_prices and the same in price bd like this; Room&
-
- 1 reply
- 623 views
-
-
Hi all, I'm trying to put together a database for a art show and charity auction held at a convention. I thought it was going well, but I've gotten stuck and I'm hoping some of you might be able to help. Here is a description of my setup and problem: db file:Buyers This has a portal to"art using ::BadgeNumber, and relarionship to Registration using ::BadgeNumber to pull in the buyers name and address. I have it set up so that when you enter the buyers badge number in the buyers db it lists everything that the person has bought and totals the amount due. Since the art can be bought at different times (for a quick sale, during the action, or on sunda…
-
- 7 replies
- 920 views
-
-
Problem: Create a "sub" list that changes when the user selects a value from the first list Scenario: 1. Created Value list of 5 Coaches (each has "X" players). 2. Created a calc to assign a number for each coach. (This seems to work as the number changes with each coach) ex: --> PatternCount(Left(ValueListItems(Status(CurrentFileName), "Coaches") & "
-
- 1 reply
- 703 views
-
-
OK, I tried to come up with a way to explain my problem, but without showing you it seems complicated to verbalize... here goes a semi-short version... I have created a Filemaker db for an educational program tracking student info including contact, grades, surveys, etc. I also have a db tracking events/activities offered by this program including student events, parents events, and pro development events. These are two different dbs, each with their own sets of related db files. Now my client wants me to modify the student db to list all the events each student participates in. Currently the Events db just tracks the total # of students per event ( a 1 t…
-
- 4 replies
- 764 views
-
-
I own a multi-media business and I am working on streamlining the bid process. I am trying to create a database that will allow my clients will choose the (project) options that they want (via radio buttons). There about a dozen sections that they will choose from, with three (radio button) options for each section. (basically low $, med, and high) When they click "submit" they will be taken to a "totals" layout that will show all of the sections but only the final options that were chosen by the client with the proper dollar amounts. I need to be able to easily modify the dollar amounts and info for each item as part of my bid research. Can anyone point me …
-
- 3 replies
- 882 views
-
-
Hi every body... Again consult my prefer page (FM Forums)... In this time I have a little problem for the FM experts, my problem is... I have a DB with a portal (invoice portal), in this portal the user capture invoice, concept, invoice number, payment and payment date. Ok, I want to collect all payments (dates) from Invoice Portal and resume in another portal by month (this will be payment month portal), how can I do this?? always in the invoice portal user can get in payment date in any time for example: Invoice portal Payment date (field) Payment (field) 02/15/03 $500 (portal row 1) 02/26/03 …
-
- 10 replies
- 1.1k views
-
-
Is it possible . . . (famous words on this board) I have a pop up field that has two selections. Both of the selections are managers and what I would like to do is when manager 1 is selected an email script that I have built is activated. The other option I have "toy-ed" with is making the field a calculation and if the field = manager1 then basically run my email script. I am not having much success with either one. any ideas
-
- 3 replies
- 839 views
-
-
I recently started a new database using the contact management template. I changed the company related field to "contact type" related field. Now in my portal the names do not show up. The list shows and the company name shows. If I lick on a portal row that record shows at the top. I have checked all of my calculations, etc. and cannot figure out what I did wrong. My contact type is a drop down list selection. Could this have anything to do with why the names do not appear? I'm stumped on this one. TIA
-
- 0 replies
- 705 views
-
-
I am looking for a work around to tab vertically up and down through my records. Does anyone know a method for doing this?
-
- 3 replies
- 982 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online