FileMaker Interface Features

Hi Folks, I've just moved my database to a server. It works fine, but it's slower and a couple of the scripts now take enough time that I could do with putting up a wait / progress bar. The issue is that the scripts dive into other layouts to create records in other tables. Am I right in thinking that I can't use a Card Window and then change layout behind it? (I haven't actually used Card Windows before...) I suspect that this isn't an unusual thing to do - what are the standard tricks? Many thanks all! Best wishes, Mike

• 7 replies
• 4k views

Lola

March 2, 20187 yr

I've placed an eps image into a layout, the company logo that appears on every page. It hung around for a day or two and then disappeared, leaving its icon. I thought it might be a linking issue (even though I recall having embedded it) so I moved it to the folder, the icon changed colour. I have tried to re-import the image and now I'm told Filemaker "This file type cannot be used a picture" - I haven't edited the file at all in the interim. What's happening here? I realise, pragmatically, I shall just replace the image with a PNG and then copy into each and every layout, but, beyond my frustration I would like to understand what's going on.

• 0 replies
• 914 views

Chris Pink

March 2, 20187 yr

Hello there. First of all im newbie in fm. I use the filemaker 16. I want to make a new base that keeps track of pages and especially registerstations and log ins. So i created 5 tables: "sites, user_names, passowrds, emails and account_descripion) I linked the tables with relationships. I created a portal witch have fields from three different tables, a field user_name from table user_names, a field password form table passwords and a field email from emails table. When i insert the first line(raw) in the portal ιτ seems to work. but if i try to insert values in the second line (say in a site you vave two accounts like facebook one ofiicial and the othe…

• 2 replies
• 2.5k views

Fitch

February 26, 20187 yr

I am creating an iPad solution for quizzing people on backgammon positions. I am trying to figure out a way of reflecting the users "Mastery" of each problem -- the idea being that they will take the quiz repeatedly over time, gradually getting them right more consistently. I thought about just showing a % of Right answers divided by Attempts -- but this number wouldn't change (improve markedly after several attempts. If they got a problem wrong the first two times, and then correct 3 times in a row, the progressive % would be 0, 0, 33, 50, 60 -- and 60% doesn't suggest the degree of mastery one deserves for getting it right for the 3 most recent attempts in a row. …

• • 
• 4 replies
• 1.7k views

Wickerman

February 24, 20187 yr

I have a file that contains records that have a beginning date field and a ending date field. My summary report is working, it is breaking as it should and contains subtotals and a grand total. My problem is I want to report records that are between a user entered beginning date and ending date. How do I get those dates and use them to run my subsummary report?

• 1 reply
• 1.2k views

doughemi

February 24, 20187 yr

Hi can anyone advise how i can make a simple value list conditional? I have a single table on a job bag system and one field specifies the choosen print supplier i.e.: "London Print ""Wards Print" etc. I would like the detail fields such as "Foil Colour" to be conditional because different suppliers have different references to the colour swatches.. e.g. London Print may use "RED032" where Wards Print could use "BlazeRed" I only want to display the user the values specified by the choosen supplier.. i'm not sure where to start? I think i need to create tables and relationships but would appreciate any help thats out there on the forum... many thanks

• • 
• 4 replies
• 1.8k views

beckham

February 22, 20187 yr

Hello I started working on a new client which has already FileMaker15. I am used with FM11 from years now. One thing I found strange, was the browsing of the fields on manage database window. On FM11 I could easily press on the keyboard the key of starting letter of a field and navigate to the fields with that starting letter, on FM15 it just hangs at the first fields it finds, sometimes jumps from first to second it finds, kind of strange. Let say I want to navigate to a field named "Saturn". On FM11 if I press on keyboard "S" it navigates to the fields starting with "S" every time I press it, I could even press fast enough "sa" and it will navigate …

• 2 replies
• 1.8k views

Toni

February 20, 20187 yr

Hello all, I have created this sample solution to demonstrate a technique that I'm trying to implement using custom value lists. I was able to fix my first issue, but the way it was fixed is bothering me a little. Because it seems like too much overhead to have a non-global/non-calculation field serving the same purpose as one. This version actually uses two extra fields whereas the first was using one field. Maybe I am over reacting and this will not cause any issues and is a fine alternative, but I wanted to reach out and see if anyone else had any thoughts, ideas or suggestions on this before I move forward? My original problem shown with versi…

• 2 replies
• 1.4k views

Gabriel G

February 18, 20188 yr

Hi, I have a line inside my tab control in filemaker 16. Do you know what it is for? I have trouble figuring it out... Thanks. Kent

• 1 reply
• 4.4k views

doughemi

February 15, 20188 yr

