FileMaker Interface Features
-
I'm trying to capture the action of a user clicking outside a popover to dismiss it instead of using escape or a close button. I have a field in the popover that has a onObjectExit script trigger to perform a find. I have it setup to exit the script if they type Escape, or to show a custom dialog if nothing is entered into the find field and they type the enter key. My problem is that I want to subvert the dialog if they just click out of the field onto the layout (slide Panel), but I see no way to capture this action. "Get ( ActiveLayoutObjectName )" doesn't work because they're not clicking into anything that would trigger that.
-
- 3 replies
- 3.8k views
-
-
Hello all and happy New Year! I am working into my first and only solution which expanded quite a bit. Now it has 4 modules: HRM, LOGISTICS, CALENDAR and DOC MANAGEMENT I would like to have a UI similar to what is proposed widely today : A fixed sidebar accordion menu. The reason is because I think this type of menu kind of orientates the user in the app. Where he is and where he can go. Is there a way to achieve this in FM18? What are your thoughts on this kind of UI and the alternatives? I have already built an accordion menu shown on a card window - with the limitation that is not visible all the time. Thanks a lo…
-
- 0 replies
- 5.5k views
-
-
I'm currently optimizing a solution with approximately 1000 layouts. I know that at most 10% of these are being used, and would like to delete the others. Usually when I do this I put a text block on all layouts saying something like "IS THIS LAYOUT USED? IF SO INFORM ME [DATE]" Going throught 1000 layouts it's kinda tedious. Is there some kind of third party tool or other solution that can help me with this? Copy Paste is the only option I know of. Tia, Andreas
-
- 11 replies
- 4.2k views
-
-
Hello, I have a layout with about a dozen tab controls, each dealing with a different FileMaker subject matter. In each tab, there is a text field intended to store notes about FM. I’d like to be able to do a search for specific words in each of these text fields and, if the word is found, I’d like it to be highlighted. Is this feasible? Or should I take a different approach for storing these notes and being able to search them? Thanks.
-
- 9 replies
- 4.3k views
-
-
Hi! I have a list view which have 7 "columns" (Monday to Sunday) and about 50 records (rows). Looks like an Excel sheet with numbers. Is it somehow possible to highlight ALL similar numbers on the table (i.e. in all records) when I enter one field. Meaning... If there is number 1002 in the first record on Monday, entering the field would highlight all "1002" -containing fields in all the record. Conditional highlight seems only handle that one active record. I was thinking also a possibility to do a script trigger which runs thru all the fields and highlights similar numbers when entering any of those fields. Did anyone understand what I'm trying to do...?😁
-
-
- 2 replies
- 3.6k views
-
-
Hi, I'd like to create a Portal with Categories for a single, rather large file with items. Each item is coded. The first 3 characters in the code define the Category. So, I'm thinking of filtering the items into Portal Categories like this: IF Left ( CODE; 3) = "321" Then show items in Category 1 IF Left ( CODE; 3) = "331" Then show items in Category 2 IF Left ( CODE; 3) = "341" Then show items in Category 3 ...and so on What should the real code be? All the very best, Daniel
-
- 3 replies
- 3.7k views
-
-
Hi Forum. I have a good fun problem for y'all here.... I generate a report in FM11 (Windows XP) and look at it in Preview Mode. It has 106 pages and i can see them all in preview mode and scroll all the way to the last page. My Report pages are numbered at the bottom it says on each page "Page 33 out of 106" "Page 34 out of 106" "Page 35 out of 106" etc and the last page says "Page 106 out of 106" Now I do SAVE AS PDF from the Menu while in preview Mode. My PDF is only 97 Pages long. The last page in the pdf says "Page 97 out of 106" All the information is in the pdf. I compared the screen output to the pdf. All the info is in the pdf, but…
-
- 2 replies
- 4.3k views
-
-
Is there any way to show the Drop Down list without the mouse, when "Include arrow to show and hide list" is active? Example: TheField has a Control Style set to Drop Down list with Include arrow to show and hide list. My cursor is currently in TheField. I want to activate the Drop Down menu without using the mouse. A possible solution would be to have a copy of TheField below the other one. This copy would be set to Drop Down list, but with Include arrow un-checked. Then, create a Script that goes to this copy, thus activating the Drop Down list. However, I am intending to use this field in a portal, and it would be awful lot of copies of the fi…
-
-
- 2 replies
- 3.2k views
-
-
I have a portal where I navigate with arrows, with the help of Script Trigger > OnObjectKeystroke. I also have drop down lists in some of the fields in this portal. It turns out that OnObjectKeystroke don't activate in drop down menus. Is there a workaround for this?
-
- 1 reply
- 2.8k views
-
-
Hi, all! I find this issue hard to google, so I bring it up here. I'm sure many people have had the same issue, but I could not find any thread on the matter. I have several value lists made from tables, where the primary key is stored but some other secondary field is displayed in popup-menus. Quite often, the choice is removed, and in it stead, a five digit number appears. The number is not the same as any primary key value in the table behind the value list. I then have to manually re store the choices. The relationship is also broken. Can anything be done to prevent this from happening? Thank you for your help
-
- 0 replies
- 3k views
-
-
I’ve got a database of film screenings, and am encountering some confusion when it comes to displaying data in a portal. I have a layout that displays a director’s name and then lists each of the films by that director that I’ve screened. Next to the title of each film, the portal displays the number of screenings of that title, and data about the earliest screening. My problem comes when there has been more than one screening of a particular title, and I’m unable to get the portal to properly display the correct city/state associated with the displayed venue for that earliest screening. In the case of a film with more than one screening, I can get the portal to disp…
-
- 8 replies
- 3.6k views
-
-
Hello My name is Jon Petrie and I am in the same boat as you are and I am trying to setup the samthing as you are with Filemaker To keep track of my bank transactions.
-
- 1 reply
- 3.2k views
-
-
ow can I add new data to a portal or to a related table?using another layout.? like this one;
-
- 6 replies
- 3.1k views
-
-
Hi, I have field 1, which is set at Checkbox Set and uses a value list of three items (A, B, C). Then I have field 2, which I’d like to be able to hide whenever A or C, or both, is checked in field 1. Hiding field 2 when A or C of field 1 is checked works fine. But I can’t manage to hide it when both A and C are checked. I’ve tried several different calculations but nothing seems to work. Is this feasible? Thanks for your help.
-
- 3 replies
- 3k views
-
-
Hi! I'm new to the forum and I don't know if this is the right place, if I'm not sorry. I am developing a database for a project in my school subject and I can't finish could they help me? The teacher asked us to create a formula so that following the SSN criteria and randomly and automatically the filemaker gave this number. The example he gave was as follows: When creating a new record student A automatically received the following SSN: ###-##-1234 which according to the same criteria is valid, repeating the same step student B automatically received the following SSN: ##-##-1235 which according to the criteria is the same.
-
- 6 replies
- 3.4k views
-
-
Perhaps this issue has been dealt with before, but I couldn't find anything in the posts about it. Does anyone know if it is possible to tell FileMaker to keep the subsummary and the body together? I never want to have a page that only has the subsummary without the body with it, but I also don't want to make every subsummary break a new page. Any help?
-
- 4 replies
- 3.7k views
-
-
I am developing a database and I need help meeting the required goals. It is a company that has about 450 branches, divided by 50 states, that they are divided into 9 regions. 3 layouts were created for the same divisions. Basically when an agency logs in they have about 12 buttons in the layout and clicking one goes to the agency information. Example: Agency 153 logs in and goes to layout A clicks the button and goes to the information for that agency. Agency 345 logs in and goes to layout A clicks the button and goes to this agency information. The same theory applies to states and regions. The big question how to implement this? I've tried…
-
- 2 replies
- 2.5k views
-
-
Hello, I have followed the step-by-step tutorial offered by Filemaker to use the tasks add-on for the event management template. Everything seems to work perfectly, EXCEPT I can't get the task card to open in edit mode... Thus I can't edit any task information once I create the task, and I cannot delete either. I realize it's hard to help from such limited info, as there are a number of scripts involved. I can only say I wrote the scripts EXACTLY as instructed by the tutorial, and yet, no editing posibility. Any suggestions?
-
- 15 replies
- 4.5k views
-
-
I have an address record with seven fields. To enter the data, my users like to tab through the fields in a set order. One of the fields is set to pop up list with a value list of world countries, the first of which is 'United Kingdom'. My problem is that if I click in the field with the mouse, the popup is triggered and the value list is displayed for selection with the mouse. However, if I tab through the list, when I tab into the field the popup is not triggered so the value list of countries is not displayed for selection. How can I set the layout so that tabbing into that field will show the popup list?
-
- 2 replies
- 2.9k views
-
-
The problem is I have a value list that is based on 2 fields from another table, the first field is Order and the second is the Description, but it only populates with the first field which is a number and doesn't make sense. We need the description. I've had this problem before and worked around it, and I wish there was a simple way to solve this. So I made a calculation that concatenates the 2 fields for the value list, and the script trigger sets the field with the description without the number included (the script trigger does other things as well). But I realize not all of the value list is sorted correctly because it's a text field. Maybe a new calculation? So…
-
- 7 replies
- 4.3k views
-
-
I'm hoping someone might be able to help, or at least point me in the right direction. I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. Any suggestions on how I might be able to achieve this? …
-
- 4 replies
- 4.3k views
-
-
Hi, I’d like to create a window, for lack of a better term, that opens up in a layout when a predetermined event happens. Is this feasible in FM? Could someone give me some guidance as to how to proceed? I guess I’ll need a script to make this work. I hope my description is clear enough. This is my first post on this forum. Thanks.
-
-
- 4 replies
- 3k views
-
-
The database that I maintain at the moment has a simple text field for “Order Notes” which is used for various miscellaneous notes that don’t fit into any of the other fields. It’s a bit of a “catch all” receptacle. A couple of problems have emerged recently. One is that staff have been relying on notes that have been written quite some time ago, treating it as “gospel” when in some cases it has been superseded. What I’d like to do is have an indication on the field of when the information was input. It wouldn’t be hard to add a timestamp that is changed when the field is updated. The drawback I see with that approach is every alteration, no matter how minor, u…
-
- 1 reply
- 3.3k views
-
-
I had a use case where the user could select the background colour for a record in a list. While it's easy to select a background colour it's less obvious how to make it user-adjustable. I found a similar example which I've simplified to do this. It creates a container with a coloured image in it which is the cleanest way for my needs. This can then be used as a background image. It could be linked to a web viewer containing a Colour Picker but it's not needed here. Please let me know what you think and if it can be made more efficient or if there's another way of doing this. Generate Colour.zip
-
- 1 reply
- 2.6k views
-
-
I've got 4 tables. Product, Vendor, VendorProducts and Product Price. A Product can have multiple Vendors. Each Vendor has their own price for a product. My issue is I want to also Track the Price changes a vendor makes but also show the latest pricing when looking at a product. When setting up the Portal to list the VendorProducts on Products is not an issue but returning the latest Product Price based on a timestamp is the issue. I could create a script to place the latest price in the VendorProduct but that seems like the wrong approach.. The other thought is maybe create a Calc Field in VendorProducts to return the price is thats possible? Or maybe there …
-
- 4 replies
- 3.3k views
-
-
I am looking to eliminate the scroll bar being shown and add a visual identifier that more data is available. The scroll function still works and will show up once the mouse scrolls, of course. Example. Portal number of rows = 25 Number of records = 50 Visual cue to scroll down, or up, or both. Any point in the right direction would be great.
-
- 1 reply
- 3.5k views
-
-
Hi there, I am sure there is a really simple answer to this but I just can't crack it. I have two related tables: Property and AoPC. Each Property will belong in a particular AoPC. I have set up the relationship and a set of tabs on a layout in the AoPC table. Each tab has a portal showing particular properties in that AoPC depending on the value in another field in the Property table called Influence. The Portal Filter calculation is really simple: If(Property::Influence = "25m";"25m";""), with a different value for each portal. There are three possible values in the Influence field: 25m, 40m or GWD. For 25m and 40m, this works perfectly. Also if the portal is…
-
- 2 replies
- 3.3k views
-
-
We have a table containing time bookings for all of our staff. Its the data for a calendar so has: Name, Start Date, End Date, Start Time, End Time, Description. We also have a table which is just the names of the people. We have a week planner view which I made by 7 relationships and portals, works reasonably well, apart from if you are viewing quite a few peoples records at the same time it takes some time to update. I have 2 Questions: Is there a slicker way than having 7 portals? The blocks do not join up with each other. (See Example) Our business want to make a much bigger view that shows 3 months at a time, for each person. Imagine the data …
-
- 0 replies
- 4.8k views
-
-
Hi. How can i do this? I have one template and i want to duplicate this template but i duplicate the layout the field contents is the same the each layout. How to do it so that the same data is not always the same? https://imgur.com/NWcAB1E The picture is same all layout, how to change this?
-
- 2 replies
- 2k views
-
-
How do I conditional farmat a portal row based off matching fields in another portal? I have created a table for employees with thier schedule for next 3 weeks. A global table so I may have two incidents of the same table filtered by global fields. This way I can display two employees schedules side by side using one table. So Table1 with Store Number, Employee Name, Work Date, Start Time, End Time. Table2 Store Number, Trainer Name(Global), Traniee Name(Global). Related field Table1::Store Number to Table2::Store Number. Table1 Copy::Store Number to Table2::Store Numbe…
-
- 0 replies
- 3.8k views
-
-
Hi all, I have a problem similar to the one discussed in this thread. It was suggested that the active tab could be captured using a normal script step with a script trigger on exiting the layout, but I can't find the proper script step. I messed around with OnPanelSwitch and GetLayoutObjectAttribute, but whatever I tried, didn't work. At least, going back to the proper tab with Go to Object is easy. Thanks for any help,
-
-
- 8 replies
- 4k views
-
-
Hi all, I have a pretty simple navigation scheme with six buttons that are attached to this script: Go to Layout (Get (ScriptParameter)) I pass the name of the layout as the script parameter and it takes me to the corresponding layout. This works for five buttons, but one refuses to do anything. I've been tearing my hair out and squinting at the screen, trying to find a typo in the script parameter or the layout name, even deleted and carefully retyped, but it all looks good to me. The only thing that was different is the fact that I've added that particular layout after the button was already on the other layouts, but I can't see how tha…
-
-
- 26 replies
- 4.4k views
-
-
I found several similar posts, but nothing that seems to fully address what I need. To start with, I have a calculation field that determines a maximum value for each record. I need to create another field that provides a list of numbers with a specific starting point, specific increment, and that maximum value field as the last number. Then, I need to create a value list that uses the values from that list field. The net result should be a pop-up menu that contains a list of numbers up to a maximum value associated with that record. i.e. record 1 will show the following list in the pop-up menu: 50, 60, 70, 80, 90; while record 2 will show: 50, 60, 70; while rec…
-
- 11 replies
- 11.2k views
-
-
I have a TODO list. Some tasks I want to put off until tomorrow, but have them re-appear on my TODO List the following day. I have two tables; TODAY, and TOMORROW. I can get the individual records to go to the TOMORROW table ok by just using a button and script. This operates on only one task at a time. I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the following day. I date the records going to the TOMORROW table and have tried to use this as a criteria to send them back to the TODAY table. One problem is that there are often numerous records and not just the one that need to be sent back. I have t…
-
- 3 replies
- 2.1k views
-
-
In list view I want to be able to "grab" an object so I can move the record up or down in the found set. Is there a way to do this? It would be just like how an item on an list in an iPhone gets moved up or down. For example, on a play list in Music, I can change the order of songs to be played. Also, I would like to have this capability when I move my solution over to FileMaker Go Thanks!
-
- 1 reply
- 4.8k views
-
-
Good day all, My apologies if i am posting in the wrong group. I am looking for some advice to accomplish the following task. I have a database with 40 fields, i would like to create a dynamic layout that would show the fields with missing data. is something like this doable. I currently have a portal that show the users the records with missing data in the portal i want to add a button that will opens a window and displays the missing data fields. Thanks JMart
-
- 4 replies
- 1.5k views
-
-
Hello, I have a text field with a number of ID's separated by a carriage return and am in need of help creating a portal filter to return all of the child records that have IDs that are in the list of IDs. I have been working on using pattern count to no avail. Thanks for the help!
-
- 1 reply
- 3.5k views
-
-
Greets, all: I want to use a Conditional Formatting calc to apply to a set of (required) fields in a portal so that empty ones are highlighted in the first row of a portal, only. (The logic is that the portal must contain at least one record, so only first row needs to be used as a flag to users.) I tried using Get ( ActivePortalRowNumber ) in the calc but the problem is that unless a portal row is active it doesn't have row number. Any ideas? TIA for your help!
-
- 7 replies
- 4.4k views
-
-
Hello, I have a portal that is moving around my layout. In edit mode, where the columns are aligned properly with the headers. list view browse mode, where the portal has moved to the right. I don't have any sliding enabled. Thank you in advance for the help
-
- 2 replies
- 1.6k views
-
-
Good Morning! What is the best way to achieve this type of layout where I can have 4-5 tables shown and sorted with hundreds of accounts on one layout/page? Would you suggest 4-5 portals with filtered settings or is there a better way?
-
- 3 replies
- 1.4k views
-
-
I've been working on a planner-style layout as part of a rental management package that I haphazardly develop. The idea behind the layout is to let users see, at a glance, how availability is looking for a particular item. There's a screenshot of it attached below. The items displayed are all records in my Order_Item table, they are essentially "line items" on a hire invoice. The planner itself is based in a separate table, with the items related using a Link-all arrangement. Then the portal is filtered to include only the relevant items. (The date range is constrained, and the item name is filtered via a PatternCount function) The blocks of colour that you see…
-
-
- 15 replies
- 5.6k views
-
-
I like to see the page margins when working in layout mode. However, View page margins is always grayed out. This happens in all my FM 17 solutions, all layouts. How can I view page margins?
-
- 4 replies
- 1.4k views
-
-
I was looking for an easy way to get a record count of a portal and couldn't see how to do it anywhere. Luckily I found a workaround to do it and thought I'd share. Select Insert | Other Symbol. Select FoundCount. Move the new merge field into a portal row. Hide the merge field by setting 'Hide object when' to True. Give the merge field a name, for example 'PortalCount'. Now you can use the following calculation to find the total row count for the portal: GetLayoutObjectAttribute ( "PortalCount" ; "content" ) Obviously you can change 'PortalCount' to whatever you like. If there's an easier (and less hacky) way to do this…
-
- 6 replies
- 3.7k views
-
-
Hi all Apologies if this is doubling up, I have posted this here also https://fmforums.com/topic/104916-display-multi-line-records/?tab=comments#comment-475037 but I think this might be the better in this forum. It's quite a fundamental thing so I worry I've been using FileMaker wrong all this time! Is there a way, without the webviewer, to view a stream of multline records in browse mode? So, if I were to have a list of email messages, in which the body field has multiple lines, I would be able to see all those lines within each record. Rather than each record's body field being a fixed height thus resulting in cut off text. Thanks
-
- 1 reply
- 697 views
-
-
I have a parent table with contacts. This points to a child table in a portal with various skills the contacts have. Some contacts may not have any skills filled out, others may have one or several. Adding skills dynamically fills a value list of all entries in this field. There is also a portal which shows all contacts and I want to be able to filter it by skill. So I have added a global field, formatted as a drop down menu listing all the skills. So far, so good. Choosing a skill is supposed to filter the portal with all matching contacts, of course, but this does not work. I can kind of see why it doesn’t work, based on the way I set up the relationship, but …
-
-
- 5 replies
- 2.6k views
-
-
I'm not well versed in summary layout parts and reports, but am trying to learn. I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked). After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in th…
-
-
- 4 replies
- 1.1k views
-
-
Hello, I’m working on an intergation with WhatsApp. Further down the line it will use the WhatsApp API but as a short term solution I had hoped to just open the WhatsApp web client in a WebViewer. When I open it, however, it says that it needs Safari 9+. I’m running Mojave with Safari 12.1.1 Any help as to why it’s asking for 9+ when it has 12? I also get the same thing when trying to access Google Drive through a WebViewer. The following code gives the following result: data:text/html, <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <style> &…
-
- 0 replies
- 3.5k views
-
-
Hi all, I have a layout with a portal from another table. At the end of the row there is a button you click to take you to another layout to add more information. Problem is no matter what button you hit on any row, it always takes you to the last record entered. Here is a video to explain it better: https://vimeo.com/350021672/a29ff64e2f Any help would be greatly appreciated. Thank you, Peter
-
- 3 replies
- 2.3k views
-
-
Can this device be usable to connect to filemaker? https://www.amazon.com/Worlds-First-Bilateral-Magpie-Tech/dp/B07975RT7L
-
- 0 replies
- 4.3k views
-
-
My horizontal scroll bar has disappeared. What should I do to restore it?
-
- 1 reply
- 772 views
-
-
I have a billing system, from customer data. I have a script to create new invoice, it always worked fine. suddenly crashed and the filemaker closes whenever I intend to create a new invoice. Thanks for any suggestions to solve.
-
- 1 reply
- 696 views
-
-
I am trying to extract lines entered in a repeating text field (named "Equip" w/10 reps) into separate fields (Equip1...Equip 2...etc) I am trying to modify (add to) a large existing database with alternate layouts so I can manage all the data better. I would assume a calculation or script to populate the alternate layout fields with the extracted data... Or perhaps a better idea? Any help is greatly appreciated!
-
- 8 replies
- 879 views
-
-
Hello. I need your help on something that maybe it's not too easy to make. I manage a database of more than 40.000 records. Each record has at least 2 images from a related table. You can imagine how big is the database. I'm trying to build a gallery view to facilitate the search of the articles, but I don't have all the skills to do it efficiently. I started by making some reversion engineering on Semantic-UI-FileMaker (contact layout - https://medium.com/@hummingtech/enhance-filemaker-layouts-with-semantic-ui-efbd1b1eca65), and graphically speaking I achieve the desir…
-
- 0 replies
- 4k views
-
-
I have created a list report with a value list assigning values to fields of certain colours. All from 1 table – no related values. Layout is based on the same table. The script filters the number of records with a certain colour. The script button is located in the footer of the report. Excursion scripts: Departure show Pink Set Variable [ $DeptG; Value:customer::Dep_Date ] Go to Layout [ “Departure_List” (customer) ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: customer::Bus_Color: “=Pink” ] [ Restore ] Commit Records/Requests Set Field [ customer::Dep_Date; $DeptG ] Perform Find [ ] (This script is assigned to 6…
-
- 2 replies
- 784 views
-
-
So I am fairly new to this and I am trying to get a inventory database set up. I am working on making the database a that is in 3nf. I am trying to pull information on a drop down menu from different tables. I have attached how they are related below. The input menu does not show me anything from the drop down menu, though there is data there. Do I need to create a desperate table for title data where I store information or am I missing a step to pulling the data from the other table?
-
- 1 reply
- 5k views
-
-
What I am tring to do is add a css field that has all the css in it and the same for javascript. there are two fields one is named css and the other js 2. I must be missing something because the webviewer is not diplaying all the css. I know very little about html. Thanks "data:text/html," & "<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">" & "¶" & "<head>"& "¶" & "<meta http-equiv="Content-type" content="text/html; charset=utf-8">"& "¶" & "<title>"</title>"& "¶" & "<script type="text/javascript" " &a…
-
- 2 replies
- 7.9k views
-
-
Hi everyone, I have a layout that I want to enter only one user at a time, i try a field where a script trigger on open layout makes a set field "1" and when closing the layout deletes it, so when another user enter the layout if the field is "1" denies the access, but if filemaker crash or the connection is lost, that field stays in 1 and nobody can enter the layout, how can this be solved? Thank you in advance for your help.
-
- 6 replies
- 1.5k views
-
-
I have a table layout but within the rows of that table layout is a portal that basically shows the last record created date, username and text. I believe this is massively slowing down my layout. When I remove the portal the layout speeds up and loads dramatically faster. my thought was to create a stored calculation field that changes or displays data from the last portal records and updates when other portal records are created. I would just now need to show the 1 calculation field on each row instead of having the portal Any thoughts on this idea?
-
- 3 replies
- 2.7k views
-
-
(I apologize if this isn't the correct forum for this, so feel free to move it to the proper one, please.) I'm stuck. I built a solution with a parent-child portal setup, the user can see the four, court reservations for the day (Current Setup attachment). However, she'd like to be able to see a "big picture" view as depicted in the Capture 5 attachment. I figure a popover or a jump to another layout is in order, but beyond that I don't know how to pull this off schema-wise, especially when it comes to filling out a range of time slots shown in Capture 5, e.g., Court 1 would have the time slots 8:00 and 8:30 populated with Practice (Emilio Lizard), blank spaces …
-
-
- 4 replies
- 1k views
-
-
I would like my users to input the time in the format HHMM (ie, just numbers, without any delimeter), and it should automatically convert it to correct time format. I have experimented a bit with this, but can't get it to work 100%. Eg; with the below calculation it works for all times after noon. Ie, "1215" converts it correctly to 12:15, but "0830" will not (it will be converted to "83:00"). Let ( $Timein = GetAsText ( indata ) ; Time ( Left ( $Timein ; 2 ) ; Middle ( $Timein ; 3; 2 ) ; "00" ) ) Is there anyone that already have done this satisfactory?
-
-
- 9 replies
- 6k views
-
-
Hi All, I'm going to try and explain this as best I can, so feel free to ask questions if something is unclear! I am building a database for clinical mental health. In working with clients, users will need to document a variety of forms using different measures, like an MSE, PHQ, DA, and other "forms" (the abbreviations shouldn't be relevant). On the client's dashboard, I'd like a portal showing all of their documents/forms that have been entered, but I dont want to have individual portals for each type of form, I'd like them to all be shown on the same portal. What would be the easiest way to do this? Is the best way to add fields from ALL of the forms to one t…
-
- 3 replies
- 2.6k views
-
-
I have been watching and re-watching a web seminar by Mark Richman called "Eight ways to make Filemaker databases run even faster. https://www.youtube.com/watch?v=yNRNMgs--T4&spfreload=10 The basic goal is to minimize the packets of information that need to come down from and go back up to the server. He makes the statement that "if you can see it or touch it, it invokes the data" . To this end he advocates for using more layouts with fewer objects per layout. My question has to do with how visibility factors into this. A database I am creating for my cabinet shop has a lot of graphics that are grouped together with fields…
-
-
- 5 replies
- 1.4k views
-
-
Hi All, Our database has properties and for each property there are multiple inspections per appliance, sometimes year to year sometimes quarterly. Anyway, we want the technicians in the field who are using iPads to view the history per property by swiping just to make it simple. Every swipe would be a different inspection for that property viewed in chronological order. Property part is "static" while they "page" or swipe through the inspections. I was thinking a slide control would work nicely, and each slide would be a different record for that property. I'm looking for ideas to jumpstart my thought processes, apparently my brain is having a hard time funct…
-
-
- 6 replies
- 5k views
-
-
Hi Guys In layouts when I drag a field onto the layout it always uses the same font. I cannot find a way to change the default font. So at the moment every field I drag onto the layout I have to change its font size and resize the field box. I have read through a few articles which don't seem to show the same for my Filemaker (V.17 Pro Adv). i.e. Edit, preferences, no font tab. Also, in layout don't select anything and then change the font attributes, but they are greyed out. I've looked at themes and styles but cannot make sense of it if this is where I need to look. Your advice would be greatly appreciated.
-
- 7 replies
- 3.4k views
-
-
Hi I am struggling to work out how to get my database to generate a report that shows the total characters for that day and not broken up by scenes. So it will show this is the total characters from the character field for that day from all the scenes. When you go on to the database. username admin password pirates it opens on the list layout. if you click on scenes then click on the report button for all units (the middle one) it will each scene for that day and the characters for that scene. What I am trying to do is get it to show all the unique character total for each unique one for that day. I thin it is the…
-
- 3 replies
- 951 views
-
-
I may be chasing rainbows, but is it possible to change the label/name inside a popover button using a variable (local or global)? I tried and failed, and was just wondering whether it's ignorance on my part of an available technique or it's just the way they are, i.e., statically assigned. Thanks! Rich
-
-
- 4 replies
- 4.3k views
-
-
Is it possible to copy a layout to another database? Relationships, field names etc are not a factor. Have a backup copy of my database. Messed up a layout and want to restore it by copying the layout from my backup copy of my database.
-
-
- 19 replies
- 36.2k views
-
-
Here’s the scenario. I’ve got a “Monthly Report” layout in my database, which has a collection of portals showing There is a “Monthly Report” table which is linked to Orders via a many-to-many relationship. Each portal then filters based on multiple criteria, a combination of the date range and division/category. This way rental is separated out from sales income etc. etc. I’ve set up summary portals as well, using the single-line technique that I learnt from another thread here. So far, this is all working well and the admin staff are finding it really useful. Naturally, this makes them ask for more features. The latest request is to be able to see the p…
-
- 3 replies
- 3.8k views
-
-
Greets, all: I have a popover in a filtered portal (same child table but filtered on Court Number) where, when clicked, appears so a user can edit that child record's info. The problem is, the popover button only appears in the first portal row; I looked in FileMaker Pro's Help entry online but it doesn't make mention of this. Am I missing something or this is normal behavior? If it is normal, is there a quick-'n'-dirty workaround? TIA for your help, Rich
-
- 3 replies
- 6k views
-
-
Hi All, Basically the layout we have has many tab panels, and I have a forward and back button that navigates through the layouts. What they would like is when they come back to this layout it goes to the last tab panel (s) they were out. I would think a script that stores the isfrontpanel (layoutobjectattribute) in a merge variable but I am having a hard time figuring this out. It seems like it should be simpler and perhaps my brain isn't working correctly this morning (it happens! Lol). Can't see the forest for the trees. I included a screen shot as an example.
-
-
- 3 replies
- 964 views
-
-
I have a list with three fields of data. The first is 'task', and the next two have autofills for 'not urgent' and 'incomplete. If the task field is empty I would like the record to automatically delete. I have messed about with 'IF (isempty)' but having no success. Any assistance would be appreciated please.
-
- 7 replies
- 1.6k views
-
-
I have searched and my question does not seem to be asked. I am confused on when to use one or the other when I want to take a person back to a field. so example person types into a field A and before leaving layout I check many things that they did. I see they need to correct field A so I show custom message as to why and i want to take them back to field A. this is all on open record not allow commit first. Is it best to object name field A and use Go To Object or use Go To field? ps i have field validation usually also but i like to use nicer messages. Also I do not always know the message i want to give them until they are finished with several fields. Ca…
-
-
- 2 replies
- 734 views
-
-
FM 17 I have a tracking log in the form of a portal where we enter data of shipments. Date input is drop down calendar. No problem. There is also a field to keep track when the shipment comes back. Date field with drop down calendar. The input on the first portal row goes instantly. The input in the other portal rows is only after 3 to 5 seconds. The drop down calendar stays visible for the given time (3 to 5 seconds) Removing the drop down calendar from the field and doing the input manually, instantly. Any idea? There is nothing complicated not fancy. Just a simple portal, simple relationship. TIA
-
- 2 replies
- 2.6k views
-
-
So right now I want to hide my Parts Purchased tab if there are no invoices. a customer has tab bar with their history, accounts, invoices and other stuff. I want them all to show. but if customer does not yet have an invoice I want to hide their parts. Can I do this? if not, what would you do so staff knows not to go to that tab? I tried changing the color but failed and it is not clear to staff even if i succeeded. thank you for thinking about my need.
-
- 4 replies
- 6.7k views
-
-
Spoiler Spoiler I have an inventory database with several different types of inventory in it. I would love to have at the top of the header a count of each type of device I have. The Column name is "Device Type", and right now I only have four different types of devices, "Printer, CiscoPhone, DockStation, and Lablemaker". I would love to have a counter in the header for each device so I can simply see how many of each device I have. I can't seem to find a way to do this, and I am sure there must be. Could you please help me out?? Thanks!!!!!!!!!!! pic1.docx
-
- 2 replies
- 4.7k views
-
-
When I set a text object as a button to perform a script, it becomes “Grouped”. I find selecting the text for editing is very difficult. One option is to ungroup the object but then the button is deleted. Is there a simple way to select and edit the text without ungrouping it?
-
- 1 reply
- 733 views
-
-
Hi, new member here - I'm wondering, I've created more than 10 scripts and I'd love to be able to assign custom keyboard commands to each one. Is there a way to do this? Thanks in advance!
-
- 3 replies
- 11.2k views
-
-
I've been gradually working on a planner layout, which uses a portal and conditional formatting to display availability of hire items. It's working well so far, and is proving popular with users. At the moment, I'm using portal filtering to narrow down the selection in the portal, typically to just one product/item. Each occurrence in an order is displayed in a portal row. What I'd like to be able to do is temporarily exclude an item from the portal results. Sometimes the query used to filter the portal is too broad, or we have a very similarly named item that turns up when it isn't relevant. In an ideal world, the user would hit a button on that portal row, and it …
-
- 6 replies
- 1.9k views
-
-
Hey.... Maybe this is a beaten topic....perhaps? While FM templates are amazing....does anyone know where to get free templates off the beaten path? I am a designer.....just looking for fresh ideas honestly. I want to see some cool layouts. Not the programing but the user interface. Every database can use a little refresher, visually. Thanks Mike
-
- 0 replies
- 763 views
-
-
I go to View Show and select buttons but it never sticks. Once I close the file and reopen it, it no longer shows them. Can I make that setting stick?
-
-
- 2 replies
- 771 views
-
-
I have a couple of layouts (dialogs) that are invoked through a script with any number of button bars on them. One button would cancel the script/layout dialog, another would OK it and then there's buttons that change settings. In order for this to work I pause the script indefinitely, in a loop and check which button gets pressed. I then take action accordingly (ie, if the cancel button is pressed I exit the loop). To do this each button on the button bar needs to have the option "Resume Current Script" enabled. So I've checked this was so by opening the Button Bar Setup dialog and walking through the various buttons to check the setting is enabled. It didn't work …
-
- 1 reply
- 4k views
-
-
I've recently upgraded to FMP 17 from FMP 10. 10 was doing fine, but I had to get a new computer and 10 won't run on it, so 17 it is. All of my existing files are running just fine, but I've now created a new file for something and have run into something that's driving me nuts. I have a layout that is set to view as a list. And my most recently used row is highlighted. I can't get it to go away. In 10, the very left part of the row was selected, which was just fine, instead of always having one row highlighted.
-
- 2 replies
- 807 views
-
-
I have a value list that displays a fixed set of years: 2018, 2019, 2020...2030. I use it for creating new records. I've already used the years 2018 and 2019 to create records. Is there a way to filter the list so it only displays the values after 2019? Or, is there another way to do what I'm trying to do?
-
-
- 3 replies
- 3.3k views
-
-
Hi all, In my contacts table, I have a check box field where the user can categorize any contact into three categories that are used in several places throughout the solution. So a contact may be in the 'client' or 'personnel' category. Ideally I would end up with three value lists that can be applied anywhere a contact needs to be entered. For example, when creating an invoice the contacts menu would pop up a list of only those contacts that have the 'client' checkbox set. I keep running into problems with globals not being indexable or the popup list showing the contact ID along with the name which I don't want. So obviously I'm approaching this wrong. …
-
-
- 4 replies
- 2.6k views
-
-
Hi All, I'm guessing it's not possible, but I'm hoping it is none the less! I would like to conditionally format the colour of an entire portal row on a value from within that row. For example, I'd like all records with Field = "Yes" to be pink, instead of the default grey background for the portal. Is that something that can be done in FMP 16? Many thanks
-
-
- 2 replies
- 3.7k views
-
-
When I add a new record in a portal, I need to scroll down to the bottom of the portal where the blank record is created. There must be a way to avoid having to scroll to the bottom of every portal to add a record. Any help out there?
-
- 2 replies
- 2.9k views
-
-
I have a portal where tabbing from the last field on a row takes me out of the portal to a field elsewhere, rather than going to the next portal row. What is causing this behavior? (I feel like I'm missing something obvious.) Actually, there is only only one field on the portal rows that allows entry and is in the tab order. The idea is to tab from portal row to portal row, staying in this field. If I allow entry into another field on the portal row and put it in the tab order, this does not change the behavior. The field is in the layout's tab order; not the last object in the tab order. The portal is based on relationship that allows creation of new records. T…
-
- 1 reply
- 3.5k views
-
-
Hi all, I ran into a bit of a problem, if you could please count me in the right direction. The question is actually 2 fold. In my table table I have a category and part number etc etc etc There is 5 categories On my layout I have 5 portals which i want to point to the different categories, so each portal should only reflect one category on each portal there is a dropdown to select the part number but again, if I am in portal for category 1, I only want to see part numbers for category 1 I am not sure how to limit each portal to only one specific category nor how to limit each dropdown to only one category. I tried using include onl…
-
-
- 5 replies
- 1.5k views
-
-
Hi, This is a peculiar bug which seems to have appeared with a recent Chrome update. Create a Web Viewer control with the following content: "data:text/html,<html><body bgcolor=\"#EEEEEE\">HELLO</body></html>" Then view the layout in WebDirect in Chrome. You'll notice it doesn't display anything. Remove the bgcolor and it works as expected. It also works in FileMaker. There are numerous workarounds but I can't find out how to fix it. Anyone else experienced this?
-
- 2 replies
- 4.6k views
-
-
is there anyway to show tooltip on button
-
-
- 2 replies
- 3.9k views
-
-
I’ve been working on a database for a rental company, on and off, for quite a few years. Some of the answers to my previous queries here have been really useful in moving things along. The volume of orders has increased to the point where we need to track things more carefully. The crucial bit is spotting shortages/overbooking, but it would also be useful to generate proper reports on hire volumes for each item, rather than relying on anecdotal evidence. However, the actual "line items” on each order are just text fields that users can freely enter. We try and impose some discipline with consistent names for popular items, but there’s always a fair bit of deviat…
-
- 15 replies
- 5.8k views
-
-
Hi everyone, I am loading lat and lng coordinates from logged from Filemaker Go into our Filemaker that we use on the Mac into the webviewer displayed in a popup card window. Unfortunately, only part of the map is shown on the webviewer. I seem to be missing something. Played around with the different refresh and pause settings but nothing works. However, if I load the viewer into its card window 3 times, it shows correctly. In attach my code and how it renders - would anyone know what the issue is? It renders fine in filemaker go.... Thank you
-
- 0 replies
- 2.7k views
-
-
Hi all, Really hoping someone can help me with this database. It is being used to collect marine mammal data from aerial surveys. Each survey has many environmental records and each environmental record can have many sightings. Because the iPad GPS is not very reliable for elevation, I import a separate table of GPS waypoints from an external GPS and use Lookup to pull Latitude and Longitude and Altitude information based on matching or near matching timestamps. Some formulas use the GPS information (i.e. plane position) and an angle to the sightings to create a position for the sighting. I would love to map the GPS positions and the sighting positions in a WebViewer…
-
- 1 reply
- 2.7k views
-
-
Hi All, please could you give some background? I am working in layout FactoryAllocations. I have a drop down with records from my ATA Table my second drop down is from the FactoryPrice, but I only want to see part with the same ATA as selected in the first drop down. I have my relationship, Factory Price and ATA tbl with relationship between ATAChapter I have created a second bable instance for FactoryPrice and linked to ATA - ATAChapter In my second drop down, I Use value from the FactoryPrice_ATA Tbl and only include values starting from ATA. Still I get all record and not filtered. Is my understanding of this incorrect?
-
- 1 reply
- 2.5k views
-
-
In older versions of FileMaker Pro, I could click on a field, show the text ruler, and graphically set tab stops - as illustrated in the picture here: http://www.filemaker.com/help/12/fmp/html/edit_layout.10.44.html In FM14 Pro Advanced (Mac OS X) I can't for the life of me figure out how to get into this mode. I've tried showing and hiding every toolbar I can think of, but nothing seems to get me the magical TabStop ruler mode. I know I can edit the TabStops numerically (Inspector/Appearance/Tabs) but I like the old graphical way. Did they remove this feature?
-
-
- 15 replies
- 2.3k views
-
-
Dear Sir, i have 12 Images Random forms are irregular and i want to enter values (numbers) depending of these number how can i change these images color such example: if value no1 = 10 change color image no1 to red and if the number is 5 change the color to green ( 3 color for each value)
-
- 13 replies
- 5.1k views
-
-
My FM 17 Pro does not have a Page margin option in the View menu, in layout mode. How can I show the page margins in layout mode so I can see that everything fits on the page?
-
- 6 replies
- 1.3k views
-
-
Hi Everyone Can someone tell me if this is possible? I have a dashboard which displays services due, services outstanding, completed services and faults outstanding. What I want to do is put a little "badge" on the buttons displaying the amount of records showing in the portal related. I have no idea where to start. I have attached some images and also my relationship view. Thanks in advanced!
-
-
- 7 replies
- 5.7k views
-
-
I have a list (not in a portal) and a button at the end of each row. The button is to delete the entry if required. The button shows up on every list entry and clutters up the look. How can I get the button to only show for the selected record in the list please? Thanks.
-
-
- 5 replies
- 4.2k views
-
-
Hi everyone i was pleased to find out that auto complete had been introduced in FM Go 17, however, it’s still not working for me because I have a Sales form that has a Products drop down box. Now the first field for the value list is fkProductID, and I use the second field to draw a list of product names. But FileMaker advanced 17 will not allow autocomplete when two fields are used. I can’t get rid of the fkProductID from the drop down box because that breaks all the related fields on the form and the inventory stock control. Autocomplete is not a problem on FM Pro because even with it unchecked, you can type and it jumps to the correct product range. Problem …
-
- 0 replies
- 2.4k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online