Jump to content

Search the Community

Showing results for tags 'field'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. Hello, I have a number field where I want the user to be able to enter things like: 42 (only item 42) 12+82 (only items 12 and 82) 1-5 (items 1 through 5) 31,33,35,37 (only items 31,33,35,37) So I am need of a way for filemaker to deal with the operators '+' '-' and ',' Do you have any advice on how I can separate out the item numbers? Thanks!
  2. Hi Everyone, I have my working solution with 10k+ records within one of the tables field i want to create new table, How can i create new table from already existing field. To clear my point i have made a demo/sample file. I have a TableA with ID and two fields Person Name and Office Name. How can I make new TableB using field Office Name from TableA and keep the existing records. OR How can i split TableA into TableB using field Office Name and give it ID/auto enter serial. Thanks in Advance for any Help. split_table.fmp12
  3. FM 16. I would like to have new field entries automatically be added to the value list for the same field. I tried searching but wasn't able to find any references to this. Apologies if it has been previously addressed and appreciate any advice. Thanks.
  4. Hello, Full disclosure: I am very new to scripting in FM. I am trying to hide an object based on 2 criteria: Leads::IsOnlineProposal = "No" and PatternCount ( $$Permissions ; "ViewOnlineProposal" ) = 0 When the Value for Leads::IsOnlineProposal is "Yes" I wanted my object ( just a big square to hide the customer data on the screen ) to hide everything on the screen. That part works great. But I wanted to give some users permission to still view the customer info ( or continue hiding the object ) when the permission is checked even if the value for Leads::IsOnlineProposal =
  5. 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!
  6. 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
  7. 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.
  8. 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
  9. 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
  10. 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 Lay
  11. 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
  12. 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 Mode I 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!
  13. 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
  14. 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)
  15. 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!
  16. 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
  17. 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 starte
  18. 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
  19. 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
  20. 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 t
  21. 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.
  22. 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
  23. 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 curso
  24. 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.
  25. 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
  • Create New...

Important Information

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