Sorry for the two-part question but they seem to go together... I'm starting to rewrite my FMP5.5 to FMP11 UI. I'm graphically challenged so with the intention of making use of the larger displays, I'm looking closely at what some of the industry leaders have put out. So far, every FM Theme sample or product, or example that I've run across for single-line fields, field labels, or buttons use both padding and alignment when it seems that having only padding or alignment on 3 of the 4 sides is necessary and would be more useful. For example: 12pt Left-center aligned text 22pt high x 200 wide field Padding of 2,7,2,7 The left padding of 7 (…

• 8 replies
• 5.7k views

Lee Smith

February 13, 20188 yr

Hi everyone, A while ago I have developed a FileMaker solution that is currently running on FileMaker server Version 14. I have 40 clients connecting to the server. Every client is either version 14 for 15 a FileMaker Pro. The solution includes a calendar which is displayed on the web viewer. The calendar pulls real-time data from the FileMaker server and displays it as a web page inside webviewer. The calendar uses PHP and CSS to generate the view. Every client that has updated to Mac OS hi Sierra he's having issues with the web viewer. Sometimes the content loads immediately, but sometimes it takes a second reload in order to see…

• 0 replies
• 1.4k views

fex

February 12, 20188 yr

Hi guys! I would kindly appreciate your help! I need a report for my employees uniforms. I have the employee table where I have these variables: employeCat, shirt size, shirt amount , pants size, pants amount, shoe size, shoe amount (employeCat can be administrative, designer, reception) So, I made 3 summary fields to add up the amounts and thus obtain the totals of each item. Soo, I'm having problems when creating the report, can't get it to work. For example, I need to see the shirt size L and see how much shirts I need for that size and the amount for the category the employee is in. I. E Shirt size L, 11 required for category…

• 0 replies
• 1.3k views

muskee

February 7, 20188 yr

Hi Folks, I hope you're all well. I'm trying to use a Find step in a script, to find multiple words from a Global field checkbox in a field in the same table. It works fine when just one word is selected, but fails when two or more are. I've tried different operators, but = and == don't work either. Is it possible to get this kind of thing to work, or is it only do-able in related tables? ------------------------- hmmm, having asked the question, I suppose I could separate the list into it's different words, give each a variable and Find for each variable. There are only three possible words so a max of three variables to set. Can't remember…

• 8 replies
• 1.6k views

MikeKD

February 7, 20188 yr

Hello, Could someone help me with this question? I have a row in a portal in wich i would like to make a calculation: Bedrag= Cases*Prijs, but if Hoeveelheid is filled in then it should calculate Bedrag= Hoeveelheid*Prijs. The fields are all numeric. The calculation should be possible on one row, in this example i have made it on two. Yours sincerely Frans

• • 
• 3 replies
• 1.9k views

doughemi

February 4, 20188 yr

Happy holidays, everybody! (Please refer to the attachment.) This is a portal that lists company names from the CompanyName child table. On its right is a field (SortOrder) that contains a numeric value that a user would enter that in turn, causes the company names to change their sort order in a different part of the solution. That part works fine. To make it a little more elegant/easier for the user to enter a number in SortOrder, I'd like to create a dynamic value list from which it would list numbers from 1 to X, with X being the count of records inside the portal, e.g., if there are 8 company names within the portal then the value list would contain the num…

• 8 replies
• 1.7k views

Rich S

January 29, 20188 yr

Hi Not sure if the is the correct forum ... please advise where I should post if not here. Thank you. I have a client that is already working on a solution created in FileMaker 13 ... Client wants to default all field fonts to ... "Calibri 13pt" ... ?? Looking in ver 15, 16 I can see anyway to change the "Font" across all layouts in FileMaker preference pane. Going back to my version 13; on my mac in "FileMaker" preferences, I know that I can preset the "Font" in the beginning when creating the File, but since the solution has already been established for some time ... One - Can I change the overall "Font" via the customer solution within…

• 2 replies
• 1.7k views

"... you mean these fans?"

January 29, 20188 yr

I have set up a portal which correctly shows the records I need. I want to be able to select the data from one of the fields - say there are 5 fields across one row of the portal and there are 5 rows of data showing. Is it possible to create a script which I can assign to a button which would copy the data in field 3 row 2, say? Thank you.

• • 
• 10 replies
• 2.5k views

Agnes Riley

January 26, 20188 yr

I’m trying to setup a portal that filters records with a calculation field. I have a set of Disk table records that have the fields Disks::Title and Disks::FirstLetter = Left(Title,1). The user selects a letter from a value list attached to a global field gFirstLetter. A dropdown displays values A through Z. The portal TO, FilterDisks, is a self join, using the “x” operator. It uses the filter criteria FilterDISKS::FirstLetter=FilterDISKS::gFirstLetter. When a value (A to Z) is selected by the user I expect the portal to display only records beginning with that letter. However, it does not display the records properly. Sometimes, but nor always, by c…

• 2 replies
• 1.2k views

Pavlk

January 24, 20188 yr

Hi, Can anyone help me how to solve this ? I have a 2 drop down list field on my portal with two values in each field . Is it possible When I select the first or the second values from the first field it will change the second field values based on the value of second field using the conditional formating Formula...? e.g field(1) have two values from Drop-down List (Pass) and (failed) field(2) have two values from Drop-down List (Good) and (Bad) If I select (Pass) it will change the second field values to (Good) automaticly and commet the record Or if I select (failed) it will change the second field values to (Bad) Ahmed

• 3 replies
• 1.1k views

Pavlk

January 24, 20188 yr

Hello, everyone. I have a question. I have web viewer object named "web". If I start a script running, Every 5 seconds, it fetches the string from the HTML that is shown in the web viewer, and keeps creating new records. Just like this GetLayoutObjectAttribute ( "web" ; "content" ) Then the target value always get refreshed every 5 seconds. javascript is just like this function updateLastvalue(new_last_value){ var current_last_value = $('.last-value').text(); var fixed_last_value = Number(new_last_value).toFixed(8); $('.last-value').text(fixed_last_value); // update do…

• 0 replies
• 1.6k views

megalomania

January 21, 20188 yr

I have hidden many fonts in the Windows 10 Font folder that I do not use. However, they continue to show up in the FM font menu. Is there a way to stop this? I would like to shorten the font menu to fonts that I use.

• 3 replies
• 1.1k views

Agnes Riley

January 18, 20188 yr

Hi I am trying to set up a database to review some surgical cases of mine. The basic structure seems to work fine. I have attached an abridged section of the database with four tables: Patient --< ProcedureEvent --< PrimaryProcedureEvent >-- PrimaryProcedure What I would like to do is: When looking at the Patient layout (Grandparent) be able to see a summary of all of the Primary Procedure Events (Grandchildren). The attached file has some text dummy data on the Patient layout to show what I am trying to achieve. I have tried using portals bu I can only get the first "Grandchild" to show Thanks for any advice and help…

• 3 replies
• 1.5k views

GarthT

January 17, 20188 yr

I'm about to start a solution that needs quite an amount of layout forms and I would like to create a consistent design based on my own custom theme that has already been developed in a separate file. I use Material Design specs as style guideline and the solution is build under the separation model, so all the data is in a hosted file. I'm considering one of these two strategies: Create a repository of interface elements (text fields, tab controls, combos, portals, etc.) in a separate file (that's mostly done) and copy generic elements into my solution as I build the needed layouts or Create layouts quickly, overlooking style and apply my theme when al…

• • 
• 1 reply
• 4.7k views

Steve Martino

January 14, 20188 yr

Every January, I send out a note referring to the previous year. Is there a way to have the previous year inserted automatically in the sentence? ex. "Total number of hours served in 2017 . . ."

• 7 replies
• 4.4k views

Lee Smith

January 12, 20188 yr

I recently upgraded from FMP 14 to 16. In layout mode, there was a line of text and icons at the bottom of the window. I don't see them anymore and can't find an option to view them. The line consisted of a zoom number (typically 100), a minus sign "-", a plus sign "+", an icon, and then another icon, and a mode selector - Layout in layout mode. I would like to use the second icon which changed the view of the part labels such as "Body" and "Footer". I would like those labels to be shown at the side and not on top of the part. Where did this option go?

• 3 replies
• 1.3k views

BiknSwans

January 10, 20188 yr

I'm working on a database right now that handles general accounting information for a department of a university. My current layout looks like this: Where the left section has buttons to take you to the different layouts and look at various different tables, and the middle column is a scrollable portal to look at all of the jobs. On the right hand side for the "employees" section, I was able to fit all of an employee's data in that space, so it worked, but each job has significantly more data associated with it and doesn't fit in that space, so I was wondering if there is a way to make that section scrollable, but looking at the same record (i.e. The job desc…

• 1 reply
• 1.5k views

Steve Martino

December 27, 20178 yr

Am a bit lost on what (I think) should be a quite simple script: Field 1 has a value list on layout. Field 2 is a general text field for typed data entry.. My goal is to use Field 1 to trigger/manage a script which does severla things, but then leaves the mouse/selector inserted into Field 2, for ease of use... So... When I select an item in that value list, an OnObjectExit triggered script: sets a variable from that, then clears that field inserts a calculated value (based on the variable created) in another field. Then it SHOULD "go to Field 2"... as in, after the script is done, the cursor should be inserted into Fie…

• 2 replies
• 1.8k views

wedgeman

December 24, 20178 yr

Good Morning I am wondering how I would go about this wee problem. I am developing a simple system which takes subs from members. I would like to display only the records that have paid, with an amount in a certain date. Any help would be great. Or maybe even if anyone has such a system developed already. Thank you.

• 2 replies
• 3.5k views

Faldo

December 22, 20178 yr

I used to know how to do this… I need a layout that tells me the total number of each plant on the list. Fields are: Plant Code, Qty. Sample data (using commas): AAAA,15; AAAA,10; BBBB,25; CCCC, 40; AAAA,5; CCCC,10 I want a layout that tells me the total number of each type of plant, like this: Plant, Total Qty (from sample data above) AAAA, 30 BBBB,25 CCCC,50 So,I tried making Total Qty field, and putting it in a trailing sub summary, sorting by Plant. This doesn't work. I also went through Phil's tutorial but apparently didn't follow directions. This has got to be Filemaker 101 but I am screwing it up. Where?

• 5 replies
• 1.5k views

suzieyoga

December 21, 20178 yr

Hi There, I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…) I’m still experiencing one big problem with my solution for which I would need help. Here’s the context : I run a little company. We receive financial reports every quarter. All quarterly reports ( Excel file or csv file) have the exact same form. I then created a layout based on the table created when importing the csv that works properly. My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout. Is there a way of having a layo…

• 4 replies
• 1.4k views

Fitch

December 14, 20178 yr

I use specific color codes in Filemaker, but am forced to store the color codes separately (outside of filemaker). Is there anyway to have stored in filemaker and then maybe even "auto-populate" in a specific field type?

• 5 replies
• 5.7k views

Lee Smith

December 14, 20178 yr

Hello, I want to split a custom value list into two lists while keeping my records intact. I used to add new vendors to a custom value list called _vendors_. I have now reached the 30000 character limit. I have managed to solve the 30000 character limit on custom value lists by splitting them into two list (_vendors_A-K and _vendorrs_L-Z) following these steps https://community.filemaker.com/thread/93937. Problem is that since I changed the value list _vendors_ into two new lists the records don't remember their old custom value meaning I would have to change over 4000 records by hand. Is there an easier way to solve this I might have overlooked? Excuse my lack of te…

• 1 reply
• 1.5k views

Fitch

December 13, 20178 yr

Quite recently I upgraded from FM11 to FM16 and converted a bunch of files. I since appear to have a portal that isn't always displaying the correct records. The first screenshot below, shows the layout based on the Route Packs table, with three portals based on different tables stacked down the left hand side. The portal that is displaying strange behaviour is the bottom most portal, although on this record (Armley Jn - Dockfield Jn) it is displaying the correct records. The uppermost portal is showing two records which are the route pack sections that make up the route pack (Armley Jn - Dockfield Jn), the middle portal shows the Train Drivers that have this ro…

• 2 replies
• 980 views

Fitch

December 13, 20178 yr

While creating a new solution, the file starting to freeze up when I try to access Part Definition. I have to use Ctrl+Alt+Delete to close the program. It only occurs on this one file. File Recovery did not work, and saving as a compressed file did not work. Computer reboot did not work. What can I do?

• 1 reply
• 1.4k views

Steve Martino

December 12, 20178 yr

I have 3 tables: Person, Session, and Contract where Contract is a join table. I am in the Session table layout, in a Contract portal. I have a field – Trainer Name in the Contract table – where I want to select the name of a person from a list of people in the Person table. The Trainer Name field is a dropdown list using values from the Trainer value list “Person::__k_p_Person and Person::Name_Full”. I have tried numerous configurations with table instances and I either cannot alter the Trainer Name field at all, or I get a “?”. After the Contract record is created, I want it to show up in a Contract portal on the person’s record in the Person table. …

• • 
• 7 replies
• 1.8k views

Lea Alexander

December 5, 20178 yr

Good Morning everybody! I am Mr. Ali Bahar filemaker developer from Pakistan. Attched is the HTML file. I want to view this HTML file/Code into the filemaker pro webviewer when the file is accessed remotely. Locally the filemaker webviewer shows the contents but when the file Database is uploaded to the server then i don't know what should be the address into the filemaker webviewer so that every user can have the correct display of this HTML. Thanks. clock for filemaker.3.html

• 1 reply
• 1.2k views

OlgerDiekstra

December 5, 20178 yr

Hi, I made a Filemaker Database a couple of years ago for a correspondence school, now I'm building the same thing for another school. The database has a record for each student and a field for each possible lesson they can be sent. When a lesson is sent the date goes in the appropriate field. For reporting I had no idea what I was doing, so I just made a table with a field for each lesson and a script that would search within a date range, take a record count of the returned records take that number and put it in my report table. The date range is set by global fields for the start date and the end date. The script would repeat for the 200 or so …

• 5 replies
• 1.7k views

Matthew Bloomfield

December 2, 20178 yr

Hi Everyone, I need help with portal show records. I have attached the example solution. There are four tables. Office, Staff, Asset and Assign (Asset assigned to staff). On Asset layout i have portal based on Assign table i want the portal to show only staff members which are related to specific/related office not all staff. Maybe its already answered or its simple to solve but i couldn't find any after searching/googling. If any answer is already in forum please give me link or modify this solution i shall be very thankful. Thanks in advance for help. Assets.fmp12

• • 
• 4 replies
• 1.2k views

ash1474

November 30, 20178 yr

What is the best way to extract a website as a pdf from a web viewer window? I have read some suggestions of creating a separate layout with the full screen as the web viewer window, changing to preview mode and printing/saving the screen as a pdf.

• 1 reply
• 2.9k views

MonkeybreadSoftware

November 28, 20178 yr

I'm trying to make a Filemaker solution to design labels. In the layout there are two fields I would like rotate 45 degrees. I have noticed that Filemaker rotate in steps of 90 degrees. However, I have not been able to find a solution for 45 degrees of rotation. Any help and advice is welcome to correct this layout problem, perhaps someone who knows a plugin that can help with this. or another clever trick to solve this? The layout of the labels is given and adamant, several labels have already been printed and will have to be replaced in a layout change. So adjusting layout is not an option in this case.

• 1 reply
• 1.4k views

bcooney

November 28, 20178 yr

I was wondering if it were possible to have indents in a text field. I would like to have a bullet followed by a paragraph that is indented for all it's lines. If there is a further (more indented) bullet, the whole text should be further indented. I know FM is not a word processor, but I am wondering if this is available anyhow. Thank you in advance, Fed

• 4 replies
• 1.4k views

fed

November 27, 20178 yr

Is there a way to show the hand cursor for a popover button? I've a lot of buttons on a layout - one of them a popover button - and I want it to behave like the others. FM Advanced 14, FM Server 15, macOS High Sierra 10.13.1.

• 4 replies
• 7.2k views

kolvorok

November 26, 20178 yr

I have several reports that use Google Charts displayed through a web viewer to display a "'gas gauge" type of chart. This is a very popular style for our dashboard reports to the point where it is a requirement. I originally started using them in FileMaker 14 and they worked great. When FileMaker 15 came out they wouldn't work at first but then did after an update to the code. I'm now testing Filemaker 16 and they're back to not working properly. They do display on the screen just fine but if you try to print preview, print, or Send to PDF they do not show. Does anybody have experience with this or know if a setting changed in FMPA 16 that could be ca…

• 3 replies
• 2.5k views

Franco Pagano

November 24, 20178 yr

How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html I'm able to grab the content from the first subsummary, not the remaining however. The following: set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.

• 0 replies
• 1.5k views

ggt667

November 21, 20178 yr

Hi guys - a very simple question which is bugging the life out of me. I want a brief comment to appear inside a field and then dissapear when the typing starts. For example within the address field i simply want the description address until the user enters the field and then it disappears. Ive seen this on many dastabases and havent a clue how to do it in filemaker ? Any help would be much appreciated ! Thanks Peter

• • 
• 9 replies
• 3k views

Lee Smith

November 12, 20178 yr

Hi, so I'm struggling with a solution for work. It requires being able to filter a set of records through two different specifications (the first being department [HR, engineering, shipping, etc] and the second is status [active, inactive, or unknown]). I want it so that WITHIN each department only the records with Active and Unknown are displayed on a value list for populating a related table. I know how to do it for one level, but not two.

• • 
• 2 replies
• 1.2k views

Ponderosa

November 9, 20178 yr

I am trying to make a checklist for tasks that attaches to different records. Ideally I would have a table that keeps track of the tasks but I also need it to connect to each object. So for example, on November 1 , 2017: -Object 102 was washed and wax -Object 103 was dusted -Object 104 was washed with power hose -Object 105 didn’t have any work done to it. All the objects (102-105) are in a table that I'd like to remain static, and acting as a primary key. I’d like to create another table that has a record of what was completed for each day instead of creating a new record for each object and the particular thing that was done for it that day…

• 1 reply
• 2.6k views

doughemi

November 8, 20178 yr

FM 16. I would like to have new field entries automatically be added to the value list for the same field. I tried searching but wasn't able to find any references to this. Apologies if it has been previously addressed and appreciate any advice. Thanks.

• 10 replies
• 3.8k views

scchang

November 6, 20178 yr

For an inventory management database, I'd like my main screen to be able to accept pulls from three related databases: - Serialized (valuable tools, which I track and want back - the paintbrush); - Replenishable (cheap tools that I buy by the yard and if one gets left behind I don't care - the paint-mix sticks); - Perishable (disposable tools that are left on the job site - the paint). These will handle their related requests differently. The serialized I'll be tracking properly to make sure we keep track; the latter two I'm looking for more like a system of 'tick marks' to help me know what we use on job sites. We print our barcodes. For ease of use, …

• 1 reply
• 1.5k views

the Otter

November 6, 20178 yr

Hi, I have a database with +1000 records, each with a long list of long/lat coordinates that need to be reversed to lat/long. The amount of decimal numbers is not fixed, yet every longitude value starts with an opening bracket "[" and is separated from the Lat value by a comma ",". Each coordinate ends with a closing bracket "]," and a carriage return. I guess if it were just one coordinate I could do it with left, middle and right. Hope someone can ease me towards a solution. Best, Daniel

• • 
• 6 replies
• 1.8k views

Quito

November 5, 20178 yr

How can I count the number of rows in a filtered portal? Filtered being the operative word. I can get a count if I don't filter. I've able to solve all my previous problems using the answers on the forum, but I just can't find the answer to this one.

• • 
• 17 replies
• 36.9k views

DanShockley

November 3, 20178 yr

Hi, So i want balance field to be red when it is less that the amount_due and green when it is equal to amount_due. How do i do that? there is a simple calculation in the balance field. I tried conditional formatting both value and formula but didn't work. Thanks.

• • 
• 14 replies
• 2.2k views

Karina_TX

November 1, 20178 yr

I've got 2 tables in an invoicing scheme: a primary table1, and table 2. Table 1 (invoice) shows a portal into which (Table 2) Invoice Item records are created, and which show in a portal field in the current layout (Table1).. On the layout (Table1), i'm showing a summary field (which totals all invoice items in Table2). IT maintains the correct amounts and updates, but does not automatically update every time a change is made in Table 2. Say for example if i change qty or change amount in one of the items in the portal, the summary field doesn't automaticallyupdate in my current layout. in order to force an update, I have to force the window to…

• 1 reply
• 2.1k views

bcooney

October 29, 20178 yr

I have a value list in my Timesheet table that includes all related values in the last 60 days, so that a user can use this as a quick reference of their recent usage instead of looking up codes every time. What I'm trying to do now is sort the value list by a second field (Timesheet::Client_Project_dropdown), which is in itself a calculation of company name and project name fields from related tables. As far as I can tell from error messages, I can't sort the value list by this second field because it can't be indexed, because the calculation is based on related fields. I know I can make these fields text fields with auto-enter calculations, but the…

• 5 replies
• 1.5k views

Courtney

October 26, 20178 yr

I am struggling with something that should be simple, but cannot figure it out. Below are three tables: Contacts, MaterialsTransactions, and MaterialsTransactionLineItems Within a layout showing records from the Contacts table, I created a portal showing records from MaterialsTransactionLineitems (so contacts could see each item and not just each transaction) Layout = Contacts Table; Portal = MaterialsTransactionLineItems The field on the left is MaterialsTransactionLineItems::Transaction_fk; the field on the right is MaterialsTransactions::TransactionDate Given the relationship, why is the date not showing correctly? Instead, just showing f…

• 12 replies
• 2.8k views

bruceR

October 23, 20178 yr

I am trying to build something like a bingo board to act as a visual management tool for my cabinet shop. This bingo board might be printed out on hard paper or could be electronically managed on an iPad. I would like to have the field names show up as a column on the left side of the layout with the field contents displayed in a spreadsheet type format on the right. The image of each cabinet would derive from a repeating container field. The value for each task would derive from scripts that are keyed to each cabinet type. A sink base, for example, would not have any values in the drawer box category but a drawer bank would not show cookie trays. When…

• 2 replies
• 1.5k views

Jarvis

October 21, 20178 yr

I have 19 different organizations with each one having different blood pressure readings. Have figured out how to get the name and number of records found as well as the total number of records in database using both Get(FoundCount) and Get(TotalRecordCount) when I do a search. I can get it to do the first organization and give me the correct data as I can see it matches the found set. What I will it take for me to get it to do this in a report form similar to this: Organization Number of Participants Total Number of Records in the System ABC Org …

• • 
• 8 replies
• 1.5k views

Teks4u

October 17, 20178 yr

hi again, I know is something simple but don't seem to be able to figure it out. Once I setup a button and add a "Optional script parameter", if I want to make a change or double check on the parameter I have to disable the assigned script and reassigned it again. Is there a way to check an existing parameter or make changes to an existing parameter on a button . Thanks JMart

• 2 replies
• 3.9k views

Lee Smith

October 17, 20178 yr

Hello, I am running FM12 Advanced (Windows), and I have a small issue regarding geocoding with Google Maps (simple marker). My FM-database contenins many different location records, and a fuction to call the layout with the Web-viewer and geocode/mark the location on Google Maps. The problem is that although there are coordinates (Lat / Lgn), GoogleMaps does not display the map when the coordinates (Lat / Lgn) are crossed somewhere over sea area, for example, the Atlantic Ocean, Mediterranean sea, and so forth. The problem is best illustrated on the attached demo DB (DEMO_LocalitiesGoogleMap.fmp12) which contains three locality records: 1) United Kingdom, Londo…

