FileMaker Interface Features
-
What I want to do: I want to conditionally hide or show fields in a portal row. The catch is a simple "background fill transparent" won't work on fields with drop shadow and additional styles as the styles still bleed through. I want the entire field to completely disappear with no trace. I know how to do this with portals on fields on the outside, but this is already part of a portal. The Why: The portal holds line items on an orders screen. When an order is submitted, certain assembly items explode to predetermined levels using their BOM information. I want this information visibly indented based on the the level it is on so that is easy for someone goi…
-
- 1 reply
- 1k views
-
-
In FM 11 and earlier, you could type @@ to display a record number. This doesn't work in FM 12. Is there a work around?
-
-
- 1 reply
- 685 views
-
-
I have built a web scraper that does a great job of pulling information out of a standard HTML page for me, looking to see which of my competitors was involved in building the actual website (in the schools industry). I would like to be able to use a scraper to look at a school's URL to find out what their tuition was. The problem is that there is no standard convention to tell the scraper to go find. Some schools might use school.com/admission/tuition and some may use school.com/admissions/finance or some may use something completely different to find the information. Does anyone have any creative way to use the web scraping concept to try and locate this data to …
-
- 0 replies
- 1.2k views
-
-
I have country names in separate table, its ascending order when i show in value list.. but i would like to show this value list in descending order ? Is this possible, Please help me any one ? Many thanks in advance
-
- 1 reply
- 1k views
-
-
I have a 'products' table that I would like to incorporate in a layout that will be used by customers to browse through products in a shop. I would like around 4 records viewable at a time (2 fields - a container for an image and a description field , and then buttons to shift to the next set of records 1-4 , 5-8 ect. like this: has anyone successfully managed to do something like this? any help would be appreciated thanks
-
-
- 5 replies
- 1.3k views
-
-
Not entirely sure how to explain this, but I have a layout with a portal. Most of the fields displayed in the portal are set as non-enterable while in browse mode, as the data is coming from a table that should not be edited. I have a script in the portal that needs to take the product ID from the portal and create a new record in another table, but there are times when I've noticed it creating a record for the wrong product ID. It seems that what is happening is that when I click into an editable field FileMaker properly identifies the record I am on and properly picks up the Product ID I want. However, if I just click on the button in the portal, or click on o…
-
-
- 7 replies
- 1.8k views
-
-
I have a record with several portals, is there a way to prevent editing of all the portal rows, if a field in the record is set to locked?
-
- 3 replies
- 2.8k views
-
-
Today I had a strange thing happen. I was entering data in a portal on a layout. I had used this layout for years through many versions (currently FMPA v12.03 Mac OS X 10.7.5). I did some work in another window then returned to the layout in question. Suddenly the portal only showed one row and there was no way to enter data. I checked the relationships and made sure Allow Creation etc. was enabled. All perfect. Finally I retrieved a backup copy of the entire solution to the desktop. In the backup all was well, but everything else was identical. Relationships etc were the same. I closed the backup and returned to the active file, created a new layout and copied all object…
-
- 31 replies
- 3.1k views
-
-
Hi, I have a status screen that contains a list of items and would like to offer the end user a way to display it in different sort order. I have created buttons that run scripts that work fine, but want to offer a drop-down box to do this, however, a drop down list is essentially a field, as as it's a field, the information is stored in the table. The problem with this is that if several users want to access this screen each wanting their own sort order, then this method does not work. Is anybody aware of a method I could employ to achieve this? Cheers, Greg
-
-
- 2 replies
- 1k views
-
-
I have a page that contains 3 portals. "Process" Filtered by "StatusIP="Process" "Hold" Filtered by "StatusIP="Hold" "Finalized" Filtered by "StatusIP="Finalized" Each record has a field "TotalQuote" I want to get a total of "TotalQuote" for all records in each portal. Can't seem to get to work, tried using "Summary field". Any help would be appreciated.
-
- 2 replies
- 1.1k views
-
-
My value list is created from entries I make in a field. I have used this list for several years and it is quite long. I pick the entry from a pop-up menu. It is working perfectly. However, I noticed some wrong entries and would like to remove them. How do I do this? There is no place where I see the values in the list. I am using FM Pro 12, Mac OS X 10.8.3
-
- 6 replies
- 3.5k views
-
-
I need a script to 'HTML' post some data to an api web-site. I have no idea what to do. Any help would be appreciated.
-
- 0 replies
- 1.1k views
-
-
Hello, I have a portal with many rows which is used to navigate a list of contacts. The user may scroll up and down the list but when they click on a record, obviously the portal gets refreshed as it goes to the related record. I am attempting to effectively make the selecting of items and scrolling to be more natural, and by natural I mean more consistent with my OS environment behavior (which is Mac.) Ideally I would like the user to click on a record but as it goes to its related record, the position of this sidebar portal which stay in the same location after the refresh. Any thoughts or ideas? Thanks in advance or if you have any questions or need further exp…
-
- 8 replies
- 1.7k views
-
-
I was wondering if it is possible to use local html data (i.e. "data:text/html," & $OtherStuff) to access PHP functions? My little tests haven't gone well so far. Here is what I have tried: Table "PHP_test"; 1 text field: html_code Layout: 1 edit box for PHP_test::html_code, one web viewer The web viewer has the 'web address' defined to be "PHP_test::html_code". I populate the field on the layout, it shows on the web viewer (or at least that is the idea). I am exploring the possibility of using some PHP functions to achieve results on FM data in the database. My first test was simple: <html><head><title>PHP Test</title><…
-
-
- 4 replies
- 3.5k views
-
-
I am using FM Pro 12, OSX 10.8.3 I have used several layouts since FM Pro 5 (I think). I upgraded to 7, 9, and now v 12. On one layout I just noticed that a field is now appearing in scientific format, not just as a number. It used to appear ok. Since it exists on other layouts ok I tried to see what the difference was in the inspector, and I could not see any difference. I copied the field from another layout where it was ok but when viewed on this layout, it too, appeared in scientific form. How can I get it back to the way it was?
-
- 2 replies
- 783 views
-
-
I have a log book, which totals a number of hours in a column. I have set up a report which prints 25 results per page. I would like to have a summary at the bottom of each page of only the totals of that page and all the previous pages. Kind of like a running total. I've tried a few methods but can only seem to get a summary of the entire set of records (all 3000). In other words, on page 1, it should total just page 1, on page 2 it should be a total of both page 1 and 2. Can this be done without having to manually create a summary field for each block of 25 records? Thanks skekum
-
- 9 replies
- 2.8k views
-
-
How to place the layout in the middle of the screen ?
-
-
- 3 replies
- 1.2k views
-
-
Can't seem to find this out -- If I am viewing a web page in webviewer (in Filemaker) is there any way to get that exact URL from the webviewer and open it in an external browser (i.e. Safari, Chrome)? I know the starting page already, but the user may have navigated away from that page when they want to open the external browser. I have searched this site for an answer and also other FM resources on the web. Maybe I am using the wrong search terms? Seems like a straightforward thing -- I am viewing a page in Filemaker and I need to open that page in a stand alone browser. Click a button and voila! (?) Any help is appreciated. Thanks! -Rob
-
- 3 replies
- 5.3k views
-
-
I have created a layout form which uses number and calculation fields. I'd like to convert it to a webform for non-filemaker users. I'd prefer not to just recreate the form in excel as I'd like to preserve the graphics and appearance that I can produce in FM. I use v 11 advanced. Any suggestions would be greatly appreciated!
-
- 1 reply
- 800 views
-
-
Hi there, I created a layout with FM 12 and the list shows only the selected record. I have 150 records but can see only one record at a time. Why's that?
-
-
- 5 replies
- 935 views
-
-
I'm attaching an image that shows a small grey square about half way down on the right side. Does anyone know why this might be there? I can't find any evidence of it in layout mode, but it always prints. Rick.test.pdf.zip
-
- 16 replies
- 1.3k views
-
-
I have a form document using merge fields that includes the language "SCPA 1708.2(a)" as part of the boilerplate There is no space between the 2 and the (a), yet sometimes the merge fields cause SCPA 1708.2(a) to go all the way to the right margin. When that happens, I get SCPA 1708.2 at the end of the line, and the (a) at the beginning of the next line. They really need to be together since it is a section of law from the Surrogate's Court Procedure Act. Is there a way to force text to be kept together, no matter what? Thanks, Kevin
-
- 2 replies
- 1.1k views
-
-
How do you use a drop down value to filter a portal?
-
- 1 reply
- 832 views
-
-
Hi All, I'm a newbie in File Maker.One of my client who is having a share point site likes to access a set of data which he is maintaining in the file maker.I would like to know -Is there anyway that we can access data stored in filemaker from a share point site? -How to connect filemaker and share point? Can anyone please help me out wit the details. Thanks & Regards, Rajee
-
- 3 replies
- 6.9k views
-
-
Hi, I hope this is the place to post the question and that questions are even allowed. I am a complete novice thus needing some quick questions answered that i can not seem to find in any helps. I have customized one of the "starter solution" layouts better suit my needs. I used one of the asset starter themes. I used the assests:Desktop:asset details to customize. My question is this, Is there a way, now that i have the asset details form how i want it, to apply this to all the other functions. Like for the other desktop sub catagories or the ipad sub catagories of themes. I would like to apply my changes to the starter solution to the Ipad "assets" and …
-
- 3 replies
- 1.3k views
-
-
Greetings, all. Â How would I pull this off (see attached)? It's a dynamic value list from another table and what I want a user to be able to do is click/enable the value choice and have the choice's text copied to the clipboard so it can be pasted into another app's data field. I got as far as figuring out that a script trigger would come into play but after that...? Â IIRC, whenever you enable, by way of a checkbox, a VL item its value is placed at the end of the field list, no? If so, how would I grab the the value from there? Â Ideally, I'd like to be able to code the list so a user can click-and-drag (or copy and paste) a value to the clipboard but I'm guess…
-
- 7 replies
- 1.1k views
-
-
I am converting an FM10 solution to FM12. I have a number of portals which contain a 0-line, no-fill rectangle object which is formatted as a button to perform a script. These objects are darned hard to grab to change the button attribute. The plan is to give them names so that I can use those object names as script parameters. What I have done is to pull the fields out of the portal and then try to lasso the button object. This is a hit or miss technique that takes a long time and is very frustrating, not to mention having to put the portals back together after I finally do get the change made. Does anyone have any tips/techniques/tricks to select those objects…
-
- 1 reply
- 875 views
-
-
Hi all! Admittedly, I am just now starting to work more fervently with FileMaker 12. I was doing just that yesterday when I ran into an odd behavior that may or may not be a bug, but I wanted to get some feedback from the forum members on. ie, has anyone else seen it and how did you deal with it. The scenario: FileMaker Pro 12 Advanced. I used custom menus to script the Close menu item. For the sake of testing, I made the script that the Close menu item calls a single step: Close Window[Current Window]. Two windows open and visible by the user, Window A and Window B. The symptom: If the active window is Window A and the user clicks…
-
-
- 5 replies
- 4.1k views
-
-
I would be grateful if someone could help me with this calculation for Conditional Formatting. I have a birth control portal that gives the next birth date according to the last service. I would like the birth date to change colour with the proximity of the event. For days > or < my formula works but not for a range of dates eg 255-269 days If (Birth control_HEATS::HEAT = "LAST" and GetAsNumber(Get(CurrentDate)) - GetAsNumber(Birth control_HEATS::SERV_date) = 255-269 ; 1 ; 0 ) I have tried using 255...269 and 255..269 but not accepted.
-
-
- 2 replies
- 1.7k views
-
-
Hi everyone, Let me explain my situation. I have table PRODUCTS where I have simple edit box where I'm collecting feedbacks from client until client likes a product. Every feedback starts with header informations like date, feedback from, product name etc. I made a script which creates for me header+feedback text and joins it with older feedbacks and finaly put all this in editbox named feedback history. It is good for fast editing but not as good for record manipulation as it is in single record.Sometimes I need to find out all comments given at specific day and current concept doesn't allow it. Ideally I would love to have 1 table FEEDBACKS with all feedbacks given …
-
-
- 6 replies
- 6.6k views
-
-
hi, is there a quick way to align text fields and its label by the text baseline? although sometimes aligning top/bottom/center seems to work, sometimes it does not. the baseline seems to be the proper criterion for alignment. thanks, stefan
-
- 0 replies
- 1.1k views
-
-
I want to trigger a script with the drop down list. I can not seem to get it to work. Any help would be appreciated. I just want to perform scripts using the value of the drop down.
-
- 2 replies
- 1.1k views
-
-
My solution was designed when a good monitor had a 1024x768 display with a zoom level of 100%. Newer monitors have increased resolution, e.g., 1600x900. The result is that the solution occupies a smaller proportion of the display area and the text appears very small. My users want to 'maximize'. Of course, maximizing just fills the rest of the screen with the background color for the layout and doesn't increase fonts etc. The only way (I think) to do what they want is to 'zoom'. However the next available zoom level is 150%. There is no way to scale up the window size on a 1600x900 screen (I don't think) so that the display will show at 150% without scroll bars. Redes…
-
- 2 replies
- 1.2k views
-
-
i trying to open this Url: http://www.smstrend.net/Trend/[email protected]&password=XXXX&message_type=GP&recipient=%2B393356292016&message=test &sender=franco i get an error because the red part of the url is passed to the browser as: http://www.smstrend.net/Trend/[email protected]&password=XXXX&message_type=GP&recipient=%252B393356292016&message=test &sender=franco i understood that it could be a unicode error but i don't Know how to solve it. Thanks for your help.
-
- 2 replies
- 1.4k views
-
-
I added a scrollbar to a text field. Now, the cursor is always positioned at the end of the field when entering in Browse mode. Even if I put the cursor at the top, then change records, when I go back to the previous record, the cursor is back at the bottom again. No matter where I leave the cursor upon exiting, it is always at the end when I return. This a headache for records where the text value is many paragraphs long. I have scroll up to the top every time I enter the field. Can't find any format settings that set cursor position. I'm not well versed in scripting, but I suspect this issue may require some kind of event-triggered script. If that's the only fix, ca…
-
- 1 reply
- 890 views
-
-
I'm not sure if this is even possible. If you have an element on a layout (text box, portal) that you've set up in a window with scrolling, FM 11 by default places the scroll slider at the very top. Upon calling this layout, what if you wanted the scroll slider to auto-appear at the bottom of the scrolled element instead? Is that a script step or script triggered event? Hoib
-
- 3 replies
- 944 views
-
-
I've used FM10 for years but just recently (finally) got FM12. With custom menus, I can attach my own script, easy. So I attach to the "close window" command my own "close window check" script. Easy. And I attach to the "find mode" command my own "enter find mode" script. Easy. Now, within any other scripts, if there's a "close window" script step, the "close window check" script is triggered because it's set to do that within my custom menu. This is a pain but you can get around that in various ways. I used global variables to turn on and off "script triggers". But what I don't get is: Within any other scripts, if there's a "enter find mode" scrip…
-
- 2 replies
- 2.2k views
-
-
Is there any way via custom menus to disable hitting Return to perform a find from Find Mode? I'm trying to allow Find Mode access to a certain group of users but I want to keep them within the found set, so I thought disabling Perform Find and Extend Found Set in the Requests menu (leaving only Constrain Found Set) would do it. Perform Find is greyed out in the toolbar, but hitting Return still invokes it. The Perform Find menu command doesn't list anything as a keyboard shortcut in custom menus, either. I know that I could create a script and attach it to the Find Mode menu command, but I was hoping this would be a quick-and-dirty way to give them what they wa…
-
- 2 replies
- 2.8k views
-
-
In FM 12 Advanced I cannot get the Tab Panel Script Trigger script to return a Tab Panel Object Name using either of the Get functions: Get(TriggerCurrentTabPanel) or Get(TriggerTargetTabPanel) I have used the GetValue(Get(TriggerCurrentTabPanel);2) but it returns nothing. Using the same function GetValue(Get(TriggerCurrentTabPanel);1) returns the Panel Tab Number. I've watched videos of people doing this and I've copied examples but cannot get it to work. Anyone have a suggestion? Thanks, Jesse Filemaker Pro 12 Advanced Mac OS X 10.8
-
-
- 6 replies
- 3.9k views
-
-
I'm not sure which section to post this question in so hopefully this isn't too far off. A client came to me with a question I never considered and don't know how to answer. They are using Filemaker 11. If you have full access privilages in a database you can right click in a field and have the option for sorting by that field either ascending, descending, or by a value list. However, other privilege sets don't seem to have this option and they want them to have that option but not have full access. I tried setting their Available Menu Commands to All, but that does not change anything. Does anyone have any idea how to change this? To be honest I've never even noticed the…
-
- 0 replies
- 1k views
-
-
Hello, I have a problem with my first layout using a portal. The relationship between the two tables has checked the option for allow adding new records on the portal side table. If a click on the portal I can create a single record but then I can't create new records. So my portal doesn't allow more records after I created the first one... Somebody can help here? Thanks in advance. Manu
-
- 1 reply
- 927 views
-
-
I have a six file solution with hundreds, maybe a thousand or more layouts. When a full-privilege user opens the solution I want the standard FM menus to display. When any other user opens the solution I want a set of Custom Menus to display. Can I do that? How?
-
- 2 replies
- 2k views
-
-
Hi all - I can't seem to figure out a good option for this aside from a portal. I'm building an order fulfillment database for our outside sales team that they will use to order sample products, marketing material, etc. Ideally, I picture something like a list view that lists all of the products (~40-50) by category, and then a box for the quantity. They would scroll through the list, add their quantities, and hit "enter" to trigger a script. But how would I do this with multiple users accessing the same records? Would I duplicate all the product records and tag them to the user, so each user has their own product list, then filter the records according to …
-
- 7 replies
- 1.2k views
-
-
For some reason the size of the background changes when I go into layout mode. No matter what I try, I cannot drag it back to regular size. I have attached a screenshot of the problem in layout mode. I can't seem to get the background back to regular size. When I switch out of layout mode, it expands and looks fine. Any easy answer to this problem? Thanks! Mike
-
- 9 replies
- 899 views
-
-
   I have a MEMBERS table with the usual information: Name, address etc...  I have a layout based on MEMBERS called Member Summary Information . In the header of this lo I put the field Members::Name_Full and made it a POPUP.  I wrote an OnObjectModify script that runs the script above when the user selects a Member name from the popup.  <<ALL THE FIELDS ON THE LAYOUT ARE FROM MEMBERS. When I select the popup and change members, the address information stays the same. Why?  How do I get the address information to update to show the newly selected Member from the popup? >>  I tried including the PK_MemberID in the p…
