Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

Search the Community

Showing results for tags 'list'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Categories

  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • 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

Blogs

  • 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

Categories

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 24 results

  1. I am attempting to use the following script in a Database: Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value: $i+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop When I run it, however, it creates zero New Records within my "Month" database. I'm not sure what the issue is. My o
  2. 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.
  3. I have stumbled upon a strange bug in one of my Databases concerning a value list. We have a table containing part numbers, which is related to a table containing "revisions" for the part numbers, which is related to a table of inspections for the "revisions". On a layout of the Inspections table, I have a value list. This value list selects the UUID of the revision, but displays the Part Number for the user. This has worked perfectly for several months. However, this morning one of my users discovered that he was unable to located "0000194" from this list. At first I thought ma
  4. Hello, If I have two lists : ListA Apples 20 Oranges 15 Pears 120 ListB Apples 13 Oranges 30 Nectarines 70 ... how can I end up to Apples 33 Oranges 45 Pears 120 Nectarines 70, with a custom function? Thank you!
  5. I have a field that is a List of values I want to match records to. The field in the target table is also a List values. So my search parameters might be this list "A|B|F" (pretend | is a new line making a List) and my target search field might be "A|G|N". Since they both share the A, the record should match. I tried looping through each item in the search parameters list and doing a Perform Find on each, but each find overwrites the last. Apparently multiple search criteria do not add to the result set unless part of the same Perform Find. I tried some creative Find Requests li
  6. Hi. I need help wrapping my brain around this problem. Assuming the following result from a SQL query: product1,A,B product1,C,D product2,U,V product2,W,X product2,Y,Z product3,K,L How would one go about transforming it into this using a CF? product1,A,B,C,D product2,U,V,W,X,Y,Z product3,K,L Here each product has only one row and all remaining field data for the other rows with the same product in the first result is concatenatied into this one row. Or even into this { "label": "product1", "data": [ {"start": "A","end":"B"}, {"start": "C","end":"D"
  7. 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?
  8. 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 Engli
  9. Haven’t found post of this problem so here I go. Windows Server 2008 R2 Standard Everything ran nominally under Server13, external authentication After upgrading to Server14 (following instruction meticulously) none of the databases would show up until I unchecked “List only the databases each user is authorized to access”. When unchecked all the databases show to all users but they can only enter the one’s they have access to. This tells me that the External Authentication is still working properly but the File Display Filter is no longer working. Note: this happens with all client connec
  10. Hi! I am very new to Filemaker Pro 13. I am creating an employee database that records all trainings they have taken. My layout is all set up EXCEPT I can not figure out how to create a summery/list of trainings that are only applicable to a specific employee. I have about 100 different trainings and if a particular employee has taken the training I have an "x" on my very large excel spreadsheet. How do I create a formula that will generate a list of all trainings that have an "x" in my excel spreadsheet that correspond with each employee? I do not want to have to list every training ever on e
  11. Hello All, I have a parent table with a related table that holds records with 2 fields - a field holding either "S" (Strengths) or "W" (Weaknesses) and a comment field. For report printing purposes, I'd like to combine the comment field of all related portal records in a combine_field in the parent table - but only if the record is a Strength. Could you please advise if I need to script the combining similar to this http://help.filemaker.com/app/answers/detail/a_id/2403/kw/combining records but with an additional check on the S/W field... or is there a more efficient solution whereby I can
  12. Hey guys. First time post here. I just purchased Filemaker Pro 14 for our company and am in the process of setting up a database for our call center to use in tracking customer contact, having notes on each contact and so on. I have the system basically setup and functional. But I am trying to expand the functionality of the database a bit. Below is what I am needing to do. I have a Database with Contact information in it. It has a related table for a number of diferent types of content. one being Notes for each contact. I currently am using the find feature for the girls in the call center
  13. I feel like I should know how to do this, but when I think about it, the only ways I know how to do it will not allow another part of what I want. What I'm after is to make something like a rolodex. The way I know how to do it, you end up with a list of found records, with a script for the alphabetical "filter," when you want that. The thing is that the only way I know to do this, you end up with a small body part, like in the Contacts starter solution. But I also want to have my virtual list sidebar alongside, because that's how I'm handling my navigation between layouts. Obvio
  14. Hello All, I have a file with shipment information that I need to import into separate tables, a shipment name/id table and a shipment line items table. The problem is it is formatted in a way that the shipment name/id is located in column 2, row 1. The shipment line item information starts at row 9 and but the number of subsequent lines vary with each shipment. I’m not sure how to go about writing a script to create a new shipment in the shipment table using the value from column 2/row 1, then create child records in the shipment line items table with the values starting at row 9. I ha
  15. Hi All, I have this fairly simple field, it's a calculation that returns a list, and it works well: If ( IsEmpty ( IP Addresses::IPv4 Address ); "No Static IP"; List ( IP Addresses::IPv4 Address ) ) However, in the resulting list that displays, I'd like to substitute the carriage returns with commas, and I've come up with this bit of code to make the substitution: Substitute ( IP Address Display; "¶" ; ", " ) Is this correct? If so, where do I place the substitute statement? Will it go into the same calculation I use to define the field, or do I have to put this into a brand new field o
  16. Fellow developers, a question I must ask (I'm sorry if this seem so unusual; my filemaker development is not the most common) I have a database of paragraphs. The idea being, each paragraph is a record, in a Table named Reference. The whole idea of this database, which has more tables but could work with just one, is to make a manual, a handbook for the company I work for. Let me give a example: we have a specific instruction on how to deal with taxes at importation. We create a record named: taxes at importation, and we related this record to another record in our self-related table (taxe
  17. Let me first preface this by saying I am by no means an expert on Filemaker, more an enthusiast looking to save my small regional field hockey facility from purchasing an expensive shrink wrapped package. So... After searching high and low for a way in which to generate a sports leagues fixture, by using a combination of Custom Functions, Calculations and Scripting. I've also been working on my own to generate something that will get me closer to my goal. This forum post is VERY close, but I've come up with a few things that make for a little more flexibility. Also, the solution pos
  18. Heads up: Our users have found that value lists in popup menus that formerly ignored pre-pended characters for sorting, now respect them. For instance, in FileMaker 12, values that were pre-pended with an asterisk were displayed in Alpha-numeric order by default — and the pre-pended asterisk was ignored: Now, in FileMaker 13, these characters are included in the default sort order, so all of the pre-pended values are now together at the top of the list: If anyone has suggestions on how I can restore the previous behavior (short of reverting back to FileMaker 12!), I'm all "ea
  19. I've been working on optimizing a complex part of a solution that relied on the List() function to send multiple parameters to a custom function. Through my research I came across this article: http://www.teamdf.com/weetbicks/the-search-for-fast-aggregates--trial--error/99/ This article discusses the fact that when you use List(), Sum() or other aggregate functions, FileMaker sends the entire record set to the client, not just the data from the requested field(s). Does anyone know if this is also the case with ExecuteSQL()? I would assume that an SQL query would only return the re
  20. Forgive me if I'm wrong but I was under the impression that when using the LIst(field) function to combine multiple records into one field, that the sort order was meant to be defined by the sort order set in the relationship. I've had this working before, but for some reason it doesn't seem to want to do it anymore, and is always reverting back to the order of when the records were generated. I've attached an example here, where i eneterd the data in this order: ONE, THREE, FIVE, TWO, FOUR (with each record having a number field corrsponding to the word to use to sort on: 1,3,5,2,4).
  21. I have a list which is generated from two separate tables, and consists of letters and numbers - for example Table A gives the list: 2, 3, 4, 4A Table B gives the list: A, B, 1 I would like to concatenate the lists and then sort them into order thus: Concatenated and sorted list; A, B, 1, 2, 3, 4, 4A Filemaker's sort mechanism allows you to sort records based on a value list. I can get them into this order with a sort using a value list like this (I've missed a few values out!) A, AA, B, BA, C, CA, D ......Y, YA, Z,1,1A, 2, 2A, 3, 3A ........24, 24A, 25 Has anyo
  22. 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 straightfor
  23. I have a portal from which I am able to go to a portal row and copy conetent from two fields in the portal to fileds outside the portal using a go to portal row script without problems but in the same row, I have two additional fields that are lookups into another table that I also need to copy into outside fields as well. What happens when I invoke the script is the first two fields in the selected portal row works without issue but the two lookups field copies always comes from the first row of the portal and not the second. The portal itself works exactly as it should but for the life of me
  24. Pretty much everything in FileMaker comes with some form of comment box to let you add more information - such as fields, menus, custom functions, calculations, scripts, and the graph. However the one area lacking in a comment box is value lists, unless that is, you think a little outside of the box… Read the Full Article Here…
×
×
  • Create New...

Important Information

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