FileMaker Interface Features
-
Question for all of you- I'm building an inventory database to keep track of pieces of A/V equipment for the media department of a university, and I'm having a bit of trouble with some more complicated value list issues. There's one entry per piece of equipment, each having the following relevent fields: Category (Broad equipment classification - Video, Projector, Audio, etc.) Type (Specific classification within category - Data Projector, Overhead Projector, Slide Projector, etc.) Manufacturer Model # Serial # Right now, users can use drop-down lists to select the category. After selecting a category, the type list is filtered to show only the ty…
-
- 1 reply
- 662 views
-
-
Problem: Value list sorts in an unfriendly manner. I want items in list to be grouped in a specific order, not by "starts with" sort. Background: A value list in <fieldITEM> is determined by a choice from valuelist of <fieldTYPE>. Further fields are populated by this combination. The problem listing is in <fieldITEM>. I want to predetermine the order of the listing. Please say it can be done....thanks!
-
- 1 reply
- 738 views
-
-
I'm sure the answer to this has already been posted, probably more than once. But I haven't found it after much searching. I have 2 dbs -- 'students' and 'activeYears' with student ID being the linking field. Every year that a student participates in our program, I create a new record in 'activeYears' with the student ID, the active year and the particular school that student is attending. As the program runs from 4th through 12th grades, students can participate more than once per school (2 years in elementary, 3 in middle school and 4 in high school) therefore generating that many records per student in the 'activeYears' file. Using a relationship between '…
-
- 4 replies
- 900 views
-
-
Hi all, Just wondering if anyone knows the maximum length of a value list. Cant seem to find it in the manual. -Raz
-
- 7 replies
- 1k views
-
-
Hi, I have a database with quite a few checkboxes, so many in fact that it's difficult to see which ones are checked and which ones aren't. What I'd like to do is highlight the checked boxes in one way or another. Ideally this would mean bolding the text and/or check mark. Is this possible? If so can someone explain in (relative) newbie speak how to do it? Thanks in advance. Dave
-
- 2 replies
- 853 views
-
-
Hi everyone, I have three files: (1) Book, (2) CDROM, (3) Files. A (record of) Book can be found on many CDROM (records), and can correspond to several Files (records). So Book A can stay on CDROM A and CDROM B, and Book A consists of File AA and AB on CDROM A, and File BA, BB, and BC on CDROM B. I want to place CDROM and Files as two synchronized portals on the Book's layout#1. When I add a new record to Book, from the CDROM portal I have to be able to select CDROM A (value list based on the [title] field in the CDROM file), and have to be able to add (!) File AA, and AB to the second File portal. Afterwards, for the same Book record, I want to select CDROM B…
-
- 3 replies
- 656 views
-
-
Is there a limit to the number of characters each value in a value list can contain? The problem is my value list has fairly long chunks of text for each value. This does not fit easily on the screen. when I resize the field the text is clipped. By the way, the field is formatted to show all the values with check boxes.
-
- 2 replies
- 910 views
-
-
Hello Forum, Yet again I am in search of your help. I have a field with two options: one radio button allows you to select regular student the other radio button allows you to select special student. Here is my request, when the special student radio button is checked I either need the selection to trigger an email to someone or to pop up a message box reminding them to notify jane doe @ dfdfdf.com Thanks Don
-
- 2 replies
- 912 views
-
-
Hi all, So glad to have found this forum! I've been able to fix all my perplexing FM problems but this one: for some indiscernable reason, I can't see the radio buttons in a field I've designated as radio buttons! I already have a radio button field in the same data base and setting it up was no problem, but the two new fields I added today and made into radio button fields DON"T show their buttons. What gives? Help! Karen
-
- 7 replies
- 1.1k views
-
-
Here's how you can duplicate the "Continue" and "Cancel" find buttons displayed in the status area when a user is paused in find mode; so you will not have to show the status area in your layout. Copy any portal (just the portal, without any fields) from another file (it can't be a portal from the file you are in!) If you don't have a handy file with a portal already in it, go ahead and create a new file and a portal. What portal you copy does not matter, as long as it is from another file. Paste the portal onto a layout you use for finds. You will notice the portal shows: <Relationship Missing>, that is what you want, don't assign it a relationship in Por…
-
- 4 replies
- 1.2k views
-
-
This is odd behavior.....maybe somebody else has experienced it and can shed some light on the issue. I have a button which fills the portal row (but does not overlap or touch boundries). I have the roll over function enabled so the cursor changes to a pointer when over the button. Sometimes, when I click this button it changes color (as buttons do when clicked) but it "hangs" in that state. What is even more interesting is that it becomes a rollover color change instead of a pointer. In other words, the button will change color when it I roll out or over it (much like a rollover button on a webpage). Any ideas?
-
- 5 replies
- 676 views
-
-
I have seen a very nice feature on a filemaker db, which I'd like to replicate on our system In short when you are done with your log in dialogue (not the fmpro one, but one built up w/n the solution) you have your start page. on one side there was a portal which showed whom else was logged in and from which IP they were at. I have found no such built in function with fmpro??? Of course the solution also used this data in it's log files to show not only who was on but from where etc,etc, this is great especially for remote user we have.etc. The start page would also show the users to do list, memo;'s phone calls, appointments, tasks, projects etc. dynamically. I…
-
- 1 reply
- 682 views
-
-
I am trying to set repeating global container fields with a script. There are two icons. The is a choice field of ABC or D There is a repeating container field that I want the script to set all repeats the same except the field that corresponds to the choice (ABCD) Please attached setContainer.zip
-
- 2 replies
- 934 views
-
-
Hey All, I was wondering if there is a way to have my value list NOT open when tabbed or clicked to. Instead I would like it to either have a scroll bar or allow the user to use the arrow keys to navigate up or down the list. It's getting way too long. Thanks, Wesley
-
- 3 replies
- 1k views
-
-
Hi all, sorry if this is old ground.... Im using fmdev 5.5v1 on windows 98, just so you know. What Im trying to do is create a value list from a global field. I have a text field called Boys and a global text field called pep_boys, into which I have entered "Manny, Moe, Jack" as the values, separated by returns. The global field has not been configured as "repeating". When I go to format the Boys field as a pop up menu using values from a field, and I click on pep_boys, I get an error stating that it will not work since pep_boys can not be indexed. What am I missing? Im certain there's a straighforward way to using global text fields for value lists,…
-
- 8 replies
- 2.6k views
-
-
this might be a stupid question, but is there a way to have all checkboxes checked on a new record? I want to keep track of my students that have paid for the months. So I have the months in a checkbox valuelist. But if I do a search of the records, it will show me all the students who have paid. But I would rather see the students who haven't paid. Kind of a reverse search result.
-
- 3 replies
- 770 views
-
-
Hi all not to similar with portal as you can read. I have a db for our national board numbers which has 700 records and would like to show all the records for review at the same time in a portal. Sofar i have been unsucessful and can only get one record to appear at a time. I know there must be a way to do this but cannot figure this out. Thanks in advance Lionel nationalb.zip
-
- 4 replies
- 667 views
-
-
I'm working on a database for a school. I have a student database, and now I'm making a separate database for marks. Rather then having a separate one for each grade (as was the previous method) I have decided to put them all in one. The report cards have different courses for each student (since they can choose their courses). I want to only display the marks and headers for those subjects that each student takes. To start, I was thinking of having a bunch of checkboxes listing the courses available for each grade. That way for each student, the courses that apply to them can be checked off. But I don't know how to display different value lists depending on the grad…
-
- 13 replies
- 2k views
-
-
FMP6 seems to be losing my custom color definitions when I stop/start FM. Or is it something I'm doing wrong? tia for any help --Bob
-
- 2 replies
- 763 views
-
-
Hi all, I dont know if I am posting this in the correct forum but any help would be appreciated. My question is ----> Is it possible to setup a filemaker database to talk to a DOS based accounting/admin program which my schools currently uses. The program is called OASIS (It is anything but) and runs on a novel network. I want to have a filemaker database setup to permently talk to OASIS in order to allow teachers to see who has paid for excursions etc on a website. Is it possible. Many thanx in advance Poida
-
- 1 reply
- 641 views
-
-
Hello all, I'm having a slight problem printing portals. All the text prints just fine in the portal. The problem is that the lines between the portal rows are being cut off. At the ends of the portal you can see a little bit of the lines but in the center of the portal it's blank. The first portal row is ok it's only the rows after that that print without the lines. Please help Ias I have a customer that is ready to use this database and this is the only thing keeping this from being used. any suggestions will be greatly appreciated. Thanks
-
- 13 replies
- 1.3k views
-
-
Ok I have got three dbs one with the main body of data. I have a portal within this db that has comments on this information and there is a join db to connect the main db and the comment db because you can assign a comment to many bits of main data. now a comment can be defined into three different types a, b and c what I what to be able to do is filter out type c information from the portal on different layouts of the main db Is this possible Regards, DJS
-
- 1 reply
- 748 views
-
-
I have a db with a simple yes/no check box in every record. What i would like is for each new record, the check box defaults to no. I would be gratefull of any help
-
- 16 replies
- 1.6k views
-
-
I have a recipe database. Think of it as a book with chapters such as "Deserts", "Salads", "Soups", etc.. Below those headings in the hierarchy are the recipes. In the preview mode, I can easily get a list of the chapter headings by putting the field in a Subhead part of the layout and sorting by Chapter. I would like to be able to get such a list in Browse mode so that I could script individual buttons for each chapter. It seems to me there must be some way I could get the index of the Chapter field and use that as you might use a drop menu, but one that would be permanently "dropped." I can't figure out how to get the indexed list, however. When a particular…
-
- 3 replies
- 891 views
-
-
From listed records in a selfjoin portal, can I make a scriptbutton inside each portalrow that takes me to that current record. I tried a script: Setfield["Globalfield","Status(CurrentRecordNumber)"] Go to Record/Request/Page["Globalfield"] This did not work, it only stayed at current record outside the portal
-
- 1 reply
- 697 views
-
-
I am trying to create a few easier reports. This is a DB showing attendance. I have established a value list using checkboxes. This value list comtains approx. 40 plus names. What I would like to do is create a report the would show only those name checked on the value list to appear.(ex. Name1, Name2, Name3, Name4, Name5. Only Name 1 & 3 are checked - Only display 1 & 3 would be diplayed on report. Not whole list showing boxes checked aswell as boxes not checked) It needs to be flexable enough that 2 names could be diplayed or maybe as many as 25. THANKS!!!!
-
- 15 replies
- 1.3k views
-
-
I have downloaded the fm solution framework it does everything i need it to do but how do i change the curency from $to
-
- 5 replies
- 857 views
-
-
I am trying to put together a new sheet with some existing sheets. The sheets I have now contain student information, ie, name, phone numbers, class level, ect.. Ok.. first I own an English school in Japan and I am trying to tie everything in on one db. So I created one that contains the student information. Then from there, I created a report card sheet that creates a new report card ID# that relates it to the student id#. After, I created a billing sheet that creates an order for that student's monthly fee. Of course relating the student id#. that sheet contains a portal that pulls the "monthly package prices" from a another sheet "inventory file" very similar to sellin…
-
- 6 replies
- 703 views
-
-
OK Filemaker buddies. This has to be basic [read a stupid question] but it still confuses me
-
- 3 replies
- 652 views
-
-
Here is my scenario: I have a contributions database and a members database. I have setup a relationship from a global field in contributions to a calculation field named "c_quick_key" in the members database. This relationship is used to allow the user to search by part of a member's name or their giving id. By entering part of the member's last name records are displayed in the portal. When a user click's on a record in the portal the GIVING ID field is set. This works great. The problem is that most husbands & wives have the same giving id. This is for tax purposes. Since most of our members file their taxes jointly they share the same giving id. N…
-
- 10 replies
- 2.1k views
-
-
I need a strategy for printing portal rows in a report. I know you can get a portal to slide and shrink, but not the contents of the portal. As it stands now, I include a portal object in a report layout that includes a large number of other objects (other fields and graphic items). I may have any number of portal rows that I need to print in my report. Also, the size (number of printed lines) for each portal row can be from 1 to 12 lines. If I make each portal row of a size to include 12 lines, each row that prints takes up 12 lines even if a particular row is only 1 line. Of course this makes the printed page unacceptable. Is there a scripting method &/or…
-
- 2 replies
- 929 views
-
-
I have a conditional value list created from a relationship from file A to file B based on a global field in file A. The global is set to create the relationship. If I use the value list on a field in file A for finds it works fine. If I put it on a related field from file C, I can use it to edit the field but the list is not availible in find mode. It seems as though the list is not being generated but doesn't give the <value list missing> error. Any ideas? Thanks, Wayne
-
- 2 replies
- 799 views
-
-
I have seen in someone else's FMP database a portal which lists the Company name (in bold) and underneath that is a list of its people, then the next Company name with its sublist of people etc. The Company names are listed only once. A script overlays the portal row: Double Click on the Company name and it takes you to the company details layout. Double click on the person's name and it takes you to the person's details layout. I have been trying to repeat this wonderful layout but with no success (bold Company name overlays person's name). Ideally, what I would like to have is a three-tiered setup: Type of Service, Company Name, Person's Names, but I
-
- 6 replies
- 927 views
-
-
This one may seem obvious, yet it's anything but. I am stumped. Any guidance will be greatly appreciated. I am trying to design a List Layout with seven fields separated by hairlines in the Body Part. There are additional fields, all within one great square outline that extends from inside the Header to within the Footer. The idea is to have around 20 records per page. The Body Part has me at a loss, since I can either, but not both: Result 1. Display the spiffy format with a single record per page in Browse and Preview. This was done by extending the Body Part and outline to a full page, with a single line of fields, in Layout Mode. Result 2. Display…
-
- 6 replies
- 1.1k views
-
-
Hi all, I have a portal that brings up records from a second database thru a relationship, and it works fine. I get all records from 2nd DB where status="live". But now I want it to use one more criteria for the selection of the records shown. I also want to match ClientID between the two DBs. So I want to show all records from 2nd DB with status="live" and ClientID=ClientID. Is it possible? How do I do? Thanks, Martin
-
- 1 reply
- 833 views
-
-
-
Hello Everyone, Here is my scenario. I have a database just for all of my value lists. There are several different codes for each ministry at our church. I have broken all of them down for each ministry. There is a Primary Key for each ministry. Then there are sub value lists for each ministry. Everything works fine in browse moden when they are entering data into the main database however my value lists do not work in find mode. I basically have a main database that has calculations with a constant value. One for each minstry. Then I have a relationship back to the codes database to build each unique value list for each ministry. For some reason …
-
- 2 replies
- 863 views
-
-
Hello! How in the world can I make a checked checkbox "flash" in order to attract the attention of the user? Or a similar thing... What happens is that I want to add that to the "owes money" checkbox in our customer service database so when when a customer service representative picks up a call from a customer that owes $$ she can look at the checkbox flashing and take certain actions (we sometimes miss the checked checkbox by itself so we need something to "pull" our attention if the checkbox is checked). Please explain step-bt-step as I'm novice. Best! Danny
-
- 5 replies
- 1.7k views
-
-
I'd like to add a region listing to my contacts database. Is there a good place where I could download such a file for my value list?
-
- 0 replies
- 612 views
-
-
Maybe Im just missing something, but here's my problem. I have 2 files. Dont ask questions on why Im doing this, there is a method to my madness. LOL. But I copied all the fields and labels and such from one layout on say FILE 1. Copied them to a new layout on FILE 2. Now with them all selected, I want to make them sit in the same place, so I look at the object size window on file 1 and set them the same on file 2. Now, they are NOT sitting in the same place. Here is why, on FILE 1 the VERY left hand edge on the layout starts at "5". On FILE 2, the VERY left hand edge on the layout is "18". PLease someone help to explain this and how to fix it. Thanks again !
-
- 2 replies
- 911 views
-
-
Is it possible to select the whole contents of a field in a value list, if the text was entered in multiple lines by using Carriage Return (Enter)
-
- 1 reply
- 854 views
-
-
BACKGROUND: In file One I have sales reps in which each rep has an <Active> field of either "Yes" or "No". In file Two I created a value list of sales reps whose <Active> field was set to "Yes". I did this by creating a global field populated with "Yes" and then creating a relationship between the global field and the <Active> field in file One. I then created a value list based that relationship. PROBLEM: I want to use this active list of reps in many other files but when I define a new list (let's say in file Three) using the list already defined in file Two, I cannot get the values to show up. Do I have to redefine the list and relationship…
-
- 1 reply
- 725 views
-
-
I saw a lot of fancy layout, but when I want to design my own layout, why can I just see some very simple components available on the right side, I even can't find the "check" and "radio" button there, I am now using Filemaker Pro 5.5. Do I need another version, or Just set some options? Thanks a lot
-
- 5 replies
- 1.3k views
-
-
I have a proposal system that uses a repeating field for the lines of the proposal. Unfortunately, I can't change that at this point. I am trying to install a portal that has a relationship to one of the columns (product model). I would like it to relate to whichever line of the repeating field is selected. Any idea how to do this? It only relates to the first line.
-
- 5 replies
- 653 views
-
-
Hi Folks, I have a survey report page, that uses repeating fields and filtered value lists. The first field is used to select a trade, based on this trade selection the second field provides a filtered value list relevant to the selected trade. On the first row of the repeating field this works perfectly. The problem lies when you move to the next row of repeating fields, instead of the second field basing the filtering of the value list on the first field on this row it, bases the filtering on the first field on the first row. Can anyone provide any assistance on how I may work round this?
-
- 3 replies
- 827 views
-
-
Hello, I have a layout with lots of columns. These columns need to be filled out using formula or manually. But one of the column (Item) is filled using value from the Item file. What I want to do is when I click on the column title I want to load a separate layout window with data from the Item file, on top of my current layout ( ie. pop-up window not a pop-up list). I then select x number of items from the pop-up window and click on an add button on the popup window. These items are then added to the Item column of the original layout. How can I do this? Can it be done in FM Pro? I am using FM Pro 6 on Windows. Thanks for any advice you can give…
-
- 1 reply
- 945 views
-
-
Hello all, I would like to display selected data values in a portal with a different background (or text colour) depending on the value in a repeating field. This is part of a Resource Booking system, where repeating bookings show up as a different colour. New or casual bookings need to be easily noticed amongst the others. The portal contains data based on a self-join where the ResourceID is the primary key. A row of the portal contains timeslots, while each portal row contains each of the ten days of a 2 week cycle. Each record of the database contains resourceID, slot1, slot2...slot10 Slots 1-10 are repeating fields (3 repetitions) that show Booking det…
-
- 3 replies
- 657 views
-
-
Ok, maybe what I would like to do is impossible, but according to me it seems like it should be pretty simple. I have a photo database with one main layout. On the main layout, each photo has a unique ID number. For each record, there is a field for the ID number and also a field for keywords (like people, business, food, etc.) and a small thumbnail of the photo. Users can do searches in the keywords field to then find a group of photos thumbnails (records) which match their search requests (as on a stock photo website). Now, what I would like to do is this: when people perform a find on certain keywords, and are then given their new found set of records, I would li…
-
- 3 replies
- 783 views
-
-
Hey there, I currently have a value list populated from a record field in another file. The file has about 1000 records so the value list requires a lot of scrolling. Is there a way to jump through the value list by typing ex: typing "m" would take you to all values that begin with m, "ma" would take you to all values that begin with ma, "man" would bring you to all values that begin with man, etc. I've seen this technique utilized often on website that ask for a state or country. Ideas or suggestions will be appreciated...
-
- 9 replies
- 1.1k views
-
-
Hi gang! this one should be easy: 2 files (not related but can be if needed) ----file_1.fp5----- [Name] [Number] <--- value list to be use ----------------- -----file_2.fp5-------- [Number] [Available] (YES/NO) ------------------------ I have sorted/perfromed foundon file_2 based on "availability" and got an X number of records while the rest are omited.(ALL good so far)..now I want to your these "found" records ONLY in the value list for the file_1.fp5! How? thank you!
-
- 2 replies
- 718 views
-
-
FMpro 6 in OSX, The manual says toolbars are not a supported in OSx. AARRRRRGGGH> Is there any workaround? Shareware? A tear off palette? Anything. Dialog baoxes are incredibly slow and inelegant. Help appreciated, Joe
-
- 1 reply
- 769 views
-
-
hey i'm just wondering how i would go about copying data from a specific row in a portal that the user clicks on. Right now i have the portal set up and all the relationships are correct. On each portal row there is a button that runs a script to copy the fields contents and then go to another file and paste those contents into another field. The thing is it doesnt just copy one field, but copies 'field1' and performs external script (which tells it to paste into that files field), copies 'field2' and performs another script (telling it to paste that into a different field from the same file as before). This has about..4 repitions. The problem i have encountered…
-
- 1 reply
- 620 views
-
-
I'm so new to this I hardly know how to ask the question.... In the absence of our usual programmer, I have to knock up a database for a mail order catalogue, to hold the information for the Curtains pages. It will be used to generate formatted text (in QuarkXPress, I can do that bit!) for the printed catalogue. Each item has a unique product code (e.g. G1234). Each range of curtains contains up to 20 products - different lengths, different widths, pelmets etc. So I need a main entry for the first item, and the rest should relate to it somehow. That is, when someone does a search on the first item, all the others should automatically pop up too. I don't really…
-
- 0 replies
- 697 views
-
-
Hi all, If you have ever seen the DB "MoreVis" from John Mark Osborne's site Database Pros, you will know this has 4 great examples of visibilty tricks. I get the idea and have used these in some of my solutions. But 1 of the examples has me baffled. It is the example where a checkbox can be seen but is greyed out until you enter a date in the date field. I see the workings of this, the relationship with the constant field, the two checkbox fields, 1 grey not allowing entry into the field, 1 black allowing entry into the field. What I cannot work out is how he has got the relationship working so as to show the correct checkbox field - I cannot find…
-
- 4 replies
- 714 views
-
-
Hi everyone... I'm still working on this donations database, and I'm stuck again. To recap: 2 main databases. One called DonationsDatabase.fp5 (the primary one) and a related one called RelatedDonor.fp5. RelatedDonor.fp5 contains all the individual donations. One DonationsDatabase there is a portal that lists all the donations associated with that donor (via relationship of the donor_id). I have several form letters that utilize the donor information. Most of the donors are single-donation entries, so it's not a problem. But a couple have mulitple donations, and I'm not sure the best way to go about retrieving the specific donation to use in a letter. I tho…
-
- 4 replies
- 653 views
-
-
Does anyone know why when I rotate text and change the color to white, the text disappears? I can change it back to black and it will be there, but not white. What the hell is that?? You can't have rotated white text?
-
- 7 replies
- 1.3k views
-
-
Sorry for this very basic question, but it's been quite a while since I've worked in Filemaker. I want to create a very simple Yes/No pop-up menu. I've done this, I think. But I also want Yes to be the default answer for all records. How can I have Yes show up as the default in the browse mode instead of a blank? -Kirk
-
- 13 replies
- 1.8k views
-
-
I'm trying to create a portal for a contact database which will accomodate a "Group" concept. A company may be part of a larger group. What I would like to create is a portal in an interface file showing a list of companies with those companies forming part of a larger group in one portal row with the group name. When you clik on the group name, I would like to display each of the underlying companies as a separate line item following the group name in the portal. any ideas??
-
- 2 replies
- 787 views
-
-
Apologies if this has already been addressed - it seems to me to be an obvious thing to want to do, but I can't find an answer. Database A has a list of companies, each with (amongst other records) and company ref, and a main contact ref (both numbers). Database B has a list of contacts. Each contact has (amongst other fields) a company ref (number) a contact ref (number) and a name (text). What I want to do: when entering the main contact into Database A, I want to present the user with a pop-up menu, consisting of contact names only ('Fred Bloggs, Andy Ellis, Jim Jnr') for example. When they pick, say, Andy Ellis, the corresponding reference number (eg 34) nee…
-
- 10 replies
- 1.7k views
-
-
In one layout of my solution, the user is presented with one field with checkboxes and is asked to select "all options that apply" (ie. selected from values in the associated value list). In different "report" layout, I show the contents of that field presented as a standard field. The contents of the field are, of course, the values selected from the checkbox, delimited by carr. returns. The order in which these are displayed in the report layout (in the standard field) are shown in the order that they were selected. Question: Is there a way to display the contents of the field in a sorted fashion (ie. ignoring the order in which they were sel…
-
- 3 replies
- 985 views
-
-
I have a patient db contains 4 fields among other fields: Surgery1 - Surgery4. All of them defined as value list (yes/no). When user add record and if yes is checked, two more fields (Surgery Date, procedure)should pop up to allow user to enter data. I've been searched the solution for days, but cannot find one I can understand well. Can someone please give me some detail information. Thanks!
-
- 10 replies
- 1.1k views
-
-
Help please? I'm glad its Friday. TGIF major problem help please? I got embarased today by our secretaries. at least I have a few days tos solve this thing for them. okay, I though I was gettin smart and created a file for them to type in their people they call all the time. so far so good. But then they wanted a pupup so they could choose type of person. No prob, I tell them smiling wisely. I've been learning about popup and have changed many existing sales fields to popup in other files. They want to base it on existing types, no problem. Ive done that many times (okay, six but whose counting). I do a value list 'from field' type. smart, I think,…
-
- 18 replies
- 1.7k views
-
-
Question 1: I want to have a value list of contacts, with values from a second database, but only those with client=clientname. Is it possible? Question 2: Multiple choice value list? Is it possible? I want my users to be able to choose from more than one object in the list. Thanks, Martin
-
- 3 replies
- 800 views
-
-
I have a portal to another DB, but I only want to show the records where anotherDB.Status="live". How do I do that? Thanks, Martin
-
- 3 replies
- 699 views
-
-
I have two files. File One contains my sales reps and includes an "Active" indicator (yes, no) for each one. File Two contains, among other things, a value list created of the sales reps names from File One. But I only want the value list to show the sales reps for whom their "Active" field is set to Yes. I am sure there is a simple answer but it is eluding me.
-
- 1 reply
- 886 views
-
-
Hi All, i have a Parent File in which one of the layouts has a portal. the portal shows all of the related records from in the child file. 1 to many relationship. what i want to do is click on a portal row of one of the records and then i am taken to the child file and shown the record i have searched for via the portal. each record in the child file has a unique ID. what i have set up is that i copy the unique id via the portal and then perform external script in child file - external script enters find mode pastes in to unique id and performs find but it always just finds the record which is the first row in the portal!! hope this makes sense!! what am i…
-
- 1 reply
- 756 views
-
-
Given 2 DB simple DBs: DB1: DB1record# - number, a unique sequential serial # for each record, never reused (primary key for DB1) : myName - text - a person's name : myFavoriteFood# - number field DB2: DB2record# - number, a unique sequential serial # for each record, never reused (primary key for DB2) : FavoriteFoods - text A popup menu with a value list in DB1 has the relationship between DB1:myFavoriteFood# and DB2:DB2record#. Basically, you enter a user and their favorite food. The primary keys prevent data from being lost, e.g. should the favorite food be renamed due to misspelling. The popup in DB1 has as it's first field…
-
- 2 replies
- 958 views
-
-
I have a script with a loop that creates records dynamically These records appear on a portal. When I have a large number of records wich requires me to use the scroll bar to access them I have a problem. When I try to go to a portal row that is at the end of the portal using the scroll bar while the script is running, The script keeps pulling the scroll bar to the begining of the portal, and I can never get to the record I want unless I pause the script. Does anybody have a better idea?
-
- 2 replies
- 774 views
-
-
Hi guys, Im sure there must be a calculation for this, but I have a value list which contains A B C D I want to create a field that picks the second value, i.e B from the value list. Can anyone help please? Thanks Jalz
-
- 5 replies
- 945 views
-
-
I use a portal to calculate sales related to an event. The file also relates to a inventory file which through a look-up field indicates if there is inventory for a specific item. If there is no inventory, I have a calculation which places an image in a container field under the data to indicate that no data should be put in that field, but I haven't figured out a way to prohibit data from being entered. If I place the container on top of my fields, of course I prohibit all data entry. I checked out DataPros.com "Visibilty" solution, which looks great, but won't work within another portal. Any suggestions? Thanks.
-
- 2 replies
- 703 views
-
-
Hi. I am new to this board. I am not new to Filemaker but I am not real knowledgable about scripting. Can you help me with this? I have a database of many records and I have put a check box in it called "Advertiser". What I need is for whenever anyone checks that box on any given record, a script will automatically add the text in the "account name" field from that record into a value list that they can choose from on another layout. Is this possible and how do I accomplish this? Ron
-
- 29 replies
- 2.6k views
-
-
I have a layout in form view that has data pertaining to an organization. In this layout I have a portal to another file that has names data. The key that links these two is a numeric field called organization_ID. The portal fields are Prefix, First name, Last Name, Suffix, Birthday. I want to enter in the first name and last name in the portal and do a search in the related records. Is there a way to do this? If I get multiple matches, I would like to choose from the results. If I get no match then I want to create a new record in the related file.
-
- 4 replies
- 712 views
-
-
Hey, we all (should) know that Macs rule graphics, and here may be another case... I create my image in Photoshop. I can select any active pixels on a layer, allowing me to copy much more than just a rectangular image to the clipboard. I paste the image either on a layout directly or in a container field; it shows up just fine... on the Mac. When I move to the PC, I get a stinkin' ugly white box where the invisible pixels were. What's the deal? See the attached GIF for a Mac vs. PC comparison of the graphic in question.
-
- 14 replies
- 1.9k views
-
-
platforms windows and mac, filemaker 5.5 I've got an image database that has thumbnails and references to images on a server. In the client database, i've created a relationship for customer_id::images and customer_id::client So, there is a scroll down thumbnail list of client images when you click on a particular client. On the right side of the same layout, I created another relationship with customer_id&record_number::image = cusstomer_id&g_record_number::client. So, when someone clicks on the thumbnail image, an enlarged image is shown to the right via a reference file. However, I have not been able to figure out how to keep the portal …
-
- 8 replies
- 1.4k views
-
-
Wow, what a great site this is! i cannot believe all of the knowledge here. Right off the bat I have a question. Of course, that is why I joined. Maybe one day I will be able to provide an answer or 2. I am attempting to create a database to track my workouts. Although there are other things I am tracking, the main 2 are cardio and weights. The question I have applies to both weights and cardio, but for simplicity's sake, I will use cardio. I have a " MAIN" file (Unique key, date, Journal), a CARDIOMAIN file (Unique Key -from Main, activity, location, time of day, notes), and a CARDIODETAIL file (Unique Key -from Main, rep #, duration, distance, and severa…
-
- 2 replies
- 737 views
-
-
Can't seem to understand the relationship trick that needs to be applied. A Value List shows a checkboxlist from the field (text). I need to have the checkboxes that are selected (on each record differently) appear as rows in a portal. This way I can click in the portal and go to the related record in the same document. Really handy to move between records. Any ideas?
-
- 6 replies
- 1.9k views
-
-
I'm not sure how to phrase this, or which forum to put it on so I'll just start here. I would like to have my database do the following scenario: IF value in field (A) = "YES" then value in field (: = "0" IF value in field (A) = "No" then dialog box prompts you to ENTER VALUE. IF value in field (A) = "Don't know" then question for field (A) shows up on a separate layout called UNRESOLVED QUESTIONS. As each question does get resolved I would like to have the requisite answer show up in the originating Layout. And since we are on a roll here, why not add an ELAPSED TIME field to track how long the question has been UNRESOLVED. I know this is…
-
- 1 reply
- 775 views
-
-
Can someone offer me some insight on this? I have an 'Artist" database that I have included in this post. There are 2 layouts, "Artists". and "Artist Report". When you enter data in the "Artists" layout it then displays the spins in a column on the "Artist Report" layout as well as the week ending data in the header for that Artist. As we enter new records we date them exactly 7 days apart. What I would like to do is to get the "Artist Report" to display not only the current week ending date and current spins, but also the previous week ending data and the previous weeks spins. I want to be able to do a find for a particular artist, then go to the "Artist Report" layout…
-
- 0 replies
- 789 views
-
-
I have a "summary page" that is running in browse mode. It is needed to do this because I have buttons assigned to it that when someone clicks on it, it goes to the selected record. I was wondering if there is any way to put a summary count of text in the body of the Browse Mode document? In other words, a Field named <<Position>> has in it, text like: V.P. of Sales, or Drill press operator, etc. And it needs to be summarized and counted. For instance, there might be 4 V.P.s of sales. I need to put a field next to the position field that says "4" so when I browse it, I see that I have 4 VP's of sales. I can then create a button that goes to the …
-
- 2 replies
- 1.5k views
-
-
Hello, I've made a layout that includes a portal. The "show vertical scroll bar" option for this portal is checked. But the scroll bar seems to disappear in certain instances. Does the scroll bar only appear when you click in the portal? When I come from another layout, I don't see the scroll bar until I click in the portal. I also have a button on the layout that takes you to the related record of whatever item I've selected in the portal (but it doesn't take you to another layout). This also makes the scroll bar disappear. There are always more records/items in the portal than the number of rows shown. Thanks, Lee
-
- 2 replies
- 821 views
-
-
I have developed a solution in mac and windows environments. Some fields are repeating fields (five repetitions). The values of these fields can be obtained from a value list shown as a pop - up menu. (the values are amounts of text). The mac version works fine - click on the field, pop-up menu appears, select text, and in it goes! On The PC, however..... click on the field.. nothing happens, I cannot gain entry to the field. I have checked the field format and "gain entry to field is selected" The solution is exactly the same, copied on to CD from mac and then dragged over to PC. I have deselected "read only" from properties menu. Any suggestions?
-
- 0 replies
- 666 views
-
-
Is there a size resitriction to value lists ? I have 2 related files, which when I create a value list from them showing 2 fields, will always (I mean always) cause FileMaker to crash if I try to use the value list in the main file. I am assuming they are too large and File Maker can't handle it. Assuming this is the problem, is there anyway that you can have a user select an item from a list of say 1000 options without using the value lists as they stand. Thanks
-
- 2 replies
- 871 views
-
-
I have a value list which looks up values from a second file. When I use the option of showing a second field from that file in the value list, FMP simply crashes each time I try to use the value list. Any help much appreciated. For those who understand these things, I get the following techno-babble. FILEMAKER PRO caused an invalid page fault in module FILEMAKER PRO.EXE at 015f:004943a1. Registers: EAX=00000004 CS=015f EIP=004943a1 EFLGS=00010246 EBX=00000000 SS=0167 ESP=0098f9d8 EBP=01b70b00 ECX=02862678 DS=0167 ESI=02862678 FS=57bf EDX=00010050 ES=0167 EDI=0000000f GS=0000 Bytes at CS:EIP: 66 83 40 02 0e c3 90 90 90 90 90 90 90 90 90 a1 Stack dump: …
-
- 1 reply
- 822 views
-
-
I am trying to redesign a multifile solution so that all the layouts are stored in one core file. At the core of the system are clients, payments, sites, and deliveries. Each client is assigned to a site, and has deliveries made to that site. Payments are linked both to the client and the individual deliveries. Currently, I have layouts and scripts in each of the files of the solution, but maintaining the solution at a distance makes this method problematic (to say the least), but I want to unify the interface in one menu file that will read and display data from all the rest of the files. To start, I have a layout that has multiple clients summarized on it. In…
-
- 10 replies
- 954 views
-
-
I have three tables, purchase_orders.fp5, po_lines.fp5 and inventory.fp5 The purchase_orders table has a portal of po_lines set by a relationship on the field po_id. I have written a script so when the items ordered from the purchase order are received, the user can hit a checkbox and activate a script within the portal row that should add that item into the inventory database. Everything works perfectly except that no matter which row is selected the first portal row is the one referenced (set field 'temp' by po_line by po_id:product_id). I assume this has something to do with the way I have my relationships setup. Ideas?
-
- 8 replies
- 998 views
-
-
I have build an work order form with 5 portals (jobs_line_item::jobs) in it and everything is ok,but problem is how I can take data from each portal(each portal have same relationship ) and display to Invoices form.(mybe it is simple but...) Database.zip
-
- 1 reply
- 735 views
-
-
Hello People! Here is antoher Q that has been more than bothering me....so if anyone can help/advise it will be great and perhaps you extend mylife for a few days I have 2 portals that lead to LineItem file but I am getting 'duplicats' generated in the 1st if data entered into portal2 is associated with it. Now, this does make sense since they booth lead into same file....my question is: Is there a way arround this and way of recording " 1->many " entries? I am also attaching a screenshot for better understanding of the problem! Thank you all!
-
- 24 replies
- 1.8k views
-
-
I would like to use a radio button with a value list. When I do this, the fields and their corresponding buttons align themselves horizontally across the layout. If the value list is long, or the values in the list are character intensive, these radio button choices require that you scroll to the right to see them all. Is there any way to have more control over how they appear in your layout? Is it possible to arrange them in groups a number eight domino? Thanks!
-
- 3 replies
- 833 views
-
-
I have a data base that contain similar to the one below: Col-1 Col-2 2 2 5 3 (from col-1 (5-2)) 10 5 (10-5) 11 1 (11-10 Value on Col-2 is by subtrating Portal Line 2 from Line 3. Problem, I need help to do it.
-
- 7 replies
- 872 views
-
-
Is there anyway to have a checkbox with a scroll bar so that the user can scroll down the list of say 20 or 30 chooses. I need to put 20 to 30 chooses in a checkbox format but i wanna save room by having a scroll bar to navigate through the chooses. Thanks for any help you can give me.
-
- 5 replies
- 1.4k views
-
-
Hi, I can not remember for the life of me what is the function to choose a specific value list entry. For example, I have long entries, and don't feel like typing the whole entry in calculation field: MyValueList entries: 1. This one is pretty long 2. This one is even longer SomeField is formatted for the above value List. CalcField: Case(SomeField(Function(MyValueList, 1), do something, Function(MyValueList, 2), do something else,...blah blah. I think I remember there's a function like that, but can't recall which one:) Thanks in advance
-
- 1 reply
- 645 views
-
-
hello all were do i begin (no not at the beginning) i have a repair database im building the important files in this problem are a a repair file, a partslist file & a stock list file i have a form with the repair product details & a portal for the parts list. in the partslist is the following fields (lineno, partno, qty, description, unit price) i am going to populate the stock list with parts held in stock (the fields will be identical (thats important i,e what is above) as in parts list) i want to use a popup list on the partno. field on the parts list to select (portal) a part from the stock list (which is fine & works) but then i wan…
-
- 1 reply
- 657 views
-
-
I have a field where you make value list selections with radio buttons. When you click in the field these radio button options are presented horizontally on the layout. If my text (per radio button) has too many characters I have to scroll to the right to see all my choices. Is there a way to format this list so that the buttons are on the left and the list presents itself as a vertical column rather than a horizontal row? Thank you for sharing my pain.
-
- 1 reply
- 731 views
-
-
I am a Filemaker newbie and find the "tab-style" interface (like the one used in the Aqua Template) both attractive and functional. I can't find any references on how to do this. Is FM6 required or can this be done in an prior version? Is there a how-to posted anywhere else in the forums or on this site? Any help will be appreciated!
-
- 4 replies
- 1.1k views
-
-
I know this might belong in Relationships or Define Fields, but it also belongs here, I think. I have a multi-file database full of portals and relationships. One is between Agencies and Addresses. I decided to put addresses into a separate file because some of our contacts have two or three locations, most have just one, and a few have 25 or so. I'd like to have an Agency Summary layout to print. I'd like it show all appropriate addresses, but I don't want to make 25 portal rows just in case and have them all be blank 90% of the time. I've considered building a different layout for each number of addresses, but it's an awful lot of work, and I'm not …
-
- 1 reply
- 682 views
-
-
I have 3 files mainly involved with what I want to do. First, I have a database that does nothing more than parse an entire webpage into the fields I want the info in, and then exports, and reimports it into my "OIL" database. The "MAIN" database then has a portal that looks at the data in the Oil database. The Oil database has 2 different kinds of data. Personal information, and account information. Here is what I would like to do from here: 1, have a radio button above the Portal, that switches between the Personal data, and the Account data for each client. 2, I need to filter out records that match various "Oil Status" entries. 3, each re…
-
- 1 reply
- 905 views
-
-
Does anyone know if it possible to change the font color of a field on the fly eg. If someone selects urgent from a DDList box the font color in the the comments field will change to RED?? The solution I currently have implemented is from the previous post and changing the background color but it would be better if i could modify the font color
-
- 1 reply
- 864 views
-
-
I am creating a billing database with conditional value lists. The first database (customer database) holds customer information, projects, and specific project information. I originally wanted to list each customer and then the associated projects, but I couldn't exactly figure it out so I just imported the excel spreadsheet I was working with. Now it lists everything as individual records. The 2nd database (time/billing) is a timesheet for consultants to use. The relationship exists between the customer database so they can select the customer, and then select the project for that customer. Here is my problem: I can get the timesheet to display the custo…
-
- 4 replies
- 897 views
-
-
I hope i am posting this question in the correct section. I seen this done in a runtime solution so i can not look at the way this was done or post it here to show you what i am talking about. I thought it was a neat way to do a help system or FAQ section. Anyway here it is: There was a layout that had a drop down value list that had predefined questions in it for example "How do i add a new record?" and when you chose that question it would give the answer in a text field right under that. It appeared to be a text field with a scroll bar. Does anyone know how to perform this? I tried searching the posts but i don't think i am putting in the correct search terms. Tha…
-
- 6 replies
- 1.1k views
-
-
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
- 814 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online