Jump to content

Search the Community

Showing results for tags 'field'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform
  • Forum


There are no results to display.

There are no results to display.


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 32 results

  1. Hi everyone! I have been searching all over for answers, and there seems to be none. I have a data entry "Comments" field and I want the field to expand when the text goes over the size of the field. Is there ANY possible way? I do not want to make a huge 'Comments' field and use the slide function for printing. I want the field to expand as the text goes. I was thinking there might be a solution using some calculation, script trigger, or conditional formatting. I haven't figured it out yet. Any suggestions? Thank you!
  2. Hi All, I don't really know if the Title really explains my situation, but here it is.. I have Four Fields: Name, Gender, Class and Policy Policy Field is an Unstored Calculation with the calculation below with result set to Text If ( Gender = "Male" & Class = "Primary"; "RUNNING" ;"EXPIRED") Meaning, my intention is to Set the Policy field as Running, if the Student is Male and in Primary Class, otherwise, it should be set to Expired.. The calculation does not work, some fields are displayed correctly with the correct value while others are not. However, if I remove the Logic "&" from the calculation making it only a single criterion, If ( Gender = "Male" ; "RUNNING" ;"EXPIRED"), then it works well.. Why can't I compare several fields using "&" or "OR" with that function? Is there a better way of actualizing this?
  3. I am importing a csv file and need to use matched field names when importing: the provider of the file adds fields from time to time. However one of the field names in the cvs file ends with a space and when managing field names I do not seem to be able to define a field name which ends in a space. Every time I do the field name has the trailing space removed when I save it. Does anyone have a solution? Thanks in advance.
  4. Hi all After moving to FMP advanced 13 I still don't know how to automatically add a new field in the current layout I work on. Before it was simple but now I always need to drag the icon into the layout in Layout mode. Is there a way to tell the app to ALWAYS add new fileds to the current layout Thanks a lot
  5. display a record number in a field

    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. 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 greys out-temporarily), the Right-Click and select 'Button Action'-'Single Step', I continually get a message saying the button is part of a group. When I select all fields while in Layout mode and then select 'Arrange-->Ungroup', it is greyed out which tells me they are not part of a group. But back in Browse mode selecting the button selects all fields. I've been doings circles with this without resolution. Whew!! Is it possible I did something incorrectly when I first started by dragging all the fields at once onto the Layout from the Field Picker? Thanks, Phil BTW, the problem is associated with this text: Attach a button definition to an existing object or objects, like text or a field Select the object(s) and choose Format menu > Button Setup. If you select multiple objects, select only objects that have no previous button definitions. FileMaker Pro groups the objects when you define them as a button. See Grouping and ungrouping objects. If you attached a button definition to an existing object, you can only use an action for the button, so skip to step 5. https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.47.html https://www.filemaker.com/help/14/fmp/en/html/edit_layout2.11.16.html#1192005 I have read and re-read these pages without resolution. The message I get is the button can only be used for an action. But I have not 'attached a button defination to an existing object' Where can I see the status of this? Am I on the right track here? Thanks again, Phil
  7. 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
  8. Anyone else having this problem? When I format the fill and/or borders on fields, they: Only show up in browse mode for the active record (none of the others)Formatting disappears completely on Preview ModeI have Alternate Row and Active Row states set to off. I'm hoping it's something simple that I just can't seem to find. I've uploaded the Browse, Layout, and Preview mode screenshots of a layout where this is a problem, Thanks!
  9. Hi All, I'm not sure this is possible, but said I would ask the experts Idea: Clients insurance details need to be validated online. The online system is basic - you enter a policy number, click submit and it returns either valid / expired etc. Process Needed: 1. Client PolicyID entered into filemaker 2. Button with script to: Copy the contents of the policyID field Go to online website for validating the policy Pastes the PolicyID into the field on the site (uses javascript) Would appreciate any help on this matter. Many Thanks Oirish
  10. We have a PDF that holds a paragraph of text ( because I couldn't get the single word to merge nicely) In my FM Script I apply some text formatting to text. I can see in FM that the formatting was done correctly. Writing that field using scribe to the PDF results in just plain text. Is this a being done by Scribe or the PDF. (the field in the PDF is set to Multi-Line and to accept rich-text)
  11. Count Field Occurance

    Have a passenger list and next to their name it has 'adult', 'child' or 'infant' in a drop down list. At the bottom I wish to summarise the booking schedule so the person reading the report can see how many times 'adult' was selected for example. The following is in a portal: Age Bracket, First Name, Last Name, etc etc (Adult, Child, Infant), (First Name), (Last Name) etc etc At the bottom of the screen I wish to have: Adults: x Children: x Infants: x Thank you in advance. I love using this forum to learn!
  12. I'm trying to find a way to create a field with a value range of 100-200 (that's the easy part) and I want to use a sliding volume-control type method for the user so they can click on the slider knob or button and drag the slider either left or right to pick the value. I'd like for the user to still be able to enter the value manually as well. FMPro 13's slider doesn't do what I need, so I'm looking for a slider type button or such. Any suggestions or plugin ideas are appreciated. Thanks. I'm using FMP 13 advanced. ~Rich
  13. Hi everybody, I am doing a POS system and I have 2 databases. The first one has the barcodes and descriptions of the products and the second one has the ordered products. I have a layout from which I would like to read the barcodes of the products and then add their information within the other database. To do it, I have a field through which I want to introduce the barcode. This barcode can be introduced handly or with a barcode reader. I have some problems to create the script to read the barcode. Handly: I write the barcode numbers, strike the enter key and a script "1" is started (when strike this key) to capture the barcode. Barcode reader: I click on the field and read the barcode, after that a script "2" is started to capture the barcode. To separate both scripts (1 and 2), in this field I have activated the OnObject Keystroke event and I run this script: Set Error Capture [On] Allow User Abort [Off] IF Code (Get ( TriggerKeystroke ) = 13) Perform Script [“Add barcode”] Else Exit Script End If Using this script I can read a barcode and the subsequent script runs perfectly but it is impossible to write handly any number within the field. How could I keep both reading options? Thank you very much, Wardiam
  14. I have an ExecuteSQL statement in a calculated field that finds the most recent Job that was referred by a Company. The calculation looks like this: ExecuteSQL ( "select MAX("Call Date") from Jobs where "Referral Company" = ? AND "Sale Amount" > 0"; "" ; ""; Companies::COMPANY ID) I have unchecked "Do not evaluate if all referenced fields are empty". So here is my dilemma: If "Do not store calculation results -- recalculate when needed" is unchecked, then my data is not always accurate. This field is used in another calculated to determine a "Rating" which is displayed to the user. If "Do not store..." is CHECKED, then my data is accurate, but any layout that has "Rating" displayed is impossibly slow. As in well over 3 minutes to return 45 records. Any suggestions on how to speed this up?
  15. I hope I am submitting this in the right place. Also I thought I already did this but cannot find it anywhere. I looked in my profile console and did not see any messages. So maybe I did not submit it like I thought. I have a database that is not letting me put anything in the field. I am getting this error: "This field cannot be modified until "Room" is given a valid value." I read up on it and it says something about a matching field. Cannot figure it out. I attached a sample database so you can see what is going on. Thank you. Inventory_ForumUpload.zip
  16. Hello, I am wondering if it is possible via calculation to compare a single field with all options in a value list? I am using this as a portal filter. I have several portals on a layout, all from the same table that use different value lists for selection. I only want to display the active records in each portal from their respective value list that was used. I am trying to use this function, but it doesnt work. Each Portal Record will be visible when: Scope::FieldName = ValueListItems ( Get ( FileName); "ValueListName") Is there a different way I can compare this field to all the entries under the value list and see if it matches any of them? Thanks!
  17. Change value in field

    Hello, I have a field I have that will only need to display either "100" or "50". What would a script be that could allow me to click on this field and the value inside changes from "100" to "50" or vice versa. Cheers.
  18. Disable a button depending on field content

    Hi, I have searched around as I thought this would have been asked numerous times, but couldn't find what I was after. I have a field that stores a 0 or 1 depending on whether there is a related record elsewhere. The button take you to that related record and associated layout. I want to disble the button if the field contents is 0 (no related record). I thought I might be able to use conditional formatting, but there's no 'disable' option (which would be nice). How do I do this please? Thanks, Steve
  19. Hi ... I can't get to work what I think should be something very simple. Our users write large fields of text. Several times they've complained because they've lost an hour of typing (medical report) Filemaker connectivity has been lost. Usually a power outage or VPN issue. I've tried to get them use to clicking outside the field and then back into the field to commit the data but I continue to hear "Why can't it autosave? Just like Word" .... Well ... I created a timer script that gets launched by an OnObjectEntry trigger. It then waits 60 seconds and then gets the cursor position using get(ActiveSelectionStart), does a set field to itself and then positions the cursor using the Set Selection. This works fantastic when typing a new entry and the cursor is at the end. Problem is when you try and edit the text in the middle of the text, the save kicks in and the next character is "selected". This causes the character to disappear when the user carries on typing. Is there no function to simply position the cursor?
  20. I can't add any data to fields

    I made a database, yesterday, I was using it today, then I closed it, but hours later, when I tried to open FileMaker Again, appear some problems: first, I made one record (Record 1), but when I tried to make any onther record (Record 2), it cames with the same data from first record, and if i modify it, the data changes to Record 1 too. And hours later, I can not type any data into fields, what's the fail ? I have not any global field. Im with full acces privileges.
  21. Hi There, On windows 7 x64 with FIlemaker 12 advanced V4 when using the "export field content" script function the content of the field is written in mac (roman) format and not ansi (utf8 would be better btw). This is a serious issue because some chars (carriage for example) are not read correctly under the platform (windows). Has anyone notice this behavior? It's a know bug/issue? Thanks a Lot, Rob
  22. Hi guys, do you know an easy solution when you have 2 or more same fields in layout and you want to search for something? In filemaker after any of multiple field is filled by user other fields changes accordinly but in IWP others stays blank what causes conflict. My temp solution is I disabled find ability but one field. Have you better idea how to deal with? Thank you AD.
  23. hello everybody, my problem is the following: i have records with numbered index fields like: Record: 1 Index: 10 Record: 2 Index: 20 Record: 3 Index: 25 Record: 4 Index: 27 Record: 5 Index: 30 and i need them replaced with the value of a valuelist like: a,b,c,d,e respecting the sort order of the numberd index field. Basicaly my output should be Record: 1 Index: 10 CalculatedValue: a Record: 2 Index: 20 CalculatedValue: b Record: 3 Index: 25 CalculatedValue: c Record: 4 Index: 27 CalculatedValue: d Record: 5 Index: 30 CalculatedValue: e is there some function to help me? To make it harder i can add that the index field can repeat across my table, as it is actually a SubIndex based on another Index.The Final Output should be something like: Record: 1 Index: 1 SubIndex: 10 CalculatedValue: a Record: 2 Index: 1 SubIndex: 20 CalculatedValue: b Record: 3 Index: 1 SubIndex: 25 CalculatedValue: c Record: 4 Index: 1 SubIndex: 27 CalculatedValue: d Record: 5 Index: 1 SubIndex: 30 CalculatedValue: e Record: 6 Index: 2 SubIndex: 10 CalculatedValue: a Record: 7 Index: 2 SubIndex: 21 CalculatedValue: b Record: 8 Index: 2 SubIndex: 25 CalculatedValue: c Record: 9 Index: 2 SubIndex: 30 CalculatedValue: d Record: 10 Index: 2 SubIndex: 40 CalculatedValue: e THANKS A LOT FOR HELPING!! if i wasn't clear just asks, as it's really hard to explain. thanks a lot! Cisco
  24. I am using FMP11 Adv. I want to do something similar. I have Multiple vendors for products but not every vendor has all of the products. I want to find the average price and then mark the avg price up. I would also like to have a double check that the Sell Price is above the highest vendor price so I never sell for a loss. Example Product Sku Vendor 1 Vendor 2 Vendor 3 Avg Cost Max Price Sell Price Mouse USB 1001 9.97 13.42 10.41 11.27 13.42 14.08 Keyboard USB 1002 10.01 15.48 12.75 15.48 15.94 Optical Drive 1003 45.23 84.91 44.98 58.37 84.91 106.14 Calculated value off average would be --> 72.96 <-- Two vendors are clearing stock of an Item but the third vendor is not. The 2 vendors run out of the item but the more expensive still has stock. so to fill the order I have to get it from the vendor with highest cost. I need a double check here for the selling price so I don't accidentally blow it. One way I have thought to do this is simply to use the highest priced of all vendors. I know how to do this with the Max command in Excel but I can not seem to get an equivalent to work in Filemaker. I have done a lot with MySQL on servers and Excel on workstations. But I am new to Filemaker. I have FM running on a dual xeon quad core with 24GB so cpu time or memory is not a big deal. I know some calculations from all the reading I have been doing takes large amounts of both. My database is around 260K items and around 90Meg on the drive. I do want a clean and maintainable solution. My product list changes about 3 times a week. As I update stock and prices.
  25. Hi all, I'm wondering what the best way to store images in a container field is if I would like to do the following. - Have the images be stored outside of the database - be able to access the images with and iPad or iPhone I'm setting up a wordpress to ecommerce store that will grab images from the filemaker records and post them to the WP server. My thought was that having the images outside the database i.e setup through the 'manage container' dialog, would be easier for resolving to the file path for the image. This method gives me good response on one machine, and If I add the images to a network drive I can access the database and images over a network. Also no problem. However, if I want to access the database on an iPad or iPhone, the only way I can get the images is by adding them as a 'reference only'. How can I can get the best of both worlds? I Don't want to store references of images, but I also would like to have access to them through an iPad. Thanks!

Important Information

By using this site, you agree to our Terms of Use.