FileMaker Interface Features
-
Good guys, If my memory serves me, I recall that back in the Version 7 days, there was a dropdown for time, similar to a calendar (I'm not sure if it was only for Mac OS or both). My issue is that when a user enters time, they have to enter the complete time. I would not mind them entering 4.34 or 434 and displaying 4:34 AM or PM. The AM or PM would be determined by the current time on the workstation. Similarly, with the date they enter 9.29 or 929 and display 9/29/2025 I am trying to facilitate an easy way to enter time during data entry. Any ideas? Thanks JMart
-
- 2 replies
- 2.6k views
- 3 followers
-
-
Good day, need some guidance. I have a Field: "Document Type" Options: "Picking Slip" or "Transfer" Then I placed another instance on the "Document Type" field, I configured the hide object on the second instance to only show if a selection was made on the instance. Then, I configured the hide object on the first instance to show only if there is no selection. My issue is that I can't get the first instance to hide once a selection is made. I have tried "isempty" and "not isempty" with the field name and with the "self" keyword. What am I doing wrong? FYI... The idea is that once a user makes a document type selection, they can …
-
- 5 replies
- 10.1k views
- 1 follower
-
-
Greetings all: Here's a puzzler: In the style that I'm using for the attached edit box, I've chosen "No Fill" for Pressed and In Focus, but when I click on it I get a dark green fill; there's no assignment of conditional formatting to the field, either, so where is it coming from and how can I change the default(?) color from green to something less obnoxious? TIA for your help.
-
- 6 replies
- 30.7k views
- 1 follower
-
-
Hi Everyone, I've got a series of images on a single layout, and I want some images to be greyed out, ie take the opacity down to say 50% so that only some images in the grid stand out. Is there any way that I can do that within the container field (that holds the image), ie if a radio button is checked, then set opacity to 50%? Another way might be to create a copy of the file, have that with 50% opacity, and then load that file through an if then calculation? I've had a search on the site but can't see anything. Comment had something from 2021 but the file that was allied to the comment isn't available any more. Thanks for any pointers!
-
- 2 replies
- 7.1k views
- 2 followers
-
-
We have a report that is a two-column report. The number of items varies on each column, due to the sub-summary breaks. Some groups of items have one or two items, some have many, etc. The person we're designing it for would like the sub-summary heading to print at the top of the RIGHT column when the group continues from the bottom left column. We've been trying all the solutions we can find so far, but nothing wants to work. Has anyone done this, or are there any "hidden" flags that we can possibly trigger somehow to get that header to print on the right side in this condition? Thanks.
-
- 3 replies
- 408 views
- 2 followers
-
-
Hi all, My current "design" of a button bar (with its three relevant buttons) that would allow a User to… View as Form View as List View as Table …has me scratching my head. JUSTIFICATION FOR THE FUNCTIONALITY The reason for building this View Layout button "functionality" is rooted in my quest to Hide Status Toolbar. Since I am hiding the status toolbar, I have been rebuilding the elements of the Status Toolbar that should be made available to Users (and to me as a "developer"). WHAT I CURRENTLY HAVE BUILT I have the buttons and the scripts working just fine that go the various Layout Views. See screenshot: 3_but…
-
-
- 6 replies
- 1.3k views
- 1 follower
-
-
I MADE 2 LAYOUTS MY IMAGES AND MY IMAGES SEARCH 1 - FORM VIEW TO ENTER DATA WITH CATEGORY AND INFO FIELD 2 - LIST VIEW TO SEARCH WHEN I CLICK CATEGORY EXAMPLE DE WINTER IT SHOWING ALL THE NAMES IN THE DROP DOWN I WANT DROP DOWN TO SHOW ONLY VALUES OF THAT CATEGORY PLEASE HELP ME ????????? AMI.fmp12
-
- 11 replies
- 1.4k views
- 2 followers
-
-
Howdy all: I'm in Stupid mode today--I can't see how (in the attached solution) the Product portal is being filtered after choosing a category. I see that the layout has a script trigger assigned so that upon record load the script captures the record ID in Category and pushes it into a global field. Still, I can't see how the Product portal is being filtered--there's no filter assigned in the Portal Setup box, so...? *sigh* This is giving me a brain hernia--time for a Tylenol. Thanks in advance for your help. Nested Portal.fmp12
-
-
- 6 replies
- 1.5k views
- 2 followers
-
-
hello in my project i associate an audio file and a waveform ... in the version 12 of filmmaker it was easy to make coherent the size of the player and the waveform ... but not anymore since the version 16 ... did someone know a way to do this ??
-
- 2 replies
- 974 views
- 2 followers
-
-
I have done my best to search for a definitive answer, but I just can't find one. My Situation: I have many types of ITEMs that have very different attributes that describe each ITEM. For example: A "wheel" ITEM has attributes such as: Wheel Diameter; Bore Size; Lug Count; Offset Size; etc. A "paper" ITEM has attributes such as: Grain Direction; Material Thickness; Opacity; Recycled Content Percentage; etc. In other words, the attributes needed to describe different types of ITEMs vary considerably. My Current Direction: I have one table called ITEM that will contain all attributes needed to fully describe each ITEM - of any IT…
-
- 5 replies
- 2.6k views
- 1 follower
-
-
I have filemakerpro 16. A couple of years ago, I made a dbase based on the “Research” template. A central feature of the template is a 3-tab system that occupies the same space. Somehow, while making some modifications to the layout, I messed up the formatting royally. Don’t know what I did, or how to fix it. My question is, if I copy that entire section from the template using “edit layout”, can I paste it into my existing database, and have it retain all the formatting, without it altering the data already input? Would appreciate some advice. Stokesy
-
- 7 replies
- 689 views
- 3 followers
-
-
(I can't seem to find a definitive answer here after poking around, so I apologize if this has been covered before.) I have a related value list that I'd like to use in a pop-up menu. The problem is, I always have to include an adjacent "clear" button to clear the field and it looks amateurish to say the least...so I'd like to have a null/blank value at the top of the value list so users can "clear" the field of an unwanted value. I thought I'd be clever and try this: Let ( [ _relatedValues = List ( fieldname ); _blank = "" ]; _blank & ¶ & _relatedValues ) ...but that won't work because it be…
-
-
- 2 replies
- 870 views
- 1 follower
-
-
Hi Everyone, just wondering if it's possible. Here's a screen grab of two radio buttons, and I'd like to have it so that if a button is not checked (ie the button on the right), then its colour is changed to grey, rather than the blue that you can see. I don't think this is possible though? This is Filemaker Pro 19.6 Thanks for any advice
-
- 6 replies
- 1.3k views
- 2 followers
-
-
Howdy all: Here's the problem with the schema as-is (see attached): If a STAFF person's status changes from active to inactive, their STAFF record ID replaces their name in the EVENT portal since it violates the condition between T.O.s (for the value list); change their status back to active and their name returns. For historical record purposes, what I would like to do is have their name remain in the portal irrespective of their status in STAFF. What do I need to change in the schema to make that happen? Thanks in advance for your help! Rich Test.fmp12
-
-
- 4 replies
- 1.1k views
- 1 follower
-
-
Greetings! A few weeks ago, some of you were kind enough to help me construct a database for my movie collection. (Thank you, by the way.) But I just now noticed something. It’s not really a flaw. There’s nothing really wrong. I don’t really HAVE to fix anything. So, I’m just asking this question out of curiosity. The database has a few portals with repeating drop down menus. I just realized I can select the same thing twice. For example, if I have the movie Jaws and select Genre, I could select Action/Adventure multiple times. Or, I could accidentally select the same actor twice. Is it possible to tweak the database so that this is pre…
-
- 2 replies
- 1.4k views
- 2 followers
-
-
Hello, I am using Filemaker Pro 20 but I’m really a beginner. I’ve made a simple flat file movie database, just to experiment with. Some of the fields have yes/no checkboxes. No problems with them. One field (named “RANGE”) is a checkbox group with four options. Those values are: 250, 500, 1000, and 2000. When I generated a report, I noticed the Range field wasn’t displaying all of the values. I widened the box and saw the values were vertical. I wanted them horizontal. I did some research using AI and found a formula to create a calculated field with the Substitute formula. Here is the formula I got from AI. I filled in the Range …
-
- 2 replies
- 922 views
- 2 followers
-
-
Hi all Firstly, apologies if this is in the wrong sub-forum. I wasn't able to determine which part of the forum this belonged. I have a small company that has a couple different departments within it. I'm wanting to create a system that allows employees to enter their worked hours each day prior to payroll processing their timecards separately. This is a request from management. No taxes and such are calculated within this, this is more of a daily/weekly review to track overtime and hours worked. They call them "production reports". They use these when approving or flagging payroll timecards. Ideally: - each user login has their own "profile" layout wh…
-
- 1 reply
- 995 views
- 3 followers
-
-
I'm fairly new to FileMaker Pro (I'm just over a month in/trying to build as much as possible under my free trial as there doesn't seem to be a sandbox, before having to pay for licensing when we're not quite ready to go live with the app) currently producing a time management solution for projects managed under my husband's small engineering company. Our current solution is based on Macro-heavy Excel files that have hit their limit in programmability / aren't user-friendly for collaborative working, hence the branching out into app development to find a solution. (My day job is as a database analyst for an insurance company so Excel, SQL, Tableau are my main skills. L…
-
-
- 5 replies
- 1.2k views
- 2 followers
-
-
I am experimenting with the use of popovers on a coin database I keep. Refer to Image 1: I have added 2 popover buttons, one in the bottom right-hand corner of the first coin and the second on the bottom left-hand corner of the second coin shown in the database. The first button, when clicked, is designed show an enlarged picture of Bluey while the second button, when clicked, is designed to show an enlarged picture of King Charles III. At the moment, when I click either button, I do get a popover with the enlarged image – but not the size/location I want (See Database). Here is my wish: when either button is clicked, I want the popover to cover exactly the…
-
-
- 11 replies
- 4k views
- 4 followers
-
-
I have a small database called RECIPES. On each record is a container field called IMAGE where I upload a small image of the created recipe. I would like to show a larger image of the one in this field. I downloaded a file called popoveContainerDEMO (attached) to show me how to do it. I installed a popover button on the RECIPES database and named it "Enlarge Image" as seen on the attached RECIPES database. HOWEVER, when I click on the Enlarge Image button to display the popover and then try to drag an image to the popover, the image does not load. It works for the demo file I downloaded - but not on my database. Can someone please help me with this. Frank popoveC…
-
- 5 replies
- 595 views
- 2 followers
-
-
Although this could be already been solved, worked out in a better way or what ever... With the help of other people and a bit of my knowledge, I have come with a solution that works for me. I'm pretty sure it can be very much improved, but by now, I think works fine and does the work I need. This lets you navigate through slide panels, showing the total number of panels and in the partial count, the actual panel you are in (been independent each panel count). Thanks to all the help I have received in this great forum. I hope this can help others. NavigatingSlides.fmp12
-
- 7 replies
- 1.2k views
- 3 followers
-
-
Hello Community I'm wondering is there a way to combine two technics: Filtering portal and Pagination the results. There is a nice sample here (thanks for sharing @comment), but I'm stuck trying to combine it with filter. I tried to make a list of ID (as summary field) to use this when result is true, but with no luck. My goal is to use multiple global fields as checkboxes or search string, and then display splitted result. This part is clear, but I cant connect it so the sample from mentioned post. Thanks in advance.
-
- 6 replies
- 779 views
- 2 followers
-
-
When I created a Tab set in layout I expected there would be some simple option in the tab setup panel that says (on click) go to Layout. No such thing. Where do I go from here? I just want to click a tab to go to another layout. FMPro 15. Without much knowledge I created a transparent button overlay, the first tab works fine, the second one on the target layout I have to click hard or twice for it to work (no idea why) but in the rollover state it goes opaque which seems to be related to its default theme.
-
- 5 replies
- 703 views
- 3 followers
-
-
I have two tables: jobs and tracks. A track can be either "pending" or "not pending" on multiple jobs. I set up a TO where the relationship is to match trackIDs between the job and tracks tables, but ignore the current job, so that for each track selected in a left side portal, a right side portal shows only other jobs (not the job on the left) on which the track is pending, using a filter on the right side portal. Now I would like to toggle the left side portal between showing all tracks on a job (whether pending or not pending), or showing only tracks which are pending on other jobs. Either that, or better still, a conditional format on the tracks on the left so th…
-
-
- 17 replies
- 23.1k views
- 3 followers
-
-
Am a newbie! I have just added a portal to a coin database I created to speed up navigation and display search results. Initially, when I open my database, all fields are displayed with a solid red border (thickness of 1) as added by me. If I click on a portal row to display a record, the border of all records changes to a dotted line; the red border disappears. Can someone tell me what is happening, please?
-
-
- 6 replies
- 1.1k views
- 2 followers
-
-
I'm having a frustrating time with some portal filtering. What we have is essentially a calendar layout. Each day has a portal, filtering records based on the order date. This means that users can see the orders due on each day at a glance, and this has worked well for many years. Recently, business is getting busier and it would be helpful to filter the portals by the type of order as well. I've started by adding three Global fields to the Calendar table, which are essentially toggles that the user sets for what they want to see. These correspond with three fields in the order table. All are text fields populated with "Yes" or "No" I'd assumed that…
-
- 5 replies
- 1.8k views
- 2 followers
-
-
Looking through a script I saw this new window step and the words "Virtual Window on Web" and for the life of me I have no idea how that got there. I don't know if this has anything to do with 'Web Direct' BUT the application doesn't use Web Direct at all so I'm baffled. I don't see this as a window option in the New Window script step and I tried deleting the line and recreating it again but the "Virtual Window on Web" keeps coming up. Can someone explain to me what this is? I tried looking in the Docs but couldn't find anything referring to these words in the New Window script step. The code still functions correct but I'd like to know how this might have gott…
-
- 2 replies
- 3.3k views
- 1 follower
-
-
Easy way to have nicer buttons, using different colors for normal, hover and pressed. Works by using a transparent white PNG as mask, a single image, instead of 3 different images, one image for each state. Using a container with a global value you can copy-paste the buttons where ever needed. hover.m4v hover.zip
-
- 1 reply
- 1.3k views
- 1 follower
-
-
I have been using the excellent VirtualSort by @jbante for years and it functions very well, but sorting on an unstored calc is, as we know, inherently slow on hosted solutions with many records. I was wondering if someone has conjured up a new method for dynamic portal sorting that is significantly faster considering that 10 years have passed. I also wonder how the 'Server sorting' in Server 19 and later affects sorting on unstored calcs, as I read somewhere that it apparently does not work. Cheers, Andreas
-
- 0 replies
- 880 views
- 1 follower
-
-
Hi Everyone. So I used to do this with the Character Viewer which is Cmd Ctrl Spacebar, but that no long brings up the Character Viewer in FMP (tho it does other apps). 2 Qs - is there a way to bring the Character Viewer back to live - using a scrip such as Insert Text, is there a way to give a script a specific keyboard trigger, ie Option 9 or Option 0, rather than this number just come based on how many other sripts I have in play? That way I can have the script trigger be the same in different files, rather than have 8 empty / dummy scripts using up the slots, so that then I can have the ones that I wan as Option 9 or 0. Cheers, and thanks in advance
-
-
- 2 replies
- 945 views
- 1 follower
-
-
I am trying to write an IF/THEN statement than presents a dialogue box if the name field is blank. If it has a name is in the field, continue.
-
- 2 replies
- 1.4k views
- 2 followers
-
-
Is it possible to use TextStyleAdd, or any stock function, really, to change the text weight in more than 2 steps (plain, bold)? I have a font that has "light" weight, then "regular" weight, "semibold" and so on. In CSS those are usually represented by a number that goes from 100 onwards allowing for precise control over weights. However I could find nothing of the sort in FileMaker. In fact, supplying "Plain" to TextStyleAdd fails to assign "regular" (bolder) weight to a text box which has "light" weight assigned in the layout. Is there a simple way to work around that?
-
- 3 replies
- 1.2k views
- 1 follower
-
-
Hi all, I have three questions: QUESTION 1 I have a tooltip calculation that DOES NOT work: FieldComment ( Get(FileName) ; template::template_field_name_01 ) Then I created a second Tooltip calculation that DOES work: Get(FileName) I have assigned these two Tooltip calculations to both Field and Field Labels for testing purposes. What am I doing wrong in the first calculation? QUESTION 2 In my troubleshooting quest and internet search, I came across some Filemaker commenters mentioning putting Tooltips in their own dedicated table. This is interesting and I can see some benefits in doing so (translated vers…
-
-
- 3 replies
- 3.3k views
- 1 follower
-
-
Hi all I have created an employee vacation scheduler that is basically gantt charts using a combination of repeating fields. On the employee record I can add related records (timeOff), set the dates, approval status, approved by and a note. This repeating field (cChart) is then recalculated into a summary field (sChart, also repeating) that shows the given date range (31 repetitions) for the employee. Numerical values complete the repeating fields. 0 is no data, 1 is approved, 2 is rejected and 3 is pending. On another layout I have the Employee table in List view and each employee has the sChart repeating field shown in a matrix so the user can see th…
-
- 5 replies
- 517 views
- 1 follower
-
-
Why does it make a difference, to put "" instead of the default none - when speaking of the topics touched in this thread? https://community.claris.com/en/s/question/0D73w000005VbkrCAC/detail This issue has occurred to me while using a button bar as rendering mechanism, instead of a repeating calc field using Get ( CalculationRepetitionNumber ) - I enclose a template where I dwindle globally to narrow the options down by excepting the already taken .... I would both have an explanation to why the active segment should be set to something like "" or char(0) to behave ... as well as some Ocham's razoring to the approach I'm working with here? --sd Ho…
-
- 0 replies
- 942 views
- 1 follower
-
-
Hi All, Is it possible to create a conditional format condition based on the portal row number? In essence I would like to use the strikeout format for any portal row that is over 100. Thanks in advance. Milky.
-
- 3 replies
- 1.7k views
- 3 followers
-
-
Hi All, I have a Portal that tracks players qualification status for an end of year game. To qualify a Player must have played 8 or more games, but also finish in the top 100. The portal contains the following fields: Name Games Points. Currently the portal is sorted by Points descending and then games descending. What I would like to happen is that the portal is sorted in the following way: Sort by Games (but only if Games are equal or greater than "8" 😎😎 Then Sort by Points Then Sort by Games (for any Games less than "8" 😎😎 Then sort by points. Any help would be appreciated. Milky.
-
- 9 replies
- 702 views
- 2 followers
-
-
Hello, I am wondering if there is a script step or or other mechanism which would cause the automatic activation of a drop-down list, or a pop-up menu, as if I had clicked on it.
-
- 13 replies
- 11.4k views
- 2 followers
-
-
using fm 21 in samsung book 4 pro ultra 5 have set tab control on a layout when clicking field in layout mode taking few seconds to select the field any1 else having the issue or any reason ????
-
-
- 18 replies
- 1.5k views
- 4 followers
-
-
Hi all, I'm trying to use the above mentioned functions to hide/show my search bar when switching between certain panels, but the functions don't return what they are supposed to. I attached a script to OnPanelSwitch that flips a hide variable between 0 and 1, which works, but Get functions just show 0 in my Data Viewer. What could I be missing? Thanks.
-
-
- 8 replies
- 1.2k views
- 2 followers
-
-
can we use multiple default themes of fm on single layout if we yes kindly guide me
-
- 1 reply
- 944 views
- 2 followers
-
-
in above pic selected field font is in red colour as u can see text colour fill color are different conditional formatting removed but font colour is red please help me
-
-
- 4 replies
- 3.8k views
- 1 follower
-
-
Howdy all: I apologize in advance if this isn't the proper forum for this question since it involves external data sources, ESQL, etc., but the crux of the problem is that none of the fields (in the portal) will sort. In the attached (original) file, everything works as it should. I've copied it, but instead of using an intra-file table for contacts, the file I created connects to an externally-sourced FileMaker Pro file elsewhere on the server for Contact data. The lookups for (external) data work fine in the new version--it's only the sorting part of the solution in the Sort layout that doesn't work, so given that everything was faithfully reproduced and …
-
-
- 18 replies
- 2.5k views
- 3 followers
-
-
Hello, I have a layout that displays a homeowner inspection report. The first page should show a header (name, address, comments, etc. and two of a possible 8 photos of the home. The second page should show the subsequent 6 of a possible 8. I set the layout up with a Sub-summary by Lot at the top to show the lot specific info and the first two photos (two single row portals starting at the record 1 and record 2 of the linked PhotoList table respectively). Then I set up the Body with the other six photos, using 6 portals, starting at record 3-8 of the Photolist respectively. Here's the first page = Leading sub-summary: Here's the second page = Body…
-
- 12 replies
- 2.1k views
- 3 followers
-
-
Apologies, I've been away from FM for about 6 months and I'm having a mental block, can someone help please? I'm trying to get a portal to filter records and I'm using "<" & ">" to do it. The problem is I want record records > but also <, essentially, if we are talking about numbers 1 to 10 I want numbers greater than 4 but less than 7. If I use the "and" operator I get all records because I've used parameters that contradict each other.
-
- 1 reply
- 1.2k views
- 1 follower
-
-
Can anyone tell me if this could be created within Filemaker? I'd like to add an audio player towards the bottom of a layout. It isn't a popover but more so embedded into the bottom of the same layout as the portal would be. You often see this with online sites like SoundCloud or similar. A couple of quick example screenshots are added below. Any advice would be welcomed. Thanks!
-
- 2 replies
- 1.2k views
- 1 follower
-
-
Hey folks, I created a simple layout with a portal. I included a couple of fields and a popover for an audio file. When I click on the green popovers and add an audio file, they seem to transfer to the other 2 portal rows but when I click on the yellow pop-ups, and pick any value from the list, they are independent of each other. Any reason why? Thanks! Screenshot attached.
-
- 2 replies
- 1.4k views
- 1 follower
-
-
Hey folks, I have a three-part question but all related. 1. I understand that when highlighting text in any field, the color is based on the operating system's settings (in my case, Mac's System Settings, Appearance). Can I use Filemaker to force and set the desired color rather than the OS's settings? 2. See the image with the calendar, can the highlighted box have the same "Corner Radius", just like the field? 3. See either image, can the text turn to white, only when it is highlighted? As always, many thanks!
-
- 2 replies
- 1.2k views
- 3 followers
-
-
Hey guys, I created a portal and added a field and a button. The field is a pop-up list and the field and button do not overlap. See screenshot. As it stands, the button is located on the right side of the portal so I can only delete the row if the mouse is hovering over the button. What I would like it to do is when I hover over the entire row, the trash can will appear but I can only delete the row if I click on the trash can and nowhere else. I hope this makes sense. Thanks so much for your help.
-
- 4 replies
- 1.1k views
- 1 follower
-
-
Hey folks, I have a portal that includes a single field. As you can see from the screenshot, all of the rows are purple, including the “add keyword” row. I want the “add keyword” row to be light gray until I add a word from my pop-up list and it’ll immediately turn purple, like the others. As it stands, they're all purple. Would anyone care to explain how this is done? Thanks so much.
-
-
- 2 replies
- 1k views
- 2 followers
-
-
my issue - an existing table, fully populated with data, now has an additional/new (numeric) calculation field HOWEVER the new calculation field result (a simple multiplication) does not appear/is not displayed. context - the existing table has 4 fields, a) item name, b) item qty, c) unit cost, d) item volume; new/added field is e) itemsValue (itemCost * itemQty) request - any suggestions please on how to obtain a displayed calculation result/value in the new field? fwiw - creating a new record displays the data as expected/required in all 5 fields. background - using FMP 19 standalone on Win 11 clean install regards, yoyojoe
-
-
- 10 replies
- 1.5k views
- 3 followers
-
-
I'm building a survey app and I have multiple types of questions that fall broadly into two categories: Single Mention and Multiple Mention. Is there a way to conditionally set the answer fields to either be radio buttons or checkboxes depending on the question type? For example, each question has an "instruction" field that says if it's One Mention or Multiple Mention. So I'd like to do a condition like If MyTable::InstructionText = "One Mention" the responses are radio buttons and if it's Multiple Mention, it's a checkbox set.
-
-
- 9 replies
- 2.2k views
- 3 followers
-
-
Hi, There is a weird behavior occuring with a couple Checkbox Sets (not all of the sets present in the layout): 1. When the user selects Checkbox #5, the selected value is correct but the visual indicator of the checkbox goes to Checkbox #3. 2. When the user selects a Checkbox #6, the value is correct but the visual indicator of the checkbox goes to Checkbox #4 3. When the user selects a Checkbox #7, the value is correct but the visual indicator of the checkbox goes to Checkbox #4 4. When the user selects a Checkbox #8, the value is correct but the visual indicator of the checkbox goes to Checkbox #3 This happens using the "x" mark or the "Check" mark. D…
-
-
- 4 replies
- 1.2k views
- 2 followers
-
-
I'm trying to create a Tab Control Panel containing seven tabs in FM19. Each tab contains a portal which I want to appear in the same position. I seem to be able to create three or four portals correctly by copying and pasting and then adjusting the copied portal, but subsequent ones appear in the wrong tab. It's driving me mad. I'm sure I've solved this before but I've forgotten how I got it to work. Has anyone got a method to solve this?
-
- 2 replies
- 1k views
- 2 followers
-
-
Hello everyone. Is there a way to adjust the dimensions of layout parts (body, header, footer, etc.) dynamically from a script? I have a popup dialog layout that I use as a card window, but depending on how much text there is I want to be able to shrink its height. I tried changing the height of the card window, but that doesn't shrink the layout itself and creates scrollbars. Any ideas or workarounds?
-
-
- 17 replies
- 3.1k views
- 4 followers
-
-
I know I've done this before, but can't remember how nor find how to do it. I have a portal, and I want to have the row number show up in the portal for each row. So, the first record in the portal would have a 1, the second a 2, etc.
-
- 3 replies
- 1.1k views
- 1 follower
-
-
In my file, I have a date field, with one record for each date, going out for the next 60 days. There's a script that creates new records once the last one is less than 60 days old, but the existing records go back for one year. I also added a field called todays date, and when the file is opened, the current date gets entered there, and yes, it's a global field. What I want to do is when I open FM, have it go to the record where todays date is the same as the date field. In my opening script, there is the option to go to the record based on a calculation, but nothing seems to work. I added another calculation field that if the date is the same as todays date, th…
-
- 1 reply
- 886 views
- 2 followers
-
-
If you need to have the option on in the relationships diagram: "Allow creation of records in this table via this relationship", you will always have an extra empty row at the bottom of your portals (see here). But if you don't want the extra empty portal row to be displayed, there is a workaround: You can conditionally hide all the fields in your portal, for example when the record is empty. In Layout mode, I enter into the box: "Hide Object, when" the following code: isEmpty ( Relation_to_Table::id ) This is only cosmetic, but nevertheless, it works great: Now, only those portal rows appear that have values in it. You might need to adjust background colo…
-
-
- 5 replies
- 1.4k views
- 2 followers
-
-
This looks like a very common question, but I haven't found a good enough solution on this forum. It's Filemaker 20 that is out now, and does it still not have a convenient way of enabling/disabling field editing on the layout? I mean dynamically depending on desired events, of course. I need to lock the entire record from editing when its status changes to "Closed". Am I supposed to add another layer to all fields and make them hide and show? Please don't say that 🫠
-
- 3 replies
- 1k views
- 3 followers
-
-
I know that you can double all the segments, and then hide them accordingly to the wished. But the issue I have with it, is that you might hide the "active" by doing so. Exists a scriptstep that actively changes the state of the now appearing segment? I guess on the other hand - that the CSS behind the button bar, can be hacked to perform this little feature. Only I'm not aware of how to do so? I attach the template I trying this teqnique on, and the idea was that the icon changed when double-clicking on the desired segment buttonbar sort.fmp12
-
- 3 replies
- 1.9k views
- 1 follower
-
-
I _know_ this must've been covered here, but I must be muffing it using search operators since I can't find what I'm looking for. I found a few .fp7 example files dating back 14+ years ago, but I'd rather use more modern commands/schema that are available in later versions. (We're using v.20x FileMaker Pro, Mac.) I want a value list (checkbox form, global field) to filter the results in a portal but I'm just not getting the syntax right using FilterValues and/or ValueListItems. What's the correct calculation? Example: If the user clicks Alpha and Beta, I want both values to appear in their respective records/field in a portal. TIA for your help. -----------…
-
-
- 3 replies
- 810 views
- 3 followers
-
-
I have a portal that shows the 'ingredients' and quantities required to make/bake/cook a particular recipe; external to the portal I have a field called 'Wish to make' to hold a numeric value variously entered by a user. How am I able please to multipy the value in each portal row and show the 'sub/total' of each listed ingredient; i.e. each calculated quantity being the full amount of each ingredient needed to make the 'batch quantity' defined by the user? Thank you for any suggestions.
-
- 5 replies
- 1.3k views
- 2 followers
-
-
I couldn't find the answer here, but I'm sure it's been answered before so I apologize for my lack of search operator coding skills. (I looked at the FileMaker online help web page but it didn't offer an answer.) In the attached, you can see a related value list setup for a pop-up menu. When inactive, the field shows the primary key, not the school name (from the second field.) I have the Override data formatting with value list checkbox ticked in the the Inspector (Field section) but doesn't alter the menu's display, so what else do I need to do to display the school name instead of the primary key when the field is inactive?
-
-
- 4 replies
- 912 views
- 1 follower
-
-
Hi, I have a database with about 300 fields in a single table, organized by Custom Order. It's a flat file (non-relational) data collection tool that I'm exporting to Excel for a statistician (the field names make sense in Excel). When I make changes to fields, I want to navigate from the field in Layout Mode to the specific field in Manage Database to eliminate searching by scrolling. Is this possible? Alternatively, is there a way to search for a field in Manage Database? Thank you.
-
- 3 replies
- 1.3k views
- 1 follower
-
-
The Filemaker solution that I (sporadically) work on is used to manage equipment rentals. One thing I've recently been asked to add is a way for someone to type a query word / phrase, and quickly see a list of current rentals that have a matching item on them. It's used for a "hire desk" scenario, where someone at the desk can see a customer coming in carrying a chainsaw, say, and they can type that into the search field, and have the customer details appear. The resulting layout has three portals on it. They are based on a Cartesian (X) relationship between the table with the rental items, and a "Dashboard" table. Each portal is filtered usi…
-
- 9 replies
- 1.8k views
- 3 followers
-
-
Tables are Gigs, Performances, Singers, and SetList Summary. Gigs is the hub, and Performances is a join table that pulls other elements together. On the Gigs layout, I have a portal listing the singers in a Gig (bottom right circled in blue). I have a TO called OtherGigSingers on which this is based. The portal lists the names of all singers who share the GigID being viewed. I have another portal top/center which represents records from Setlist Summary. This table uses GigID and SingerInitials in related records from Performances to summarize information for a given Singer in a particular gig. This related table only has one record for ea…
-
- 1 reply
- 865 views
- 3 followers
-
-
I installed idautomationhc39m font on both of my client's computers, But the other one is not showing it just plain text. I already clear the font cache but still not working.
-
-
- 4 replies
- 1k views
- 4 followers
-
-
I literally haven't asked this question in 10 years so I'm not sure if there's a solution to it whether new or just forgotten. When I have a text input field on a layout (height specified to allow viewing of one-line of data only) and the user enters more text than expected, the field opens vertically. Is there a way to always maintain the set dimensions so that as the user types the field contents will scroll horizontally without any changes to the text box?
-
-
- 12 replies
- 1.5k views
- 3 followers
-
-
It's been a while since I've developed a solution in FM. This may not be the right place to post, but searching didn't get me anywhere. Using FM20 and, in list view, when I scroll down to view more records, the screen automatically jumps to the top. Can someone please help me with this?
-
-
- 12 replies
- 2.2k views
- 4 followers
-
-
I have a button for a script that takes the user to a layout (for use on iOS or macOS) that presents a value list as 100 radio buttons in a second layout. I want the numerical value of the radio button (1-100) in that second layout to be used as the value for a Find that will take the user to that record number in the original layout. It would accomplish the same thing as a Find where the user would type a value from 1-100 into the field but be mouse/touch based. I am not too with variables (concept but not syntax). Is the radio button value already stored, or does it need to be captured? FM 19 on Sonoma.
-
- 1 reply
- 967 views
- 1 follower
-
-
Hi all, Please could you assist? When I add a part number and description to layout x, I need the part number to automatically be added to my parts catalogue if it does not exist How do I accomplish this? I also want duplicate part numbers to be automatically be deleted
-
-
- 1 reply
- 1.4k views
- 2 followers
-
-
I want to use UUID for all my tables and also for linking them together, but I don't want to show the long id. Yet I need them to pull up information from another table. How I can solve this dilemma? Thanks. KC Production.fmp12
-
- 3 replies
- 1.3k views
- 1 follower
-
-
Hi, I have a table called Books and a table called Publication. On a layout based on Books, I have a portal based on boo_PUB_BooksId (Books::Id = boo_PUB_BooksId), where one or two publication dates are selected. In a card window based on Books, I have a portal based on boo_BOOKS::Editor (Books::g_SelectedEditor = boo_BOOKS::Editor) that displays the nos and the titles of books from selected editors. That works fine. Except I want to add the publication date or dates in that portal. But I can’t manage to extract the dates from boo_PUB_BooksId (the portal on the Books layout). Could someone help me achieve that. I’d like the dates to be displayed as fo…
-
- 13 replies
- 1.9k views
- 3 followers
-
-
I have a printed container label layout, for which a customer would like me to "invert" the colors of the Month of a date field. Is there a creative way to accomplish this, aside from creating three fields to separate DAY, MONTH, YEAR and piece it together? See attachment for goal. TIY!
-
- 2 replies
- 781 views
- 1 follower
-
-
I have attached a sample database to illustrate my question. The database has 4 layouts. I would like to combine the data in layout Order, Products and Summary to create an invoice like the layout "Invoice" I have provide some sample data in the database Test DB.fmp12
-
- 9 replies
- 1.4k views
- 1 follower
-
-
Our database has a container field that we mostly have PDF's inside of, with the occasional PNG. Currently we have this container in three different layouts. On all layouts the scrollbar is visible when applicable. However, only one layout allows the users to interact with this scrollbar. This includes using the scroll wheel of the mouse and dragging the scrollbar with a click of the mouse. I've tried ensuring all the settings for this container field are identical across the three layouts, but nothing seems to fix this issue. One thing to note is the layout where it works properly does have the same Associated Table as the container itself, whereas the other two layouts …
-
- 1 reply
- 824 views
- 1 follower
-
-
Hi. (Being an interface matter, I assume this is the correct forum to place it into.) I am looking to setup 'toastr'-style notification boxes as found in this link by CodeSeven. I have seen a few mentions of people having done it but been unable to contact them or see any working examples. It's the implementation of JS into Filemaker that has eluded me. Has anybody got any working examples of doing this please? Greg
-
- 6 replies
- 1.7k views
- 3 followers
-
-
Hello all and thanks for your time reading this. 😀 I have 3 tables : Call order items Relationships : 1 call has many orders, 1 order has many items. I am trying to design a layout where I can display the call information at the top of the layout, then the multiple orders information in a tab control object (one tab per order) and then the items information related to the order displayed in the selected tab. image I have created a portal in each control tab showing the order (I only display 1 row with the initial row set to 1 in the first tab, 2 first the second tab and so on), that seems to work, but now I want to display in a seco…
-
- 8 replies
- 1.6k views
- 1 follower
-
-
I use FileMaker Pro 15 and I've created a photo catalogue for sorting exhibitions and books. I tried to create a PDF document via the Print function on a Mac. Print > Save as PDF but the margins are quite large. The image layout is 590 x 320cm without a header or footer and the page setup is these same dimensions with zero margins. I was hoping to get near edge to edge images but the margins are quite large. There are what look like grey page breaks every two images. Is there any way to reduce the margins in FileMaker or is this just a quirk of PDF page generation?
-
- 2 replies
- 1.2k views
- 1 follower
-
-
I have been slowly redoing my solutions with the relatively new feature of using a portal to filter the results from the same table on a Form layout. This takes the place of having a list view and then clicking on the item to get the form view. I have a table of Lessons. One of the fields is Topics. I would like to have the functionality where I could select, within the Lessons Form, from a list of Topics, and then the self-portal on the form would show me all the lessons on that topic. Then I could select that lesson for other details to be displayed. It appears that I cannot use two self-portals to achieve this. I also tried using a global field with…
-
-
- 4 replies
- 1k views
- 2 followers
-
-
I've been using FileMaker for over 20 years, but up until today had never tried making a chart with it. I'm tracking the dates that students inquire about my school and would like to make a line chart that shows total per month for each year. I have the date field, a month(date) field, and a year field. There are a few hundred records. It's clear that I need to do something else to get this to work but I'm not sure what it is. Do I need to create 12 global fields that count the number of records for each month? If so, is that what I would put on the y axis? Do I need to add something to the relationship graph?
-
-
- 11 replies
- 1.2k views
- 2 followers
-
-
I run a school and keep track of almost everything related to the school in a FM database that I developed. The one thing that I don't use the database for is making transcripts. For this I have been using MS Word, making one file for each student. But I would prefer to have the database do it. To do this, I take the transcript template in word, save as PDF, and then insert it as the background on a layout. The functionality of this works fine except that I cannot figure out what the strategy is for creating the layout so that it prints as a pdf or just prints to paper in a way that works. If I don't set the sizing just right, a one page document becomes a fu…
-
- 0 replies
- 1.1k views
- 1 follower
-
-
As part of their workflow, some of our employees prefer to drag-and-drop PDF's into the container fields of our FileMaker database. This works with files in local directories, but if they try to drag a file from a network folder nothing appears to happen to the database. If they use the Insert>Insert PDF command, or if we use the Insert File function in a script, then the files are imported perfectly even if they are in a network folder. I'm curious if anyone else has run into this, or if we simply have something strange going on with our network stack. This happens across multiple computers. All users are on Windows 11. We are using the latest version (20.2.1.60) of F…
-
- 0 replies
- 633 views
- 2 followers
-
-
Hi, I have a simple calculation field that consists of a fraction. The numerator and denominator are both number fields. On my layout, I've formatted the calculation field as a percent with a fixed number of decimals of "2". The result is decimal (not a percent), and the decimals are not fixed to 2 but instead have 16 numbers following the decimal. I've tried formatting the field as decimal with a fixed number of 2, and get the same result (16 numbers following the decimal). I've tried with and without storing calculation results. Any suggestions? Thank you, Jason
-
- 7 replies
- 1.3k views
- 2 followers
-
-
Hullo everyone! I'm using FM Pro 18 Advanced. I'm wondering if there's a way to format a field so that, should the content be longer than the field allows, the font is reduced until it is all visible. Basically, we have a couple of suppliers with extra- long product codes & at the moment they get cut off. (Increasing the field size takes away from the next field - which could also occasionally use this format...) Here's hoping! 🤞
-
- 1 reply
- 1.4k views
- 2 followers
-
-
Hello all, I have a small accounting solution with two tables: Dashboard and Expenses. On a layout based on the dashboard, I have a 10-row portal that displays all expenses. I'd like to be able to move from the first 10 rows to rows 11-20, and then 21-30, etc., and back, by simply clicking two arrows, so that there is no longer a need for the scroll bar. Can someone guide me through this? Thanks.
-
-
- 17 replies
- 2.1k views
- 2 followers
-
-
Hello all, I have a hosted db running on FMS 19. In the same folder, where the hosted db lies, (Databases), I have a small web project. How do I point my webviewer to the index.html file?
-
- 0 replies
- 5.1k views
- 1 follower
-
-
Hi all I'm trying to build a simple solution which tracks which PRODUCTS have been selected on an ORDER and filters the list of available products so that for each new line on the LINE ITEMS portal, those already chosen don't appear on the list. I have three tables: ORDERS, LINEITEMS (join table) and PRODUCTS. My proposed solution is: • Have an unstored calcuation field in ORDERS called Products Chosen set to dynamically populate a List of ProductIDs as they're chosen (by using the List function on the ProductIDs in related LINEITEMS.) • Choose items in the LINEITEMS portal on the ORDER based on a value list called PRODUCTS UNCHOSEN which refere…
-
-
- 16 replies
- 1.3k views
- 2 followers
-
-
I've created a value list of discount types based on a table of discount types. I have a specific order in which I'd like these sorted in a drop down list. Is there a way of sorting these besides the order in which the records were created? (Sorry, this shouldn't have gone into Portals. I don't see how to delete it)
-
- 9 replies
- 1.5k views
- 2 followers
-
-
Hi, I started a project from the invoice template in Filemaker 17 and I need some help formatting the print layout. My Invoice layout has different tabs for selecting different types of products, for example printing, framing, books and other products. Almost everything is working great, but I can't figure out how to format the print layout since it's not possible to have two body parts. This is the preview: This is the layout view: I can show the first tab's information in the print layout: I'd like to be able to show the "Framing" info and the other tabs' info when they are present. The fields in the other tabs are simila…
-
-
- 3 replies
- 1.6k views
- 2 followers
-
-
Hi everyone, I'm trying to adjust the invoice template to my invoice needs and I have it mostly working but I have one problem. I have this setup with a portal: The problem is, when I erase one of the records it erases the same line in all of the tabs. Is there a way to separate the different line items for each tab? Should Each tab come from a different table?
-
-
- 3 replies
- 1.3k views
- 1 follower
-
-
I have a summary field that shows the total of the prices of items listed in a portal. The summary field is a part of the table of line items, but is mainly viewed next to the portal, in another table. When I make changes to line items in the table (quantity, tax status, or discount), the summary field doesn't refresh unless I click somewhere on the layout outside of any field. Is there a way of doing this action by script? Refreshing the portal doesn't help, and re-looking up the value doesn't help (just gives an error).
-
- 2 replies
- 1.3k views
- 1 follower
-
-
I'm making a database of customers and inventory items to sell to them. I've created a file of work orders, which would contain a portal to line item records, each line item linking to the work order number, with a line item for each item sold, quantity, cost, etc. This seems pretty routine. I've created a script run from the work order file that runs a script in the line items file. This script does what is needed, linking to the work order with the requested item info. The problem is that when the script is done, the line item created, and the user is returned to the work order screen, the new line item does not appear in the portal. It will only appear wh…
-
- 5 replies
- 1.6k views
- 3 followers
-
-
Hi all, I have given this the old "college-try" and worked until I have exhausted all variations to get it to work. I would not post this here unless I exhausted my search for a solution. I have attached a file that "should" open up to the "Paper Thickness" layout. I have reworked the file to try and explain with note labels what you are seeing and the troubles I am having. To me, it is bizarre. It kinda works and gives a weird unexpected result when creating a "first" record in the table. It is behaving as if there is no "internal" index of the "second field" display configuration on the Dwindling Value List I created - but only for the first record. In ad…
-
- 6 replies
- 2.2k views
- 2 followers
-
-
Hi there, I have attached a sample version of my database here, which I hope will help. My set up: We have grant schemes with applications. Each application is applying for funding which will come from a variety of sources: some from the scheme, some from us ("AIBN" in the database), some that the applicant needs to provide themselves ("AIBN group" in the database). There are numerous groups. The funding is also provided across several years, so AIBN might provide $50k in Year 1, $20k in Year 2 and $30k in Year 3, a total of $100k. Most schemes are only across a maximum of 5 years. Funding is added to the Application record via a portal linking to Finance.…
-
- 3 replies
- 1.5k views
- 1 follower
-
-
Hi all, I have created a "Dwindling Value List" that appears to be working. However, after I have "assigned" all of the available values from the "dwindling list" as I build out records, I am presented with a default message that says "<no values defiend>". I understand the massage, but prefer the message to say something more specific and understandable to a User (and myself). If I could customize the message to read: "All widgets have been assigned." or something that makes sense in the context of its use. For example: All available "People" have been assigned a "Task". All available "Cars" have been "Rented" . Is th…
-
-
- 4 replies
- 1.4k views
- 2 followers
-
-
Hi all, In FORM view I created some pop-up value lists assigned to fields defined as foreign key fields to related records from another table. The value lists are defined as using the "id" of the first field, and displaying the second field "name". Nothing unusual with this and works as intended. In TABLE view, the field functions just as it does in FORM view. This is fine for "data-entry" and functions as one would expect. However, there are times when I wish to see the values from the first field in TABLE view, and not the "display values from second field". How can I achieve this? I have poked around to see if the might be a configuration …
-
- 13 replies
- 2.4k views
- 1 follower
-
-
Looking for any tips. I have a very involved file, a complete software package for people wanting to offer Career Coaching. There are fields that information gets entered into, and a variety of functions to assist in the career process. I want to convert the entire file for use in China. Mainly thats a manual process, translating each label, the help text, etc. I plan to get someone to go through the file, first using machine translation, and then refining it so it flows properly, and is not just clunky sounding. Some of this is on the layout, and some is related to information currently in fields. So, everything has to be translated. Its a big project. An…
-
- 0 replies
- 1k views
- 1 follower
-
-
I was adding files to a tab, which is very hard if you haven't worked with tabs in some time. Hard to select exactly what you want to. Somehow one of the tab names disappeared. The name for the fourth tab should be send. I can't see how to recover it in the tabs setup: As you can see, the same appears correctly in Tab Control Setup. How to get it to reappear? Thanks.
-
- 2 replies
- 1.4k views
- 1 follower
-
-
Hi there, I'm curious how I can adjust the height of a the tab portion of the tab control? I don't see a way to do it natively in FMP, but using BaseElements or MonkeyBread, I can copy the tab control and get the XML. I've played around with it, but don't see anything readily apparent? Any suggestions would be appreciated.
-
- 2 replies
- 2k views
- 1 follower
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online