FileMaker Interface Features
-
Hi, I'm using FM7 on MAC and I'm a beginer. I'll try to use the good terms to explain my problem. My problem is that I'm entering date and I want to set it up YEAR-MONTH-DAY. I've changed it that way i n the LAYOUT, clicked on my date field and went to FORMAT>DATE and changed the format there. Selected Custom, then Year, Month, Date seperated with "-". No problem so far. Now, in the BROWSE section, it looks as I wanted, YEAR-MONTH-DAY. But when I click on the field, it changes MONTH/DAY/YEAR and I have to enter the data that way. When I hit enter it goes back to YEAR-MONTH-DAY. Now how I do change the fact that when I click on it, I have to enter the d…
-
- 4 replies
- 922 views
-
-
Hello I am kinda at a stand still with this one form I am working on. Ive attached it for your visual reference. Heres what I am trying to do: Its a contacts page using a Tab Controlled Form to seperate contacts by groups. Then using portals to retrieve that information and display it the correct Tabbed page. So for instance, if Company Test 1 was associated with Group 1 from the drop down menu, I would like that Company to show up only on the Group 1 Tabbed Portal. And say if Company Test 4 was associated with Group 3, I would like that Companies information to show up only on the Group 3 Tabbed Portal. I am kinda getting some results from the 'gues…
-
- 2 replies
- 712 views
-
-
I have a layout for printing that combines all the information from other layouts. It spans two pages in layout mode. As the fields' information content varies, I use sliding. In preview mode/printing the follwing happens: All the fields that are slided to the first page show up properly but the text labels belonging to them do not. They just disappear. Turning off sliding or turning the text labels into fields is the only way to get them to show. The second problem I have with sliding: When slided to the first page certain fields get separated (one part of information showing on page 1 and the other part on page 2). This wouldn't be such a big problem if they were jus…
-
- 0 replies
- 672 views
-
-
I have a layout on which the only user-changeable field is a date field, which uses the pop-up calendar for entry. The problem is that after clicking on a date, the calendar does not pop back down like it does on other layouts. These calendars seem to have a need to auto-tab to a next field and on this layout there's not one. I tried several things but an extra click out to the side is always required. Is there a way to get around this without adding a dummy field just to "catch" the tab action? Thanks for any help with this.
-
- 9 replies
- 1.2k views
-
-
Hey all, Here;s the issue, i need to produce a report such as the following: Sex - Male________100 (50%) BREED 1 = 5 (5%) Andy Will Ashley BREED 2 = 55 (55%) John Brendan ... BREED 3 = 40 (40%) Joshua William ... Sex - Female________100 (50%) BREED 1 = 10 (10%) Laura Willma Ash BREED 2 = 50 (50%) Joanne Brenda ... BREED 3 = 40 (40%) Lianne Jo ... And so on, i'm just having problems figureing out how to get the percentages of a particular subsummary - anyone lend a hand? Cheers, ~Genx
-
- 2 replies
- 900 views
-
-
I apologize if this has been answered before but... I want to create a report based on: Managers Table: Mgr # Cost Center Hours Worked Table: Employee Cost Center Hours The report should look like: Manager Cost Center managed Employee charging time to that CC 2nd Emp charging time ... 2nd Cost Center managed Employee charging time ... Next Manager ... I'm sure I'm missing something obvious, but I don't see how to do this short of creating a new table via a script and then reporting from that. Any help would be apprec…
-
- 0 replies
- 588 views
-
-
I have a layout with a background set by a global container field. The Field Behavior has "Allow field to be entered:..." all unchecked. This field object is locked, using the Arrange:Lock menu. In Browse mode, when the user clicks on the background a message window is displayed with: "No records are present. To create a new record choose New Record menu command." The layout is based on a TO and has a portal and a couple of other fields. The background global container is in a separate globals table. Why does this happen and how can I turn it off? TIA
-
- 4 replies
- 2.9k views
-
-
Hello, My apologies in advance if this is not the correct forum to post this question in. I'm fairly new to FMP, although I have quite a bit of experience with databases generally. The issue I'm having is in trying to create a drop-down list that contains values from one set of fields, while actually storing something related to those fields. Here's the situation: I'm making a database to keep track of appointments for a medical professional. I have one table ("Client_info") that has reference data on the patients, including First_name, Last_name, etc. It also has an automatically generated, unique number called Client_ID, which is the primary key for all t…
-
- 2 replies
- 876 views
-
-
Hello everyone, is there a way to have a button that opens a windows explorer window in a specific directory?
-
- 1 reply
- 986 views
-
-
Newbie Question: When someone enters my db, is it possible to open to a blank record? and if so how, as I have looked and looked for the solutions but have found none. I really do not want to enter with the New Record Request as I want a blank start for the user to decide what they want to do...search, new etc. Thanks for your assistance, Jim
-
- 3 replies
- 1.1k views
-
-
Hello, I'm wondering if FM has any way of making something similar to the Title Footer, except instead of appearing only on the first page, it appears only on the last page of the Preview. Any ideas? Thanks, M My apologies, this has already been dealt with http://fmforums.com/forum/showtopic.php?tid/177458/post/208840/hl/footer+last/#208840 Apparently the answer is sort of (with Trailing Grand Summary).
-
- 1 reply
- 642 views
-
-
Hi all.. I'm having a big problem developing a "Fast letter create" solution. My goal is to get it done by a layout which is divided in several parts like salutation, content, closing and finalisation of the letter, where the user can click a selection-field and select a pre-defined value. So far, so easy. But now the problem consists in the fact that this Value-List must be influed by several parameters; language, topic etc. (e.g. Only values on the right language, amd of the right topic must be displayed). How shall I realise that? I thougt about some kind of Value-list filtering, but have no idea how to do this. Please help me with that…
-
- 10 replies
- 940 views
-
-
A small thing, but slightly annoying. Everytime I go to a layout and choose print and then from that dialog choose pdf it comes up with a default filename for that pdf. It's slightly annoying because I sometimes have clients over me watching and it's not good to see some other projects name pop up. Any thoughts?
-
- 3 replies
- 635 views
-
-
So, if I can't subsummarize a report based on a related field, how do I do show summarized information from several tables? I need to show information about the current school year (table = activeYear which is the base table for my report layout). How do I summarize students and teachers by memberCode (table: activeYear),by school district (table: districts), by school level (table: schools), by school (table: schools), by ethnicity and by gender (table for both: persons)? I know this is a very bare bones description of my problem, but I'm better at answering questions that at anticipating them. Abbe
-
- 2 replies
- 613 views
-
-
Some of my portals defualt to having an extra line to add a new record, while others do not have the extra line for quick, new records. How does one turn this extra line on and off?
-
- 3 replies
- 641 views
-
-
Is there a way to show a dropdown list in a custom dialog box? When the user clicks "new" I want them to be able to choose which subsection it's going under and that value will fill in the subsection of the new form.
-
- 2 replies
- 1.3k views
-
-
If you've got two layouts in one table, can you restrict which records are shown by each layout? I know I can write a script that shows only certain records based on field contents, but can I make it work in such a way that the user doesn't have to run the script? I just want Layout A to show X records and Layout B to show Y records, all in the same table. Is this possible? Thanks! Tom
-
- 2 replies
- 597 views
-
-
I am trying to invoice a group for membership fees. I would like to keep record of all invoices for each customer. There are some other things which I need to do, but I think if I can figure out how to set up TOs for a simple invoicing. I have members who get billed yearly, and I would like to be able to input past dues information to keep track of what each member has paid as well as ongoing dues which are billed. What is the simplist way to go about this? Thanks.
-
- 1 reply
- 655 views
-
-
This is probably a very simple question, but I'm still trying to convert from a FM4 way of thinking to FM8. I have a "sample" table where records are entered as samples are submitted. I also have several "service" tables, each representing a different "service". Any combination and number of services may be performed on a particular sample. I need to generate reports for invoices and packing lists as follows: Sample (from Sample table) Service 1 Record 1 (from Service 1 table based on sample) Record 2 (from Service 1 table based on sample) Record 3 (from Service 1 table based on sample) Service 2 Record 1 (from Service 2 table …
-
- 6 replies
- 904 views
-
-
Hi, I have a traditional Invoice layout containing a portal that lists the Lineitems. Until now, line items are added/deleted/modified as portal rows. No problem. Now I need to implement an edit that cannot reasonably be done by editing a field in a portal row. For this, I want to open a new window, show the LineItem record, allow the edit to be made, and close the window. I placed a button in the portal row layout, which runs a script that creates a new window and does a Go To Related Record (to display the LineItem record in question). The layout here contains about 30 checkboxes that set a multi-value field in the LineItem record. It works, except on "new…
-
- 10 replies
- 1.3k views
-
-
Is it possible to have a portal inside of a tabbed Control element? I created a tabbed element with 3 tabs, and tried to drag an already created portale into it, but it doesnt seem to work.
-
- 2 replies
- 1k views
-
-
Hi, I have a field on my layout which has Get(FoundCount)…am I wrong in thinking this should not show a total of the files found in a search (a total of files?) Mine shows 1, then you arrow over to the next record and it shows 2 and so on. What I am seeking is something to show the total number of records found in my search. Can anyone assist me? Thanks, Jim
-
- 2 replies
- 691 views
-
-
Hi, all. What a weird "problem"! I need to put two merge fields next to each other, inside the same "field", right-aligned, for display on a layout. I want them to display in the left-hand third of the layout. The problem is that <><> is so long that I can't slide it into position: it bumps into the left edge of the layout! If I try to resize the whole gizmo, FM re-extends it towards the bottom which results in the "field" being 3 or 4 lines high, which is not what I want at all... Any suggestions? Thanks!
-
- 8 replies
- 929 views
-
-
I know this should be easy but... I want users to only information into a portal, not see the file where the info is kept. I have a button that creates a new portal row, but when I try to click into it and enter information, it selects the entire row and won't enter into any fields. I've got "Allow creation of new records" turned on. Can anyone tell me what I'm overlooking? Thank you!
-
- 1 reply
- 667 views
-
-
Hi, Beginner here. I'm creating a form letter which is fairly long. About 2 of my paragraphs plus the signature show up in the layout mode but not in preview mode. It looks like the text box is big enough to accommodate it, so I'm not sure what's wrong. Any suggestions?
-
- 1 reply
- 628 views
-
-
Im new at filemaker and have a lot of questions. so bear with me... I use filemaker at work and we have 1 layout so far which was created before I started working here. It's a 8.5 x 11 form. Now we want to create a second layout - cue card size -. Will the information I input into the form automatically input into the cue card?? Is there a way I can do this?? Thanks for your help
-
- 1 reply
- 578 views
-
-
hello, I work for a large University and lately I've been scanning slides and putting them into FMP 7. I'm using the photo catalog to display the slides. The issue I'm having is it takes forever and a day to display the images. My question is how can I speed that up, and is it possible to make the default viewing mode "List View?" If it is, is it also possible to make it so that the only way they can see the slides blown up is for them to download them? Also the file sizes for the pictures are about 3 megs. Thank you for any help.
-
- 2 replies
- 640 views
-
-
I'm setting up a new database to put a handbook into...there are sections (admin,sales,marketing, etc.) and sub sections(marketing_database, marketing_pricing, etc.). I have it set up so there is always the sections and the buttons change for the subsections depending on the section. On each subsection I have the usual fields (date, title, regarding, procedure text, etc.)...but on the main page of each section I wanted to put the section title and subsection titles with the articles listed as links to the articles under each subsection... like this kind of... Marketing Pricing Article1 Products Article2 …
-
- 1 reply
- 938 views
-
-
Hi, I use filemaker at my job, we basically use it to keep track of all our design/web jobs. There was already a layout existing when I started. Basically just a 8.5 x 11 page form. Now we want to create another layout a cue card format. But we still want to have the existing 8.5 x 11 format. So is it possible to have 2 layouts?? Im not very familar with the software so any tips would help! Thanks!
-
- 3 replies
- 773 views
-
-
I am creating a set of pop up menus that are part of my Dynamic Values Lists and was wondering if it is possible to get the first box under the list not to be automatically selected when I use check boxes. For example. I have a field called country, and I can select USA, Canada, Mexico, etc. If I use the check box layout once I click on USA, the first state checked is Alabama. Is there anyway for it to not to check anything until I click on it first? Many thanks! Chris FMP 8 Novice
-
- 0 replies
- 706 views
-
-
hi! i got a database with a valuelist for different interests that i want to link ta another valuelist in the same table. depending on what value you choose from the first valuelist, different value (are suppose to) appear in the other valuelist. for example: sports --> basketball crafts --> arts that is, if i choose sports arts should not appear. ive got all the valuelista and field defined, i just need to link them. am i suppose to use a linking within the same table? thanks...
-
- 4 replies
- 773 views
-
-
This is fairly complex (to me), and I probably won't explain it right, but here goes. I have two tables, Table1 and Table2, a one to many relationship. Table1 contains JobNumber (the relationship field) and JobRep. Table2 contains Portal1, multiple instances of ItemPrice, and TotalPrice, a summary of those prices. TotalPrice is multiplied by field Commission to return TotalCommission. Table2 also contains Portal2, OutsidePayments, and TotalPayments, a summary of those payments. Calculation field Profit = TotalCommission - TotalPayments. I want to run a columnar report sorted by JobRep with Subsummaries and Grand Totals of TotalCommission and Profit. But when I ru…
-
- 5 replies
- 877 views
-
-
I'm trying to make address labels. When I preview them, there are a few little changes that should be made on selected labels. Can I go into separate labels and edit them? I'm pulling my hair out here! Any help would be very much appreciated! Thanks!
-
- 4 replies
- 772 views
-
-
Newbie here. I have a self join relationship for Tasks. I have a layout that shows a portal of a few fields for all the tasks. I want to be able to select one of the portal rows and open it in a new layout to show all of the details for that task. How would i script this with an "open selected task" button on the main task layout? Thanks for any guidance.
-
- 5 replies
- 804 views
-
-
I am trying to create a field that uses a drop-down list to allow users to navigate between layouts. I would prefer not use a seperate "GO" button. Basicaly a customized version of the layout navigation system that FM uses, any ideas? jeff
-
- 2 replies
- 786 views
-
-
I'm constructing layouts where I hide the status area and don't want the user to use. The users still would like an omit checkbox and symbols drop-down. I made a separate find layout to place these items on, but I'm not sure how to construct them or get them to work...or if there is an easier way. (I'd like to stay away from plugins if possible.) I'm new to this, so I'm not really sure what's possible in FileMaker. Thanks.
-
- 4 replies
- 935 views
-
-
I have assets printing to a report. On the software report there is a notes section. Some items have no notes and others have really long notes. Is there a way to make it so that I could put a field on the report layout so that if there was a note, it would display (to the right length to include everything), and if there was no notes...it wouldn't show at all?
-
- 4 replies
- 800 views
-
-
Is there a way for the columnar (list) view to behave like Excel where you can keep the left most column...say, a persons name...as you scroll sideways right to bring out-of-view columns in to view. So you can keep the name visible on the far left as you search across to info in various fields. Can this be done in Browse and/or Table view? Thanks all in advance, Michael
-
- 2 replies
- 832 views
-
-
Am I missing something? I have a value list to pull the sales persons id number from the staff table, placing it in the clients table. But the value list only shows the first record in the staff table.
-
- 1 reply
- 722 views
-
-
I could not find an area for this question,so forgive me if it does not belong here. I'm sitting here poking the buttons on FM8A and everything is good. I close the program out and go eat. I return to working and open the db and my print options (the printer button on the tool bar) as well as the drop down from the tool bar are greyed out. Anybody know what I did? Thanks, Jim
-
- 7 replies
- 964 views
-
-
I have a many-to-many relationship between Contacts and Companies. I want to add a new Contact from a Company Layout. Do I... 1. Use a script to set the ID field relationships? 2. Use a Portal from the CompanyContact Join table? Using the Contact Portal in the Company table does not seem to work in this case. I know 1. & 2. work, but what would a pro do?
-
- 0 replies
- 733 views
-
-
I am having difficulty getting the Edit button to appear in formatting the layout for a list that uses two fields. When it does appear the "using value list" does not show the list name. When I change it to show the list name I have chosen, the edit button is no longer available. What am I dong wrong?
-
- 5 replies
- 926 views
-
-
I was hoping to figure out a way to easily set a section of a form layout to be similar to the columnar setup, where every other line is a lighter or darker shade of grey. Is that possible without manually drawing the boxes and coloring them manually? I want a NOTES field, similar to an address book, but I would like every other line colored differently. thanks
-
- 2 replies
- 1k views
-
-
Many examples I see online have nice icons for the header menu items. Like COntacts,phone book, things like that. But I dont see anywhere in the program where there is a selection of clip art like that. Is there one? Is there a web site that has a collection of icons for use with filemaker? I was hoping to just find some, and not have to make any.... Thanks
-
- 1 reply
- 725 views
-
-
Here I have a drop down menu container field solution for labeling purposes! The problem i have is when I click the menu and select the color it stays on text until I click off the menu, then it will reveal the color container! Please see file! iPassword_4.04.fp7.zip
-
- 21 replies
- 1.5k views
-
-
I have a script that runs by clicking a button in a portal row. In order for the script to complete its steps, I have to click anywhere outside of the portal. Is there a way to eliminate this step? Thank you
-
- 7 replies
- 764 views
-
-
Hi everyone, please excuse the newbie question - I consulted the search engine but didn't net a result. I'm trying to figure out how I can set up a custom dialog script (popup window) that displays a value list (drop down menu) for a given field. Basically I want the diaglog to ask 'What is this persons location' and then the user can select one answer from a given value list (which then becomes the 'location' field). I understand how to define fields that must be a member of a certain value list - I just can't get those values to show up in a custom dialog script step. Can this be done? Thanks once again in advance
-
- 5 replies
- 1k views
-
-
How do I have buttons remain visible in View as Table mode? Thanks!
-
- 4 replies
- 821 views
-
-
I'm trying to display multiple full, printable multi(15-20)-page documents in FileMaker. Now, I realize that as opposed to copying and pasting the documents into FileMaker to print them, it would be more feasible to simply allow FileMaker to print them through their own file with a script, but I'm supposed to have them viewable (all 20 pages) in FileMaker. It seems, however, that FileMaker has a maximum page limit of 11. Is there a way I can properly display all 20 pages and print them from FileMaker? Thanks a lot! M
-
- 5 replies
- 1.8k views
-
-
I'm trying to create a value list for use in a popup. Each record is a company, and each company has up to eight locations, each location name defined by a separate field in the record. Now, I see from examples in this forum that I can create a new table, linked by a primary key (say, Company ID), and then create a new record with the primary key and the field value for each location in order to make a popup list. That's fine. But is it possible to keep the field values directly within the company's record, so that I don't have to make a separate table for the locations? It seems like I cannot because popup lists only want to grab from one field, whereas I need it to grab…
-
- 1 reply
- 658 views
-
-
i am looking to use a massive portal filter/query in fm7. i have 6 fields of various types i want to filter with, and i want the ability to select "all" from each of the fields. i'm having trouble getting my head around a decent solution here and am still struggling through the new relationship model. it's a 1 file system and the portal will show records from just one table (of course). i just can't find a nice way to make the huge portal filter work. each record in the bugs table has the following properties, amongst others: status - can be 1 of 4 text choices from value list target - can be 1 of unlimited text choices from value list prior1 - can be 1 o…
-
- 4 replies
- 1k views
-
-
Hey there, I'm working on making a database of products for a company. I can't get it to end up displaying properly though. Firstly, my portals go across pages, a no-no. I've grouped them in with the parts that they should stay with, but this still doesn't prevent separation over pages. I've looked, but couldn't find out. How do I accomplish this? Secondly, because it uses portals, it also slides. However, the first slide never seems to work properly (the second part doesn't slide up far enough) unless there is a certain amount of data in the portal. Is there a reason for this? Lastly, in looking at my example (sorry I had to clear it and fill it up again) is ther…
-
- 0 replies
- 683 views
-
-
Hi everyone, First, I'm sorry if this is too simple of a question to ask. I really don't know how to proceed. I have a database that is basically a rolodex of companies, with addresses, phone numbers, and contact people as fields. Everything has a 1-1 ratio except that a company may have up to five contacts, each with his/her own phone number. These are all separate fields as part of the company's record, meaning there's a contact #1 field, contact #2 field, etc. There's a separate database for creating job postings that uses the employer information from the first database. So, under the employer name field, a user can select an employer from a drop down m…
-
- 1 reply
- 716 views
-
-
I have been beating my head against the wall trying to figure this out! I want to print a record, but at the same time create a log of the record in a seperate file. Here is my code: Go to Field [select/perform; Office Copy Card Activity::Date] Go to Portal Row [select; Last] Set Field [Office Copy Card Activity::Date; Get( CurrentDate)] Set Field [Office Copy Card Activity::Time; Get( CurrentTime)] ... I have created a relationship between the 2 files, but everytime I run the script and expect there to be a record created in the other file there is nothing! Please help!
-
- 1 reply
- 730 views
-
-
sorry if this is posted in the wrong location. I'm working on documentation for my latest solution which requires a lot of screenshots. To get a little better image for print I increase the view size to 150% to do my screenshot. Today I noticed that my portals were slighly off when viewed at this size. at 100 and 200 % they look fine as intended but at 150 they are off. In the "object size" palette they stays the same but viewed on screen they get a little taller as if they gained a few pixels in height. Can anyone confirm this as a bug?
-
- 2 replies
- 729 views
-
-
I am trying to create a column/list report that summarized data by department. The problem is report has spaces where the body is for each record under the department. I have shrunk the body down all the way, but when you have 450 records the space is still large. Is there a way to build the report without the body so I just have the summary data showing? Thanks, Scott
-
- 5 replies
- 1.1k views
-
-
Hi, all! Set up: I have a Pop-up Menu Field that displays values from a Value List, a list of employees in this case. Below that is a Portal that displays various data about the selected employee. Need: I'd like to have an "Next" button and "Previous" button to the left and right of the Pop-up field that activates a script to go to the next/prev. employee in the Value List. Is this possible?
-
- 16 replies
- 1.5k views
-
-
Hi, hope this is the right place to post this question, as it sort of straddles a form/portal divide. What I am trying to do is add a "Find Duplicates" function to a major contacts database for the university I work for. Idea is that: (1) Find Duplicates button on the main Contacts form pops open a dialog box. (2) The dialog allows the user to choose which field (Surname, Organisation) to check for duplicates and what other information to factor in when considering a record a duplicate. (3) On clicking OK, a table style view of every matching record opens in a new window. (4) User can click on any one of these table rows to open the full record ca…
-
- 8 replies
- 1k views
-
-
Hey gang, Is there a symbol or merge to insert the total records in a table onto a layout. I thought I saw something like that somewhere. I have @@ for the record but I want it to have @@ out of ?. Can this be done? Thanks Mike
-
- 9 replies
- 1.4k views
-
-
I'm not sure this can be done and I haven't seen this discussed recently so let me ask the question. Can you change backgound or border colors based on the content of a field? I have a field called "Type." Choices are "Client", "Candidate", "Source." I'd like to have the backgound color change based on the type of contact. Any help would be appreciated. Thanks. Al
-
- 4 replies
- 958 views
-
-
I've went through and read all the posts i could find relating to portal sorting/filtering but i am still am having an issue. The issue being: I have a portal wich displays all the records in my "contractor" table. I have another table "FP" wich has info regarding our jobs. These two tables are related by a field called "recordID" in each respectivly. There are mutltiple "contractor" records, for every one "FP" record. The "Contractor" records that correspond to the "FP" record share the same "recordID". I need the portal to display only the records that have a "recordID" that corresponds to the "FP" record Im on. Sorry if this sounds a bit con…
-
- 1 reply
- 572 views
-
-
Is there any way to create a navigation "breadcrumb" menu on a layout (similar to one on this page)? I am looking to create something dynamic depending on where you are: Home > Planning > New Request So that you can click on the names and return to the previous layouts.
-
- 3 replies
- 980 views
-
-
Hi. I have a main table, contracts table and amendments table. Main can have multiple contracts and contracts can have multiple amendments. I have a portal for contracts on the main table. I can successfully add multiple contracts. Now I need to be able to select a contract row and be able to add an amendment (or several) for that contract record. How would this be handled? Thanks for any help!
-
- 13 replies
- 1.2k views
-
-
All I am in need of what I thought would be a simple solution. No luck. I have 1 table that is a summary list of my clients. In it there is a unique 6 digit client id number. The second table has multiple records per client. There also exists the same 6 digit client id number in each record. As the number of times a client could pay is different, there can be anywhere from 1 to 4 (or more) different records per client in table 2. I have used the sum(child table::amount) calculation. It works. Kind of. I'm only getting a result returned for those clients that have 1 payment record. Those clients with more than one are not showing up. I know…
-
- 7 replies
- 898 views
-
-
I am having tis problem when I lock one field in my portal for editing, all the fields in the portal become locked to editing. Any suggestions where I went wrong? :
-
- 2 replies
- 656 views
-
-
I was hoping some one might be able to give me some help using windows, is there anyway to remove the side bar or make new windows act more like pop up windows online? I know the basics, resizing, tileing, movement etc. I just need some help on the more customizable aspects of the windows, if there are any.
-
- 5 replies
- 1.5k views
-
-
is there a way to replace the buttons with custom buttons or arrows?
-
- 3 replies
- 1.3k views
-
-
Hi im trying to get my value list to work where I have a main date field where a customer selects a particualr date. Then after they select a date there is a value list where the user has to chose what kind of reservation the reservation is. ie. birthday party, corporate, fundraiser etc. Once the two fields have been selected the third field, is so the user can choose what time the reservation is for. Keep in mind that the time slots are different depending on what day of the week it is and what kind of reservation is chosen. What I was thinkin was something along the lines of if(DayOfWeek(:date) = 1) Load a particualr value list or something. If anyone has any sugge…
-
- 1 reply
- 722 views
-
-
It seems that it's not possible to replace the content of a field with a value list by a calculated result. I have two fields in my solution called "Status" and "Commercial status". My Commercial status field has value list that reflect the overall status of the job (in progress, to invoice and finished). I would like to have these values changed by a calculation based on the status field. My calculation is like the Case(num_jobs::totalprint<"1";"To invoice";"In progress") But nothing happens! The calculation runs ok when i change the field to an edit box. Anyone an idea why ? Thanks in advance.
-
- 0 replies
- 737 views
-
-
i have a database with both software and non-software assets in it. i was told to keep it in the same table within the same database but with two different layouts. as it is now, there are the two layouts which i have a button to switch between when i get to something that looks like software to see it in the right form. i was wondering...is there a way to set up a filter or something so that if someone was going through all the assets...if it got to a software asset, it would display it in the software form, and if it got to a non-software asset, it would display it in that form? i am new to filemaker...i have done a little scripting in it so far, but i can't …
-
- 2 replies
- 808 views
-
-
Drop down menu 1 display all results from table X row A. I want drop down menu 2 to display table X row B where row A matches the selected value of drop down menu 1. I also want drop down menu 3 to display table X row C where row B matches the selected value of drop down menu 2. How is that done?
-
- 10 replies
- 2k views
-
-
Hi there is no way to land (and highlight) a portal row into a TAB control, that contains more than one portal ? I mean after a GTRR and come back. It is simple to land to the right TAB... but to land to the right ROW ?
-
- 6 replies
- 1.4k views
-
-
If I use the Tab Control and create 4 tabs - Option1, Option2, Option3 and Option4 - is there any way of specfiying which tab (and its contents) to display when users go to the layout that contains the tab control? I find that it defaults to the first tab when you go to a layout which contains a tab control - but I would like to go to a specific tab instead! Possible? Frank
-
- 7 replies
- 1.6k views
-
-
I am new to Filemaker Pro and found your site extremely useful for making a conditional drop down menu. My question is How do i make three conditional drop down menus. For example, in the first category, I choose a type of food (meat, vegitable) if i choose meat, my choices are (fish, beef, chicken, pork) if i choose beef, the third drop down will be populated with a host of dishes with meat as its primary ingredient (peppercorn steak, beef bourgninon, BBQ beef ribs, etc). I have tried doing this but i get into trouble with the third choice, as there are now 2 qualifiers. I have searched the net for a guide to this, but i havent found one. Thanks so much…
-
- 9 replies
- 2k views
-
-
Here is my relationship diagram. My problem is that I can't add records to fields whose relationships are set to allow records to be added to the "many" side only, but not to the one side. All of the relationships in the database are set up so that records can be added to tables on both sides with the exception of those whose "1" side would never change. Specifically, refer to table [interestTypes] (at left in diagram ). There will never be more interest types, so the relationship between table [interestTypes] and [interests] is set so that records CAN be added to table [interests], but not to table [interestTypes]. The same relationship exists betwe…
-
- 2 replies
- 836 views
-
-
I am having trouble finding an elegant solution to this problem. I have a portal which displays 50 records on a layout. However the found set can contain from 1 to 500+ records. What I am not sure how to do is allow a button to be created if the count of records is greater than 50, so the user knows that there are more records found and can click on the button to show those records in the portal and so on for the next 50 etc. This is exactly like the forums here, where x number of records are shown on a page with buttons at the bottom to go to page 2, 3, 4 etc. I can achieve this with multiple layouts and scripts, but I need one of each for each set of 50 reco…
-
- 1 reply
- 662 views
-
-
Hello everyone, I am going nuts trying to get a sub summary report to work. what is crazy is that I got it perfect in another report just a week or so ago. two tables. Quote and QuoteItem this is a one to many relationship; One quote number to many or one quote items. Now I'm trying to create a "job card" based off these tables. I just want a subsummary based off Quote #. Layout shows records from QuoteItem; sub-summary by Quote #. When I find records for certain Quote #, it is only showing one record per page. This is so madening because I set up a purchase order database basically the same way, and it works fine. I should probably post my …
-
- 5 replies
- 949 views
-
-
Hey all, I hope it's not frowned upon to ask for help having only registered... But I have just been thrown in the deep end with filemaker and have been asked to do a couple of things that I have no idea how to do... First thing I need to do includes the use of auto entry and drop down lists That is... I have set up a section which has 3 pop up lists. Pop up 1 = project Pop up 2 = category pop up 3 = category # - IE entry is #1 2 etc in that category What I am trying to achieve is to change pop 3 to a auto entry. I want the auto entry to increment by the value of 0001 each time a new label is created. The catch is that I want it to …
-
- 0 replies
- 925 views
-
-
I'm newish to FM7 and I need to create some calculation or summary fields (not sure which) for a report I need to build. I have a field in my set of 1000 or so records that is a drop-down box with the defined values "yes" and "no". I want to be able to count how many of the 1000 records show "yes" and how many records show "no"? I appreciate anything you could offer. I work with secondary school kids and this would really help me in the right direction.... Also, can you point me at any other good references for learning about FM summary and calculation functions? Many thanks in advance, Adam
-
- 6 replies
- 1k views
-
-
Is it possible to display a "<>" from another table? If I add a ":" like <<:text>> it shows me the <> called?? Thanks TMAS
-
- 2 replies
- 927 views
-
-
Current Setup: FMS 5.5 FMP 6—70% Flat File Migrating to: FMS 7 FMP 7 & 8 mixed I have started and restarted this project at least 10 times over the last month. The system has to be able to handle all aspects of our company, from quoting, order entry, creating job tickets for each line item on an order, then once the order moves out of entry phase. Each of the departments will access the jobs in a different way. Department 1: Quoting Department 2: Order Entry Department 3: Preproduction Department 4: Production Department 5: Shipping Department 6: Invoicing/Accounting I believe my attempts to follow the anchor~buoy method lead me astray whe…
-
- 7 replies
- 1.8k views
-
-
I've built a US state abbreviation value list, but can't figure out how to have the full name of the state and the abbreviation in the list without having both in the results. i.e. I want the list to show Maryland MD and the field to only show MD. Is there a way to do this?
-
- 3 replies
- 2.9k views
-
-
What is the best way to allow users to add to a value list on the fly? A line items table with a drop down list that uses values from an items table. If the user needs to add a new item to the value list, what is the best way to accomplish this?
-
- 5 replies
- 3.7k views
-
-
I have an invoice which looks great in browse mode, but when printed or viewed in preview mode, the content of several fields disappears. I'm stumped. Please let me know if you need more information, and thanks in advance for any suggestions you may have!
-
- 2 replies
- 831 views
-
-
In an effort to boost performance, is there a way to force load graphics into memory when a database is opened?
-
- 1 reply
- 582 views
-
-
FMS8 1.) Are there any performance advantages using embedded versus linked graphics? 2.) If I am running a solution off of a server would there be any benefit in performance by having the graphics stored in a separate folder on each client's computer so they are not constantly loading over the network? 3.) I have several tabs with several different interface graphics on each tab. When I open the tabs on a client computer I notice a slight delay when the tab is viewed for the first time. After each tab is viewed once it seems to load the tab almost instantly. I assume that the tab graphics are being loaded into memory.
-
- 0 replies
- 627 views
-
-
I have 1 Table called CONTACT Each contact has the following fields: Name (Text) ID (Unique auto Entry) ID_List_g (Global Multikey) Record_Number_cu (Unstored Calculation) There are two occurances of the CONTACT Table: CONTACT_RECORD CONTACT_LIST The relationship between the two is occurances is: CONTACT_RECORD::ID_List_g to CONTACT_LIST_::ID There are three layouts One using Table occurance CONTACT_RECORD viewed as a Form: CONTACT_RECORD_layout Two using Table occurence CONTACT_LIST viewed as a List: CONTACT_LIST_NAMES_layout CONTACT_LIST_IDs_layout The layout CONTACT_RECORD_layout contains 2 Fields and …
-
- 3 replies
- 786 views
-
-
I have a FM5.5 File that open up in FM6. I have portal and in this portal there are about 32 records. Is there a way where I can page break the portal when printing after 16 records? If so how?
-
- 2 replies
- 772 views
-
-
Hi, Just bought FM8 Advenced from FM's dealer in China. Get problem when I am creating a service call book system: 1. Value list based on current date; 2. Date Caculation/Relationship. Who would give valuable advices to me can find more information in attached sample file.(winziped). Thanks. Value_list_based_on_currentdate.zip
-
- 9 replies
- 1.5k views
-
-
I have a Meetings table with the days & times for various meetings: Meetings CourseCode // e.g. 209ALG DayOfWeek // "Sun" - "Sat" StartTime // e.g. 9:30 pm Notes For a class that meets 3x a week, there would be 3 records: 209ALG, Mon, 9:30 PM, Lecture 209ALG, Wed, 9:30 PM, 209ALG, Fri, 7:00 PM, Lab I would like to display the schedule for a meeting in a calendar format, with 7 columns labeled "Sun" through "Sat" and rows containing cells with the start time and notes in the appropriate columns. (I don't know how to force a monospace font, or I'd supply an example - hopefully you can imagine what I want it to look like :-) …
-
- 4 replies
- 2.1k views
-
-
Interface Rad by Dawn Heady Well AS new use do someone try to develop with this intersting tool ?
-
- 1 reply
- 1.5k views
-
-
Is it possible in Fmkr 8 to nest portals? That is, put a portal inside another portal? Table A is linked to Table B; Table B to Table C. I'd like to put a portal on a Table A layout showing related Table B records. In that portal I need a second portal showing Table C records related to the Table B records in the outer portal. When I try this the inner portal shows up in only the first record of the outer portal, and shows all the related Table C records indirectly related to the Table A record.
-
- 2 replies
- 1.6k views
-
-
This probably has a simple answer, but for main menus or navigation menus, I put buttons on top a square (that I drew and added a color). Now everytime the square is clicked on, an error pops up saying the required table is missing. What am I doing wrong? Thanks in advance for your advice and guidance.
-
- 2 replies
- 1.3k views
-
-
So I got Portal Of salary to each employee This portal get a new line each payroll day I like to create a Table that will show each employee payroll information, But I like to have the option that i can change the date and get the payroll for that specific date to all of the employees on the table. The date in the portal is a drop down menue that each payroll got a specific date. PLS edvice , THNKS
-
- 3 replies
- 629 views
-
-
Hi I want to use a text block as a dynamic label. For example the contents of the text block could be This is a <> The problem is that the text block auto expands to fit the contents of what you type in, however the labels are short and so the text block is always too big on the layout - you make it the correct width and it gets deeper, or adjust the depth and it grows in length. Is there something simple I'm missing to force the size of the text block, or do I have to work around this by making a block with no background colour & using a filled rectangle behind it to get the background I want - (seems cludgey!).
-
- 2 replies
- 987 views
-
-
Can I set the horizontal end to a layout? See, I have the these nice looking grey bars that run horizontally through my layout. They separate the layout sections. But, as you can see in the attachment, they end and the layout sections' background color do not end. If I extend the gray bars, the horizontal scroll bar appears, implying to the user that there is more too see to the right when there isn't. Any suggestions? Clipboard01.bmp
-
- 1 reply
- 1k views
-
-
Hi I need somehow to rotate a portal field (is it possible) if not is there any way to display portal info with a 90 degree rotation? Also if there isn't how is it possible to just have one layout horizontal letter size insted of vertical?? Any clues? Thanks
-
- 6 replies
- 955 views
-
-
I would like a form where a user inputs data into a new record with 4 or five fields, presses a button and the new record appears below as in list view. The next new record I would like to appear next to the last one so that it produces a record group in a box on two lines with the new one beside it. I would like there to be about a maximum of 20 of these records in a row. Help please
-
- 2 replies
- 953 views
-
-
Is there anyway for a customer to customize a layout template external like with text or xml or similar and hav filemaker load the template with existing fields in the solution?? Thanks TMAS
-
- 0 replies
- 648 views
-
-
Hi, i have a field that calculates the fiscal year of the current date. I also have a portal of related records that are sorted by the fiscal year, including previous and upcoming fiscal years. How would i highlight the row in the portal for the current fiscal year? i think i have seen something similar to this done before. perhaps a container field with a fill color behind the fields?
-
- 1 reply
- 697 views
-
Recently Browsing 0
- No registered users viewing this page.