• 6 replies
• 2.2k views

asterix

October 16, 20178 yr

I have a layout for printing on a letterhead and have inserted an image file as the Background Image to serve as the letterhead. Printing and Save to PDF work as expected, but for the life of me I cannot get the background image to display correctly in Preview mode. Not displaying correctly in Preview mode is not terrible except, when the client does a print preview and it doesn't line up, there will be questions...even though it print correctly. Basically, it looks like the background image has a pre-determined padding applied to it at the top, but all parts and objects are set to padding 0. Has anyone else experienced this? Preview mode - letterhead…

• 0 replies
• 1.3k views

Bobby Bradley

October 9, 20178 yr

I have a file with 2748 layouts in it. I just completed the table structure design, with a layout for each table, 2782 tables in total (a few did not need representations in the layout structure). I split out my tables into folders. When I go to select a table from one of the folders, it does not navigate to it, but does not freeze, nor does it show an error, it simply behaves as if it is on the layout and continues functioning as if nothing had been done. This File is half ESS tables, half local tables and written in 13.ov3. Anyone have any thoughts on how this might happen and why, seen it even before, and what can be done, I am effectivel…

• • 
• 2 replies
• 1.5k views

LaRetta

October 6, 20178 yr

How to show the record number in a sub-summary layout? It should start at record 1 per group, the parts of the layout are header, sub summary and body, It should look like this Group A 1 John Doe 2 Jane Doe Group B 1 John Doe 2 Jane Doe