-
- 17 replies
- 1.6k views
-
-
Hi. Has anyone else observed this in FM12? I have a pop-up value list on a number field. The value list inserts a record number, but displays a second field, which is a text field. The text in the second field is interspersed with numbers. As long as the total number of digits in the second field is less than 9, everything works as expected. If there are nine or more digits, however, wherever they are located and even though intermixed with letters, the field only displays the numbers themselves, without the intervening letters. The pop-up list looks correct, but the selected text changes into a string of numbers in the actual field. Is there any explanation f…
-
- 4 replies
- 1.1k views
-
-
Fix it///  found a piece of code that looped.. several lines// with a delay and counter// seems to work  thanks  Hi I am just trying to simply extract Date/Time as a reference to a variable... from a US Naval time site..  (suppose one site is as good as another?)  When I parse out the Pacific Time,   it still is yesterdays?   seems like browsers,  I need a refresh of some sorts?
-
- 0 replies
- 1.2k views
-
-
Is it possible to format a field so that the field's font size changes downward (reduces) when the text is longer than the field size. The object is to allow the data to fit the field content and avoid a 'wrap'. Sometimes one only needs to drop down a size (12 pt to 10 pt say) for a text to fit. It would be a useful characteristic or option for field behavior. One wants to be able to set a minimum font size since dropping down to a 6pt or 4 pt font might not be a desirable outcome. Thanks
-
-
- 8 replies
- 9.9k views
-
-
Hi, I'm putting together a database in filemaker 11 to schedule volunteers for events and I was wondering if it is possible to have the text color change in a portal row if a volunteer gets scheduled for more than one event at the same time. So far I have 3 tables: Volunteers JoinStaffVolunteers Events Each Volunteer record has a portal that lists all the events that the volunteer has signed up for, and each event has a portal listing all the volunteers that are going to the event. I would like the text to change to red in the portal rows if the volunteer gets scheduled for two (or more) events that take place at the same time. Is this possible, and if so h…
-
- 5 replies
- 1.7k views
-
-
Basically, I want to allow users to add items to a checkbox list on FM Go. The scenario is this; I have a text field called "visit notes". To the side of that is a checkbox list with existing items set up as custom values using 'Manage Value List' window on FM12 desktop. When checked, the text of the checked item is inserted into the text field. So far all works fine. I want to be able to allow users, on the iPad, to be able to add custom items to the list but NOT by using the 'other' checkbox that appears when you select 'allow entry of other values' in the Inspector (as this results in a drop down list of the additional items when the user selects 'oth…
-
- 1 reply
- 993 views
-
-
I have a database that contains a value list that is made up of values from a field (Person's Name) in one table. In a layout for a related table, I have a drop-down list that uses the value list. Recently I noticed that some of the items (Names) that should be in the value list/drop down list do not appear. I have the value list to sort the names, so when selecting the drop-down list I see names in ABC order. The names that do not appear are towards the end of the alphabet (ex: Walter Smith.) However if I change the name of Walter Smith to AWalter Smith, it then shows up, but then one of the names that previously showed up at the bottom is not there anymore. The…
-
- 7 replies
- 7.6k views
-
-
I have a portal that I use to display tasks that have been assigned to specific associates. Currently I filter them so that if the task status is "Complete" it gets removed from the portal list. This works fine. Tasks::tStatus ≠ "Completed" I also added a field to the tasks table, "parentProjectStatus" in hopes that I could filter out tasks that belong to projects that may have been cancelled or put on hold. The field is set to be equal to Projects:Status. Tasks::tStatus ≠ "Completed" and Tasks:arentProjectStatus = "Current" The problem is that the filtering doesn't always work. If I go to my projects layout and change the status of a project and come back the tasks a…
-
- 0 replies
- 824 views
-
-
Is it possible to have a custom menu appear once the user right-clicks a portal row?
-
- 8 replies
- 3k views
-
-
I couldn't find what I was looking for on the forum. I was wondering if it's possible to create a value list showing only unique values. Example: Camp sites value list showing: Site #1 Site #2 Site #3 Site #4 Record 1 of a reservation table selects Site # 2. Record 2 of the reservation table would now see the camp sites value list as following: Site #1 Site #3 Site #4 Record 2 selects Site #3. Record 3 would see the camp site value list as: Site #1 Site #4 Hopefully I explained what i'm trying to accomplish clear enough. Thanks for your help in advance.
-
- 2 replies
- 3.2k views
-
-
I work for a law firm and we hold Wills, Powers of Attorney etc for our clients. I am creating a database to record what we hold that will allow our staff to create a receipt for clients to sign when they need to take the documents away from our office. Some clients have several documents, but only wish to take away one or more of them. I need the user to be able to select the documents based on the Testator's name and then print the receipt for the selection. Additionally, in my layout to view the documents held, the pdfs are viewing in landscape, when I need them to be viewed as portrait. The pdfs are always legal sized paper (8.5 x 14). I attach a copy of …
-
- 0 replies
- 784 views
-
-
Hello! I'm a complete novice and I'm wondering why some of the edit boxes turn red when I add additional fields  to my table?   I've added a picture on this! Really thankful if someone can help me!
-
- 1 reply
- 1.2k views
-
-
Hi All, I am trying to create a series of records in a related table from a portal but my Loop is failing at the "Go To Next Portal Row" script step as it returns to the layout and selects the first portal row. Could you advise on where the script is failing please. Script: Go to Field [ Job_Card::Job_No ] [ Select/perform ] Enter Find Mode [ ] [ Pause ] #Allows the user to select the Job Card then finds the Active Items in the Installation_Items and sorts them Perform Find [ ] Copy [ Job_Card::Inst_No ] [ Select ] Go to Layout [ “Installation_Items” (Installation_Items) ] Enter Find Mode [ ] Paste [ Installation_Items::Inst_No ] [ Select ] Perfor…
-
- 1 reply
- 1.6k views
-
-
Not sure if this is the right place. If not please point me in the right direction, I'm new here. I'm creating a database to record details of sessions with a client. After each session, I record several different types of notes & other information stored in one session record. I also store 'notes for next time'. What I am trying to to do is get these 'notes for next time' to appear in a layout when I create a new session record. I just can't figure out how to do it. I would be grateful for any suggestions. Is a portal even the right way to go about it?
-
- 2 replies
- 843 views
-
-
I am needing to create a report that essentially would need to bring in 2 list views on the same layout (one will be a list of expenses and the other a list of income). What is the best way to bring in these records in a list view on one single report? Thanks for any feedback. Stephen PS - I am using FMPA12 on a Mac
-
- 3 replies
- 897 views
-
-
Hello, I have a sidebar portal that has a list of 300+ contacts. I am attempting to create a script that will navigate to the previous and next record in the portal (which may or may not be filtered.) I don't always have the current row number of the record being viewed. So my question is... how can I get the portal row number of a particular record when no portal is currently active? Do I have to loop from the first record to the last until it matches? Is there an easier way? Thanks, Stephen
-
- 4 replies
- 2.6k views
-
-
I'm having difficulty creating a simple line chart for related data in a tab panel. Currently, I have a "grid" of related fields (spreadsheet style, rows/columns) in multiple tab panels. Each tab panel needs to show a single related record. This is done by displaying the related fields in a portal on each tab panel, with each portal set to show only 1 row (row1 = record1, row2 = record2, etc). Thus, tabbing through will show one related record at a time. All of this works fine until I want to use a line chart to display the same data. I believe the issue is here: The chart will allow me to display a) the current record, b ) the current found set, or …
-
- 2 replies
- 1.7k views
-
-
Hello... I have build a layout with 15 field dynamically, both titles and the data field. However.. sometime these 15 fields are not always used.. the remainder fields are blank Still in my layout Tabbing through... ALL these field still exist I can hide them no problem using a Condition, if a certain field is empty But when data entering.. its still there.. I can tab down these blanks.. Is there any way to disable the field from a GET? TIA Rod
-
- 2 replies
- 838 views
-
-
Hi, I am having a javascript timer running in the web viewer. At certain moments I have to clock-in the time running in the web viewer. At that clock-in moment I am creating a new record in a related table. Each time when I create a new record in the related table the web viewer refreshes itself and the timer starts all over again from the beginning. Is there a way to keep/stop the web viewer (from) refreshing/reloading. Thanks DikkeHenk Rotterdam Holland
-
- 7 replies
- 2.8k views
-
-
Hello, I'm hoping for someone might point me in the right direction for this strange anomaly. At first, I wasn't sure what was producing the error but I have to do is login through IWP and on the first page, all I have to is click edit and then submit. This first page has two portals, one for the projects, and the second for the requests of those projects. A few "random" projects will duplicate their title within the projectName field. Something like "Hotel Sonesta" will become: "Hotel Sonesta Hotel Sonesta Hotel Sonesta" There is no auto-enter, and no script involved, and I've been trying to figure out what might ties this projects together but I hav…
-
- 4 replies
- 1k views
-
-
Looking for a hero. I have searched for an answer to this online and if one already exists, please point me to it. Otherwise, I'm hoping there's a FMrock star out there capable of identifying what I'm doing wrong. Am trying to create three levels for conditional value lists to identify the location of assets. Consider this a library inventory sytsem that tracks: multiple locations where items are held, multiple aisles within each location, and multiple shelves on each aisle. The goal is to enable users to enter an asset record and select from a value list of LOCATIONS. That's a straightforward list from the LOCATIONS table. Works fine. Next the user should be able…
-
- 1 reply
- 1.6k views
-
-
Hi, I'm hoping to divine a way to achieve the following: If a particular condition is met, a checkbox will be displayed, otherwise, "invisible". I'm familiar with using conditional formatting to achieve this type of result with text fields, etc., but of course, conditional formatting cannot be applied to the line attributes of a checkbox. Any ideas? Thanks!
-
- 12 replies
- 9.7k views
-
-
I hope this is in the correct area. We have a portal to where each record the User can select Contact Type(phone, fax, email, cell phone, etc) then they can enter the correct info in the field Contact Data. I need to know if Email is in their Contact Type and if so what value is it so I can locate it in the list of Contact Data. thanks, Jim
-
- 1 reply
- 961 views
-
-
I have a working portal with 2 fields: Degree (holds 1 2 or 3) and Description. The description is part of a Dynamic Value List (based on degree) and it works great; sort of. The problem is a user sometimes forgets to first indicate the Degree but instead clicks the Description fields which then shows "<no values defined>". Question: "Is there a way to trap / eliminate the <no values defined> message and substitute a user friendly reminder like "You need to first supply the Degree". Thanks
-
- 10 replies
- 2.1k views
-
-
We use an appraisal form which is on paper. People fill in their name and answer a few questions. We can scan them all in in bulk. I want to somehow get the scans into filemaker so people can type them up. Ideally FM would split the questions into different container fields and then data entry workers would each get a question at a time to type up. This way the work can be distributed accross workers. Any ideas?
-
- 1 reply
- 997 views
-
-
I have a layout that includes a header part. I realised that I want that header part to be a Title Header part because I only want it to appear once - on the first page. Whenever I change the part from a regular header part to a title header part, the entire title header disappears in browse mode. It reappears in Preview mode and prints correctly and pdf's correctly, but when in browse mode, the entire part is not visible, the page starts at the body. If I change it back to a regular Header part, it behaves as expected, and heads each page in the print, which is not what I want. Am I doing something wrong? I am in List view, Table view is disabled. I have some…
-
- 1 reply
- 3.3k views
-
-
This is probably a small thing ... unless it catches you off guard like it did me ... I use webdings for creating buttons because they are low resource and color can change via conditional formatting. But when I convert to 12 and apply custom theme, Webdings changes to the theme font as well and all those graphics become worthless text. Just be aware of it. :-)
-
-
- 3 replies
- 2.4k views
-
-
I have 3 tables Client record Session note Intervention. I want a field in session note to use a checkbox value list to enter text based upon the a field in the intervention table. However, I would like to be able to add intervention descriptions as I go, is it possible to use the "Allow entry of other values" option to add to the Intervention table? If not, how can I solve this. The intervention table is not currently related as I can't work out a logical way to do that.
-
- 1 reply
- 1k views
-
-
I'm using the web viewer to scrape data from a website on a daily basis. The script loops through my records and loads the web page. I use a loop script like the below to make sure the page has loaded before scraping data. Loop Pause/Resume Script [ Duration (seconds): 1 ] Set Variable [ $html; Value:GetLayoutObjectAttribute("source";"content") ] Exit Loop If [ PatternCount($html; "<head>") ] End Loop The problem is that occasionally the web viewer returns a "the request timed out" error in the status bar and this causes the script to just loop infinitely and not complete. If I come across this error and manually load the page again it continues with …
-
- 1 reply
- 2k views
-
-
I am running 12 v 3 advanced in Windows 7  The situation is pretthy simple.  I am on a layout. But pressing a button, the user goes into PREVIEW. This works.  However, in Windows the printer icon at the top of the formatting bar / tool bar is grayed out and not functional.  In OSX it works as expected.  Same script   Ideas are appreciated.  Thanks    Â
-
- 10 replies
- 1.6k views
-
-
I am using FM 12 03 Advanced on OSX  I have a layout based MEETINGS and a portal on that layout based on MemberMeetingJoin. (FYI The LO is based on Meetings because to the right is another Join Table that holds VISITORS and there is a second Layout to the right that holds a portal based on Visitors.) Everything works OK   On the left Members portal, I have the the MemberMeetingJoin::KF_Member field.   The Value List definition for MemberMeetingJoin::KF_Member is:   And consists of the KF_Member field and NotDOP which is a calculated field that puts the name of the member in the NoDOP field if the member is not deceased. It works  =…
-
- 1 reply
- 1.6k views
-
-
I have a standard government form that I would like to auto-populate that has boxes for each letter as many have seen. The original PDF is not an active form, nor do I want to mess around with Acrobat. Even if I did I think I would run into the same issue of putting one character in each box. So, I have converted the PDF to a JPG cleaned it up / resized it and have it on a layout that I want to populate with FM data. Obviously, I can't just drop the fields on the layout because the text doesn't line up with the boxes. I tried playing with font sizes etc., but without control over character spacing I can't line them up. So, my idea was to create a custom functio…
-
- 3 replies
- 970 views
-
-
The summary field in a portal does not update automatically when values in field changes. I have to double click on the filed to update ... what's wong I'm doing?
-
- 2 replies
- 4.6k views
-
-
my system is being designed on a mac, and it's looking pretty good - clean, user friendly windows, and it looks like an independent application as the filemaker interface is transparent. however, it is going to be used cross-platform. when the application is opened in windows, the filemaker background is grey and unattractive, and the interface windows have grayed out scrollbars on the right and bottom of each of each frame. any way to clean this up on windows? i need to leave the database inside of the filemaker application as i will be doing layout updates and changes as the system grows. if only our users were all using macs...
-
- 4 replies
- 1.8k views
-
-
I want to incorporate the ability to draw in to my system. I was thinking a flash document accessible via the web view should do the trick. However, I'm thinking there could be an issue with the flash document talking with filemaker - knowing which record is currently being accessed, etc. Is this possible?
-
- 0 replies
- 1k views
-
-
i am using a portal row where the user can enter history for particular items. the portal row has a button for each record to open a new window where additional information (four fields) can be entered for that particular related record. i want to incorporate a non-user editable check box in to the portal row that will be checked if these additional fields contain values, and not checked when they're empty. what is the best way to do this? i'm assuming a single value must be auto entered in to the check box field using the IsEmpty function. is this a script trigger or calculation? that's needed?
-
- 5 replies
- 949 views
-
-
Hello, I am beginning a project that includes a time table schedule for employees, based on 15 minute increments. The layout is for just one day at a time. Each employee is on a column, each row is a 15 minute increment. I am contemplating the best strategy to provide the cleanest interface with the most functionality. I was planning to use a portal for each employee column, and a separate field for each 15 min. increment (from 7AM to 9PM); but this seems like too many relationships, not to mention hard on reporting. I appreciate any thoughts you may have, as I am open to all ideas at this stage of development. JohnnyZ
-
- 2 replies
- 1.2k views
-
-
Hi Everyone, I am having a problem with my Events Registration. I hope someone has a suggestion and thank you in advance! Whenever we register guests for an event, we sometimes put in duplicate names as temporary placeholders. For example, if someone buys 5 tickets but hasn't given us the names of all the guests. Once we get the names, we change the guest records accordingly. Unfortunately, the guest list (Guest Tab) won't sort properly (alphabetically by last name) based on the updated guests (see portal row 2 on the sample attached). The same problem occurs if you add a new contact from this portal, using the green + sign. Any ideas on how to fix this? W…
-
- 3 replies
- 1.8k views
-
-
I have created a conference tracking database that has three tables: - Association: The association that puts on the conference. ie Medical Association, Real Estate Association, etc. - Event: The reoccuring conferences of the association. ie Spring, Fall, etc - Conference: The actual conference that includes date, location. ie Medical Association 2013 Spring Conference on 3/15/2013 in New York The problem I am having on my Conference layout is that I select the Association that is using a popup menu control with the list of assocations, then I want to use a popup menu control that provides a list of Events that are only related to the Association. After that I…
-
- 1 reply
- 1.5k views
-
-
using filemaker pro 11 I created a working portal that views INVENTORY items. Using a VENDER field I was able to get the to portal show only related records. (based on venders). The VENDER field is a drop down, value list, of venders. In addition to viewing inventory items for each vender, is there a way to view all of the inventory items regardless of vender. In other words .. is there a "view all records / command J" function for the portal. let me know if you need more specific information. jeff
-
- 2 replies
- 852 views
-
-
Hi Everyone, Apologies, as this must have been asked before (I have searched and browsed). I have a portal sorted in the Length_of_Time since i've spoken to a person, with those most recent at the top. If i haven't spoken to a person, their field is empty. When i sort, empties go to the top ... https://www.filemaker.com/12help/html/find_sort.5.25.html Is there anyway to get them to the bottom, so that only those i've spoken to most recently are at the top? (I was thinking a kludgey way of doing it would be to say that if i've never spoken to them, set the Length_of_Time to a huge number, but it's not that pretty!) Many thanks for any help Slater
-
- 5 replies
- 1.8k views
-
-
Hi All, I have a field on my layout that is linked to another table through an ID field. I want the user to be able to select the field using a drop down value list. So my first field is "COMPANY ID" which is a serial number, and my display data (second field) is "Company Name", which is obviously text. The display on the drop down looks like this: So far so good. The lousy part, is after they have selected the company they want, the display in the edit box defaults back to the id number (like 342). Is there any way to get this to display the Company Name instead? Thank you in advance! Ryan Smith
-
- 2 replies
- 937 views
-
-
For some reason, filtered lists give me more trouble that just about anything. And they appear to be such a basic thing that I am frustrated that it eludes me. The technet manual hasn't done anything to clarify it so I turn for help to you guys/gals. Here is my problem. I have a product table, products have a category(either A or B in a field called productCategory. On my invoice entry layout (based on the Invoice table), I have a portal showing the invoice line items (based on the InvoiceLineItem table; relationship is Invoice :: InvoiceLineItems based on Invoice ID). I would like to have the productID field display only products based on a category, for example, on…
-
- 1 reply
- 882 views
-
-
I have a portal with 5 fields in the row 1. Why the FileMaker adds a new empty portal row immediately after I enter a value in the first field in the row. How can I make it adding new row after entering the value in the lasat field in the row? 2. Is there away to hide portal row with empty field?
-
- 3 replies
- 1.4k views
-
-
I am using FM 12 Adv in OSX and Windows I have a MEMBERS table that has: PKMemberID etc ActiveInactive (that holds the value 'Active' or 'Inactive' I need to base a value list on just the 'Active' Members. I suspect I make another TO of Members but I can't 'get' how to setup up the 'filter' for my popup that will show just the Active members... I am mentally stuck. Can someone give me a swift kick to get me started? Thanks Ron
-
- 4 replies
- 1.9k views
-
-
I need help with the above function. I have a database with companies. In the date box for when the accounts are due say 01/01/2013 - If the date goes past this date then I want the box to change to red. Example when the date goes to 02/01/2013 then the boxes turns red. Hope someone can help as I am new to filemaker. I am using Filemaker 10. Thanks for any help.
-
- 3 replies
- 2.1k views
-
-
Hello, I want to get list of all connected printers thru my custom plugin using 360works. or How can we get any printer using index(i.e. Printer(1)=printer no. 1 and Printer(2)=printer no. 2)? My main task is to design Printer setup by which user can set printer/Printers for printing. Please provide me java code for the same.... Thanks Anirudh
-
- 1 reply
- 2.2k views
-
-
We have number fields which are dollars and I have formatted them with two decimal points. Sometimes people put 3 decimal points and that is allowed - even more if they wished. But what they don't want to happen is that when they click into the field, a 3.00 turns into a 3. They think it is very distracting and weird. I tried formatting the number using inspector but that just handles the display. So what I want is to default with .00 I think, as actual data. And when they enter a number, it formats it so the following is the result (first number is data entry and second number is number result in the field itself. 1 ... 1.00 1.245 ... 1.245 1.1 ... 1.10 -…
-
-
- 8 replies
- 1.3k views
-
-
Okay, version 12 will be on ipad and iphone also and I have separated model. I have 15 icons I use for various buttons. Is it best to: store them in container so server has to pass them down to people (easier for changing icons later but they probably won't change). paste them onto each layout as a layout object so they do not have to be downloaded but are part of the layout (will take more work if we decide to change one). Use a file on each station to hold these icons and maybe other stuff which doesn't change. I have read enough to really confuse myself but nothing that specifically says the best way. I have the company logo in a container in the Interfa…
-
- 1 reply
- 749 views
-
-
i am creating my own dialogue boxes for my database. i want the new windows to position in the center of the original layout on screen. the 'distance from top' and 'distance from left' options are great, but they reposition based on the edge of the monitor rather that the active filemaker file. i'm assuming a calculation in these fields will solve this... how would i go about this?
-
-
- 1 reply
- 737 views
-
-
Hey all. What's the best way to have a field display the latest record in a portal row? For space purposes on the original layout, the portal row is only accessible through a script that opens a new window. I want the user to be able to see the newest record in a field on the original layout. Edit: The related records are date and time stamped, which is used to sort them.
-
- 2 replies
- 787 views
-
-
Hello, I am at my wits end trying to figure out what is going on with my Events_Guest portal! For the most part, I have used the scripts and fields that came with the Events Management template. The technique for adding a portal record uses the contact ID field placed below the Full Name field, allowing a search using the last name. When participants sign up for a program, they are assigned a time slot. When the event is originally established, all the time slots are entered with a blank contact name. This way a volunteer can just sign a client up by clicking in the name field and using the pull-down list (which works) or if the contact is new, they click on the …
-
-
- 9 replies
- 1.5k views
-
-
Hello....I am totally new to File maker coming over from ACCESS...I see that there are some things that are close to each other. Well im having trouble getting the value lists to show what I need...not sure where to go.. what i have is this. table LIfts: LIft_ID Lift Lift Classification 1 Bench Press Horizontal push 2 Incline Press Horizontal Push 3 Power clean Explosive 4 …
-
- 3 replies
- 1.1k views
-
-
Does anyone know the precedence of the the OSX print dialog's saved print configuration settings (IE. "last used" or "custom saved print presets") vs. print setting in FMP print script step? I am setting up "print setup" and "print" script steps however it seems some settings are still followed by OSX setting such as two sided. Anyone have any experience with this? Thanks,<redacted>
-
- 1 reply
- 1.5k views
-
-
I have a conditional value list set up to show only values for active accounts. The value list is defined by the calculation field cActiveAccountID = If (CustomerStatus = "Active" ; CustomerID) The value list shows values both from the CustomerID field and from a second field: CustomerName The value list works perfectly if I sort by the first field. However, I would like both to sort by and display only the CustomerName. Meaning, I would like to sort by the second field and display only the second field. If I select either of these options the value list now returns all customer records, for both active and inactive accounts. Has anyone else run into thi…
-
- 11 replies
- 1.7k views
-
-
I don't know where to start with this one. Inside a portal I want to control both where the cursor is placed and limit text placement by calculation. I'm trying to mimic an outline display akin to Word where based on some set of conditions, i.e., some predetermined level/hierarchy structure, the cursor indents accordingly and restricts the placement of text to the left of the cursor placement within the portal row. In the past I've just used a calculation field placed on top of the text field in conjunction with some conditional formatting. I'm just wondering if anyone is aware of any other options to explore. Thanks in advance as always.
-
-
- 13 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