FileMaker Interface Features
-
I am using a value list with a person's affiliation. They consist of offices, commissions and committees held. I know where to go to edit the list. When I print a report it prints phantom values. There are a couple that I originally created but do not see them in the list nor are they assigned to anyone. When I print the report it shows the value with no one tied to it. How can I find this phantom data in order to delete it. Many thanks. On further review - I think my difficulty can be in one of my three tables that are tied together. When I try to see what is in the Affiliations table I can only see one of the affiliations per person. It keeps the …
-
- 0 replies
- 1.1k views
-
-
In Table view, if the user's Privilege set has "Available Menu Commands" set to "Editing Only" then they can not sort fields by clicking the table column header (the "Sort Ascending" and "Sort Descending" popup menu items are missing). I've tried installing a custom menu set that has the "Sort" menu item available, but "Editing Only" seems to override this. If I use a Custom Menu Set and also set Available Menu Commands to "All" then the Sort Ascending and Sort Descending popups are available in Table View, but the user also gets access to a bunch of confusing / dangerous options such as "Add Leading Grand Summary" and others. Is there way to …
-
- 2 replies
- 4k views
-
-
Hi Anyone have an idea on how to display the Record number in a field? I want the field to display the record number every time I got to the "Next or Previous" (scroll through) record. Thanks in advance for any help. pyorkie
-
- 6 replies
- 4.6k views
-
-
Aloha All, DISCLAMER I'm not a programmer nor a technical writer and also is ESL. So my writing is tailored to me or someone like me aka noobie as F* (toward me not you). Detail and step by step and as clear as possible. Please let me know if i’d missed something or grammar correction. System: As of 04-20-2016 (not potting around) macOS 10.11.4 (yeah I’m using macOS name form now on instead of OS X), iOS 9.3.1, Filemaker Pro Advance 14.0.5 and GO 14.0.4 OBJECTIVE Make merge variable to show the slide control panel's object name (the name of the front most slide panel). So when the file is open the merge variable will show the name of the from mos…
-
- 0 replies
- 5.7k views
-
-
So have have products which have multiple part numbers and sizes. Part number table being the join table of products and sizes. While the portal view works fine on single product layout view to display sizes/partnumbers, it of course doesn't work within another portal view of scrolling products. I've used a button to open sizes/part numbers into a new window, but doesn't really work well on webdirect. I am trying to find out a way to pull the data into dummy fields that can host the portal data in order to display the information horizontally. field:Size 1 | field:Size 2 | field:Size 3 | field:Size 4 | field:Size 5 | field: Part 1 | field: Part 2 …
-
- 5 replies
- 1.3k views
-
-
i need to import records into a portal in my database but i have come across a number of problems. i have a table that contains a list of all products with product category, product name, product description etc. etc. the data i need to import is a list of products that are included in a quote for a customer. however, this data only includes product name, product description and quantity. to use this data i need to run a script that also finds the product category for each product before it imports it into the quote. currently i have a portal where i can select product category from a dropdown, then a second dropdown b…
-
- 3 replies
- 1.1k views
-
-
Hello, I'm using filemaker's built in Google Maps (US) to render a map from an address I have in my filemaker solution. I want to be able to put a circle within the rendered map and also some text. I cannot figure out how to make filemaker do that. Is there such a way or what are my options if there is not a way?
-
- 0 replies
- 1.4k views
-
-
I can't seem to find any examples of this, so I thought I'd try here. I want to build a product list that will have multiple levels (N number of levels). I would like to display it in several ways, but if I could start with a portal that would be great. Basically the list would look something like this: Item1 Item2 Item 2A Item 2A1 Item 2B Item3 The parent / child relationship in the DB is easy, but how can you do the indented display, etc...
-
- 6 replies
- 1.4k views
-
-
Hello Friend , Is there any way to make folders in work space scripts of different colours likely in table relationship there is an colour option. Thanking
-
- 6 replies
- 1.9k views
-
-
hi, fairly new to filemaker i have two portals each with various different fields inside but there are two fields i need to subtract which are "Qty Sold" and "Qty". both of these portals show records relating from the same table but i am unsure on how to calculate this function
-
- 1 reply
- 1.1k views
-
-
Hello, I think I have a knot in my brain and could use some help. Working on a simple database for a small school, which contains (amongst others) three tables: A students table (PK:StudentID) A table that contains a record for each class a student attends (PK: StudentID, ClassID). This table also contains a ProgramID (see below). A table that contains a record for each ProgramID along with a human readable description of the program The classes table contains a numeric field with the hours for that class. My requirement: On a layout that contains all the student details, I need to show a portal, which contains a list of the Programs tha…
-
- 2 replies
- 1.3k views
-
-
I have several layouts that contain large amounts of boilerplate text entered as text objects. I need to be able to enter a "soft return" (aka "line break" or "newline character") to force text to a new line without invoking the Line Spacing settings that control paragraphs separated by "hard returns" - like you get when you hit the Return key. But I can't find anything on the subject. This is not about importing or exporting anything. This is just about static text in a text object on a database layout. Is there a special character or command that can be used to force a soft return? No combination of shift - control - option & Return that I have tried a…
-
- 8 replies
- 8.7k views
-
-
Hi, I have Contacts portal on Company layout. Now, I can do FIND in other fields of the portal but email field., I already checked inspector > Field Entry in find mode is cheked.. I have attached screenshots
-
- 6 replies
- 1.8k views
-
-
Hi. I built a database about a year ago but it wasn't required at the time, a year later and it is needed so I'm pretty rusty at present ref FMP but need to is user friendly. All I want to do is add a slight tint to the background colour of certain fields in list view when the row is not active but try as I might I just can't seem to do so. In the active state yes, but not when the row isn't active. I have made a little video that might help the reader understand my predicament, any help would be appreciated. https://drive.google.com/file/d/0B687aT8LAHKmRHEyZjh5OFdlSnM/view Karl.
-
- 2 replies
- 2.1k views
-
-
Hello, Issue: I have Sales Activities Portal on each company's record, now I want to list all first rows of portals from each company record on another layout. Now, I also want only those rows with non-empty follow-up date fields too. My Portal is sorted by Activity Date in descending order. What I have done: I have onlayoutenter script as below: Enter Find Mode Set Field[Daily Log::date_followup; "*"] Set Field[Daily Log::date_activity; Max(Daily Log::date_activity)] Perform Find[] It is fetching all records from each Portal which has non-empty follow-up date value I want only highest activity date value row from each portal
-
- 6 replies
- 2.9k views
-
-
I am brand new to Filemaker 14. I have a table with information on individuals (ex: ID #, name, Address etc.) I have a table with categories for the individual (groups they belong to: ID #, Council, Board, Committee) Example - table 1 has persons name Table 2 has a list of commissions the person serves on. When I do a layout it shows all the people and all the affiliations I would like to make a list of all the council members. I want the layout to show title council members and have those members listed. I want to then have another layout showing "such and such" a board and show all the members that belong to that board. An…
-
- 4 replies
- 1.1k views
-
-
I just updated to FileMaker 14. I have thousands of records with container fields where I used "insert Quicktime" to link audio files. This latest version has removed that option. So I learned I need to make the container fields interactive. I did this properly, and now the audio is playing. However, the Quicktime controls are gone. I can't move a playhead around, fast forward, rewind, or much of anything. The only options I have are Play/Pause and Volume. Is there any way to fix this so I can have more controls? The playhead control would be the most important for me. I attached some photos of the old controls and the new ones. Using: OS X El Capit…
-
- 0 replies
- 945 views
-
-
Has anyone come up with a way to nicely add a couple of static options to a value list generated from a field? For example, assuming I have a field that I'm using to create a value list. I want the exact same value list, but with "All", "Mine", and a separator to appear at the top. I figured out a way to create a value list that includes "All" and "Mine" in addition to the names in the field the values are drawn from, but the words appear in their alphabetical order, not at the top. My fallback solution is to have radio buttons for "All", "Mine" and "Values" with the value list only showing up if the user selects the "Values" radio button, but this wouldn't be a…
-
- 7 replies
- 2.7k views
-
-
I have a portal with a list of dates and I would like a horizontal line to appear on just one row, the record with the closest to Get ( CurrentDate ). I was trying some get Nth options but no luck. divider.fmp12.zip
-
- 1 reply
- 1.8k views
-
-
I have a layout with a summary report, the report breaks on the Category field. The layout resorts whenever the Category changes in a record. I would like the focus to stay on the record that had the Category change, instead of going to the top of the layout.
-
- 1 reply
- 1.6k views
-
-
Hello friend, How we can Restrict for not showing last empty portal row in portal table.
-
- 5 replies
- 6.1k views
-
-
Hi All After instaling Filemaker Pro Advanced 14 in Windows i notice that inside Script work space if you have a script step like Import Records (with ODBC configuration and a Sql Query ) There is no way to go directly edit the Sql query (Short Cut Key or double click) to change only the query Example : you always have to - Specify data Source (Drop down Menu) - Select ODBC Source - Confirm User Password Edit Menu - Then Edit Sql Query.... Is there any easier way ???? Thanks
-
- 2 replies
- 1.6k views
-
-
I feel I'm surely overlooking something obvious here, but I can't figure it out. I'm uploading a sample file which is actually one of the starter solutions from FM12. I've added a layout "Popup - View Attachment", and a script "Popup - View Attachment". I have a button on the Tasks Details layouts, Attachments tab to run my script. I add two attachments, each a PDF file. What I'm aiming for is to click that button and have ONLY the one record I'm selecting from appear in the new layout via my script. What I'm getting is both related records opening. How can I narrow it to only the record that I click the button from? (Can I?) Tasks.fmp12
-
- 7 replies
- 1.3k views
-
-
I am designing a layout for print, and I need to see the page margins in the layout design. The problem is that the option is grayed out in my menu under View > Page Margins. The funny thing is that it is available on some of my layouts, but unavailable on others. Anyone else experience this? Thanks, GG
-
- 2 replies
- 1.3k views
-
-
Hi all I have a personnel portal (looks up values from the 'personnel table'). When I click a row then the associated personnel_ID is put in to a personnel_IDF field in a new record of a different table (Case_personnel). This second table is also displayed in a portal. No changes have been made to the 'personnel' table. How can I get the personnel portal to exclude records where the personnel_ID matches the personnel_IDF field in the Cases_personnel table?
-
- 9 replies
- 2.7k views
-
-
Hi All, I have created a database and am hitting a wall with one of my portals. A brief structure of my DB is. Customer details (Accounts table) > Their enquiries (Enquiries table) > Send a quote (Quotes table). I require the portal to show 2 quotes from the account using information gathered in the enquiry. Both the quotes are showing up in the list and table view of quotes, but when I try to show them (including the related data) in the portal the duplicate info shows up. I have uploaded a video here and I have attached a relationship portion and the actual relationship. https://dl.dropboxusercontent.com/u/70042807/Simon-PortalHelpVid.mov …
-
-
- 9 replies
- 1.8k views
-
-
I'm an absolute FMP newbie I have a table called 'artists' and another called 'contacts'. And I have a layout with a portal listing that artist's contacts However.. In real life, each 'contact' can be linked to many 'artists'. E.G one guy might manage three bands I would really appreciate any of you pointing me in the right direction of allowing a 'contact' to be linked to many 'artists'
-
- 3 replies
- 1.1k views
-
-
I was just wondering if anyone had any ideas why this would be happening. I've been working on a database that was originally created in FM 11 but has been converted to work with FM 14. I went to format a checkbox set the other day, and I don't have any of the additional options that are standard for FM 14 (see screenshots). I ended up creating the style I wanted in a FM14 database then copying it to the converted one. A bit of a bugger and a little time consuming. I'm assuming it's due to the conversion since I can't think of anything else. It's been converted for a while (nearly a year) and running fine, but I'm wondering what else could be missing. …
-
-
- 2 replies
- 3.7k views
-
-
Hi i have a portal which shows related products to a customer , next to it i want to display another portal which has the products BUT now i only want to show something which has a certain condition. the field is in the product table and the way it is selected is through a check box. i tried filter (field) = 1 but my portal was empty even if in the product that field was selected. how would i filter this
-
- 2 replies
- 937 views
-
-
Hi, I am using Filemaker 14 and Filemaker server 14. I have people DB, Product DB and orders DB. On People DB, I have portals for ralated Products and related orders. People and Orders are related only through Products table. When I open the people layout for the first time and navigate through records to the record I want, I see the products and orders in the portals. But when I open the people layout for the first time and search for the record I want, I only see the data in products table and I do not see the data in orders table. When I click the ralated button I have for products, it takes me to orders layout but shows zero records.…
-
- 1 reply
- 1.7k views
-
-
So I'm fresh & new to FileMaker but am fairly savvy with MS Access. Struggling to setup a form/report that can display some fields by a drop-down calender (date range). • Currently I've got a small portal setup on my home page that I can select the date (already made a field that generalizes the month/year) from although ideally I want the selection to stem from the drop-down calendar range, and below it I'm initially wanting to see a total amount of "shop tickets" within that given date range. Following the completion of this, I aim to try to figure out how to add more filters so that I can then possibly see the amount of tickets that are tied to a particular "…
-
- 13 replies
- 2.7k views
-
-
I've got some text and a button that I'd like to make visible only if a condition is met. I've set the text to a color to match the background if the condition is not met. The button is a small graphic (an email icon) that I pasted into the layout. Is there any way to do this in FM 12? I know it can be done in 14, but we're not ready to upgrade for a few months yet.
-
-
- 4 replies
- 2.5k views
-
-
Hello I am just wondering if there is way to make the last empty portal row to create a new record at the top row. I have sorted the portal by a date field with the most recent date at the top. I would like the empty portal row at the top so that the data collector wont have to scroll through a bunch of records to get the the empty row at the bottom. Thanks
-
- 9 replies
- 6.7k views
-
-
Hello Friends, Here I am in project for Employees Attendance. Everything is ok only I could not figure out to filter the portal table month wise. At present it is in All transactions records. I have distribute the portal by tab control for all months. Here I want report of records month wise. And also it can calculate the values of each status (Present by 1 no., Absent by 1 no., Half Day by 0.5 and extra day by 0.5). I have tried as per my best but could not reach to point. I am attaching small demo file . Samarth Attendance.rar
-
- 5 replies
- 2.8k views
-
-
Hi... I have a portal with records that have a date field. I would like my users to be able to define a date that the portal will filter and show only records with the date the user defines. This seems simple, but I cannot figure it out. If I use a filter that uses a calculation with Get(CurrentDate) it will work, but only for the current date! So I know my relationships etc. are working...but I would like to be able to choose the date in the user interface...and have the portal search and display that particular date (NOT a date range, just one date). I have tried to perform a find, but that doesn't work (I am new to FM!) Any help? Thanks!!! Todd
-
- 5 replies
- 1.2k views
-
-
Aloha Everyone, First off I'm ESL and my gramma is not up to par with an English major. Second, I'm a photographer and not a programmer. That said, I am determine not to let that stop me from learning FM enough to program me a simple but functional DB. I'm familiar enough to understand and get around FM and it's back end but have not spent enough time to know it intimately like one who spend everyday in FM. In other words, I know basic of FM parts and functions and attributes but have not had the opportunity to learn how to connect everything together to make one simple idea to work. Lastly, I'd greatly appreciate you all for taking the time to help me with my…
-
-
- 10 replies
- 2k views
-
-
Hi guys! I need to make a drop down list depending on a value selected, here is what I have: Basically I have a database for assets. I need to store the location of where the asset is, depending on the city it may have different factories, so the asset is in one of those factories. So for example, the city of Miami has 3 factories, when I register a new asset I must pick the city and then the factory in where it's gonna be. How would I do this with some drop down list? thanks for the help
-
- 2 replies
- 1.4k views
-
-
I am trying to import my price sheet (excel file) daily, and sometimes I don't want it to update my fields "Regular", "Pair", "Package", but update everything else in that record if I have my "Override" checkbox checked. If I don't have the "Override" checkbox checked, then I want it to update all fields in that record.
-
- 1 reply
- 1.1k views
-
-
This seems like it should be super easy, but I'm running into a speed bump. I am creating a simple project tracker using the Starter Solution 'Project.' (FM12) While in project details, I cannot get it to sort by the Due Date. If I go to the 'Sort' function, and do an ascending sort by verbose due date, it remains in an descending sort.
-
- 2 replies
- 1.1k views
-
-
hi i created a portal for where i want to be able to add in several items for it to total to create a report. however it only allows me to add one row. how can i fix this ?
-
- 10 replies
- 1.4k views
-
-
First, I have a tab control with 3 tabs, I would like to use the Hide If feature to hide certain tabs depending on certain conditions. When I try this it hides the whole tab control (with all 3 tabs) and I'm looking to do this individually, is this at all possible? Second, I have quite a few fields that I need to have on my layout for calculations and scripts but I don't want users to see these. What is the best way to keep the fields on a layout but hide them from users? Thanks!
-
- 5 replies
- 1.9k views
-
-
Hello All, I want to find the total quantity remaining of my materials excluding my materials with status (Used ; Rejected ; and Expired). I tried using case function Case ( Material Remarks = "Expired" ; 0 ; Material Remarks = "Rejected" ; 0 ; Material Remarks = "Used" ; 0 ; Material Quantity Received - Material Quantity Used ) but its not working. Please find attached file that Im working. Thank you so much. LoLa Materials.zip
-
- 2 replies
- 1.4k views
-
-
Hello peeps, I'm just getting to grips with Filemaker 14, skipped 13 so this is the first time I've had the opportunity to play with the popovers which I've been much looking forward to. I have to admit that I'm a little surprised that data entry hasn't been made much easier with the advent of popovers. Creating a data entry interface is certainly easier and looks good too, but the process of entering new record criteria and confirming or cancelling the process is much the same. Currently I use global fields to place on a popover and when data entry is confirmed scripts will: Copy the entered data to a new record, field by field Clear all global fields used for entry…
-
-
- 19 replies
- 7k views
-
-
I'm looking to store an editable pdf file that I created in a container that's accessible in every record What is the best way to do this?
-
- 1 reply
- 1.1k views
-
-
Is there a means to tell which iPhone is running FM Go? I have created a Solution that I use to track my Disney Collection. It basically on my PC/Mac with screens for an iPad and iPhone 6plus. [I copy it to my iPhone 6Plus and it is not the primary input source] I have several friends in the Orlando Disneyana Club who may be interested. If I developed a less robust iPhone screens how could I distinguish between iPhone 5 and a 6plus. I am in the process creating system for a Toy Collector friend and I would have the same issue; unless I dumb the iPhone screen down to the lowest common dominator. I was hoping the Get(Device) would do the trick.. but It does not appear to …
-
- 2 replies
- 1.4k views
-
-
I am updating the field picker to update field options and I am getting a frustrating glitch. I right click on a field in the field picker and select field options and it opens just fine. I make a change and then close the popup and the field picker half greys out (see attached image). If i then right click on another field and select field options I get a message telling me that I am currently modifying the database definition. In order to be able to update another field I have to quit out of filemaker and log in again which is totally untenable. The only recent change that has been made is that I have shifted the database from a commercial provider to a locall…
-
- 1 reply
- 1.2k views
-
-
I would like help designing a drop down value list which filters the list based on what is already type in the input field. See example - admin 1234 - When they click on the field the drop down menu appears and would be filtered by the first letter of what they typed in so the user can correctly match up with the exact name - the field data comes in from a web form and I do not want to change the web form - just the value list - thanks ValueLists.fmp12
-
- 2 replies
- 1.1k views
-
-
Hello , Im hoping somebody can help me :-). I have a portal on my customers layout its a single date field portal. This portal is connected to my service layout. The Field shows the retest date of a piece of equipment . It works perfectly if there is only one retest date. My problem is if there is many. What i would like the portal to show is the NEXT retest date . At the moment it shows the LAST retest date. So if i have a customer with many machines tested on different dates it always shows the LAST which means i miss the retest dates in-between the current date and this last retest date. I hope that makes sense. Thanks
-
- 6 replies
- 1.4k views
-
-
Hello everyone, Thank you in advance for your help. I have a contacts table that I will be adding fields to in order to describe volunteers more fully. For example, skills, active status, desired tasks. One of the requirements is a set of check boxes that indicate when the volunteer is available. The users want the days of the week across the top and 3 check boxes under each one for morning afternoon or evening. I need to be able to check multiple boxes. When a volunteer is needed, the users would do a find for the particular time needed. Here is a screen print of my layout using one field for every value with a Boolean "1" for each checkbox selected. Is ther…
-
- 17 replies
- 3.1k views
-
-
Hi Guys, Firstly I am using FM Pro 12, my company needs to utilise a map system, we work in the vehicle industry, and we would like a map system to show all available garages (which we will plot ourselves on the map) in a customers post code (UK) range. I have tried using the web viewer and the built in UK Google Maps system, however I find it very limiting in what our staff can do. I have seen a host of different open source solutions, such as FMEasyMaps etc, but they all seem to be for FM 13, not FM 12 like we are using. Any help / advice / suggestions are welcome. Thanks in advance.
-
- 4 replies
- 2.3k views
-
-
Hi everyone, I would transport an excel table in filemaker, and I would maintain the same logic. This excel sheet contain the orders, one per row. The row color changes according to the state of progress. Pushing a button after the selection of the cell, all the data of the order along the row are shows in a form with tab. How can I transport this Excel in filemaker? Which tools are necessary? Is realizable? Thanks in advance for help and/or suggestions! P.S. I'm not sure if this is the right section of the forum, my apologies!
-
- 8 replies
- 1.2k views
-
-
Hi all im trying to use FileMaker to: open an https website navigate to username field enter username, navigate to password field Enter password then click the go button on the website what is the best way to approach this?
-
- 10 replies
- 2.8k views
-
-
I've been reading up on the Saved Finds. I knew it was an available feature, but it was disabled. I did find that Custom Menus, pre-FM10, would have this case. We are on 14.0.4. Converted from 11. Files were built in 5 or before. FM Server is up to date. Using Windows. I have full Admin privileges. It is available for the Standard Menu Set. My problem is that, when I try to Edit or Create an Custom Menu, Saved Finds is not an available option. I can even try to build a new Custom Menu from scratch. No luck. Any suggestions?
-
- 1 reply
- 4k views
-
-
Am I missing something? I've used FMPro for decades and can not believe that with the advent of .fmp12 (using version 14) that the Powers that Be decided to dump the ability to add multiple fields to a layout. Here are screen shots from Version 9 (.fmp7) Screen Shot 1 is the first window when creating a new layout. There, I choose the type of layout. Screen Shot 2 expands on that choice. Screen Shot 3 allows one to select ALL the fields desired for that layout in a single action. The only thing I see with FMP14 is Screen Shot 4. One window, one choice. Finis. What I find with .fmp12 is that I have to go to the Insert tab in the menu bar, draw down…
-
- 1 reply
- 1.1k views
-
-
Hello Filemaker display white zone and very smal menu. Driver and FMP are up to date. It displays fine on another computer. Any idea ? Thank you very much for any help/suggestion Regards
-
- 1 reply
- 1.3k views
-
-
Hi all, I am new to the forum and new to FM-Pro14. I have been knee-deep reading books and tutorial videos on it for 2-3 weeks so far. I am stuck on a problem and I can not find any documentation. I wonder if someone can help. I am guess this is an easily solution and my beginner status is the problem <; When I create a new button, or modify the existing button, it keeps reverting back to being part of a Group. I have 'Arrange-->Ungroup' many times without success. When I go back to Browse mode and click the button, all fields are selected. When I go to Layout mode and select the button alone, then select 'Arrange-->Ungroup' (it gre…
-
-
- 13 replies
- 5.4k views
-
-
Hello friends, Though I have transaction list and at present I sort this list by timeframe i.e by week,by month,by year and etc.but I get all reports accordingly. If I select month then it sort report all monthwise. It's OK but now I only want to sort list by desired month say want to select January then how it can be. I have make a global field as name month selection by drop down value list name as Jan,Feb,Mar etc. Pls help me for what kind of script shall be applicable to get the sort list. Thanks
-
- 1 reply
- 1.3k views
-
-
I am working on a pre-inventory form. The form will basically be listed by product SKU numbers. Each line (row) of the form will contain a different product SKU number, for example; Product #101010 Product #111111 Product #123456 The stores database automatically keeps track of each product amount in stock, BUT, because of theft and misplaced items, we count each item every morning and night, and then compare it to what the stores database says. I'd like to make a conditional, where when the amount counted equals the amount the database says we have, the entire row turns green. If it doesn't equal the same number, then the row turns r…
-
- 15 replies
- 2.7k views
-
-
Hi, First time poster here. I have a database with 2 tables: document-sections and requirements. Document-sections has one-to-many relationship to requirements. I have a layout that lists the first document-section and then have a portal that lists the requirements related to that document-section. The portal row is set to 5. Can the portal be setup to only have rows if there is a record there? Thanks
-
- 12 replies
- 2k views
-
-
I am just trying to do something that should be simple, click on a row in a portal and save the row number to a variable, $row. I've attached the script to various triggers, OnObjectEnter, OnObjectExit etc, I've attached it to a button on the portal row, but no luck. The variable, $row, never shows up on the script debugger data viewer. The script only has this step in it. Set Variable($row;Get(ActivePortalRowNumber)) My objective is to be able to go back to the last row that I was on when I re-enter the layout. There are a total of three portals on the layout.
-
-
- 11 replies
- 4.3k views
-
-
I'm attempting to pull some data from a webpage here: http://www.ehso.com/siccodes.php This is a one-time thing and all I really need are the 4-digit codes and their descriptions as records. I placed a web viewer thinking this might be faster somehow but I cannot identify how to find the beginning the text. I also am capable of horsing it and parsing each line from the copied text field but would that be quicker than web viewer? I tried using a container and Insert From URL but once I have it in the container, I have no idea what to do with it. My goal here is to match these 4-digit codes to existing records with those text codes so I can import their des…
-
-
- 14 replies
- 3.2k views
-
-
Hello Mavens, I have a container field into which images can be pasted. I want to create a popout window run by a script, that displays the image in its full size. How do I get the size of the image that has been pasted into a container field? Muchas gracias.
-
- 1 reply
- 1.5k views
-
-
Hi. Is it possible to switch rows in the portal by just simply drag n drop? Like for example, we have four rows: 1. Mike 2. Linda 3. Bob 4. Phil If I take 4.Phil and drag to 2.Linda - they switch places. The whole row that is. And just by dragging the number (row number) - which is another trick, to keep it always in the sequence. The portal doesn't have to be sorted. I assume it is possible thru some clever triggers. Couldn't find this anywhere yet.. Thank you
-
-
- 4 replies
- 2.9k views
-
-
FM14 Advanced 14.04 I have a solution with about 15 files. All use the same Theme - Classic under the Basic group. I use the default font (Arial). Today, I opened every file and every one has the font set to [email protected] I checked the theme and they are all still using Classic under the Basic group. So I tried to change the theme. As soon as I do, in any of the files, the Classic theme is gone in the menu. At the bottom of the font menu are 5 or 6 of these same fonts with slightly different letters. Digging tells me they may be Adobe PDF related? The last thing I did on this solution was print to PDF - 100's of pdfs that is scripted. …
-
- 9 replies
- 15.9k views
-
-
Hi Forum. I had a question about how to select a window, when multiple windows are opened. Brief explanation. I am on a layout with 1 window open, called Delivery Management-regular document window. I import records to this layout then open via script 2 more windows with information I need to look at while working in the first window. Both of these are floating windows. When the script ends (the 2nd and 3rd window open), I'm left on the 3rd window. I would like to land on the first window so I can resume working. What I tried, that didn't work for me: 1. Select Window [Name: "Delivery Management"; Current file] // I made sure it was typed correctly b…
-
- 3 replies
- 1.1k views
-
-
Hi please can someone let me know if this is possible. would a popover button work within a popover??? Thanks,
-
-
- 6 replies
- 3.8k views
-
-
Hi What i want is that when i create a new record my check box field get auto selected the correct option. How would i script that what ever i try doesn`t seem to get it working. Please can someone help me out with this. Thanks
-
- 13 replies
- 1.7k views
-
-
I was thinking of setting up 6 tabs to display 6 main categories, then 9 slides in each tab, with portals related to 9 tables requiring data entry. Will this work? So far I have not been able enter data in the portal/s. This could be my own lack of experience with portals though.
-
- 1 reply
- 3.7k views
-
-
Hi is this that usually happens, i created a popover but when i open it it moves all the way to the left blocking the button, i want it to display next to the button like it does in layout mode, please can someone help me out achieve this. another question is it possible to display the over the size i want it to be on the top or bottom or do i have to go with the way it was design and just strech it evenly not let say have 1 cm on top and m10 on the bottom. please can someone holp me out with this.
-
-
- 2 replies
- 1.3k views
-
-
Okay so I have forms which must go to head office and they have combination of text fields and checkboxes and these questions are all over the form sometimes in 3 columns sometimes 2 or 1. I have scanned the form and matched my text to it but I am worried to make records for each questions or make fields. If I make records then I have to put each answer from join table in an individual portal changing portal row for each answer. I think. HQ may also change there form and send new one which is mostly same but few different questions or wordings of same question probably because their legal eeked them. I can scan again and rearrange layout but each employee must an…
-
- 5 replies
- 1.7k views
-
-
Hello, I have a problem with making a filtered value list work. I want to have a drop-down list in one of my portals showing only certain records from a related table, but I can't make it work. I have (for the purposes of this problem) 3 tables: "Quotations::" "Line Items::" and "Products::". "Line Items::" is the child in both relationships. The table "Products::" contains all of our stock, not all of which is for sale, so I would like to have a check-box field that allows me to include the item or not in the value list of sellable items. From what I read on the forums here, the way to do this is to create a second occurrence of "Products::" and relate it …
-
- 3 replies
- 1.6k views
-
-
I am building a layout with a tab control. I would like to have a visual indication to the user if a tab has data in it, even if the tab is not selected. For example, if a comments field on a comments tab is not empty, I would like to give the user an indicator that the comment exists when the tab is unselected. I know I can change the style of the tab individually, but can it be made conditional?
-
- 6 replies
- 3.5k views
-
-
I've been building my database for about 4 years now and its tricked out with portals and conditional formatting. The problem is its running extremely slow on all computers, when you click from one layout to another, theres about a 10 second waiting time before the layout switches. I'm trying to go through each layout and do what I can to optimize or speed up the database. One thought I had is converting any (conditional formatting/Hide Object If) I had into a calculated field. Is this a generally good practice to have? One example, I have a table within my main layout called Phone Log, you can add records, drag in files into container fields/etc. On the left I …
-
- 3 replies
- 2.8k views
-
-
Wondering if anyone has a creative solution for getting records to appear like the attached sample where the record only appears for the length of text based on a certain field. Basically to have records that are variable height (not fixed). The trick is to do this in browse mode so that records can be interacted with. This is similar to threads in mac mail. Thanks
-
- 7 replies
- 1.6k views
-
-
Hey all. I have a database I inherited that uses a lot of Text objects formatted to look like buttons. As I am going threw and modernizing this system, is there any tangible benefit for me to re draw these objects as buttons? On the one hand, why should I bother? I have all the same tools in the Inspector for buttons and for Text objects (drop shadows, boarders, fill, hover state) so I can just use special 'button like' styles for these text objects. By and large all the buttons look OK. On the other hand, are there any behind the scenes benefits I am not aware of? For example I remember Matt Petrowsky (?) once mentioned that there is a lot of overh…
-
- 1 reply
- 3.9k views
-
-
Hi, New to this so not sure what is needed to help me. I have several portals in my database and they all have filter and sort settings. All the settings are the same on each portal (just pulling from different layouts). Each portal has a button with a script in it that has it "go to the related record." All of my portals and go to related things work great and quick an no issues. Yesterday, I added a new portal and a new go to related and updated my relationships, etc. everything mimics the same settings on all my other portals. BUT for some reason this one portal and go to related are lagging big time and everytime I do anything that affects that portal I get …
-
- 4 replies
- 5.7k views
-
-
Hello all, (Another) FM noob here, getting there slowly (I think). I'm having a problem with portals that I was hoping someone might be able to assist with. I'm building a database for my boss that requires a series of drop-down boxes that act as filters - these work fine in that they successfully find the appropriate records - I'd like to display the results in a portal, however the portal is only displaying one record - I suspect my table relationships might be the culprit, but I'm at a bit of a loss. I've attached my tables below. g_DropDownList stores global values for the drop-down fields - each field can be cleared using a scripted button. T…
-
- 2 replies
- 1.9k views
-
-
Hi, I've created a custom menu that shows only the Help Menu (streamlined) to users. The navigation is carried out within the layouts themselves. When I've tested it and logged in as a user, I am also getting the Tools menu appear. How can I get rid of this? In custom menus I've defaulted it to use my new menu. TIA Ann
-
- 2 replies
- 4.6k views
-
-
Hello, French user I found a sample of resizing a webviewer (I join that file). I want to display local pdf files in that WV. Under MacOS that runs fine, under Windows 7 or 10 I get the screen copy joined too with only a "Image" Since tree days I do and undo unsuccessfully ! Perhaps an error in the path but I don't see where ! Hope in yur help Regards Noël WebViewerImageResizing.zip
-
- 2 replies
- 3.2k views
-
-
Hi Guys, I have a customer file which is a just a table of data. I then subsequently have a interface file, with a reference to the customer file, however I have a locked layout where the user can find add etc data to the customer table. The interface file has scripts, values lists etc. and is pretty locked down. I have then created a reports/exports file which is totally unlocked. I have a reference to the customer table and only the customer table is showing in the database diagram. My question is, if the user is doing a 'complex' find in the interface file, and out of 12000 records they find 641 records. How do I pass that foundset to the reports file. I can'…
-
- 3 replies
- 1.2k views
-
-
Hello, I am trying to create a daily sales call log, for that I have used Portal for which I am using "company" table in which I have "contact 1" to "contact 12" separate fields for each record (company) Now, on the portal, I was able to fetch contact names dynamically based on chosen company using conditional value list relationship and creating new text field with auto-enter calculation of List(contact1,....,contact12), but how can I fetch contact number for selected contact name for that company? I created a new field to auto-enter calculation of contact numbers like the same way but it seems like I am going in wrong direction It would be great if anyone…
-
-
- 13 replies
- 4.9k views
-
-
I am using FMPA13. Recently, I noticed the layout font changed by itself, and messed up the formats on certain layouts that still look fine on FMGo. Any ideas what may be going on? I have tried to change UseSystemFormatsState, but it does not seem to work. Any help would be great. Thanks
-
- 13 replies
- 6k views
-
-
Hi I have a report that has two sub summaries, so it is first sorted by date, then within that date it is sorted by unit. When I only have one sub summary it (the date one) the sub summary part is always the correct height (seen when clicking on the crowd report button, however when I put in a second sub summary so it sorts the units within those dates it can then randomly do different heights for the date part. (seen clicking on the crowd report with units split button) I need to have it so it doesn't do this... some pages it makes it 3/4 of the page, others half a page, others it does it normally. The second issue I am having is in the divi…
-
- 0 replies
- 782 views
-
-
Hi, I was wondering if it is possible with FileMaker Pro Adnvanced (12 my version) to create a layout containing a list and a card (details view displaying a whole record) in the same layout, i.e.: - on the left side, see a list of all records (and a scrollbar maybe) - if I click on a line, in the right column, a details view is shown to edit the details. It does not work with the referenced records tool - they are not records from other tables, but the same table. (and sorry for maybe some odd words - I have the German version and I am not sure about the correct English ones) Does that work? Many thanks for your help, Claus
-
- 1 reply
- 958 views
-
-
Is it possible to remove the filemaker name? Client want to remove the filemaker name and replace with the solution name instead. for instance; the filemaker pro at the top, he want to change to corp point of sale and the filemaker name in dialog boxes he want to replace with the solution name also. Like the annoying alert box in listview if there's no record. Is it possible?
-
- 5 replies
- 2.3k views
-
-
On FMP GO on and iPhone 6plus and a iPad, both with the latest IOS, sometimes the fields / buttons on the popover do not display. Please see attached. Any ideas as to why? On the sample below. I closed the file and then reopened and the navigation buttons were visible. The same has happened on the Character and More Popovers.
-
- 0 replies
- 1.3k views
-
-
Hi please can someone help me solve my issue I created a manufacturing solution that to every product one can select its ingredients from a pop up menu in a portal. the portal then take you to the related ingredient page where it has additional info about the ingredient my issue is when i created it there were only a few products so wasn`t such an issue scrolling down the list to select the relevant ingredients, but as the solution expanded and more products were added the ingredients list became very large and one has to scroll through several 100 of ingredients to select the one he is looking for. i would like to break up my pop up menu , ie one…
-
- 8 replies
- 1.9k views
-
-
Hi i'm new to filemaker and programming too. I need to create a layout that allow me to enter daily people's choice between two menus: Menu 1 and Menu 2. I create a people's table, menu tables and a join table peoples_menu. It should be something like this (see attachment) How can I grab the choice? How can i create automatically a record every day and check if it already exist? Thank you in advance. Themusic
-
-
- 4 replies
- 1.1k views
-
-
Hello, In my table I have text fields "ABC", "DEF", "GHI". I have these fields on a layout and have set each field as a button that runs a script. The script needs to return the field name (GetFieldName?) and change the contents of the field based on the existing contents of the field when the button is clicked (Case function). How do I let my script know which button (field) has been pressed? Thanks in advance, Ben
-
-
- 4 replies
- 1.8k views
-
-
Greetings all! I'm admittedly quite "green" when it comes to FileMaker, but I do have 15 years in application development in a variety of different languages, primarily geared towards web application development. That said, I have what I would consider a fairly common scenario and I'm struggling a bit with the best way to implement a solution in FM. Basically I have a "file" table and a "file_type" table. The two tables are related by the file type relationship. Currently I have two file types, "documents" and "files". Now, within my layout I have a tabbed interface. Included are tabs for "Documents" and "Images". Each of these tabs contain a portal to our "files" ta…
-
- 9 replies
- 4.2k views
-
-
I want to be able to add something to my filemaker system. I've got about 5 items that are currently in a drop box. Right now we select the item in the drop box and then manually type into a comment box about 20 other items that we need. I would like filemaker to help me. When I choose the item in the drop box I would like it to keep asking for the information I need that corrolated to the first drop box. What is the best way to go about this.
-
-
- 8 replies
- 1.6k views
-
-
I am not very proficient with the web viewer in fm, but I was wondering if there was a way to use the web viewer to display only the photo of the linked in profile in my contacts database? Would love to add a little 'human' to the database and we already have most linked in url associated with each contact. Thanks in advanced.
-
- 1 reply
- 1.3k views
-
-
Hello all: Could someone give me a high level view of how I would go about pushing data from Filemaker to an online form. I'm assuming I could open up the online form in a Web Direct layout but what would be the procedure to pull data from fields in Filemaker and push them into input fields on the web form ( if this can even be done ). Just a high level process. Thanks. Dom
-
- 5 replies
- 1.8k views
-
-
Thru versions of Filmaker going back at least to FM12, I've heavily used webviewer on my layouts. 1000s of records with stored urls without issues until recently. Some, but not all records with urls crash Filemaker when accessed. A fair number of my records include urls to articles in NY Times. It seems as if the older ones find the NY Times pages and work ok. Perhaps NYT website is doing something differently. For the past couple of weeks, nearly every NYT page whose url I store causes FM to crash. Non-NYT urls aren't doing this. It happens both on 32 bit desktop as well as 64 bit notebook - both Win 10. Any thoughts? Thanks,
-
- 1 reply
- 2k views
-
-
Why the master record delete if I delete a record in the portal... Please help. I have checked all the options properly.. It has been working, suddenly it stopped working and deleting the master record also...
-
- 6 replies
- 2.7k views
-
-
Hello - I'm not a developer but have been using FMP for a long time. I've never learned scripting but am now taking a stab (unsuccessfully as yet) at it. My database begins with tables for "Projects" ... and these are related to "Grants" ... and these are related to "SubGrants." From the "Projects" screen, I'm trying to create a script for a button in order to create a new "Grant." FYI, I've been doing this for years now by simply using the portal relationships ... but I'm designing for use by others, so I'm trying to automate things a bit more so the user doesn't need to know too much about FileMaker. Here's what I have but it doesn't return a "Proje…
-
- 9 replies
- 3.9k views
-
-
First need to apologize for re-posting this, since it appears to have been solved once: But, the links in the orginal thread are all dead, and after an exhusting search for both the example file and attempts to reach the original author have all failed. The gist, looking for a way to allow end users to "select" portal rows in a single or multi user environment and display that selection. Further it should allow the selection of multiple portal rows simulating general OS functionality. Any help would be greatly appreciated.
-
- 7 replies
- 5k views
-
-
I have a simple list view with about 5 fields in each record. I would like to use a slide control to change the fields to ONLY that single record while in list view. I realize I could use a popup menu, but the interaction is not the same. Anyway to do this with a slide control? Thanks
-
- 7 replies
- 5.4k views
-
-
I upgraded my computer from Windows 7 to Windows 10. FM 12 Adv no longer fits properly on the screen. At 100% zoom the image is too large and I have to reduce to 75% zoom. This is too small and fonts are very poor. I have the screen resolution set to the maximum monitor resolution of 1920x1080. Is this a scaling issue with Windows 10 ?
-
- 1 reply
- 1.6k views
-
-
Hi Everybody I wish you all a very prosperous 2016 and may all your wishes come true. I have been using some of my holiday time to update my FM solutions, so far I have managed most of what I wanted to do and learned a couple of tricks on the way. Now I have found a roadblock, using different value lists on the same field. I have many value lists based on relationships and they work fine, but in this case the situation is: a) It is a checkbook solution, if there is a relationship it displays certain values (List of debtors/creditors in one field, invoice numbers with balances > 0 in the next and Invoice value on the next). b ) However payments …
-
- 8 replies
- 1.8k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online