• 3 replies
• 3.1k views

rwoods

October 6, 20178 yr

I have a portal within a tab. Each portal row has a button bar. The buttons open popovers associated with the portal row context. If I change the layout of the popover, the associated button bar on the portal often disassociates from the portal row and jumps onto the tab surface. At that point it only shows in one portal row (the first), since it is back one layer. I have had a big problem getting it back where it belongs, sticking to the portal surface. I have dragged it out to a clean non-tab surface, I have tried copy pasting it back into place, moving it up down with the mouse, bringing various surfaces and objects forward and back, etc. Only recrea…

• 0 replies
• 3k views

Michael_

October 6, 20178 yr

Does Filemaker 16 offer the ability to utilize responsive design? Is there anyway to create breakpoints within a database so as to have the displayed layout be appropriate for an iPhone, iPad or desktop device? If this is not possible and I need to create three separate layouts, how does the device know which layout to toggle to? I

• • 
• 3 replies
• 2.7k views

Jarvis

October 5, 20178 yr

Hello, Full disclosure: I am very new to scripting in FM. I am trying to hide an object based on 2 criteria: Leads::IsOnlineProposal = "No" and PatternCount ( $$Permissions ; "ViewOnlineProposal" ) = 0 When the Value for Leads::IsOnlineProposal is "Yes" I wanted my object ( just a big square to hide the customer data on the screen ) to hide everything on the screen. That part works great. But I wanted to give some users permission to still view the customer info ( or continue hiding the object ) when the permission is checked even if the value for Leads::IsOnlineProposal = "Yes". Thus the second part of the hide scripting in the hide section of the in…

