FileMaker Interface Features
-
Hi All, I am looking for some suggestions on how to work around the following: I have a table and layout for Jobs. Each job is assigned to certain employees, which is done with a popup menu in a portal that shows records from a join table between the employees table and jobs table. The portal is set to allow creation of records. Assigning an employee is a simple matter of clicking the field and selecting the name from the popup which creates a record in the join table. The popup is based on the employee ID and employee name, showing only the name. So it shows the employee names but populates the employee ID as a foriegn key. Now the old familiar issue. I have fi…
-
- 8 replies
- 1.8k views
-
-
Does anybody know how to set up a FMP8 DB so that the font is absolutely fixed in a field. I have a problem that if people paste stuff from another source in to a field it takes the pasted font. I would like to ‘lock’ the field so it records everything in the font I preset and at the size too, so no other options are possible. Thanks.
-
- 17 replies
- 2.6k views
-
-
Sorry im still new here, now sure whether these questions are at the rite place.. just trying my luck.. Q1 : I was wondering is there any script that enable me to edit value list with a click of a button in browse mode? Other than the "Edit..." function.. Q2 : When we convert our filemaker file to php, how do we edit our value list? Will the "Edit..." still appear at the bottom of the value list and pop up a window for us to edit it?
-
- 2 replies
- 1.4k views
-
-
Hi, I was wondering if anyone knows a way to make Table view behave a little like excel. For instance... my first column has item numbers. It would be helpful if I could freeze that column on the screen, so that as I scroll to the right, the item #'s are still visible. Anyone know of a way to do this?
-
- 3 replies
- 2.6k views
-
-
It seems so to me... SubSummary part in Table View. ( not that I know if it can help somewhere : ) Edit: It IS documented... "Viewing summary data in Table View ... If a break field is placed in a subsummary part, it will always appear in the left-most column in Table View. Break fields appear at the bottom of leading parts or the top of trailing parts." SubSummaryInTableView.zip
-
- 0 replies
- 1.2k views
-
-
Im looking to accomplish the following: I have one table - a transactions table that has two types of records: expenses and income in it. They are defined with a TransType field. I would like to have a screen that does something like this: top area-------------------------- transaction entry area ---------------------------------- list of income list of expenses the top portion would have an entry interface below that would be two portals - one on the left showing income one on the right showing expenses. I can get one portal working fine - but I cannot figure out how to make a portal only show category income. I…
-
- 1 reply
- 1.1k views
-
-
Hi, I have several related value lists in my database. When I create a new record, these value lists work fine. However, when I enter find mode, the related value lists not longer work --- the only option is ''No values defined''. Does anyone know why? Thanks.
-
- 2 replies
- 1.1k views
-
-
Hi all, As you know Middle eastern languages such as Hebrew and Arabic are written predominantly right-to-left. Numbers are written with the most significant digit left-most. So is there's any one have an Arabic layouts as an example. thanks in advance
-
- 3 replies
- 1.6k views
-
-
When I go to Preview mode in any of my layouts, i get a grey screen. I click on the Body part definition and I get the object info (see attached image). How can i adjust this. My layouts look fine in Browse mode but nothing in preview. Any ideas? Layout set-up is fine, although the layout setup page margins have changes for all layouts (25 in total). How could this have happend.
-
- 4 replies
- 1.5k views
-
-
Is there a way to have a value list show (2) two fields together. Right now I have the option selected to use second field -- this only shows one field after selection is made. I need some way to show to fields in same cell after selection is made.
-
- 4 replies
- 2.1k views
-
-
I want to be able to have users view PDF files through a WebViewer in a FileMaker database. The PDF files are stored on the same server as the database, the path to the file is stored in the database. So the user clicks on the file name visible in the FileMaker layout and a script sets the WebViewer to a PHP program and provides it with the parameters needed to find the file. The PDF is supposed to open in the WebViewer using Adobe Reader (or Acrobat if the user has that). This works fine in Safari, but Firefox downloads the file and opens it in another window. Is there a different PHP method to force the PDF to display in the WebViewer? Currently, I'm using …
-
- 1 reply
- 5.3k views
-
-
I was asked a question on a support forum for Non-Profit businesses about displaying grandchildren records rolled up to a child record via a portal. Here is the desired result: This is on a Parent of Donor... My first thought was to use the List function but that wouldn't give the desired effect of grouping the data, but I am not sure there is another way to accomplish the desired design. Any ideas? Thanks Kevin
-
- 2 replies
- 1.1k views
-
-
Hi, Has anyone built any custom functions or does anyone know of a way of how to get all the URLS/links from a text field or web viewer within FileMaker 10? Many thanks for any suggestions... Jim.
-
- 7 replies
- 2.9k views
-
-
Hi There, I'm having some woes with what seemed like a simple idea at the time. I'm using Filemaker Pro Server 8 on Windows. My database has uses 4 tables that are causing the woe: Contacts, Companies, Addresses, and Lookup. There are several many to many relationships involved: a Company can have many Addresses as well as many Contacts, A Contact can have many Addresses, etc. The Lookup table is used to track these relationships and I have scripts that add ID's to the Lookup fields to make this easier to maintain. Here's where I run into trouble: on the Contacts and the Companies layout, there is a Portal to Addresses that displays all the related Addres…
-
- 0 replies
- 1.1k views
-
-
I have a database with one table containing a number of fields. This is related to a table in another database using a reference number field. I would like to display all of the records from the main table in list format in a tab, and then when I select a 2nd tab, have the related records from the other table displayed in that 2nd tab (also in list view with one row per record, with each row corresponding to the respective row in the first tab, as defined by the reference number field). I tried doing this by putting the tabs themselves in the header of my layout, with the part containing the records (in the body of the tab panel) in the layout body. However, when I d…
-
- 4 replies
- 7.4k views
-
-
Hi, I am using repeating fields in my project.i want to delete repeating fields row by row instead of deleting all the record. it's possible in fm to delete repeating fields row by row.plz help me . Thanks, John
-
- 12 replies
- 2k views
-
-
When I view records as a list, is how far I've scrolled or my distance from the top referenced in any calculation? Thanks.
-
- 6 replies
- 1.2k views
-
-
I have created the above sub summary report. It works well. Is there a way to get a Sub Summary Total by each stock; ie. Apple?
-
- 0 replies
- 974 views
-
-
I have a portal where I'm building a list of parts and quantities for a model. The parts I want in my valuelist is a subset of all the parts: I just want the parts that are assemblies. assemblies have a value of 1 in the isAssembly calculated field of the part. How do I get just the assemblies? Do I somehow join the part table to itself or : I have searched on conditional valuelists and have not discovered an appropriate solution. Thanks much for any pointers.
-
- 1 reply
- 1.2k views
-
-
Hiya Gang! Little new to FileMaker development and I need some help on this one. I have a table that holds different categories for a contact Table: Category Field: pk_ID_Category Field: Category Then I have my Contact table with a relationship to the Category table Table; Contact Field: pk_ID_Contact Field: fk_ID_Category === Category::pk_ID_Category Field: First_Name etc.. etc... etc.. When I designed my layout for the Contact table I wanted it to where the user would see the actual Category as opposed to the Category_ID.. I created a Value List based on the Category Table and set it to only display the second field. I assigned it to…
-
- 2 replies
- 1.1k views
-
-
Hi All, I was wondering if someone can point me in the right direction with this contact sheet I’m trying to create. I did a few drawings that explains what I need to do, and what I would wish the system is able to do. (Don’t know if it’s doable) pretty much I would like to see thumbnails of all images that meet my criteria based on my "Find". Then I would like to be able to click on a box right by the image(s) so I can populate a contact sheet 2 columns by 3 rows. The main idea is because based on my find I might have 50-100 images and I want to be able to pick 5 or 10 or whatever amount of images and have a report populate with the ones that I've selected. (D…
-
- 10 replies
- 1.8k views
-
-
Hi, Any thoughts on what might prevent a field formatted as a drop down list using a value list fail to "drop down" in browse mode? I know I modified it inadvertently however I have recreated the exact settings for the field based on a working backup but alas to no avail...the current version will still not work (are you wondering why I do not continue with the backup. There has been substantial modifications to the current db from the backup unfortunately and the daily backup from the last use was overwritten when I closed the inadvertently modified file...ahh the wonders of scripting ). Any thoughts? Thanks, Jack
-
- 6 replies
- 1.8k views
-
-
I work in a print shop and would like to print large reports on digital laser printers. I have worked with Filemaker since FMP3 but always with Letter or A4 paper sizes and I have never been aware of a "problem" until now. The paper sizes I need are SRA4 (225 x 320 mm)and SRA3 (320 x 450 mm). In layout mode I create a new layout and then select print setup and choose the printer, size and orientation, but Filemaker refuses to acknowledge and just reverts to Letter. The laser printer is a Canon imagePress C7000VP accessible via server. Filemaker is only installed on my computer. I have tried other printers available on the network but same result. Can anyone help me?
-
- 0 replies
- 985 views
-
-
Hi all, I'm looking for some ideas to make this layout more clean, and more intuitive. I can't attach the db, it's hosted right now. But, attached are two pics, one of the layout, and one of the table structure. The layout is from the perspective of the input_filter table. The user is to select a Tool record in the portal at the left. The tool info is then shown in the "Selected Tool" box. Each tool will have multiple "Work entries" which are shown next, with the selected data below. Then, each "Work Entry" will be quoted by several vendors, only one of which is awarded the work. Everything is working on this layout, but I just feel that it's busy,…
-
- 5 replies
- 3.2k views
-
-
I have an application with a STOCKS table. Stocks Table is composed of: stockid.pk stock_symbol stock_name I have a layout based on stock. On that layout I have a tabbed interface. In a tab I want to have way for the user to add a new STOCK. I tried duplicating the Stocks table with Stocks2 and setting a relationship between them using stockid.pk (with allow addition and deletion turned on on STock2). [color:red] But, when I add a portal to the tab and base it on Stock2 I get only a single stock entry and not the list of existing stocks. Got any ideas? Thanks
-
- 25 replies
- 4.1k views
-
-
Is it possible to Prevent Record Deletion on just one specific Layout? Any other situation is fine... This particular layout is from the perspective of a certain table, but is used for filling in a related table. I don't want the user to get confused and accidently delete the records from the table they are viewing from, thinking it would delete the related tables.
-
- 1 reply
- 1.1k views
-
-
hi guys, sorry if this is under the wrong section. i've got text fields on a layout linked to table A. i've got a table B that has field names and comments from B. So whenever a user starts typing in "paragraph" text field, i would like a comments field to get updated from table B. i know i can put onModify trigger script. what i dont know is how to select and update the comments field. i can get everything in variables but how do i pull up the record and update the field with it? thanks!
-
- 3 replies
- 1.6k views
-
-
Hi all, I am recreating the form below in FM: http://wirenet.mcmaster.ca/indicators/wmi_form_v.html each row in the table is a species of plant that the user can check off to confirm having sighted when doing research. each species has a "U" value and a "T" value that are added to two running sums when the associated checkbox is checked. the running sums are then divided to give the WMI value at the bottom Here is an example of the Java code for a particular row: if (document.getElementById("ELAC").checked==true) { wmi_top+=12; wmi_bottom+=3; } wmi_val=wmi_top/wmi_bottom; In FM, I have two tables: WMI - has columns Species, U-value an…
-
- 13 replies
- 2.5k views
-
-
I am building a database in which I want to use a portal that has a similar behaviour to the portal used in the Event Management Starter solution which is displayed on the Events->Details->Contacts tab. Namely, when clicking on the Name field in an existing or the new record row, a drop-down list of names (if they already exist in the Contacts Table) appears and by clicking on one, it is selected for use in that record. Since the field's control style is defined as a normal edit box and the table on which the portal is based seems in fact just to be a collection of pointers to the Contacts table, I cannot see how this drop down list is generated. I'd be v…
-
- 1 reply
- 1.1k views
-
-
I've looked, and haven't found an answer to this question. Say that a date field is black, bolded. You want a conditional format that evaluates the date in the field, and if past today's date, changes the color to gray and removes the bolding. If you use text functions in a formula, eg TextColor or TextStyleRemove, do you check the relevant button on the conditional dialogue, eg Text Color & Bold, or leave it unchecked? Would not the formula be: Case ( Self < Get ( CurrentDate ) ; TextStyleRemove ( TextColor ( Self ; RGB ( 206 ; 206 ; 207 ) ) ; Bold ) ) Yet it doesn't work, whether I check the button or not. Thanks fo…
-
- 3 replies
- 1.5k views
-
-
I was wondering if there have been any open-source attempts to more thoroughly automate the webviewer with a plugin. It seems as though some commercial plugins such as MBS can interact with the WebViewer. So far, by running "Microsoft Spy++", I've discovered the embedded browser (WebViewer) is a window of type Internet Explorer_Server, and has parent windows as follows: Window 0017115E "Filemaker Pro Advanced" FMPRO7APP Window 002A13B0 "" MDIClient Window 001A07C2 "Test_JS_Calc" Afx:00400000:28:00000:019... Window 0002085A "" AxWnd80u Window 00040842 "" AxFrameOrView80u Window 00020850 "" Shell Embedding Wi…
-
- 0 replies
- 1.7k views
-
-
I have a feeling this is impossible... but so many developers have surprised me with solutions... I had to ask. Is it possible to do a Vertical Header column in Table View? I have an excel document I am trying to mimic... it would make things looks a lot better if I could rotate some of the headings... Possible? Impossible? Thanks!
-
- 4 replies
- 2.1k views
-
-
I would like to keep a layout in Table View... but have been requested to include photo's for the records. When the image container is viewed in Table View, it is very small... Anyone know a way to make this larger, and keep it in Table View?
-
- 6 replies
- 1.4k views
-
-
HI, I am creating a report in which its showing 20 records.what i want is that it show 10 records per page.how can we do this in fm. Thanks, John
-
- 1 reply
- 989 views
-
-
Hi All I have a layout (layout1) that has a portal in it. This portal is displaying 2 fields (field1, field2). There is a "add" button outside the portal on layout1. When this button is clicked, it takes the user to Field1 of the portal with the drop down list open. Now once the user selects data from the drop down list of field1, I want the cursor to land on field2 of the portal with the drop down list open for field2. I cannot get this to happen. Any help in this would be highly appreciated.. Thankyou
-
- 1 reply
- 1k views
-
-
Excuse the newbie question, but I'm stuck and need some guidance: I have a fill-in layout that shows a series of checkbox value lists in this manner: [ ]STUFF 1 [X]STUFF 2 [ ]Stuff 2 subvalue A [X]Stuff 2 subvalue B [X]Stuff 2 subvalue C [ ]STUFF 3 [ ]Stuff 3 subvalue A [ ]Stuff 3 subvalue B [ ]Stuff 3 subvalue C I need to generate a report with all of this information in a special format and I am trying to understand how I can test to see which value list items have been checked so I can indicate this on the report. I can't just show the value list content for each record since there is some special text formatting that needs…
-
- 0 replies
- 1.2k views
-
-
I've recently learned how to use summary fields and subsumary parts. My issue is i'm attempting to create a report that groups vertically rather than horizontally. For example I need a report for widgest sold that groups all the months in one report and the months are the column headers. For example [April][May][June] [widget1][#April][#May][#June] [widget2][#April][#May][#June] [widget3][#April][#May][#June] [TotalApril][TotalMay][TotalJune] hopefully that illustration explained my point.. I have no issues grouping by widget names, types, etc.. but I can't figure out how to count within the certain months. My find requ…
-
- 1 reply
- 1.2k views
-
-
Hi, all--What's the best way to make Filemaker switch between "left" (even-numbered) page layouts, and "right" (odd-numbered) pages during preview and printing? Selecting "facing pages" in the "Layout Setup" dialog changes the inside margins to print a left and right page view of the same layout. I want to use a different layout for the left and right pages.
-
- 0 replies
- 1.1k views
-
-
Hello, I'm trying to create a solution for an online ordering system. this is for a delivery company. I'd like to know if there is a way for the client to log on, click place an order, and when it goes to the order page there is a field that displays this clients previous delivery addresses. There will be several accounts each with unique delivery addresses. So is there a way to have a field that will display only client a's value list based on the log on or only client b's based on the log on name? Not very good at this stuff. I greatly appreciate any help or advice. Thank you.
-
- 0 replies
- 1.1k views
-
-
hi i have a order layout in the layout i have orderline portal. in the portal in have 2 value list. value list 1: category. value list 2: items in category that i get the item number. the there'd field is the description of the item it is a lock up from item list. what happens is when i select the category the deception fills it self up. and when i select the item it dose not change the description . does any body have an idle?
-
- 0 replies
- 1k views
-
-
My staff and I are working on a room reservation database and we're trying to figure out the best way to show people the available rooms for a given start/end time. An event name is created in one table, a related table holds all the instances of that event, and a third related table holds the locations for each instance. Right now we've got a portal that shows all the instances (Tues 2-3, Wed 9-11, etc.), and what we'd like to do is next to it have a portal to the locations table that shows which rooms are available based upon which instance/portal row they choose. Our problem is that our search for available rooms is handled by finding all rooms that have conflicts (…
-
- 2 replies
- 1.3k views
-
-
I cannot figure out why my global field is not allowing input! I could swear this was working yesterday... I ran the FMP 10.3 updater today. Did that cause a problem?? I have looked and looked and I am just not seeing it. If someone can please take a look at this file; go to the Tax tab and please tell me why I can't enter the Usage tax field. Thank you!!
-
- 5 replies
- 1.4k views
-
-
I've removed this post as the problem was more to do with my brain than with the pop up menu apologies
-
- 0 replies
- 1.4k views
-
-
Hey First I need to say thanks for Søren Dyhr to create this calendar function back in 2006.. =) Called CalcVsGenSlots CalcVsGenSlots to quickly fill you guys in here is a summary what Søren Did. with my modifications Here is following tables and relationships Relationship Events::Start_time = schedule::cSchTime Events::Date = schedule::cSchDate Table 1 (schedule) Fields cSchID, | auto enter serial cSchTime | Mod ( SlotID - 1 ; 48 ) * 30 * 60 cSchDate | Let ( [ sunday =Contacts::gDate - DayOfWeek ( Contacts::gDate ) + 1 ] ; sunday + Div ( SlotID - 1 ; 48 ) ) Table 2 (Events) Field EventID auto …
-
- 3 replies
- 1.4k views
-
-
I have 2 text fields (first Name)(second Name) i am using the <> and <> script to show that persons name in another area of the layout. i would like to see names and have it appear with 1 single space in-between them both. How do i accomplish this? for example: (my current format) Jerrad_________________Mills (the '_' represents space) (what i would like to see) Jerrad Mills Thanks again, Jerrad
-
- 1 reply
- 1k views
-
-
How do i 'turn off' the function for fields to automatically increase in size based on the width of the FileMaker Program? In the layout mode a field looks to be normal, but when i am in browse mode, they expand depending on maximizing the Filemaker Pro window or created a wider windowed version of the program. Please help cause its driving me crazy!
-
- 4 replies
- 1.2k views
-
-
I have a LAYOUT based on a table (STOCKS) Stocks holds 2 fields: symbol and name On the layout I have a mergefield that shows the stock name and buttons for navigating to previous and next. Question: "How do I get the mergefield to show the names in alphabetical order?" I have sorted the underlying table (STOCKS) and yet it does not appear to be effective. This is something pretty fundamental that I am missing. Thanks for reading.
-
- 4 replies
- 1.2k views
-
-
I would think this would be easy, perhaps I am missing what function to use. Lets say I have one table.. called products. The Products table has all of the item numbers, their item description.... along with other fields. Same Table...2 new fields. 1st field: is a "you may also like"..which is a dropdown list based on all available Item Numbers. 2nd field: autopopulated item description of what was chosen in the first field. So basically an old fashioned excel vlookup. How would I do the lookup of the Item description, based on what Item number they chose in the first field? Remember, it is all one table....
-
- 1 reply
- 1.3k views
-
-
I'd like to work on an application during the business day when users are actively working. Specifically, I'd like to edit layouts that may or may not be in use. Is there a risk of layout corruption or other reason not to actively develop a database in use? The alternative seems to be to work on a copy and have users connect to the new database or work at night. (Note, I searched the forums and can't find this topic - sorry if it's commonly asked.)
-
- 2 replies
- 988 views
-
-
Hello all, I'm not sure if this is the correct place to ask this question - but I'm not sure where is. It sort of applies to Layouts?! I want to have a "useful info" page where weekly one of the guys in the office inserts a PDF into a container field that then is available to everyone on the system, kind of like a noticeboard. I've set up a global container field for this purpose, which works ok in isolation, but I've only recently learnt the fact that global fields have a new instance per user in a multi-user environment (as I am). This is, of course, great most of the time. But for my example, what's the easiest way to make the field available …
-
- 1 reply
- 984 views
-
-
Hello, I am using FM10 developer and have a problem with my web viewer displaying. The viewer was displaying properly until recently, I tested the viewer and noticed this problem. I get the following message; (“Still loading slow?” Try basic HTML). The page does not load. I tested this out on other computers on my network and have the same problem. I am using Google Maps (US) with the required, address, city, state, and optional zip code fields. I copied the web address I am using from the web viewer setup; ("http://local.google.com/maps?" & "q=" & /*Address=*/ ${K-9 Reports}:street & "," & /*City=*/ ${K-9 Reports}::city & "," & /*State=*/ ${K-…
-
- 3 replies
- 5k views
-
-
Is there a way to do this...: I have a Herd database. The animal records all have a unique ID. Each animal record has 2 name fields, a full (registered name) and a short or common name. Each animal can also have a parent relationship (ie. dam and sire.) So, Animal A can have Dam D and Sire S. Dam D and Sire S each has a full name and short name. Animal A;s record stores the ID number for Dam D and Sire S and uses calc fields for full or short name using current relationships. On Animal A's screen, the dam and sire fields each have a non-enterable calc field in front that always displays the full name. Behind that is an enterable field that uses a …
-
- 2 replies
- 1.1k views
-
-
Hi - I'm looking for a way to have a field that displays **** when data is entered, like a password field would. This is for a custom login layout. Many thanks, Z.
-
- 3 replies
- 1.1k views
-
-
I'm currently updating my office's filemaker 9 database, but am fairly new to filemaker and so I'm having a few issues. I'll explain what I need it to do, then I’ll get to what I have already done as I’m probably using a fairly backwards solution already. What we have right now is a list of media contacts, each of whom are broken down by the kinds of publications they work for, and which clients they are relevant to. The final area we'd like to add is allowing them to be a member of a distribution list (DL). The DL list is constantly changing, depending on what press releases are circulating, so I’d like users to be able to modify the list of available DLs for the…
-
- 3 replies
- 1.1k views
-
-
This will probably be another 'duh!' for me, but I can't get a conditional formula to work. I am trying to get a value to appear in red when it is out of range. Yes, the values 'not between' works dandy. This time, however, the range depends upon the gender of the person. So here is the formula I wrote: Case ( Gender__lxt = "Male " and RBC__lxn > 5.9; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Female " and RBC__lxn > 5.1; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Male " and RBC__lxn < 4.5; TextColor ( RBC__lxn ; RGB ( 237 ; 31 ; 36 ) ); Gender__lxt = "Female " and RBC__lxn &l…
-
- 5 replies
- 1.6k views
-
-
Hello All, First off, many thanks for a great forum. Whenever I do a google for something I'm stuck with FMP, the answer always seems to be here! I'm in the process of building a large (for me!) database that will be at the core of our business. As such its going to be viewed predomenantly by people using FMP on either a mac or PC. Being a Mac man, I've done most of the design thus far using FMP Advanced on a Mac. The database is now served by FMS on a Windows Server 2003 system. Viewing the layouts on a Mac, and they look as I expect. Load the same ones up on a PC, and they look rubbish! The fonts are different (I guess I've not used co…
-
- 4 replies
- 1.1k views
-
-
hi guys i've got a single table to which 40 layouts are associated. these are layouts for print ads in different sizes. each layout has 6-9 user editable text areas. i need to display formatting rules for each text area the users can type into and need to display "x number of lines allowed, x characters allowed". the idea is that as user moves to the next text area, the formatting rules window updates and displays the rules for the text area the user is in at the moment. putting in validation checks for fields wouldn't work as the same "Paragraph" field might have 80 characters allowed in one layout and 100 in the other. the rules needs to be associated wi…
-
- 1 reply
- 1k views
-
-
Firstly the last time I did some serious work was in FMP Dev 6. So updating a couple of solutions. I am having trouble with the long distance relationships (ha ha). I suspect this has been asked and answered before but couldn't find in searching, so here is my problem. I have 5 TOCs (Things)as follows Things A one to many to Things B one to many to Things C many to many Things E with join CE (D) in the middle. Things A -< Things B -< Things C -< ThnigsCE(D)>- Things E. The last many to many seems to be the stumbling block for me. On a layout looking at records from Things A I have a portal to show Things C (no problem). On the same layout…
-
- 5 replies
- 3.8k views
-
-
Hey people New on here, so be gentle... I have a table named 'ASSESSMENT' which creates a primary key '_pk_assessment_id'. Within that table there are also two foreign keys, '_fk_student_id' and also '_fk_unit_id' which both link back to the STUDENT and UNIT table respectively. What I would like to know is, how can I put in a conditional (and what do I need to put) if I want to check if the combination of _fk_student_id & _fk_unit_id exists within another _pk_assessment_id row of data. Not sure if I've explained it properly, but basically there can every only be one instance of the combination between _fk_student_id & _fk_unit_id and I want to …
-
- 1 reply
- 1.3k views
-
-
Is there a means of muting audio that emerges from a web-page displaying in a web viewer, short of turning off sound on my computer? What's particularly problematic is that the audio continues even after moving off one record and onto the next. I'd think this would be a common problem for which there is some simple solution? Albert
-
- 1 reply
- 1.3k views
-
-
Well, in Browse mode a User can omit a field if they wish (vs. 10 table view). I thought (silly me) ... how wonderful because I could use the same layout and add or remove fields (via script) for Save As Excel!! Sometimes Users want a field and sometimes they don't. Firstly, are we not given the ability (in Browse mode AS DEVELOPERS in a script) to show or not show fields? That would be cool because I wouldn't have to create several layouts (each with different fields on it) just for Save As Excel. Secondly, dang if FileMaker doesn't mess up the data when a field has been 'removed'. Create two fields (Field1 a number and Field2 text) and place them both …
-
- 6 replies
- 2k views
-
-
I use a lot of table occurences. So when I create a layout in Table view, it is likely you will see the same variable listed more than once, but each has its own "Global Variable" to trigger what information you see in that corresponding occurence. In browse mode this isn't really a problem, because you can create labels. But in Table View, the headers match the variable name preceded by "::" Is there a way to change the "Column Headers" in table view? If not, has anyone come up with a reasonable work around?
-
- 4 replies
- 1.2k views
-
-
I was curious if there is a way (either built in or via some plug-in) to display images that the user uploads. I'm making a table to store some scientific data, and part of the data for each row will be a few graphs that the user uploads. I've done file uploads before, where the file is simply saved in the DB and can be downloaded, but does anyone know of a way to display the files themselves in a layout, assuming they were image files? Tim
-
- 5 replies
- 1.2k views
-
-
In my "master" layout, information in my fields appear like this: $1,000.00. When I try to merge them into a letter, they appear like this: 1000. I want the monetary merge fields in my letters to appear the same way as in the input fields- like $1,000.00- but I cannot figure out how to do this. Please give very simple instructions- I'm not that great at Filemaker! Thanks!
-
- 1 reply
- 952 views
-
-
I have a portal based on a self join (stocks) table. The portal is based on stocks2 and works well. However, I have an "X" button on the portal row to delete the portal row but unlike my other portals (which are based on regular tables related to STocks), when I press the X on STock2 to delete the row I was surprised to get "Do you want to delete the entire master record or just his one related record."? Deleting the Master Record deletes ALL ENTRIES in the portal .. wow! I would like the portal row to be quietly and quickly deleted without user 'approval' or a message. BTW, IN THE RELATIONSHIP JOIN, I HAVE TURNED on and OFF [color:red]"Delete Reco…
-
- 2 replies
- 1.1k views
-
-
I'm a little bit confused on how to display a bunch of related data on a single layout. I'm using to portals to display lists of related easily enough, but what if I want to display form details of a related record (or multiple related records) on 1 layout? Here are the tables/relationships I'm working with... As you can see we have an orders table and an order items table. Pretty straight forward there. Each order item, though, can have multiple "sides" added to it so there's a related table for those. And then each side can have multiple "side options" added to them so there's another related table for that. So, I've got a page setup where I'…
-
- 1 reply
- 1.1k views
-
-
Here is the situation: I have a layout based on STOCKS. On that layout there is a tabbed interface. One of the tabs is OPTIONTRANSACTIONS in a portal. In this portal are all the fields in the OPTIONTRANSACTIONS table. The OPTIONS table holds: optSymbol and optExpirDate (Option Expiraton Date). Since the expiration date is all ready in OPTIONS, I want to avoid entering it again when I make an OPTIONSTRANSACTIONS entry on the portal. I have tried: Putting OPTIONS::optExpirDate on the portal. Setting OPTIONTRANSACTIONS::expDate = OPTIONS::optExpirDate and I have even tried to do a lookup starting from the optsymbol. It s…
-
- 1 reply
- 891 views
-
-
I have upload a image that i am locking how to do a text wrapping in the report, the problem is in Desciption ?
-
- 1 reply
- 933 views
-
-
This feels like a stupid question to be asking, and I'm sure I'm missing something obvious, but I can't figure out how to alter the background color scheme on a layout once I'm finished with the initial layout creation process. I can, of course, create a whole new layout, giving it the color scheme I'm looking for, then paste in elements from the old layout, but that's a cumbersome workaround, one that breaks script references, etc.
-
- 1 reply
- 1k views
-
-
I am working on a solution where i need to save a pdf that is opened from web to a container field to be displayed in a layout. This is for stock research so let say that the web address is www.website.com/reports/Symbol.pdf and i want to have a script that will download that pdf for every record and put it in a container or save it somewhere on a computer so it can be viewed without being connected to the internet. Thanks for your help. If you need any clarification please let me know. Scotty
-
- 0 replies
- 1.8k views
-
-
hello Would really appreciate any help on my problem please - I need to generate a personnel report - employees in my company are assigned to a specific group name - each group is assigned to one of 3 cost centres. I need to generate a report which totals the number of employees for each group and then also provides a total under each of the 3 costs centres with a grand total at the end - the report needs to be something which I can export to excel. I've tried playing around with sub summary and grand totals but I'm failing miserably each time - just can't seem to get the right information to show up. example of type or report required is cost cen…
-
- 7 replies
- 1.6k views
-
-
I have been grinding on this 'non functioning' value list for over a month and no matter what weird / exotic / unexpected methodology I try, it still acts weird. Please check it out at: http://ronaldogordono.googlepages.com/valuelist2 The database is there for the downloading. I appreciate your thoughts.
-
- 6 replies
- 1.6k views
-
-
Hello, I am trying to find an inventory system that can show also the profit of something sold. Here is my idea for the problem. I think that it does not work as I like and that is the reason I as you here. When something is bought it is written to the inventory table with its price and quantity. When something is sold it is written also to the same table with the sold price and quantity. At every sold Item I need to have the purchased price of the product and so I search the original purchased item I marked it as sold take the price and write it to the sold item. So I have the profit of the sold item. This was easy. The problem now What if…
-
- 3 replies
- 1.9k views
-
-
I have events table where the values look like below Event_ID EventName 1 Event1 2003 2 Event2 2003 . . . 10 event10 2003 11 Event11 2004 . . 22 event22 2005 . . 30 event30 2006 I have a field from different table on the layout which accepts the data from the Events table eventName field where I need to pick from one of these events. But there are thousands of events, so I want to group them by year. When I click on the event name, it should dispaly a pop up menu by year when I hover over the year, it should display all the events from that year and I select one of the event from the list and the value os that should be s…
-
- 4 replies
- 2.1k views
-
-
I am having a problem with overlapping portals. What I have is several portals each with one field that relate to the selection in a previous field. I am using the Portal Visibility trick which for the most part is working as expected. The problem is that the only Portal that allows editing is the topmost one in the layout. If I make a different selection in the previous field the correct Portal displays but you can not change it unless you go back into the layout and move it to the front. Is there anyway to make this work.
-
- 7 replies
- 2k views
-
-
I'm a beginner. I've looked everywhere and can't find how to do this, and it seems simple. I'm basically just trying to create a table of contents what will display the page number of the records. For example, I have several names with information.. maybe like 100 pages worth of information. I am just trying to create a table of contents at the beginning of this page, where it shows me the record/name and what page number it's at. How do I do this? I'm very new, so please explain easily!!! thank you soooo much!
-
- 24 replies
- 5.1k views
-
-
Hi, Is it possible to add totals to the bottom of portals? Or in some other way add a layer of summary to the layout that totals the data in the portal? Regards, Simon
-
- 2 replies
- 1.1k views
-
-
Hi, Just converted from Access to FM. Why does anybody use Access???? Wondering whether anybody can help me omit blank address rows when creating a letter i.e. I have fields as follows: Add1 Add2 Town County Postcode and of course not all addresses have an Add2 so any ideas on how to omit this when using the fileds in a letter?? Apologies if this is basic! Kindest regards, Simon
-
- 4 replies
- 1.6k views
-
-
Lots of people have reported slow value lists, and often the response here has been to say, "Your value lists are too long". Well, now I have a very slow value list that is very short, so I'm hoping someone has an idea I might try to solve this problem! We index some records with a fully flexible thesaurus of about 4000 terms. So any term can be a child of any other term. In practice, there are a number of (mainly) distinct branches of the tree and to simplify selection for users, these are identified by a number field in the term record called "branch_id". So, all I want is a value list of the all the terms in a given branch. To do this, I have created a global…
-
- 2 replies
- 1.3k views
-
-
Hello, I would like to create a "widget" in my layout which is an Edit box with vertical scroll bar, however, I want the text to be view-only. And if the user clicks in the text area, I want to have a button that takes them to a checkbox set which presents the choices they can choose for that field. I have created the textbox, but in order to get the scroll bar to activate, it appears that it must allow Edit in Browse mode. So, I tried making a transparent button the size of the textarea and placing it on top of the Edit box, but once the user clicks on the scroll bar, it appears to bring the textarea forward, allowing the user to edit the text. If the user cli…
-
- 2 replies
- 1.4k views
-
-
maybe this is the wrong place to post this but I'm having an issues with some value list no longer working and some just disappear completely. One day they are there and working fine the next it not. When I go into view the values lists the space for the missing one is there but the row is empty. Its has not been deleted its as if it gone bad. Any one experience anything similar? As I'm the only one with Full access to the db I know it can't be something others are doing it just odd.
-
- 13 replies
- 2.4k views
-
-
Hello all, A friend has a FMP file they have been using in v9 at thier office. The file is for an art gallery (inventory, sales and invoicing)... all integrated into 2 seperate files (the 2nd file containing only the art images). No online functions or anything seeming that complex... just LOTS of seperate tables, relationships, and billions of fields and scripts created by probably 4 previous developers. They need some cosmetic work done on some layouts. I think i can do the changes they need but only have an older version (v7) available to me. And, I'm not familiar with what has changed with the file formats since v7. I do have the file and it opens fine witho…
-
- 5 replies
- 1.2k views
-
-
Hello, I have a database with two tables. In the first table (rgbtext) there is a text field "Category" with 3 other number fields "red" "green" "blue" The second table (rgbcontainer) has a text field "Category" and there is a join between the category fields. In the second table I have a calculation field called category_color that uses the TextColor function and pulls the values from the red, green & blue fields I also have a container in the second table which I'd would also like to display the same rgb color as the category_color. So it needs to pull the "red","green" & "blue" values from the rgbtext table. I've messed with the condition…
-
- 6 replies
- 2.7k views
-
-
Hi, I hope this has not been answered many times. My (seemingly?) simple problem: I have a parent/child relationship, and in the vast majority of cases there will be only one child. But there will be cases when there are two, three, or more child records, and those need to be accommodated. The chance of the number of child records growing to a large number (more than 3 or 4) is VERY slim. There are about 10 specific fields fields for each child, and a notes field. As in most cases it will be a 1 to 1, I am hoping to have a portal with all these fields for one record showing on my layout (like a little "standard layout" with the main layout). Then place buttons…
-
- 14 replies
- 2.9k views
-
-
HI, I am creating a inventory project in which i want that after selecting radio button depending upon its value the edit box should visible to me if i don't select any value from radio button the edit box should not visible to me. i tried a lot but can't find how to do this. please help me out. Thanks, John Wiliams,
-
- 11 replies
- 2.3k views
-
-
I apologize if this has been answered, but I can't find it. I have a file that uses a record ID and date. I have a self join relationship for matching record IDs and the date sorted as desc. FileName = Fiber Relationship = Fiber Shearing (match to Record ID in Fiber, sorted by date desc) Example: Fiber Shearing::Date in current record = 7/1/09 Fiber Shearing::Date in prior record = 6/5/08 I need a calc field (Prior_Date) to retrieve 6/5/08 in the current record. I tried: GetNthRecord ( FIBER Shearing::Date_Shorn; Get (RecordNumber) + 1 ) but that does not use my sort and retrieves the newer date into the older record. I know thi…
-
- 2 replies
- 1.1k views
-
-
I have created a file with 2 tables. Table one is for participant information, and table two is for his/her entries. Each participant can have multiple entries. I want to create one sheet per participant, and include a list of their entries on that sheet. I tried a subsummary section, but it only returns one entry per participant. What am I missing here--what's the best way to accomplish this?
-
- 7 replies
- 1.8k views
-
-
I had 3 windows open looking at different tables from the same solution. One of the windows sort of froze...that is to say I could not close that window and I could not quit filemaker (had to eventually Force Quit). Within the frozen window, I could switch layouts, go to different records, run scripts, and enter data. I could not switch to the other 2 windows, which remained in the background regardless of where I clicked. Any ideas on what causes that behavior? Sorry if this is the wrong forum. I wasn't sure where to start.
-
- 3 replies
- 1.2k views
-
-
Hello, I am still pretty new to Filemaker but have done a ton of reading. Anyways I have a MYSQL database that I am working with that is used for lets say keeping track of stuff. What I have are a lot of fields that depend on the previous field. So I put them in Portals and I have Calculation fields set up and also relationships set up. The problem is that on new records the Portals will not display when the correct previous field is set. However on existing records on the database the Portals work fine. I have played around with setting the Allow records to be created option for the relationships also. An example of one of my calculation fields: case…
-
- 2 replies
- 856 views
-
-
I'm starting a new project. There are two distinct systems, Inventory and Activities, that share two tables: Staff and Sites. Since FM7, I've never developed a multi-file system. I'm interested in pros vs cons: All one file vs. multi-file. I could have this be one file, and based on priv set, navigate to the "proper" main menu. However, maybe it would be a good thing to break it out to Inventory (multi-table, of course), Site (actually also multi-table as this is for a school, and each site has a district), Staff (single table), and Activities (reporting system, multi-table). Would someone be so kind as to debate the two approaches with me? (This …
-
- 6 replies
- 2.1k views
-
-
Anyone know how to change the run time icon to a custom icon?
-
- 1 reply
- 1.5k views
-
-
Hi. I'm brand new to Filemaker although fairly handy around MS Access, Oracle etc. Here's my problem/question: I have to tables - for the sake of this example, I'll use card. So the parent contains makes of car (Ford, GM, VW etc) and the child table are models. The related field is the make. I want to be able to scroll through the parent (car makes) and any child records (models) of that make should display all the fields of the child record in a form (NOT a row!!!) but in several columns and laid out in an arbitrary fashion to my design. I only want a single model to be displayed at a time and the vertical scroll bar (or another mechanism (button?)) s…
-
- 5 replies
- 1.6k views
-
-
Hi everyone. I have a layout that shows all the records in the table. However when I go there I want it to only show the persons records that is logged in at that moment. I am capturing the user logged in user correctly however the layout is still showing all the records in the table. Any ideas? Thanks!
-
- 1 reply
- 1.1k views
-
-
HELP!! I'm completely new to FM and am trying to create a timesheet database where we enter 2 weeks (one pay period). I've got the entry set up & it works exactly as I want - the problem is running reports. I have 2 portals going to different tables (LinesWeek1 & LinesWeek2), and now I need to merge the data for project reporting. Is this possible or have I completely messed up my entire structure? Can someone please review the attached file & help me figure out where I've gone wrong or what step I'm missing to do these reports? The report I have is only pulling off of one of the Lines tables. Thanks in advance from a newbie! Time_Sheet_Database.zip
-
- 2 replies
- 1.1k views
-
-
Hello FileMaker Group, I wrote a little javascript to run a FileMaker script from the web viewer and use a data url in the web viewer to run it. Unfortunately, every time I run it, I get a warning message box that says "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction." Does anybody know any way to prevent that message from coming up every single time? Create a a webviewer and a field called "html" and put this javascript code in the field: In the webviewer define the url calculation as follows: "data:text/html," & html Here is the javascript that goes into the ht…
-
- 4 replies
- 5.4k views
-
-
Hello guys, I have a table called documents. each document has a code and a version. I have a layout where I need to display the document evolution: basically some data for each previous version of the same document. I have created a relationship between documents and documents (this instance is called documentsByCode) and I have tried different way to set the relationship up but no one works so far. Any ideas about how I have to set the relationship up in order to display for each document its history? Thanks and have a nice day
-
- 5 replies
- 1.4k views
-
-
Hi all I have a text box with scroll bars activated that will show anything from a few lines of data to many, many lines. The text box is set to show 20 lines and users must scroll for anything beyond that. What I would like to do is have the box present the user with the last data entered rather than the first. Any thoughts?
-
- 2 replies
- 1.2k views
-
-
I would like to allow a filemaker user to enter a field in order to be able to copy the contents for a later paste into a different application. I don't want the user to be able edit the field or change it by mistake. I guess I could create a button for copy to the clipboard and leave the field not enterable in browse mode, but that seems a poor work around especially if I want all fields to behave the same way. Is there some secret filemaker dialog box that allows you to enter a field in browse mode and copy but not modify the data? Thanks - Mark Using FM 9 advanced on OSX
-
- 13 replies
- 3k views
-
-
Hi All, I'm trying to sort out a profit and loss report, and i was thinking it should be with sub-summaries, but i can't see how to make them only show / take into account certain records. Perhaps an explanation: I have a Database of jobs / costs. I can get a basic p&l report done ok, using a calculation field and summary field method, along these lines: Sales = If (Type = "Sale"; Amount ; "") Total_Sales = Total of Sales (this is a summary field) Doing this for Sales, Cost of Sales, Operating costs etc gives me the totals, and i can tott them up to make a nice basic profit and loss. (ie "sales" = Total_Sales "cost of sales" = Total_cost …
-
- 2 replies
- 1.5k views
-
-
hello i what to make a conditional Value List in a portal. i try to do it but with no success. i have up loaded the file can any body have a lock please tank you dani tectop.fp7_2.zip
-
- 5 replies
- 1.7k views
-
Recently Browsing 0
- No registered users viewing this page.