FileMaker Interface Features
-
I want to export my data from FMP. I have a DB with different layout templates. Let’s say field 1 is the same in all the layouts. But field 2 is only in layout a, and field 3 is only in layout b. How do I export this best, so it all comes together in one file? Thanks.
-
- 1 reply
- 1.2k views
-
-
Hello Forum, another brain fog, despite doing this before, and looking at my files & sample files. I have these relationships: On the JOBS layout I have a portal of GALLONS. One of the GALLONS fields is Vehicle_Name. I want to attach a drop down list, conditional value list to aid in data entry (for IOS). So a CUSTOMER, can have many JOBS. And any JOBS record can have multiple GALLONS records (in the portal). What I want the drop down list to only show, are all the existing GALLONS::Vehicle_Name values, from the same CUSTOMER, regardless of JOBS. IOW, CUSTOMERS Bob has 5 JOBS records Debbie has 3 JOBS records Mike h…
-
- 4 replies
- 1.5k views
- 1 follower
-
-
Night all, Is there a way to get a count\s based on a conditional format. I have two a calculation field to determine time between to entries, then i have a conditional format for the calculation field if < 0 = color is "red", if > 900 = Color " pink. Is there a way to know how many are red and how many are pink. Thanks
-
- 1 reply
- 1.5k views
- 2 followers
-
-
Good day all, My apologize if I am posting in the wrong group. Can someone tell me why this calculation does no work. It always teturn the same value "Picking" I have a button bar with 6 segments, each element pertains to a department, i am trying to change the labels as each department enters data. It works is is not nested. Case ( not IsEmpty ( WTS v2.0::PickerDatePickingStart ); TextColor ("Picking"; RGB (255; 0; 0)) ; not IsEmpty ( WTS v2.0::PickerDatePickingEnd ); TextColor ("Picked"; RGB (255; 0; 0)) ) Thanks JMart
-
- 2 replies
- 1.7k views
- 1 follower
-
-
I need to be able to show a preview in the container in much the same way that a jpg shows the image in the container. When loading a pdf into a container with Optimize for images selected filemaker has the following behavior. When loading a pdf into a container on my mac using right click - insert file, or script step - insert file, or simply dragging and dropping into the container, I get a preview of the first page in the container which is exactly what I need. It's visible on Mac, Windows and webdirect ( on both mac and windows ). But if I load the pdf into the container on windows or in webDirect ( on Mac or Windows ) I get the file icon and file name…
-
- 7 replies
- 3.6k views
- 2 followers
-
-
Hi all I'm exploring the option of adding this feature if it's feasible or if another solution is warranted. Currently I'm working on a property management database to manage rental properties I have. In the Invoice table/portal I use to track charges and rent payments for each lease I have a Tenant field that allows me to tag a particular tenant within the lease to that charge or payment (useful if the lease has more than one tenant and they all pay separately, also to track how much each tenant pays individually). This is done using a pop-up menu and using the value from a second field that shows their name rather than their ID number from the first field. Cur…
-
- 5 replies
- 1.5k views
- 2 followers
-
-
Hi Forum! Im unsure if this belongs here please feel free to move this entry to the right place if need be. In the last 35 years, I have programmed in SQL, MySQL, Oracle and Filemaker. Native as well as Web Interfaces. I consistenty find that for writing a native interface for a local inhouse database, the development time required is *way* faster with filemaker compared to the other comparable technologies. (Yes we all agree if you want a zillion clicks a second we need Oracle, but for the rest of the 99% of us who dont need that...) I estimate the development time for a local inhouse database is about three times faster. I dont need to cre…
-
- 2 replies
- 1.5k views
- 2 followers
-
-
Howdy, howdy: I have a self-join portal (by recordID) with five global fields above it that I want to use as filters, with the "default" filter being EVENT_PARENT_X_ID::EventDate__lxd ≥ Get ( CurrentDate ) so that if no values are chosen as filters, the portal will display the records with the current date, forward. The problem is how to set up the filter calculation so that if one or more filters have values chosen, the portal will filter records based on those values. The problem is--at least how I'm looking at it currently--is that I'd need to create many permutations for the filter calc to cover all conditions. Surely, there has to be a better way of …
-
- 3 replies
- 1.6k views
- 1 follower
-
-
Good day, I am trying to center a "Floating Window" using the new windows command, i want to accomplish one of two objectives. 1- Open the new windows to the right of the "button" that triggers the script To do this i am using the "GetLayoutObjectAttribute( "VendorWindows" ; "Top" ), and "GetLayoutObjectAttribute( "VendorWindows" ; "Left" ) 2- Open the new window in the center of the screen To do this i am using "Get ( ScreenWidth ) /2" and "Get ( ScreenHigh) / 2" But i cant get either way to work. Both option i am entering it in the "New windows" function What am i doing wrong. Thanks JMart
-
- 7 replies
- 2k views
- 2 followers
-
-
Good afternoon. Let's say I have a layout with several boxes on it that span the width of the page, and each box is a different section of data. Between each box vertically is a space of approximately 1cm so that when printed the boxes are not all jammed together. I have changed the visibility on some of these boxes and content so if that section is not required on the report then it is not shown, and the items below it move up - that all works fine. My question please is that if - for example - 6 sections (consecutive) are not required on a report, then there is a gap of around 6 cm between the section above and below it. How can I get around this please? …
-
- 4 replies
- 1.7k views
- 1 follower
-
-
Hi All, in fact, I try more than one time to improve the script to show a count employee check-in on the dashboard. Knowing that employee records are saved in (Staff car Layout), the dashboard will belong in ( visitor system layout.) while press the update button gives me zero and ignores any record save daily as shown above. Thank you in advance for any help 🙂
-
-
- 1 reply
- 1.4k views
- 1 follower
-
-
I have a FM file with Students and Classes, each record has a unique ID and are connected via a join table. Each student can have more than one class. Students can not change their classes, only the Admin. I want each student to be able to see the student data of those who have at least one of the same classes. Any suggestions on how to set this up?
-
- 3 replies
- 1.7k views
- 1 follower
-
-
I have four tables (Projects, Customers, Products, and Users) and a Join table. All four tables have relationship with Join table, configure to be a many to many relationship. A record in layout based on Project have one Client, one Product, and multiple Users (using portal). I need to export each record to a csv file, and need to be a one liner. My issue is if I export based on Project table, I can not get one liner result if I have multiple Users in the portal. And also the second user (User 02) will have no information about Project, Client, and Product field, and sometimes users can be more than 5. Project Title Custome…
-
-
- 5 replies
- 1.9k views
- 1 follower
-
-
Good day, Trying to figure out how to do the following but my knowledge don't go that far. I need to auto populate a field based on a value of another field but at the same allow the users to manually enter a value if the auto criteria is not met. If value of "Field A" is equal or less then $1000.00, "Field B" should auto populate with the word "Small", otherwise the users should be able to select "1 Year", "2 Years", or "3 Years" I tried Auto enter and field validation but nether work. Thanks
-
- 1 reply
- 1.6k views
- 1 follower
-
-
Good day gurus, I have a true \ False value list, where i require the user to select only one option, but an option is required. I currently set it up as follow and it works. Auto-enter->GetValue( RightValues( Self ; 1 ) ; 1 ) Do not replace existing value of field: unchecked What i can not figure out is how to do is enforce a selection, something like using radius, where one of the two option MUST be selected. Thanks JMart
-
- 8 replies
- 2.4k views
- 3 followers
-
-
Hello all The ctrl key does not appear to work within the web viewer in FM pro on windows. This would be useful for text selection e.g. select all. I've implemented a restricted menu set in the hope that keyboard shortcuts would not activate anything outside the web viewer but this has made no difference. Does anyone know a workaround for this? Thanks!
-
- 3 replies
- 1.6k views
- 2 followers
-
-
Hi I am trying to create functionality in my FileMaker 19 solution to connect to Dropbox using oAuth2 using the Webviewer. However when I use the URL 'www.dropbox.com' for Dropbox with or without the necessary URL parameters all I get is a page saying 'Upgrade your browser to use Dropbox' with error code 409! My machine is Windows 10 with the latest version of Internet Explorer (20H2), I also have the latest versions of Firefox, Edge and Chrome and have installed the latest FileMaker V19 update as well. Also I have checked my machine for any outstanding updates and there are none. Even my previous functionality for Xero and Quickbookswhich I succe…
-
- 1 reply
- 1.6k views
- 1 follower
-
-
My solution is hosted in FMS on a Mac and there are a couple of Windows 10 clients. Some layouts include container fields set up to display PDF files (optimized for interactive content). Those pdf files are stored externally in the server but clients run the solution through a local file. Under Mac it's all right, but under Windows 10 it's a nightmare: it happened before, suddenly those PDFs don't display and it all seems caused by a software update (I can't tell if it's Windows 10 or Adobe Reader). The error message comes from Reader: "There is a problem with Adobe/Reader. If it is running, please exit and try again. (507:507)" it is not running alone, only through …
-
- 1 reply
- 2.1k views
- 2 followers
-
-
Hello! I'm creating a new database and I'm having problems with a conditional list. The table has 3 fields (Code, Prefix, Locality), and when we enter a number in the code field, it automatically shows the available results in the prefix field. I wanted to do the same thing for the location field, but I can't get it to display all the data without me asking to show it. Example: (Code, Prefix, Location) 98989, 001, SPAIN 98989, 002, PORTUGAL 30303, 001, PARIS 30303, 005, POLAND The results that appear in the locale field is for example if I type 98989 in the code and 001 in the prefix it will show me Spain and Portugal …
-
-
- 6 replies
- 1.9k views
- 1 follower
-
-
On my layout, in addition to fields from the current table (Music), are two portals with related records (Trcks). I want to duplicate the entire record (Music) AND include contents of the two portals. (The layout is for example, an album with the tracks. have two (or more) copies and realize it's better to have separate records over a field indicator. The Music Table contains info on the album, the Tracks Table of the various tracks and time shown in the portal.)
-
- 4 replies
- 1.5k views
-
-
[Newbie] - I'm trying to get my head around what would appear to be a very simple task (according to some of the video's I've found online), but I can't get the final result I'm looking for. I have a portal which I'm using to create a new record (customer address), inside my main "Contacts" layout, inside of that portal I'm trying to create a new record using a button (external to the portal). The button should add a new Record and display the Portal Row ONLY when the button is used for this purpose. Otherwise the portal should only have ONE blank field waiting to be populated Presently I have the Portal and button working but not as I need it to. When I have fi…
-
- 7 replies
- 1.6k views
- 2 followers
-
-
Portal1 on my Music Table layout has condition of side="A" and Portal2 condition of side="B". The portals contain the name of Artist and Track Name(s). When the Format=Single, I'd like the Portal1 Artist and Track_Name to appear in lieu of the Album_Title/Artist, per side. Tried If statements but not sure how to address the fields within the Portals.
-
- 2 replies
- 892 views
- 1 follower
-
-
I have a popover with two panels. Both have container fields for images stored external. I'd like to capture the filename saved as and thought this would work. I'm not getting expected results. I've put this into my IMAGE NAME field as auto enter calculation assuming it'll populate when I add the full size image to container.
-
- 6 replies
- 1.3k views
-
-
Perhaps I'm having a brain fart, but I'm stumped... I want to isolate "n" number of characters at the beginning of each line in a value list field and put the extracted values into another list field via calculation. The number of values is dynamic based on the user adding items to the list. An example: Value List................ Desired result 0001|Chocolate...... 0001 0002|Christmas...... 0002 , etc. Of course, if I use Left, Middle, etc. I only get the first line of the list. P.S. - I'm forced to go no higher than FileMaker 17, so the While function is off the table.
-
- 5 replies
- 2.1k views
- 1 follower
-
-
field = "Music Format" Value List (checkbox) Album Cassette CD EP Single iMusic Same field done in text format (temp). However, when the checkbox VL is empty, content still exists in text field version. My aim is getting my calculation to work. Field = "zFormat" used in my header. Case ( MUSIC FORMAT = "ALBUM"; "ALBUM"; MUSIC FORMAT = "CASSETTE"; "CASSETTE"; MUSIC FORMAT = "CD"; "CD"; MUSIC FORMAT = "EP"; "EP"; MUSIC FORMAT = "SINGLE"; "SINGLE"; MUSIC FORMAT = "iMUSIC"; "iMUSIC"; MUSIC FORMAT = "iMUSIC" and MUSIC FORMAT = "CD"; "CD + iMUSIC" MUSIC FORMAT = "ALBUM" and MUSIC FORMAT = "iMUSIC"; "ALBUM + iMUSIC" )
-
- 5 replies
- 1.6k views
- 1 follower
-
-
Trying to create reports. Stuck on my Music_Title layout. Currently, I have two fields: Music_TItleA and Music_TitleB. Where the format is an Album, CD, EP it displays Music_TItleA because both sides are the same. Where Format = Cassette the Music_TitleA may/may not equal to Music_TitleB. eg: FOrmat=Cassette > Music_TitleA is "Christmas Songs" and Music_TitleB is "Easter Songs". I need to display Music_Ttile before print detail sideAB="A" and then Music_Title for sideAB="B". Where Format = Single, there is no Music_Title (I don't use iTunes approach and associate singles to albums) so need to put the "sideA" track into Music_Title and then "sid…
-
- 1 reply
- 625 views
-
-
Hi, I am wanting to use this "Checkbook" font "MECRENC.ttf But FileMaker doesn't see it. I've installed in to the "Computer" folder inside the fontbook and FileMaker still can't see it? The "Users" folder doesn't work either. Other apps I'm able to select this font but not FileMaker, strange ... suggestions? The reason I am using this font is that I need the "A,B,C,D" feature which yields the strange characters in front of and at the back of the account and routing numbers. See attached pic and I've attached the font file. Suggestions would be grateful. Thank you. micrenc.ttf
-
- 2 replies
- 1.3k views
-
-
I want to have a set-up whereby a field is hidden until a button press "unhides" the field. I can hide the field by using Get(WindowMode) = 0 in the "Hide object when" section of the Inspector. I am after a script for a button that will unhide the field when the button is pressed. The closest I have come to, without success is, to create a script for the button that uses the Set Field command. This command allows you to set the target field but requires you to also enter a calculation result. I do not know what to enter or whether using the Set Field command in my script is the right way to go to achieve what I want (show the field). Any assistance would be app…
-
- 5 replies
- 2.3k views
- 1 follower
-
-
Tried using Google and haven't been able to apply solutions to my portals. Now that I have one portal filtered into two, I need to revise the summary fields to count entries and total the time. My attempt: 1872:00:00 = Sum(SideAB TimeCalc::sideD_TIME) should be total time of portal "A" 13 = Count (SideAB TimeCalc::sideD TITLE) (because there are 6 in the portal "B" not shown) should be 6 total count of portal "A"in mm:ss format which isn't working unless I use hh:mm in which case less than one minute fails The same solutions for this side will be applied to the other portal. Then, I need two fields that combine the results for total count and total ti…
-
- 10 replies
- 1.4k views
-
-
This question may be more of an incorrect relationship setup than a value list, so I am hoping to get help with either/and. The tables in question are Budgets - which have a unique name and number; and are comprised of the table Accounts ; Transactions for expenses within a single budget; and TransactionsLI, that allow for multiple line items inside of the transaction via a portal and allow for a different account numbers for each line (e.g., line 1= salary, line 2= benefits - each has a different account number). In short, I need to create a new transaction in the transaction table, select the budget associated with the transaction, then within the Transaction …
-
- 4 replies
- 1.5k views
- 1 follower
-
-
The table, "Address" has a field "Location". The Location field is formatted as a popup menu using a value list "Locations_VL" "Checked with "Override data formatting with value list" The value list "Locations_VL" is pulling from a table called "All_Locations" with a "Primary Key" field and a Location Field. the table is populated with separate locations The Value list "Locations_VL" is using the "Primary Key" as the first first field and the "Location" field for the second with the "Show values only from second field". This works fine the issue is when I want to concatenate fields into a field "Main Address" I enter the Location field and I get th…
-
- 1 reply
- 958 views
-
-
I have a script that tests the Product Code field, in a portal, for validity (using a script trigger -- "on exit"--Attached to the Product Code field) so if the user doesn't enter a known value, a Custom Dialog window appears telling them so; the script then clears the product code field so the user can re-enter a known product code. That part of the script works. The problem I'm running into is that after the script clears the Product Code field (k_ProductCode__lxt) using the Set Field command, I can't find the correct command to place the cursor back into the Product Code field so the user can re-enter a value ; I've tried many variations of Go To Field (using har…
-
- 4 replies
- 978 views
- 2 followers
-
-
How can I add product to LineItems portal under the Invoice Layout? I am using New Window to search a Product (portal) then when select it opens New Window (based: on LineItems)and i can add quantity to that product? I need to get the invoiceid and productid to New Window (LineItems) in order to add record to that LineItems based on a Invoice Layout. I hope there is someone that could help me with I'm stuck in this ,for 2 weeks now,,please need some help!asap
-
- 1 reply
- 1.6k views
- 1 follower
-
-
BACKGROUND I have a musical performance management solution (Gigs) which contains several tables including Gigs (performance dates, times, etc.), Songbook (information about an actual song performed), gigs_PERFORMANCES which joins the two, and other related tables. Two fields in the Songbook table are large text fields (Lyrics and Chart) which are the lyrics for a song and the guitar/piano chart for the song, respectively. Both can be long - particularly lyrics. Also a flag field indicating the presence of data in either field exists in the Songbook table. GOAL The objective is to print a lyrics book or charts book for a Gig or create a PDF of same (p…
-
- 0 replies
- 859 views
- 1 follower
-
-
I am a newbie and trying to use the standard email script with a button. It works once and then when I try again it will not open a new email window in Mac Mail. I am using FMP19. I note that there are options in the button set up and mine seems to default to "Pause current Script". Is this the issue or something else? This is a screenshot of the basic script I am using and it only opens my mail folder and not a new email. Using GMail on FireFox I have opened my Mac Mail to use with FileMaker Pro 19. Any assistance will be appreciated. Thank you.
-
- 1 reply
- 979 views
- 1 follower
-
-
I have a simple web viewer in one of my solutions, which is an address book for customers, to display a google map of their location. Using the following: "http://local.google.com/maps?" & "q=" & /*Address=*/ CUSTOMER::AddressLine1_m & ¶ & CUSTOMER::AddressLine2_m & "," & /*City=*/ CUSTOMER::city_m & "," & /*State=*/ CUSTOMER::state_m & "," & /*Zip Code=*/ CUSTOMER::zipcode_m & "," & /*Country=*/ CUSTOMER::country_m The problem is that there is a "detail" tab that displays by default, which blocks the map view and requires user interaction every time the record loads. Is there a way to default to this tab hid…
-
- 0 replies
- 1.2k views
- 1 follower
-
-
*sigh* It's a good thing I'm paid by the hour. After Comment's outstanding help with setting up a value list for grade levels, I've run into a snag: how to create a summarized list by individual grade level when each record's value list contains multiple-checked values? Example: If I want an ascending-order, summarized list of teachers who teach in 1st grade, then 2nd grade, then third grade, etc., how do I parse that from a value list field (GradeLevel) where ticked checkboxes have 1, 2, 3, 4, 5? My best guess is to create a looping script to parse 14* separate variables--using GetValue--to generate discrete values for use in a Find-by-grade level (also looped)…
-
- 2 replies
- 841 views
- 1 follower
-
-
I am working on a very simple QR code in a web viewer using qrcode.js. The resulting Qr code can be dragged and dropped into a container field or I can right click on the web viewer and select "Save Picture as" and save it to my desktop. I would like to be able to automate this so that it automatically saves the resulting qr code to a container field. Interesting note, when i drag and drop into a container it results in a file called untitled.bmp, but when I right click on the web view and "Save Picture as" it saves as untitled.png. Not sure if that matters but I found it interesting. I have been researching and have seen mentions of using FMP Url to get…
-
- 5 replies
- 3.6k views
- 2 followers
-
-
For our retail store layout, we created a dropdown to allow the user to select an existing item of clothing, although we were hoping to filter this further by the category that the user selected (i.e.; kids, outerwear, women, males, shoes) so that they would not have to scroll through everything to find what they need. For example, the user would enter kids wear, and then the dropdown would solely have clothing related to kidswear.
-
- 1 reply
- 893 views
- 1 follower
-
-
I currently have a layout that contains a portal that shows all the products a customer has purchased. I want to add one new order. In order to select the product for that order I want to click on products to search through existing products. If an existing product does not exist I want the user to be able to add a new product
-
- 1 reply
- 560 views
- 2 followers
-
-
We are trying to sync the scrolling on the 3 portals we have for our layout. (All the rows in the 3 portals are related data).If this isn't possible do you have recommendation for how to make the layout easier to read when scrolling/navigation.
-
- 0 replies
- 829 views
-
-
I have been searchind here for an answer, but probably don't know what to search for. And/or I am missing a simple solution. Three tables: Customers Sites Tickets Each customer may have one or more sites. Each Site may have one or more ticket. Most of the "action" will be creating tickets. I would like to have a single pop up on the Ticket layout that allows the user to pick the Site primary key, but displays the "Customers::Name - Sites::Name." Ideally this would looks something like: Cust A-home Office CustA-satelite officeA CustB-Home Office I thought -- no problem, add a calculated field to Sites table "Sites::CustS…
-
- 2 replies
- 1k views
- 2 followers
-
-
My next problem is a shopping list. This database is for a game, in the game I play at manufacturing, and this database helps me determine what products to manufacture and which to avoid. I’ve attached a copy of the database. What I want to do now is create a list of all the base materials if I decide to build one product or another. All the Materials are listed in the table “Materials”, however, the number I need for various Goods is scattered throughout the database in various join tables. If you take a Material, (for instance, Tritanium) and you go to its record in Materials, I don’t see how to assemble a list of all th…
-
-
- 7 replies
- 1.4k views
- 4 followers
-
-
Good evening. I was wondering please if anybody knew of a product or method whereby I could store files in a structure that worked similarly to that of folders and sub-folders. At the end of every "branch" would be a container field that housed a file - such as a PDF. As the client would be adding, editing and deleting the folders, the levels within, and the files in there, it would need to be a tool that is easily manipulated. I'm sure you know what I mean, but I have included a screen dump of an example folder structure to illustrate what I have in mind. If there is an existing tool out there - terrific. If not, where does one start with Filemaker to create this…
-
- 2 replies
- 1.3k views
- 2 followers
-
-
Here is a navigational button bar menu: Log | Billing | Accounts | Resources Log opens a new layout, Billing opens a new layout, Accounts opens a new window, resources opens a new layout. The 'active' button segment works fine for all of these except Accounts, which upon opening a new window the Accounts button segment remains the active segment. I would like it to be the Log segment, since once the new window is closed the menu is now incorrectly identifying the environment of the previous window. I am assuming a script trigger could reset this, but I'm not sure what should trigger it; and my main question is 'What is the best way to handle this?'
-
- 3 replies
- 1.1k views
- 3 followers
-
-
I have the following code in a webviewer to vide a pdf: "data:text/html,<!doctype><html> <body> <object data='data:application/pdf;base64," & Base64Encode ( PDF::File_Container ) & "' type='application/pdf' width='100%' height='100%'> </body> </html>\"" If I only want to view the bottom half (or top half) of the pdf, is there something I can edit here to achieve that? Somewhat also related, what if I want to view page 2 of the pdf by default?
-
- 0 replies
- 939 views
-
-
What I need to do is provide sequential line number for records instances on a report in list view. The number is of no value other than to provide a visual tool for departments to communicate. It's not stored, and it's not referenced by any other field or table. But the numbering must restart after a sub summary break for a new category. As you can see by my example (see pic for example marked in red) where the numbering continues 6,7,8... I need that to restart as 1,2,3..... at the new category. I know this topic has been discussed before and an article exists by Osborn. But I cannot find the article. I would very much appreciate a link to the article or a maybe an ans…
-
- 2 replies
- 687 views
-
-
Hello. My first question here. I’ve been working with FMP since it was Filemaker, but I’m not a professional, and I think FMP has managed to get away from me this time. I have no idea why my summary fields aren’t working. Here are some of the facts: I’m designing a database to keep track of project costs in a game. Everything is fictional. The problem is in the second line of tables. I noticed the problem in this layout: This shows Items, that are used to build Goods, and the Items are made up of Materials. This screen shows the table Items, and the portal shows records from Items Material Join Table. Items are added to the portal by…
-
- 3 replies
- 1.3k views
-
-
Friends: I'm having an issue where the portal shown below works fine in the application (FMP 16), but does NOT show on the web (WebDirect). I'm using the latest version of Chrome, and also the latest version of Java. Also, both logins are mine (the developer - complete access to file). Does anyone have a solution? Help!
-
- 0 replies
- 649 views
-
-
I have a database with 3 tables (to simplify): keywords (keyword_text and keyword_ID), files (filename text and file_ID) and a join table (keyword_ID, file_ID). Suppose I want to have a list view that shows all filenames with their associated count of keywords attached to each file, and conversely another list view with all keywords and their associated count of files attached to each keyword. How would I go about doing that?
-
- 3 replies
- 970 views
- 1 follower
-
-
I have a portal which display fields songs titles from related tables. One such field indicate the Genre of the song. I'd like the portal row to change color based on the Genre field. My current implementation has a text field containing a space and sized the same as the portal row with conditional formatting. While this basically works, I find it inelegant, plus, when editing the layout, it's another object to deal with. Suggestions?
-
-
- 1 reply
- 1.9k views
- 1 follower
-
-
On the client - View as a table On the web - view as the layout Is it a way to have the same view?
-
- 1 reply
- 616 views
- 1 follower
-
-
Howdy, all: Well, I've spent the last twelve hours beating myself up trying to get the attached to do what I want it to do, but couldn't; I did manage to utter a unique, fantastical, banquet of curses throughout the day, though. What I'm trying to accomplish is in the School (and in turn, District) tabs in the Activity_Log layout: I want to have the the user choose a school (using the global field's pop-up menu) and have only the District_Staff names appear in the Name-labeled field's (::_kflt_District_StaffID) value list who not only belong to the chosen school but also have "Active" entered in their respective Status__lxt fields. (By the way, did I set up the …
-
- 0 replies
- 652 views
- 2 followers
-
-
Good day, I am having an issue that i never seen before. I have a very basic layout, 5 fields, and a global field for searching with a button to execute the search, all is working perfect, except that when i press the search button the result shift to the right, once i clear to show all the list shift back to the left. Any idea what i could be doing wrong. Thanks Jay Mart
-
- 0 replies
- 609 views
- 2 followers
-
-
Hi Group how do i create a calculation / script to place data into the search bar in the top of the window? See image I want to click a button, then in the script i want to collect data from few fields (i can already do this) and then i want to paste the data as a search string into the search box (i don't know how to do this)
-
-
- 2 replies
- 908 views
-
-
I have a solution that is a catalogue of audio files. The actual audio files exist on a web server, and I play them in a web viewer. However the user can alternatively play them from a local folder if he has a copy of that, and that is done by copying a reference to that local file into an interactive container field. This works fine, however the web viewer player looks better - it has fast forward by 30 seconds and back by 15 seconds buttons, and a time display on the progress bar, while the interactive container does not. I read somewhere that I should be able to play the local file in a web viewer by first referencing it in the container, then getting it's URL by …
-
- 7 replies
- 2.3k views
- 1 follower
-
-
So... after a lot of trial and error, I finally have something working in the Web Viewer. The task I'm doing requires me to go to multiple web pages, tab through some fields, enter data in a field, and then press a button. Some other things happen, but that is the gist of it. I have to tab 29 times to get to the correct field, and then I have to enter a 4 digit number (or something similar). Each of the tabs and each of the digits seems to take a bit more than a second to happen, which is agonizingly slow. I'm wondering if there is any known way to speed it up. Here is the AppleScript that I've put into the Perform AppleScript command: "--this script assumes…
-
- 6 replies
- 4.7k views
-
-
Hello, I have created a report in Filemaker 17 that pulls data into it from other relational (fmp) databases. My issue is that I want my managers to be able to review their particular reports via teams. I am currently uploading a new PDF every day but I'd like it to be "live" and for their access to be limited to just selecting their button which is scripted to bring up their report. I am no expert in any type of integration, I am fairly comfortable with Filemaker, I have been using it since version 3, but not utilizing it outside of itself.
-
- 1 reply
- 2.8k views
-
-
Stuck on a solution. Problem: I have a script that creates a pdf of the current record which has two pages. My layout body tab is dragged down past the single page boundry to the end of the second page. I have a picture container field on the 2nd page and the first page with has all my text fields. When I run the script, only the first page is created and not the second page with the container. In my script (showing only two lines but there are other that deal with saving the pdf file in a windows directoy. I don't think these are relavent so I don't have them listed below): Print Setup [Restore; No dialog] Save Records as PDF [Restore; No dialog; "$Fi…
-
- 0 replies
- 1.1k views
- 1 follower
-
-
Hi All, as mentioned on the topic, I would like to create a unique value script instead of Validation the field for code put like ex.12324331 in the portal. thanks in advance for any help or support ...
-
- 0 replies
- 805 views
- 2 followers
-
-
I am trying to do something like this, Upload a pdf in to Filemaker On the pdf file I need to ad one or more markers like a circle with a number in it. The number comes from field. It has to work on filemaker in IOS. We are trying to do a app for marking differ ten things on a drawings inside filemaker (the pdf file) and as you walk around the building same as the PDF we kan mark and typ in any problem areas. Some of you guys know how to do that?
-
- 2 replies
- 1.3k views
- 3 followers
-
-
I use jQuery and the jQueryUI slider widget to display a slider in FileMaker Pro (v17-17-18-19). Works fine but I also need to have it work on FileMaker Go, so I tried my luck on jQuery Mobile 1.4.5. The slider is working nicely on FileMaker Pro, but on FmGo 17, 18 or 19 it doesn't load, keeps displaying a spinning logo. When I publish the HTML page on a website and open it in Safari Mobile it works fine. Any help appreciated! See the example file: just downlaod it and open it on FMGo. The Webviewer and the HTML are displayed side by side. sliderExample.fmp12
-
- 0 replies
- 1.9k views
-
-
I have a layout which is a list of names and addresses. There are 7 records and on the layout they are displayed from top to bottom. However, because he list is too long to fit on one page, when I print this list, the last two records print as a partial second column (apparently they are too wide) and not as a second page. How can I get the list to print as only one column and when it reaches the bottom of the page, print on a new page instead of as another column? Additional information. Sorry. I'm using Filemaker 19 on Windows 7.
-
- 2 replies
- 806 views
- 1 follower
-
-
Hi! I have a calculation field in a portal which shows the value according to ActivePortalRowNumber. Each row has a special determined value. When I manually enter the value in the field before the calculation field and thereby make a particular row active, my calculation field automatically shows the designated value. Great! But, if when I do the import from Excel, all data gets nicely imported and the portal shows the imported data but the calculation field is without value. I guess the importing process is not making a portal rows active so the calculation is not working. Any ideas how this can be solved? Many thanks!
-
- 0 replies
- 1.1k views
- 1 follower
-
-
I'm trying to make a value based on the content of JSON_cListKeys in this specific record only: The fields involved: I get the "This Value List Won't Work... based on a calculation" message. So I tried to see if looking up the content or calculating the content and using that instead.. um.. no, it's still a calculation. I Tried changing to a calculated text field ... I get no error from the value list creator, but I still don't get actual values in the list. In order to only get the values from the current record, I created a self join [Items <--> Items_Current_Record] and linked it to itself by the un…
-
-
- 9 replies
- 2.3k views
- 1 follower
-
-
I there a way that I can set a larger zoomed view as the default for opening the dbase in FileMaker Pro16?
-
- 4 replies
- 1.7k views
- 2 followers
-
-
I have two order tables. A bikeOrder table and a carOrder table. I now wants to have a list view where i can view all orders in the system, with a list layout but cant figure out how. any feedback is appreciated.
-
- 6 replies
- 1.5k views
- 2 followers
-
-
I am using FMPro 16 on a Macintosh (MacOS 10.13) In Browse mode, viewing Format>Font I see the following: PROBLEM: some of the fonts installed on my Mac are grayed out, and ALL of the "options" (Roman, Book, etc) are grayed out. In EVERY other programs on my Mac these fonts are available and work and print perfectly. CAN SOMEBODY please explain what is the problem that FMPro has with them. And if possible, tell me how I can fix this. Thanks.
-
- 5 replies
- 1.8k views
- 1 follower
-
-
Greetings. Reaching out for help as I'm staring at a brick wall currently. The more research I've done the more lost I've become. Primary Table is a List of ALL Active Matters. Each Matter is Unique. Portal is a List of Related Nominations. Relationship is the MatterID Two calculations are performed for Every Matter & Displayed/Saved in the Primary Table (Save Preferable) 1.1 Count the Number of Nomimations For the Matter (SUPPORTCOUNT). 1.2 Add the Value of each Claim per Nominations (SUPPORTVALUE) The above Calculations are for the Primary Table & Preferably a Saved Value. The Calculations Must be part of the visible Primary Row. eg:…
-
- 7 replies
- 1.5k views
-
-
Consider a long list of records in list view. For each record there is a field. When an entry is made in the field, a script is run and at the conclusion the next record is selected. When reaching the bottom of the layout, the next record is not visible unless the user scrolls up. This has to be repeated for all of the remaining records. Is there a way to always keep the selected record, say in the middle of the layout? Or t least always visible?
-
- 8 replies
- 864 views
- 3 followers
-
-
Hi, I have encountered an error message I have never seen before. When trying to copy anything at all (fields, text, etc) in Layout mode and paste it on to the layout, I get the message: "This operation cannot be completed because it would exceed the maximum allowed dimensions of a layout." Can anyone explain this to me? With kind regards, - Johan.
-
- 1 reply
- 619 views
- 1 follower
-
-
I am new to FileMaker and I've accomplished quite a bit so far, but I cannot for the life of me get the borders to print. Anyone know how? I'm using FM 15 Pro using enlightened print theme with delineate unchecked.
-
- 1 reply
- 1.2k views
- 2 followers
-
-
Hi, I've been using the Kargas Dialog plugin for years, event if it's no longer supported, it's still working in FMA17, I'm planning to move to FM19 this year and I need to get rid of old 32 bits plugins. It's a lot of work since I use it in so many places. I already replaced large dialog and custom dialog with card windows (Technic by Matt at Filemaker Magazine). Mainly it is used to allow the user to select related information about something. The items in the list are not fixed. For example, we sell an item and we prepare a list of parts the installer will need to go with that item. So I have a table relation from item.id <----> …
-
- 1 reply
- 1.1k views
- 1 follower
-
-
Hi All, Attached is a zipped FM DB which contains a single popover and script that creates a time picker much like Google Calendar's time picker on Android. I created it because FM doesn't have a time picker, and I just felt like it. Have attached a screenshot of what this time picker looks like. If you improve on it, share it. Enjoy!TimePicker.zip
-
- 11 replies
- 9.8k views
-
-
Hi, I'm creating a dropdownlist where the user can choose between different units. The user should be able to choose between the general unit being "PCS" or the sub-unit (could be gr, kg, boxes etc..) which is mentioned in another field of the record. Main idea behind this is that the user has the freedom to be able to select the full quantity of a record or a smaller quantities in logical units. Lets say one PCS = 10 boxes (instead of for example 0,2 PCS the user can enter 2 boxes). So I want to create a dropdown value list based on a combination of two sources: - 1 fixed value, which is always the same (in my case it is value "PCS") - 1 value b…
-
- 6 replies
- 1.3k views
- 2 followers
-
-
Recently I've upgraded to Pro 19 and I noticed the arrow icons are gone in layout mode. It's pain in the neck to go to another layout. Any tips are welcome.
-
- 1 reply
- 610 views
- 2 followers
-
-
I have a client layout which displays one client per page. Each client has several phone numbers (home, work, mobile). I created a separate table for phone numbers (one to many) connected by the clientID. The phone table has ID, clientFK, type (mobile, home, work), and number. I created a portal on the client page to display the various numbers for each client. It works ok. I then created a Client list. Can I display a specific number from the phone list on the portal?? Thanks for any assistance.
-
- 6 replies
- 883 views
- 2 followers
-
-
I've been using FileMaker for many, many years... dabbled enough in building solutions to be dangerous. Over the years I often come across a problem that has no solution, but a notorious work-around. Filemaker's limitations provide endless frustrations for this simpleton. Just this evening, I was building a very-very simple database, and just needed a field to have a basic drop down list... but no matter how i work it, it is ugly, or over complicated, and borderline dysfunctional. Why is the very basics of a useful tool like a drop down list so gosh dang junky!?! There are many features FMP has, I'd almost trade them all for a simple/functional way to build a drop down li…
-
- 1 reply
- 1.2k views
- 1 follower
-
-
Any ideas why webviewer on a Mac isn't working? Works correctly on a PC but on a Mac shows URL can't be shown. Seems to be for any URL. Safari is working correctly on the Mac. FileMaker 19 very latest update, Catalina 10.15.7 - safari 13.1.3
-
- 0 replies
- 1.1k views
-
-
I have tried to find the answer to this but cannot. I have a HOUSE Table (parent) and an OCCUPANT Table (child). I have a portal on the HOUSE layout showing the occupants for a particular house. When I delete the occupant, it also deletes the occupants record!! I do not have the delete box checked in the edit relationship dialogue box. I have attached the file. Thanks for any assistance. HouseOccupantExampleForumQ.fmp12
-
-
- 4 replies
- 1.4k views
-
-
Hi everyone, looking for an assist. I have related tables, and use a portal to display records. I would like those records to be numbered, simply 1 through whatever. I can't figure out how to get this done. Can someone help? Thank you! Roger
-
- 4 replies
- 1.8k views
-
-
Hi all. I'm working on a project that utilizes touch screen monitors and I am wanting to find the most efficient way of scripting an on-screen keyboard for users to enter data when prompted. The typical QWERTY keyboard with backspace, left/right arrows, Enter, etc. If possible, if someone could direct me on how to script a single letter (say, "Q"), spacebar and Backspace I should be able to figure out the rest. Many thanks.
-
-
- 3 replies
- 1.6k views
- 1 follower
-
-
Hello, I'm sorry if I am asking a repeat question. I searched the forums and found plenty of information on formatting, conditional formatting, check boxes and so on, but not what I was looking for. I have a value list with checkboxes, and have formatted the default text. What I would like is for the text to change to a different color when the corresponding check box is checked. How can I accomplish this? Thank you for any help!
-
- 2 replies
- 1.5k views
-
-
Hi, I m extracting data from web viewer in filemaker, It takes time to load media, so I wonder if it is possible tu load only text ? without media file (pic, gifs, video ..) any plugin are welcome thank you
-
- 5 replies
- 1.7k views
- 2 followers
-
-
I use FM Pro 12, and I hope this is the correct forum for my first post. I have a text box on my website into which I often add dates in this format: 5th November 2020. Is there a way to have FM automatically change the “th” after the date number to the superscript version of itself? In other words, the date is entered as 5th November 2020, but FM changes it to 5th November 2020. By way of example, it is certainly possible to have Microsoft Office do this automatically, but I would like to know if FM is also capable of this function. Thank you Richard
-
-
- 5 replies
- 1.2k views
-
-
Is there a way to achieve this? Example i have 36 record, then i need to show only 5 record per portal. I have a total of 4 portals which bring me 20 records showing. Since 36 record can't fit on 20 row, I should have a button next and back. below is the sample, Number represents the record portal 1 portal 2 portal 3 portal 4 1 6 11 16 2 7 12 17 3 8 13 18 4 9 14 19 5 10 15 20 Under the portal th…
-
- 1 reply
- 981 views
- 1 follower
-
-
I have a table parent and a table child. And a join table child to parent because one child can have two parents, one parent can have many children on the Layout using table parent I would like to display the other parent (if it exists). For the life of me I can't work out how?
-
- 5 replies
- 1.3k views
-
-
I have a 'Jobs To Do' file. In it I create a job and assign it to people who are listed in a portal. I have a dwindling VL on the portal which ensures the same person cannot be assigned to the same job twice. What I am trying to do is to ensure a person is only assigned to one job. ATM when I create a new job, the list displays all people including those who already have a job. Can anyone assist with this please?? I have attached the file. Thanks. DWINDLING TEXT FIELD FOR FORUM.fmp12
-
- 0 replies
- 1.6k views
-
-
Wondering if any insiders know if the "Animated Go To Layout" will ever be available on for desktop version of FMP?
-
-
- 5 replies
- 1.3k views
- 3 followers
-
-
Curious if there is a solution to this problem I'm having.... I would prefer to use a Button Bar over a standard Button. But, a Button Bar has an Active State that holds hierarchy over Hover State, which makes the Dial Up/Down Button in the attached sample file "appear" to not work correctly. Is is possible to somehow override the Active State so Hover State works properly? Thank you for any help! 😃 sample_button_bar.fmp12
-
-
- 8 replies
- 1.4k views
- 2 followers
-
-
Hi, I created a form which has two different ports. My question is how to print a report data coming from two ports, since they are different. I can only print report from one portals... Many thanks. KC
-
- 2 replies
- 813 views
- 4 followers
-
-
Hi All, As per mentioned on topic I Would like ask someone to help me this issue because I am trying more than time unfortunately all is not successful to send e-mail for birthday in case have in the same day more than one employee. on filemaker server :
-
-
- 11 replies
- 1.5k views
- 2 followers
-
-
Hi all, I would like to create a script or function for the Email field in case the entry of the email without @ give him an error or an invalid address. thanks a lot for any help or support
-
-
- 6 replies
- 2.1k views
- 3 followers
-
-
Hi all, Actually, as mentioned on the topic also as per shown below this layout dedicated for visitor in kiosk because sometimes the guest login to fill the required fields but for some reasons leave or ignore to complete it or change to mind to stay and leave ,Therefore the layout still shown till next visitor. I would like to add in my script to delete the request if some field empty. thanks a lot for any help or support
-
- 1 reply
- 724 views
- 3 followers
-
-
Hi all, As per mentioned on title ,I have two report in different layout in my database .I hope find script to solve my issue without change orientation every time manual. I have two type setting to report print. - First report print need landscape. - second report print news portrait.
-
- 3 replies
- 857 views
- 3 followers
-
-
Dear Developers, I'm struggling with an in-house Expense Report solution. I have a linked portal of LINE_ITEMS, which contains individual expense details. One of the fields in this related table is a container for receipt storage. I would like to include a field on the parent layout to add receipt data to the highlighted portal's field. I've been unsuccessful finding a related solution's implementation.
-
- 1 reply
- 749 views
- 2 followers
-
-
Hi, I'm newbie in filemaker, and I have started to build my first new database, but a new challenge floated on the surface that I believe someone can help. I have a category field "consignment item" that unit of measurement could be different (Kilogram, ton, animal, ...etc). The problem when I want to group or sort my report based on the "consignment item", the subtotal field count every value in the "amount" field whatever the unit of measurement was. Any idea how to fix this problem? Thank you, and I appreciate your help
-
-
- 10 replies
- 934 views
-
-
I have a STUDENTS (parent), and SPORTS (child) table. The relationship id STUDENTS_ID in the STUDENTS table, to STUDENTS_FK in the SPORTS table. I have a SPORTS portal in the STUDENTS table showing the sport name. Can I make the sport field in the portal a dropdown list to select various sporta for various students?? Thanks.
-
- 4 replies
- 797 views
- 1 follower
-
-
Claris have released a new Rich Text Editor Add-on with the latest FileMaker Pro update. I've had a look at it and it looks good, and works in FileMaker and WebDirect. The only issue I've had is that the toolbar sometimes disappears for seemingly no reason in FileMaker Pro (seems more stable in WebDirect). Also it's based on quite an old version of Quill, and although I'm not so familiar with the new add-ons there seems to be a fair bit of dev stuff in there. What's the AddonSampleData table used for? Has anyone else tried it?
-
- 2 replies
- 2.4k views
- 1 follower
-
-
Checking a file with BE it throws me the error "Style has no name! This style has no name, and so won't appear in the style list, even though it exists in the file. This is a bug in FileMaker Pro, and there is no simple way to clear out the style as it can't be located. They don't cause problems, but do take up a small amount of space. You can try saving the style changes or the theme to clear these out." But neither saving all Styles on all Layouts nor saving or renaming the Theme works. Does anyone have any idea how to fix that? TIA pixi This is the xml coming from the DDR:
-
- 0 replies
- 903 views
- 1 follower
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online