• 8 replies
• 4.9k views

Lee Smith

October 4, 20178 yr

I have stumbled upon a strange bug in one of my Databases concerning a value list. We have a table containing part numbers, which is related to a table containing "revisions" for the part numbers, which is related to a table of inspections for the "revisions". On a layout of the Inspections table, I have a value list. This value list selects the UUID of the revision, but displays the Part Number for the user. This has worked perfectly for several months. However, this morning one of my users discovered that he was unable to located "0000194" from this list. At first I thought maybe the UUID's somewhere along the line had become disconnected from their respe…

• • 
• 5 replies
• 1.9k views

LaRetta

October 3, 20178 yr

I have a 4 column report for an invoice: Date, Activity, Time, Charge in that order from left to right. Activity can sometimes be 2 or more lines. I really want the time and charge fields to align horizontally with the last line of the activity field: so if activity is 5 lines long the time and the charge will print on the same line as the 5th line. if activity is only 1 line I want time and charge to print opposite the first line. I cannot get this to work: I have tried each field aligned in bottom, I have grouped and I have locked. Can it be done?

• 5 replies
• 1.5k views

MikeKD

October 2, 20178 yr

Hello I have two related db which returns a proper result in a portal I created As the records involved are many how to write a script to only find the populated records and then export them to a tab file for additional work? Thanks and Regards Dan

