FileMaker Interface Features
-
Hello all, I am working on a project where the client has requested what is essentially an index of items and their statuses. Here's a screenshot of the idea: The black row is the overall category (there are 4 total in the real world) The light colored rows are the items within categories (there are variable numbers of these in the real world) The white rows are individual components of the light colored rows (there are variable numbers of these in the real world) Initially, I thought a subsummary report might work, but I don't know how to handle the white rows since they contain different fields/information. I think those rows would be the "body" pa…
-
- 2 replies
- 1.1k views
-
-
Hello, thank you for your help. I'm new to FileMaker, after only recently learning Excel, so please bear with me. I'm working on building a database for my eBay inventory (many different items), which I will be uploading to eBay's bulk uploading system called File Exchange in .csv format. I'm pretty far along, but I'm stumped on this issue I'm having... Many of the categories that eBay offers allows sellers to upload ads using a 'standard format' template of feilds that determine the content of the published ad. However, some categories, such as clothing, CDs, and DVDs, require 'category-specific' templates, which have added fields that examine specific details o…
-
- 11 replies
- 2k views
-
-
I have an almost completed solution where I started with the "Classic Theme", but have customized every field, portal, button, etc. Everything is a local style, and I would like to now convert my work into a new theme. I started on one layout, and it was very straightforward to select objects, select and save them as a new style, and then save the "Classic Theme" as a new "Custom Theme." So far, so good. However, when I go to another layout, I don't seem to be able to add to the "Custom Theme" I'm building. I can do the same thing where I save new styles, but the current theme for this second layout is, of course, still the "Classic Theme." My only choice seems to be to s…
-
-
- 2 replies
- 1.6k views
-
-
Dear FileMaker professionals. I have a question regarding selection one field from a table depending on another field. I have a layout like this: |Room # |v| |Name |v| |BUTTON| It is the entrance form. So i entering a room# and name. All data goes to my table. So in my table i have two fileds: 1)Room number 2)Name of person i would like to use the same layout for choosing person linked to a room number. If i choose Room number 2, in the next field (with drop down menu) i can choose persons who live in this room#2. And next to the second field i have a button that opens a layout with person's details. Do i need to write a script? If …
-
- 0 replies
- 774 views
-
-
So here’s what I have, simple: Three tables the second on being the child of the first, and the third that of the second, Ids (pk), fks, and a couple of dummy fields. (The real life scenario I try to emulate is clients having a child of departments and that a child for employees) One layout from the first table with a portal to the second, and a nested portal there of the third. The portal doesn’t stay put but floats above. What am I missing out? b. I ve taken a turn to an approach of using value lists created on the spot, I ‘ve not taken it more than 50% in development, and it seems rather convoluted from what I am trying to do. That is have a nested…
-
-
- 1 reply
- 1.4k views
-
-
Hi There, Â I am totally new to Filemaker but have a bit of experience making Access databases, My issue is as follows; Â I have two tables Subscriptions & Family Members, one ambulance subscription can have many family members covered. Â I have created a subscription layout with a portal to the family members in it, what I am trying to do is using a button popover add a new family member to the subscription. Â however when I add the popover and all the related fields inside it and create a button to add a new record, it first shows the family members already entered and when I click the add new record it adds a new subscription not a new family members. …
-
- 2 replies
- 1.7k views
-
-
Greets all:  Brain hernia of the month: What I'm trying to do is create a value list from chosen names in a portal so I can use it in a calculation later for a text field and I'm stuck. (Please refer to the attached.)  I have a table connection between RESUME and CONTACT; of concern in the CONTACT table are the fields, Name and ShowInResume. The portal (in RESUME)  has the filter enabled so it only shows the names within it that have the checkbox in ShowInResume ticked (with an "x"). So far, so good.  What I want to do is place another checkbox to the left of each name so the user can choose which name(s) he or she wants to use as a reference in a résumé. S…
-
- 1 reply
- 1.2k views
-
-
This is a sort of off topic, a bit, post and thread. I just listened to Lee and Andy's podcast about splash screens, and creator's rights, but it's more about the splash screen's that I ll tie this is in with what I replicated in my solution as a splash screen. Inspired by the what's new screens in ios and iwork in particular I created a table with version updates. So here's how it goes: Basically I replicate what Ive's done with pages, a simple gradient screen with a nice eye cathing pallete, a set of simple icons, and the "what's new" features in a lean nice looking font. I love this style, it's so simple and concentrated. Now I have a table, that I use for user…
-
-
- 7 replies
- 1.8k views
-
-
I have a table called Services I have another table called Versions. This table services has a portal into the Version table and shows all software versions associated to a given service. So for example if I am on Service A the portal window shows all Versions of software that are part of that service. I have conditional formatting setup so that a version row is out of date in more than a year it is filled in green If it is out of date in less that 6 months it is filled in Amber. If it is already out of date it is filled in Red. It looks at the support date field and compares it to the system date and colors it accordingly. Some services show lots of…
-
- 1 reply
- 934 views
-
-
Hi , I have a report layout. Â In preview mode the "Save As Excel" Option is working fine. But when through script I pause the script in preview mode "Save As Excel" option is greyed out , but "Save As PDF" is working fine. Â Menu set is Standard Filemaker Menus. Â Please suggest if there is any solutions to make this work in preview mode with pause script .
-
- 9 replies
- 5.2k views
-
-
I have a home screen which contains 11 buttons. The top button is visible to all. The top 7 buttons are visible to those users in a Priviledge Set called 'Office_Admin' All 11 buttons are visible to those users in a Priviledge Set called 'Sys_Admin' Can anyone please help me understand the logic for the 'Hide object when' property for each set of controls based on the user's priviledge set? Thanks Martin
-
- 7 replies
- 2k views
-
-
I've done this loads of times but for some reason the fields on the CPD Report and CV Report layouts (attached) won't slide up in preview mode. I think I've done the obvious but obviously something isn't right. Also wonder why the page counter in the footer isn't displaying Page 1 | 2, Page 2 | 2, but instead Page 1 | 1, Page 2 | 2. I'm actually just getting into using FM on a macbook after a long while on Windows, but this may be a feeble excuse. Thanks in advance. CV & CPD.fp7.zip
-
- 4 replies
- 1.7k views
-
-
I am looking for a way to avoid the user to close a popup without clicking a button in the popover (thereby running a script) so I can use the popover for data entry. My searching capabilities seem a bit lacking today, as I couldn't find any previous discussions on this topic. I've come up with a solution, but I thought I'd check here and see if anyone had any input or a better way to do this. My solution: I created a script "Abort Click-out" The script is simply: If [ Get ( ScriptParameter ) = ""] Exit Script [Result: False] End If Then, in the popover, I do a script trigger of: OnObjectExit: Abort Click-out; Parameter: Get(ScriptName) In this way,…
-
- 1 reply
- 6.3k views
-
-
Dear Filemaker Wizards: I have a filemaker pro 13 database containing data(Names, project completed, etc.) where we print completion certificates for our study program. In this database, there is a button that when pressed,opens a layout(certificate) that can be printed. Unfortunately, this opened layout covers the entire database screen and this is an inconvienence when we have to go back and search for another person. Is there a way that when a button is pressed, this certificate opens in a new window and can be printed? Thank you all very much, Dee
-
- 2 replies
- 1.2k views
-
-
Hi, Would like to use a custom google search engine, such as: https://www.google.com/cse/publicurl?cx=000620537607643025006:pi1r2a4z-2e in Filemaker. Can't get a field/search term to show up in the search engine./webviewer. Thx. David
-
- 2 replies
- 2.4k views
-
-
Simple set up, portal on top, a button under, OnObjectKeystroke trigger, got to object(the name of the portal) go to portal row last. Not working. Alternatively, button set up, go to portal, goes to another portal in another tab... Can anyone shed some light here?
-
-
- 8 replies
- 4k views
-
-
Ok, I have a portal issue. Objective: Portal layout I am using has space limitations so I want to be able to click a button and expand the picture in a portal out to a full screen view. When I use a script to open a new window (from inside portal)to enlarge a picture it goes to the 1st record every time and not the related record. I can then manually scroll through the records to the correct one... I have Table A: Primary Data Table ------------>Layout #1 Table B: Display Table with Portals.---->Layout #2 Enlarged view------------------------->Layout #3 My script is: Allow User Abort [Off] New Window [Name: …
-
- 1 reply
- 1k views
-
-
Hi I have a table with standard comments in icelandic and english, named standard comments. I use the field comments::standard comments in icelandic as a checkbox set in a form in a sample table. When the user checks one or more values the field sample comments in icelandic updates. If I uncheck value the sample comments in icelandic updates. I also have a field which is comments in english and is a looked up value based on a relationship between comments::standard comments in icelandic and sample::standard comments in icelandic. When I check one or more values in sample::standard comments the field sample::comments updates but when I check one sample in sampl…
-
- 1 reply
- 1.3k views
-
-
I have a simple report that lists Faculty by their Credential (Doctorate, Masters, Degree, etc) The goal is to have a list, by name, of all faculty that have a specific credential. The list is Counted as well. The problem is that many faculty have more than one credential of the same type (eg. two Degrees). I want to see the description of the credential (so I know what it is for) and a count of faculty that have it. What I have lists all the faculty with that credential and it shows multiple credentials for those that have them but I can not get an accurate count of the number of faculty. What I get is a count of the Credentials. The tables involved are: (abbrev…
-
- 3 replies
- 1k views
-
-
Hi all, Not sure if this is the right place to ask, but here goes… I have a field, control style = Edit box, with Auto-complete using existing values checked. Is there a way to reverse the order the Auto-complete suggestions show up? It shows a–z, I'd like it to show z-a. Thanks.
-
- 0 replies
- 884 views
-
-
Hi All, I have used FileMaker for YEARS but only for very simple projects (mailing lists, etc.) I'm on version 12 now and we want to container fields for a project. For instance, we'd like to have a file saved alongside each record so the file and the info/status/etc. are never disconnected. We would be exporting these files using scripts at some point in the project. Question: I keep reading nightmare stories about data loss and corruption when using container fields. Are they actually dangerous to use? I want to be clear: these projects would be short-term. A few months of use, maximum. We could close & back up the filemaker project each evening. We …
-
- 4 replies
- 1.7k views
-
-
Just verifying that only "number, date, and time data " get carried over. The reason for this is that fm's documentation is, imho, confusing: " If necessary, select Apply current layout’s data formatting to exported data to format field data as it appears on the current layout. FileMaker Pro allows you to format fields on a layout, which makes the data look different on the layout than how it is actually stored in the database file. (For more information, see Formatting and setting up field objects in Layout mode.) Select Apply current layout’s data formatting to exported data when you want to export number, date, and time data using the field …
-
- 1 reply
- 958 views
-
-
I have been trying to find an answer to my problem for ages and have had some really good help on the Filemaker.com forum, but I am hoping i might find a different answer here, that is more in tune with what i want to achieve! I need to create a database that generates and stores information about tv commercials that i make. The most crucial thing i need to do is generate new "clock numbers" for each ad. This is a unique 15 digit code in the format ABC/DEFG123/020 - ABC = ad agency code, DEFG = product identifier, 123 = serial number between 001-999, 020 = the ads duration in seconds. I have figured out how to generate a new code for each new record, and its been …
-
- 8 replies
- 2.4k views
-
-
I am having a really hard time implementing active row and alternate row state colours in fmp in table view. I ‘ve read quite a bit on it, documentation, blogs, threads here etc. (whatever there is to read, which of course isn’t much), but I am not having much lack. I am getting the basics right setting colors via the insperctor for primary, active and alternate and then I select one option for my body, either one, so far so good… then nothing works at best I get one coloured line at the end and the rest of the layout in table view where there is not text is coloured. I read somewhere that transparency might be an issue, I am not sure I ‘ve figured this out, but I ‘ve…
-
- 0 replies
- 1.2k views
-
-
Ok I thought this was simple and I might be making it harder then what it seems , I have searched the web and the forums and I guess I just don't get it So I have a value list driven by a related table I want to search against that value list and if the field matches anything in the value list I want it to give me a 1 if no match don't do anything I've tried the filter values , value lists etc functions but to no avail its always a 1 no matter if it matches or not So Field = LAt Value list = LAT_List I thought is would be as simple as If LAt = (Any Value inside the list LAT_List) Then show 1 If LAT (Does not equal Any Value inside the list LAT_List…
-
- 23 replies
- 2.3k views
-
-
I have a slide control and I'm trying to recreate the button effect of the starter solution Contacts. In that solution, the buttons Business Address and Personal Address when clicked (go to objects) either slide 1 or slide 2. I got this working great, but I'm trying to have 1 button fade/change when 1 object/slide is selected and vice versa. It wasn't really clear to me how to do this, I looked at conditional formatting, etc, not sure what to do. Any ideas?
-
- 1 reply
- 1.4k views
-
-
I'm trying to find a way to create a field with a value range of 100-200 (that's the easy part) and I want to use a sliding volume-control type method for the user so they can click on the slider knob or button and drag the slider either left or right to pick the value. I'd like for the user to still be able to enter the value manually as well. FMPro 13's slider doesn't do what I need, so I'm looking for a slider type button or such. Any suggestions or plugin ideas are appreciated. Thanks. I'm using FMP 13 advanced. ~Rich
-
- 1 reply
- 3.1k views
-
-
I have a database of Donors I have created a “Dashboard” type view that I would like to add some portals to display useful information on the “Front Page” of the database. For instance, birthdays of donors, Annual donors “month-before donation due” reminder, and “Late” donors, to name a few. To accomplish this, I’ve created Table Occurrences for the desired Table::field and created a relationship to a global Dashboard::MatchField to create this “query relationship”. I’ve successfully accomplished this for the birthdays and “month-before” reminder listed above. Where I ran into trouble was with “Late” Donors. The field that I’m attempting to create the “query relation…
-
- 2 replies
- 1.1k views
-
-
I want to add a large text field where one can write notes, comments ... Because of the limited space, I added a new button "comments" to this object that looks like a tabs but isn't (I think). I'm using the default invoice starter solution in Filemaker 13. This already included the "invoice address" (left) and "shipping address" (right). Here's the situation I currently have: I added the button to the first view, but when I click the second button I probably need to add it here too? Obviously I need to add some sort of new object and name it "Comments". I've configured the button settings to go to object "comments", just like the invoice address and sh…
-
- 2 replies
- 1k views
-
-
I created a VAT field. Now I would like to use conditional formatting when I enter a VAT number. I want it to make the color of the text green if the VAT number exists, and make it red if the VAT number doesn't exist/wrong number. To do this, I can use a calculation together with conditional formatting. However I need to send a request to an api and catch the response. Let's say it returns "1" if the VAT number was found, and a "0" if the VAT number can't be identified. Then it will be easy to handle it in the calculation. How can I talk to an API and let the conditional formatting behave according to the response? EDIT: Found it I think. I have an API that out…
-
- 0 replies
- 1.2k views
-
-
I am trying to replace the use of a repeating field with a child table. A number of years ago I thought I saw a method that would allow you to display portal data horizontally, but I can't seem to find it again. What I thought I remembered was you could have four different portals all from the same child table, each with the same field, but each one would display the values from a different child record. So the first one on the left would show the data from the first child record, the second portal would show data from the second child. I am on a Mac using FMPA 13. hoz_portal.fmp12.zip Thanks in advance for any ideas.
-
- 4 replies
- 1.3k views
-
-
Just started experimenting with the Troi dialog plugin, which allows for specifying the position of dialog boxes. I'm trying to decide whether the user experience is better when a) dialog boxes show up in the same position in relationship to the filemaker window, so that if the user moves the main filemaker window future dialog boxes also move accordingly, or dialog boxes show up in the same position in relationship to the computer screen regardless of where the filemaker window is. Filemaker's own dialog boxes follow the latter method, but the former makes sense, especially on larger screens. I'm curious if anyone has any experience with, or an opinion on, this. Tha…
-
- 4 replies
- 1.7k views
-
-
I have a database with just under a couple of dozen fields within each record. In its current form, only four fields are included in the Tab Order--about a third of the fields are calculated or otherwise don't use keyboard entry so I wouldn't tab to them anyway, and the rest are only used in particular instances. However, there are another three fields that I do enter text into with some regularity; when I do so, it's usually in all three. What I'd like to be able to do is to have two independent sets of Tab Orders--that is, if I'm editing any of the four fields that currently have a Tab Order set, then tabbing switches between the four. If, however, I click i…
-
-
- 5 replies
- 1.5k views
-
-
Hello Board, Is there a way i can open 3 new windows (for example) and script them to different monitors? If I had a 3 head card with 3 monitors, can I put one window in each and build a video wall with timed scripts changing content? I have opened new windows and placed them at positions on a screen, at a certain size. Is this the only way to try something like this? If my desktop is one across the monitors, i could just place them where i need their corners and size to suit. What does everyone think? H
-
- 7 replies
- 946 views
-
-
Hello Board! I am trying to hide a button in a List Layout view. I have two tables connected together. The first table puts a record in the second table through a script attached to the record button. I have this setup as a conditional format, that changes the colour of some text: Count (Job_Logging_Job_Scanning_Terminal::Combined_WO_JobID )≥ 1 So, if a record has already been made, then the text goes Red. I have tried using the same code in the button 'Hide Object When' part, but it does not work. I cannot figure this out at all. What am i doing wrong? The text that can be conditionally formatted is part of the same table, part of the same rec…
-
- 2 replies
- 991 views
-
-
I've got to believe I'm just having a brief episode of "stupid" and I'm just over thinking this... I'm essentially trying to create a portal of summaries of items that appear in another portal. Here's the plan... I have a table with individual expense items. I then I have table used for invoicing the expensed items. The data is sorted by date and customer and category creating an invoice with the total amounts. There are several items on each invoice of the same category (i.e. meals & entertainment, or car rental or hotel). A simplified list of expenses on the invoice might look like this.. 04/01/14 Hotel $250 04/20/14 Car $63 04/02/14 M…
-
- 2 replies
- 1.7k views
-
-
We're just in the process of upgrading to FM 12, and I have 12 Advanced on my machine for testing. I'm making some cosmetic updates to some of our files, and trying to line up and center multiple objects within the layouts. In FM 11, if I selected multiple objects, the "inspector" tool would show me the position and size of the objects as a set (i.e., the right edge of the right-most object selected and the left edge of the left-most object selected). In FM 12, when I select mutiple objects, the "Position" dimensions just zero out and the "Size" dimensions just don't change. Is there an option or a way to easily check the dimensions of a group of objects like this? (As a …
-
- 2 replies
- 948 views
-
-
I have a invoice layout that only has room for 10 portal rows. I'd like the last portal row to show something like "X addition items" if there are more than 10 items in the portal. If someone could point me to some examples of how this might be done, it would be very helpful. Thanks.
-
-
- 4 replies
- 1.7k views
-
-
image attached I have 2 Select windows showing I am in the SELECT Main, I want to test making certain the SELECT mc_RemoteAgent window is was closed.. ..which means operator logged out correctly, mc_RemoteAgent app properly by using the Exit button.. if not I need to log operator out script, before proceeding to close MAIN TIA
-
- 4 replies
- 937 views
-
-
Hi i would like to add image from container field to webviewer using <img> tag. My image is present in my local disk. i used reference of image but it is not showing image. it is just showing cross mark.. Kindly reply. Thanks in advance.
-
- 2 replies
- 3.2k views
-
-
I have a table titled Matters and a second table titled Notes that relate to the individual matters. I have created a portal in Matters that displays an abbreviated version of the notes that looks somewhat like the the individual email list in Mac Mail. I would like to be able to select a individual note in the portal that then displays the complete contents of the note in a "note content" box next to the portal - similar to what happens when you select the individual email. If you put a field in the "note content" box it displays the content of the most recent related record. I'm thinking that the result I want could be scripted with a button over the portal row tha…
-
- 13 replies
- 1.9k views
-
-
Hi All, Â I have a report that shows a bunch of detail records in the body, and in the "Leading Grand Summary", it displays a Notes field from the header table that the detail records are related to. Â My customer asked me to move that Notes field to the end of the report. Seemed simple enough. Unfortunately, that field is blank if it is in the Trailing Grand Summary, the Footer or the Title Footer. Is there any reason for this behavior and is there any way to fix it? Â (I have included screenshots of where this field is currently when it works) Â Thank you, Ryan Â
-
-
- 3 replies
- 2k views
-
-
Hey, I have the following tables: sidebar_items ------------- id listable_id listable_type pages_pages ----------- id events_events -------------- id Now in my sidebar_items portal I want to display data from both the pages_pages table and events_events based on the listable_type. So if listable_type is page I want it to grab data from the page_pages table and if listable_type is events it needs to display data from events_events. hope anyone can help me!
-
-
- 1 reply
- 734 views
-
-
I got a request by some people wanting other versions, so is anyone else interested in a special "dotfmp Edition" of those? http://www.herrfriedrich.com/lang-en/goodies Just drop us a note with the color (CMYK) you prefer!
-
- 0 replies
- 1.3k views
-
-
Hi all. Been lurking for a few months and have learned a lot--thanks! I am trying to use a script to set a webviewer in FM 11 on both a mac and a PC to send some info to a google form using the info from this page: http://justingale.com/2013/09/url-tricks-for-google-forms-pre-populate-and-automatically-submitting-responses/ The url being sent to the webviewer looks just like example 4 on this link. This needs to be scripted because the user will likely submit multiple google form URLs in one go (this is working with a Loop in the script). I have the script set up to gather the relevant fields and properly create the form URL. When I run the script on my P…
-
- 1 reply
- 1.6k views
-
-
I currently use the Layoutname function to create a list of layouts that I have in a file used for spreadsheets only. This list works great as it allows the user to click on the layout name from the list that they would like to view and the script merely takes them there. Now that the list has grown to a large list, I would really like to be able to filter this list down by one mechanism or another. I have tried limiting the list by the Table that it is associated with but have had no luck. Does anyone have any idea's with this thanks in advance...Chad
-
-
- 11 replies
- 1.6k views
-
-
I'm trying to create a sub summary report to track trends in Customer Satisfaction Surveys.  As Surveys are received, each is given a classification as Promoter, Passive or Detractor. A calculation field based on a Summary field calculates a "Net Promoter Score" by subtracting the % of Detractors from % of Promoters.  A report summarizes the results by month but it restarts the calculation with each change in the break field c_Survey_YYYY_Mo.  I would like each new month to show the result for the current month and all previous months.   A screenshot showing part of this report is attached.  All of the data to do this should come from a single fil…
-
- 5 replies
- 1.8k views
-
-
I have a database that contains a client table, a journey table and a destination table. From these tables I need to create a list of clients that go on regular shopping trips and print them out for a bus driver. I’ve tried using a portal on a separate layout but any record I add gets overwritten when I select another client. Can anyone give me any clues how I can select specific clients and add them to a list?
-
- 6 replies
- 1.4k views
-
-
I am trying to create a script that will go to the next row of a portal (thus creating a new, related record) and enter data there. For some reason, no matter what portal commands I use, I cannot get past the last row that already has data in it. Any advice on how to create this new record in the portal through a script would be appreciated. Thank you.
-
- 3 replies
- 1.6k views
-
-
See the pic attached, theres a light blue outline bar that surrounds my layout, how do I get rid of this? filemaker outline.tiff
-
- 1 reply
- 916 views
-
-
I hope I'm posting in the correct place. I need some help recreating a report page. I attached a picture on how it's supposed to look.  In the report page it moves horizontally from Monday-Friday and shows what time the task was done, by who, and on the left side what kinda of task it was.  What i don't understand is to make a table with columns only showing that day of the week. So if it was done Monday it will be under Monday only.  I also attached a screenshot of the actual task page. This is where they choose the date, type of service, and has the workers name.   Here's a link to the file if you'd want to get a better look: https://www.dropbox.com/s/on…
-
- 7 replies
- 3k views
-
-
May I please ask what everyone's doing with pasting text from any application in windows to filemaker to "paste to match style" as in the mac? Or perhaps scripting a reformating of the text after the pasting?
-
- 7 replies
- 1.7k views
-
-
Is there a depository, or some resources on this, from filemaker inc. maybe? I had a hard time locating material on the web and technet.
-
- 4 replies
- 1.1k views
-
-
Hello Board! Firstly, Thank you for all of your input so far. I have recently installed FMS13 and rolled out our small application to 10 users. I have come on leaps and bounds in the last few months and now our FM solution is becoming more and more useful and powerful every week. My issue: I have built a Dashboard type display that shows the sums of quantities for each day. It works well. It is driven off a Global Field 'Date'. This is an editable field, a drop down calender. The user selects the day and then the dashboard shows the previous 30 days. I want to put a big TV up in our office so everyone can view these KPI's instantly and get live feedback. I …
-
- 2 replies
- 991 views
-
-
In FMP 12 one used to be able to do a simple trick with merge fields, where you formatted the first letter in the text (the "<" for example)the format you wanted to display and the rest with any small fonts you chose so you could have its size manageable on your layout. I had got hooked to this, but now I can't seem to replicate the action in fmp13...
-
-
- 4 replies
- 1k views
-
-
The scenario is as follows, a user accidentally enters a value from a pop up with a non editable value list. Then they want to edit the field and set it back to void. Well, they can't unless you script a button to do so, which to me seems clumsier than having a " " in your value list and maybe a - before or after, separators being great for such staff. As an aside, in find mode you again can't use the field to search, as far as I can tell, unless again you put in a button or some pop up. Another way I would go about that would be to have to fields overlaid one visible in browse and the other in find mode, that's my approach at least.
-
- 2 replies
- 807 views
-
-
I have a field in one table which I would like to auto complete with values from a field in another table. I can see that using a drop-down list will work, but I'd prefer not to ever actually have the drop-down list show. I'm thinking I could use a script trigger so that whenever the user enters that field, a mouse click is performed in that field to make the drop-down go away. Is that possible? I don't see any script step that seems to fit the bill. Thanks, Michael
-
- 2 replies
- 1.2k views
-
-
I set up a repeating field in my layout with borders and vertical lines to separate each cell. They look fine in browse mode. However, all borders and vertical lines disappear when I switch to preview mode. Is it a bug, or is there anyway to show the border and vertical lines of a repeating field in preview mode? I use FMP 13 Adv. with the same behaviour in OSX Maverick and Windows 7.
-
- 1 reply
- 1.9k views
-
-
I am a novice learning Filemaker.I have a database for Horse racing(attached) and have come to a halt at 2 problems. 1.) In the Horse Layout I want to be able to type the Horse name in the box and have their past performances displayed in the Portal. The second is a bit too advanced I feel for me at the moment as I think it requires some scripting. In the daily races I would like the last 3 runs of each horse displayed in a Portal as shown in the word document attached. I don't know whether this is possible and would appreciate any assistance. many thanks Davey H RATEFORM.zip
-
- 4 replies
- 1.2k views
-
-
Ok, this is one of those issues that you sort of feel like an idiot to have to post about because I have a feeling that the answer is completely obvious. I have two portals, one that was created in FM12 and the other than was created in FM13. In the FM12 portal, setting the anchor to both top and bottom on a portal will cause the portal to extend in size to include additional records and the portal rows stay the same size. When I do the EXACT same thing to the FM13 portal, the portal resizes but it also resizes the portal rows and does not extend to include additional records! I cannot for the life of me figure out why this portal is resizing the portal rows ins…
-
- 1 reply
- 973 views
-
-
This script step is supported in web direct but the 13 documentation is vague. Anybody know the parameters of "Partial" in the compatibility section? http://www.filemaker.com/13help/en/html/scripts_ref2.37.68.html Found out already that data:text/html urls will not work in webDirect.. Love to know the other things to consider. TIA Kris
-
- 1 reply
- 1.3k views
-
-
Hi Is it possible to change a fields background colour depending on the data entered. I have a field that will display text which is 1 of 2 variables ether "Final" or "Concept" selected via a drop down value list, If "Final" is selected I would like the field background to be Green if Concept is selected i would it to be Red. Is this archivable at the moment in Filemaker? many thanks
-
-
- 3 replies
- 1.8k views
-
-
Hi, I've just been given a project to produce statement from Filemaker 6! The only bit I'm struggling with is page numbering. Most statements are on page so no problem there - I've set page numbering to restart after each occurrence - so each is numbered as page1. The problem I have is when the summary breaks across two pages, each is still numbered as page1. Is there any way - in filemaker6 or newer versions - to get the second page to have the number 2? Thanks in advance Iaxe
-
-
- 2 replies
- 1.3k views
-
-
I have - somehow - created a situation where non-active tabs are greyed out as shown in the attached image. I don't know how I did it - but I like the effect and would like to experiment further (different colours, etc) with it. Â Any ideas on how to get the effect? Â Frank
-
- 4 replies
- 2.3k views
-
-
I have several record summary reports that my users pull up at different stages during a product. Most of the information presented is images related to a single project. What I want to set up is the ability for the users to change the size and location of the image fields without having them use layout mode. I saw a sample solution for something like this a long time ago, but I can't find it now. Anyone have suggestions? One option I'm considering is having a field in which users can choose the number of images they want visible on a particular page (1, 2, or 4), have all the options on the layout, and then hide the unused fields based on the user selection. That wo…
-
- 1 reply
- 840 views
-
-
I have encountered a problem that I can't explain or work around.  I am using FileMaker Pro Advanced 13.  I have a global field on a table (glbClients). I also have a value list (Client Code and Name) that displays the Client Code as the first field and the Client name as the second field.  I have a layout based on the Client table. On this layout, I am displaying the glbClients Field with a Popup Menu that uses the "Client Code and Name" popup menu.  There is a On Modify script trigger on the glbClient field that runs a script that finds the appropriate client code.  The problem: The Global field with the Popup Menu is not always displaying c…
-
- 4 replies
- 1.7k views
-
-
I have a conditional value list as on my attached picture, which is very simple and shows a company and their products. I pick a company and the next field shows the products for that company. This works well. Companies table holds the company name and the products, order table displays the company name and lets you select the product.(Item). I need to display another company and product on the same layout so i have Company Product Company 2 Product 2 The all must work of the same companies table so i can display 2 separate companies and products on the same layout. Hope this is clear enough. Any ideas?
-
- 2 replies
- 1.2k views
-
-
Does anyone know if there's a limit of unrounded decimal places in FM? As in what's the maximum decimal place FM can work with? Thanks, Agi
-
-
- 3 replies
- 1.7k views
-
-
Hello,  This is my first post in FM Forum and just started using Filemaker days ago.  I would like to register some selected products from the market to recommend that for clients. This way I created 2 (3) tables, Table 1 - Register Manufacturers Table 2 - Register Products Table 3 - Help table for categories according to the tutorial http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists  In table 1 I would like to register product as attached drawing shows, I woud like to achive with some checkbox all together. (This will be about 50 checkboxes) In table 2 I want to register the products via sub categories - kind of f…
-
- 1 reply
- 1.1k views
-
-
To anyone that can help! I am using Filemaker Pro Ver 12 I have only one table called Customers with data files: Account#, First Name, Second Name I would like to use my Drop Down Box like a search box so when the user clicks on the drop down box and finds the account number they wish to select, all the other fields such as First Name and Last Name will be displayed on the Layout form in the fields that I have called then. First Name and Last Name are the field names. My question lies, are these fields that I am trying to have displayed based on the drop down box, am I making them a normal field or a portal field? How or what tool am I using to place …
-
- 4 replies
- 1k views
-
-
One of my favorite features in 13 is by far the Hide objects feature so that you can hide an object when certain conditions are met. The results save hours of countless other workarounds that we've employed in the past, such as hidden tab panels. or making text 500 points or 1 point and try to get it to blend in to the background. It's taken me while to articulate an issue I have had when working with this feature. We know the string that you enter will be evaluated to a boolean result and TRUE or 1 will indeed hide the object FALSE or 0 (Zed for those outside the States ) will show the object. This is just fine for most objects, but I have found that many time…
-
-
- 1 reply
- 3.5k views
-
-
Hello everybody, I a beginner using filemaker and i would like to do something. A lot of search on the web but no solution. I have a table and a google map using webviewer. For each recorder i would like to add ( or remove ) a maker / pin by clicking directly on the map. The makers are not on a specific address, it would be on a mountaine without road for exemple. If i select all the recorder, all the marker will appear. I don't know programming that why i'm looking for an exemple that i could adapt to my program or someone that could help me to do this. A other solution ( less better ) would be to use a static picture and add marker ( by drawing ). Bu…
-
- 8 replies
- 6.8k views
-
-
Hi folks, Â I am creating a print layout that is in two columns and involves a leading sub summary part. Is there any way to line up the body section in the second column if there is no summary break at the top of the column? I don't want to add a page break after every sorted item though. My guess is no, but I figured I'd ask. Â Jamie
-
- 1 reply
- 1.1k views
-
-
I have a straightforward list layout formatted as follows; Field 1 | Field 2 | Field 3 | Button 1 | Button 2 I've set the tab order for a straight left to right, so 'Field 1' is 1 and 'Button 2' is 5 in the tab order. Problem is, tabbing just rotates around the 3 fields and never lands on 'Button 1'. I note in the inspector for all my buttons that 'Go to next option using' has Tab, Return and Enter as possible options but they are all ghosted and therefore not selectable. I feel that this is the problem, but can't figure out how to get it working. I've been scratching my head over this for two hours and it's not a problem I recall having before. I'm willin…
-
-
- 8 replies
- 1.6k views
-
-
Hi, I have a FileMaker database that is acting as an archive for items deleted from our primary database (not FileMaker). Effectively, the 'Home' layout shows a fairly standard set of contact data. Below that, I have a Tab control, each with a Portal showing related records (so the tabs are Orders | Subscriptions | Advertising | Futures | Company Details | Mailings ) I would like to alert the user to the fact that there are related records somehow. Whether conditional formatting is the best tool for this I'm not sure, but either way, I'm torn between (and don't know how to implement) the below scenarios; Disable a Tab if there are no related records (portal reco…
-
-
- 2 replies
- 2.8k views
-
-
In previous versions of FMP the default text color was black. Now, in 12... it is white. At least on my copy. I thought I knew how set default color, text justification left, center and right. But, now it seems like it no longer works. What am I missing? brobins
-
-
- 5 replies
- 2.7k views
-
-
Hi, I am trying to sort out our company Database. We have a field called Company_name which is a drop down from a value list with all the company names in it. I have a field underneath called Products. what i need to be able to do is select a company name and the product field only shows the products for that particular company in a drop down list. any ideas?
-
- 3 replies
- 1.4k views
-
-
I have the following tables: [schools] ID School Name ... none = Allow Creation of Records, Delete Related Records [JOIN People with School] ID SchoolID PersonID Allow Creation of Records, Delete Related Records = Allow Creation of Records [People] ID First Name Last Name ... I have a layout "School Information" from [schools] as Form Inside the layout I have a Portal that shows related records from [JOIN People with School]. The portal row displays People::First Name, People::Last Name and several other fields. It has the People::ID field hidden. I am able to remove the relationship between the school and person by deleting …
-
- 5 replies
- 1.6k views
-
-
Ok, Can anyone tell me if this is even possible? I have a fairly simple invoice solution... With one very troublesome issue. I have customer table, product and invoice table. I have an issue though that each product is base: Widgets, Gidgets, Gadgets, etc But on each and every widget I have a modification that I have to make: XL, engraved, Blue/Red, etc. along with notes for the invoice. But when I pull the records into the invoice in the portal and I allow modification in browse mode anything I type into one product automatically changes all like products. Ex: LINE #1: Widget: XL, Blue. Engraved. If I enter another Widget it automatically changes the pre…
-
- 1 reply
- 1.3k views
-
-
hello I want to create a table that has only previous entries of chosen person. Tried to use portal tool, but there is no way to choose its own page. I want to enter and see results on same page. thanks
-
- 1 reply
- 958 views
-
-
Hello I have an address list in which I need to choose town and village. Every town has different village names. how to choose correct list after choosing the town? thanks
-
- 3 replies
- 1.3k views
-
-
Hey Guys, I've using a checkbox set to assign people to an event, but the checkbox set is displaying Full Names and actually storing contactIDs. What calculation would I need to display these full names separated by commas ? I'm currently using Substitute ( id_contact ; ¶ ; ", " ) which gives me "C004, C007, C0991 etc..." what I'd really like is to be able to instead have "Name1, Name2, Name3..." I'm sure it's just a case of using a slightly more complicated calculation but I can't work it out James
-
- 1 reply
- 1.2k views
-
-
Hi, I have two simple related tables: plants and images. The "images" table has the plant name in a field, and an image viewed through a webviewer, with a record for each image. The images are on a server, we are using a calculated URL to display them. Each plant has a different number of images, we would like to display them in one record per plant, in the "plants" table. When I go to the plants table, and create a portal to display the images, however, the webviewer from the "images" table only displays in the first portal record, not in the rest of the records. Other fields, such as the calculated URL, do display. Does anyone know if you can use the webview…
-
- 10 replies
- 7.3k views
-
-
I have a set of 7 buttons - one for each day with an attached script. If I click a button, I want its background to change color. This works, but only when pressing it. It then goes back imediatly to previous appearance. I want it to keep the new background color to help remember the user what he choose. When he clicks any of the 6 other buttons, that button will then be the one with the new background color. Do you need a script to do that?
-
- 9 replies
- 3.5k views
-
-
hello I wonder how to change the way of portal look like. it is horizontal, and i want it to be vertical., search in inspector, there was no clue. like in excel, i want to enter data from left to right in my portal tool. thanks
-
-
- 1 reply
- 891 views
-
-
I'm using Fm13 Advanced. My solution has a form view of products. The form view has three additional fields that I use to flag products as I scroll through them. Each of these flags is a Yes/No, and each has an accompanying field that is used to indicate the customer number/order number. I cannot figure out, though, how to create a list that would be automatically updated each time I flagged a record- and have the list on the form view. For example, perhaps I flag Product A, then Product C, then Product F. I'd like a list that shows what's been flagged. I've tried various portal combinations, but that's not productive. I've been able to make it work using a new wi…
-
- 1 reply
- 1.1k views
-
-
I like the new popover button. But is it possible to have the same thing happen when something other than a button is clicked (eg making a label or field into a button)? Thanks, Fed
-
-
- 9 replies
- 10.3k views
-
-
Im trying to build a database for my work which is at a music venue. I have already built a layout to record all information at the end of every night . What I now need to do is make it so if I look up a particular band I can see laid out the date of every time they have played as well as other information such as the amount of people who paid to get in and such.
-
-
- 12 replies
- 1.8k views
-
-
Hi, i have a survey database used to collect client personal data including post codes in UK (United Kingdom). It appears that almost 50% of the time people are getting these postcodes wrong and return invalid data, so they need to be validated somehow. British Royal Mail issues a data file with over 26 000 000 existing postcodes in UK and i need to validate the postcode field against these 26 000 000 existing records, each time it is populated. My first thought is to create a table in a separate file with 26 000 000 (more or less) postcode records and make a value list that would contain the records from that table and that field. Than i would make the postcode fi…
-
-
- 16 replies
- 5.4k views
-
-
I just wondered whether any of you have any solution (or know about it) whereby PDF files in the 'web viewer' can be marked using the Acrobat reader Pro (I use version 9) . I use Mac platform., FMP Pro advance11 (switching to 13 soon). Marking PDFs is for the application I am developing essential. As hundreds of historical documents are catalogued and can be opened in the 'window viewer'. The user will than search through documents in the PDF (which has been passed through an OCR program). Now by copy & paste parts of the PDF document can be selected. It is essential that these selected parts are marked for later use, or use by others, who thus can know these parts ha…
-
- 0 replies
- 1.2k views
-
-
Hi all - thanks in advance for any help you can offer.  I'm currently working on a report to show average keyword ranking (in Google search results) for a group of keywords, reported at monthly intervals.  I have a table which stores the average ranking position of 4 keywords, "marzipan", "flower paste", "ready to roll icing" and "fondant icing" each month (stored in field "SR_Keyword_Position")  In this table I also have a summary field ("SR_Average") which calculates an AVERAGE summary of field "SR_Keyword_Position"  I have a list layout for this table with a sub-summary part which has the "SR_Average" field on it which summarises the average ranki…
-
-
- 3 replies
- 1.6k views
-
-
I am working on a catalog printout with the name and description in the left hand column and an image in a narrow right hand column. While the description is often short, it is sometimes extremely long. I would prefer to allow these long descriptions to break across pages, but I'd like the accompanying image to not break across the page. I want something that I believe FileMaker cannot deliver by default: something like a conditional page break. I'd like a page break if the remaining space on the page is not enough to accommodate the container. If the the container can fit, then allow the text to flow onto the next page. My understanding is that "Allow part to b…
-
- 4 replies
- 1.1k views
-
-
I designed postcards that have name and address on the front and a message on the back. I made a layout of four cards on a page in landscape mode and for one side it works fine. If I try to extend the page into two to try to put the message from the other side on it it comes back and says I can't do it. So I made a second layout with the message on the postcards. How can I get it to print the two layouts double sided without having to stick it back into the printer?
-
- 3 replies
- 1.1k views
-
-
I just realized that I could put portals inside of popovers. I really like the idea of using this in a list view to show related records. I was thinking of using it as an expandable portion for each record sort of like a "+" used in other programs. One down side is that I could only keep one popover open at a time, but I think that would be alright. I'm curious what the filemaker community thinks of something like this. Would this be poor design? Has anyone else tried this out? Any other cons to popovers besides only one open at a time?
-
-
- 3 replies
- 5.2k views
-
-
I've got a layout that's used for printing invoices. It's a single page letter size 8.5" x 11" with a portal with the line items on it. This has allowed me to put a full page watermark image on the layout. I'd like to switch to layout mode Is it possible to accomplish this with list view mode? Thanks!
-
- 1 reply
- 2.3k views
-
-
Filemaker 13 has a script step, "Close popover". Is there a way to open a popover using a script?
-
-
- 2 replies
- 2.7k views
-
-
Hi All, Hoping somebody can help please. When setting a field to 'Unique Value', how do I stop it telling me that the value already exists if i'm in a different related record from a different table. I.e. Silly example sorry - Say I have two tables 'Months' & 'Dates' I select January from 'Months' table and go to related table Dates and enter in field with value set as 'Unique' 1, 2, 3, 4 and so on. I then select February from 'Months' table and go to related table Dates again and enter in field 1. Straightaway it stops me and says value exists, yet I want it to exist as as it's a different related record/month. I don't want to set it to have the us…
-
- 1 reply
- 1k views
-
-
If there a way to, when I hover over a certain container field, other text fields are conditional formatted? I want to hover over a container and have the text disappear when hovering... Thoughts?
-
- 1 reply
- 1.5k views
-
-
Hi guys, I've got a container field on my layout, completely unstyled, no fills or borders or anything. I've got "Reduce or Enlarge Image to Fit" selected and I have tried checking and unchecking "Maintain Original Proportions" no matter what I do there's a white border around the image within the confines of the container field. This border is not part of the image. I need the edge of the image flush with the edge of the field! Anyone run into this? Thanks.
-
-
- 7 replies
- 3.1k views
-
-
I have a value list that is based on field in a table (Attachment 1). Â When I set the field type that uses the value list to Pop-up the field displays the Name and stores the Contact ID as required. Â However, when i set the field as Drop-down the field displays the Contact ID. Â Is there any other way than stacking the Name on top of the Contact ID with the field set as a Drop-down? Â Thanks... Â Â
-
- 1 reply
- 859 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online