• 6 replies
• 2.1k views

LaRetta

September 28, 20178 yr

I´m not sure why but the WV shows the correct result in some computers and devices, but in other just shows an empty page (please see attached file with WV including code). This is the result after testings: - It doesn't work on my Mac (10.11.06) - It works on my iPhone - It works on my iPad - I works on one of my colleague´s Mac (10.12 I believe) - It doesn't work on another collegue's Windows I have attached the file with the wv, is this working for you? any clue why this is happening? any help would be very much appreciated!! WV_Table.fmp12

• 0 replies
• 1.4k views

TJ53

September 27, 20178 yr

Hello All, I'am wondering the best way I would go about making a custom report. I have a table with results for around 30 different tests. I would like to make a report that could allow users to customise what results are included for example Test 1 - Result Test 2 - Result Test 4 - Result Test 12 - Result Test 14 - Result Would this be best done by using a sub summary when sorted by or is they a better way? Jon

• 0 replies
• 856 views

jon1009

September 23, 20178 yr

I have a portal within my main layout that I use for all phone log comments and documents. Is there an example or a (best practice) way to create a search field that searches within that portal only and shows the correct records searched?

• 1 reply
• 3.2k views

Steve Martino

September 23, 20178 yr

Does anyone know if this is supported in filemaker go or support soon to come? It would completely change my business if this were possible. Thanks

• 0 replies
• 1.8k views

wattmhite

September 22, 20178 yr

Hi there. I have a list view layout that gets saved to PDF and print. On my computer everything looks good. However, on clients computer, the right side is cut off. I have the margin view showing and everything seems to be within the lines. I am using windows and client on Apple.

• 1 reply
• 2k views

Lee Smith

September 22, 20178 yr

L&G, I have read the guidelines for posts in this forum. Therefore I did not enter the Post title that came first in mind: Do I understand portals (aka do I understand Filemaker) and I do not emphasize now on being new in Filemaker issues. I am trying to achieve something simple at a first step of a big plan: Entering recipes in a Filemaker testversion database. The longterm goal should be a database in which I can enter my collected recipes. Followed by tool for a weekly menu plan for my family and a shopping list coming out of the database after taking care of my fridge's stock => so far so good, but currently this is a plan for the next ten …

• 8 replies
• 3.8k views

bruceR

September 19, 20178 yr

Hello, Noobs here. I am looking for some assistance that when I select a record on a form I am taken to that record. Example below. I am taking this simplified hypothetical example in the parts table with columns: Finished, Shared1, Shared2, Shared3 Row 1 values: A, B, C, D Row 2 values: B, A, C, D When Row 1 loads in the layout you sent, say that A appears on the upper right box. Therefore B,C, D load in the bottom in red Desired behavior: when B is then clicked, you want it to replace A in the upper right box and have A, C, D appear in the bottom in red. Thanks in advance, Brett

• 4 replies
• 1.4k views

bmarcowka

September 14, 20178 yr

Hello, I would like to ask question for which I didn't find answer. I have several filemaker dbs which differs only by data entered. All tables and fields are same. My question is if it's somehow possible share layout design across all those databases because occasionally I need to modify that layout. Change it in all dbs could be time consuming. Of course I can have empty "design db" where I could re-import data after layout change but again it could be time consuming too. Also I'm wondering if is possible to use field name (in layout) without any table name and table would be used relative by table defined in layout? (Shows records from) Thank you

• • 
• 7 replies
• 2.5k views

AlesD

September 14, 20178 yr

I tried looking in the forum but couldn't find anything similar. I'm having a hard time with creating a value list from a many to many relationship, this is the diagram. The goal is to have 2 drop down lists, ddl 1) shows all of the companies ddl 2) shows the programs that are related to the company selected I'm not sure how to create the conditional value list, do I have to create a table occurrence? if so, of what table? This is what the ProgramCompany table looks like Thank you guys for your time, you're awesome

• • 
• 12 replies
• 2.2k views

muskee

September 13, 20178 yr

Our current system organizes employees into Teams, and those Teams into Groups. Reports can then be run that display employee time with a sub-summary part for Group and one for Team to give a big picture into performance (see attached image example). New management wants to split SOME but not all of those Teams into smaller functional areas. I'm trying to figure out what kind of layout and calculation gymnastics I'll need to do to display something like the example, but to add a third layer - only where a third layer exists. So it might look something like this: All Clinical Affairs Clinical Affairs Consulting Writing Clinic…

• 4 replies
• 1.3k views

kingzcq

September 13, 20178 yr

I have table with list of addresses. I need simple way to show, visually how they are clustered geographically - ideally one map location "Dot" for each address. Any suggestions - would like to display result on demand in a web viewer

• 1 reply
• 1.9k views

Steve Martino

September 12, 20178 yr

Hello I am experiencing a strange issue with custom menu and CTRL+F keyboard shortcut when changing keyboard layout to albanian. The custom menu is basically a copy of the default menu with some items left out, not the view mode though. But when I press CTRL+F nothing happens. If instead I go to the view menu and click on find mode it switches to it and I can see the CTRL+F shortcut on the side of the menu. Also, if I first go to layout mode by pressing CTRL+L then it works by pressing CTRL+F but will not work back again. If instead I switch to the default menu, all works fine. Issue is verified on two PC, both with Windows 7 and FM11

• 0 replies
• 4.8k views

Toni

September 12, 20178 yr

Hi Folks, I can't quite get my head around this one.. I have a portal that contains basic info about pieces of music. Each piece is either a work or a movement. (pieces are either self contained or consist of movements). I'm using 2 globals and 1 local field to filter down the list of pieces: 1. Composer 2. Title 3. Work ID This works almost as I'd like: ( ( IsEmpty ( Resources::gSearchPieceTitle ) or PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle ) ) and ( IsEmpty ( Resources::gSearchPieceComposer ) or PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect )…

• 2 replies
• 1.6k views

MikeKD

September 6, 20178 yr

Hi...Please Help! I am designing a database for out maintenance guys. I have a table called "Machines", this contains all the machines we have with serial details etc, I then have another table called "Service Info", these are linked with a primary key called MachineID. On my machines form layout is a portal that shows all the services for that particular machine. I want to create a script that adds a service file for that particular machine and copies over the last service date, how ever what I tried doesnt work because it take the last record within the whole of the service info table and uses that, in otherwords it copying another machines service date. This is th…

• 2 replies
• 1.2k views

cheerfulzebra

September 6, 20178 yr

I have a portal with more values than fit on the screen. I scroll to a value and select it. If I leave the layout and return, the portal does not automatically return to the active row. I would like the portal to scroll and make the active row visible when I return to the layout. I've tried using Get(ActivePortalRowNumber) but can't get it to work. Is there a way to do this?

• 8 replies
• 2.6k views

bruceR

September 5, 20178 yr

I currently have a portal that I am filtering with 3 different global fields, all work fine. I would like to add a field to filter by a months block from current date. There is a sale date column in the form of 8/29/2017. The date drop down filter field would have the following entries. The filter will be referenced to the current date. If "3-6 mos" were selected only records in Dec 2017, Jan 2018 and Feb 2018 would show ( 3, 4 and 5 months from today's month). This would be the drop down. All Dates < 0 mos 0-1 mo 0-3 mos 3-6 mos 6-9 mos 9-12 mos >12 mos This is what I currently have with the date filtering, using a custom func…

• 5 replies
• 1.9k views

comment

September 5, 20178 yr

I'm scratching my brain raw as to why this is happening: same layout setup, settings are the same in the layotu setup, same (defunct) Electric theme; on a Mac, FMPA v16. Image 1 (from Layout "A") After clicking a button that fires the Adjust Window (Resize to fit), it sizes the window correctly. Image 2 (from Layout "B") After clicking a similar button. Notice the bottom-right corner. Image 3 (from Layout "B") I stretched it the window to the bottom-right so you can see it's the same as in Image 1. What could cause this to happen? There aren't any objects in the layouts so...?

• 0 replies
• 1.2k views

Rich S

September 4, 20178 yr

FM 15 Adv. When I click on a drop-down list it selects the whole value making it difficult to edit the value. I have to click 4 or 5 times before the selection disappears so I can edit the value. The drop-down reads values from a field and is not configured to select the entire contents on entry. Is there a way to stop this? I would prefer to just click and have the insertion point appear where I click.

• 0 replies
• 1.3k views

john9210

September 1, 20178 yr

This is a stylistic issue: I have a calculation field (text) that displays a three-line address: Street Address City / ST / ZIP Country The field is clickable so when the user clicks on it, it copies the entire address into the clipboard so it can be pasted in a non-FileMaker Pro form on-screen. To save vertical space in the layout, I want to display only the last line of that field that shows Country, but no matter how much I play with the controls in the Inspector--and adjust the field's height--I just can't get it to work. Is this do-able or no? TIA for your help!

• • 
• 3 replies
• 1.3k views

comment

August 29, 20178 yr

Is it possible to filter a portal based on another filtered portal content where a relationship exists. My question stems from a scenario where I have a jobs table and a plant (being machinery) table. I am trying to figure out a way to filter a complete list of plant to only show those that are not allocated to a specific day on the job table. I guess I am just seeing if it is at all possible or is there a better method to do it.

• 20 replies
• 2.4k views

Peter Barfield

August 26, 20178 yr

I'm a novice, and would love some help. In the attached file, I have portals for notes and documents in an applicant's record. The button above the portal creates a new document record in the new document layout, and I have a 'save' or return button to return to that applicant's record. A button over the portal row takes you to the related record of a document . the button is set to be invisible when the document primary key is empty A delete button in the portal row deletes that portal row. The problem is that when I delete a record the button remains (in an empty row) - when it is pressed, it takes you to an empty record, and then the back buttn does…

• 6 replies
• 1.5k views

Lee Smith

August 24, 20178 yr

So I am very close to getting my modal custom dialog windows to work with the new window card feature that was introduced in FileMaker 16. I have a script in my database that allows users to type in a list and the script parses out the information and finds the appropriate records in my database. When a record isn't present, a custom dialog pops up and notifies the user that the record is not present in the database. The script works flawlessly with the old show custom dialog and will cycle through every record that is not present...popping up a custom dialog for each one. However, using the new window card feature...it is only popping up the first record that is not …

• 0 replies
• 6.3k views

jl2017

August 23, 20178 yr

is it possible to size a layout that matches the exact size of an object/container for export purposes (say 468x60 pixels) I'm wanting to do some graphic style layouts. Printing them limits you to the inherent dimensions available on your printer, but exporting them as PDF and then editing them further there is a distinct option. ANd I am more interested in keeping them in teh digital realm than in printing them to paper. Any way to export the results in the desired size?

• 1 reply
• 1.2k views

comment

August 22, 20178 yr

Hey everyone, I love how open the Filemaker Community is, and how much is shared freely, so I wanted to contribute. I created a database to manage SVG icons. The icons are all royalty free provided by Syncfusion and there are about 4,000 icons, all with search tags to make finding them super easy. You can find out more about the file, and download it here: http://www.indats.com/2015/06/15/indats-icon-manager/ Please let me know any feedback you have on the file, thanks!

• • 
• 41 replies
• 24.8k views

Claus Lavendt

August 21, 20178 yr

FMP 15 Adv. I am having a lot of trouble working with Popovers, placing objects in Popovers and formatting Popovers. When I move an object into a layout, I can’t resize the popover to fit around the object. Sometimes the object disappears and bring to front does not bring it back. Also, focus on the popover is always turning off and re-seleting it is very difficult. You can’t just click on it. I have to repreatedly keep clicking. Any suggestions or good references?

• 5 replies
• 3.2k views

Lee Smith

August 21, 20178 yr

Hi guys Hoping for some intellectual input from those more experienced than I. I am trying to create a "portable tick box" By this I mean a script that I can attach to any field to make it a tick box So far I have created a number field and set it to display all non zero values as a tick. I have then attached a scriptrigger which runs a script on entering the field The script is as follows: Set Field by Name [Get (ActiveFieldTableName)& ::" & get (ActiveFieldName);Abs (Get (ActiveFieldName)& "::" & get (ActiveFieldName)-1)] This way if the field is empty it will be set to 1 and if it isn't it will be set to zero. …

• 8 replies
• 3.5k views

eyedoctor

August 20, 20178 yr

i have Problem when I use OnLayoutKeyStroke. I use Barcode Scanner so I use OnLayoutKeyStroke But I have Ploblem about to click or type other field it's jump to Field Codebot( field for Script Barcode Scanner ) Plaese Help me to type or click other Field

• 4 replies
• 1.4k views

Wim Decorte

August 19, 20178 yr

Hi, A customer needed to "List" only if the item was "Different", if more than the same item, the customer only wanted to see it "Once". As I pushed the value list to his field, I noticed that it was not in the correct order. Is there any way to list within a value list "creation order", the value list organizes itself either alphabetically / numerically. I need creation order ( M43, C167, S26, G6789 etc ... ), suggestions ? Thank you. I tried ordering within the "Value's" relationship by my "Creation DateTime Stamp" but the value list still ordered incorrectly ... The value list needs to organized this way ... creation order; …

• 12 replies
• 2k views

"... you mean these fans?"

August 19, 20178 yr

I'm trying to do something that is turning out to be much more difficult than I thought. I want to produce posters for series of workshops, one poster for each series. I have accomplished this in the past using Mail Merge in Word. To simplify somewhat: In FileMaker, I have a script that creates an Excel file, one row per poster. The data gets pasted automatically into fields in the appropriate Word file, and I can produce PDFs from there. Different types of series need their own word file, but there is a manageable number of possibilities. I am attaching examples of two typical posters. Here's the problem I seem to be having in arriving at a solution that occurs…

• 21 replies
• 1.9k views

jjjjp

August 16, 20178 yr

I have a product catalog solution [Database A] that consists of a "master" record and several related records through a parent-child relationship. A separate solution [Database B] tracks shipping/receiving of these products. I would like to create daily records in this separate solution (B), and copy information via a related field with the catalog (A). **Easily done via lookup or auto entry calculation.** In addition, I would like "replicate" the related records, via the parent-child relationship, so that the shipping/receiving solution has the same related records as the product catalog solution. In other words: MasterRecord1 --> ChildRecord1 …

• 2 replies
• 1.1k views

Lee Smith

August 16, 20178 yr

Well... I spent about two weeks of trial and error getting my DB to provide conditional value lists as I wished, since I couldn't post the DB online. After using the DB for a week (mostly flawlessly), my conditional value lists didn't end up working. Being frustrated after beating my head against the wall for so long, I researched (more) about this ability, and have come to the conclusion that either 1) I have issues translating simple two table examples to my more complex example, 2) I'm missing something fundamental, 3) my structure isn't conducive to my goals, or 4) I have issue with creating the value lists from the proper sources (which is easy to do, considering the…

• • 
• 5 replies
• 1.8k views

vwgtiturbo

August 11, 20178 yr

Hi All, In the attached file in BD Demo, in layout Prospects All and Tab *Prospects All*. I have tried to follow an existing script, so when you you applied a *Filter* you can then click on the Side Button which should then take you to the next Tab, which will present the information based on that entry, in the respective tags. This is at present a Demo I am trying to work up, the data is at present all messed up as the people compiling the data screwed up filtering / sorting in Excel. I can get all other scripts to work except this one. Would appreciate some help in where I have gone wrong, so I can learn, I have searched on the web but cant fine any examp…

• 3 replies
• 3.4k views

Kevin Pledger

August 7, 20178 yr