Jump to content

Search the Community

Showing results for tags 'concatenate'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker 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 Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

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

Found 4 results

  1. I tried few calculation in Filemaker like substitute trim etc but did not get same result. Google sheets has nice function JOINTEXT any help to replicate/convert the function in Filemaker calculation.
  2. 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"} ] }, ...etc This is actually the final JSON format I need.
  3. hello, i hope someone can help me with this. I am creating a field that is a concatenation calculation, the purpose of which is to combine multiple pieces of information into a unique number that will be used on our contracts. One of the pieces of information to be included is the date of the contract. I am picking that up from a Creation Date field and trying to GetAsText so it will appear in the concatenated number as just a string of digits (say, 021513.) Currently that is how I've formatted it to appear in the Creation Date field. But when it gets picked up, even with GetAsText, the date formatting returns" 02/15/13." Here is what the concatenation calculation looks like so far: Contract Number_Company Code & "-" & Contract Number_Department Code & "-" & GetAsText ( Contract Number_Date record created ) &"-"& Contract Number_Sequential Component I tried setting the Calculation result to text and still the date appears as 02/15/13. What do I need to do to change the date into a simple string of numbers that is the same as the date but without the date formatting? I'm baffled! Thanks! jmm
  4. This seems so simple by I'm stumped. If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";" returns exactly what I need it to: Appliance Cookbooks>Data from Cat Appliance Field; now, I need to go on so I end up with this: Appliance Cookbooks>Data from Cat Appliance Field;Ethnic Cookbooks>Data from Ethnic Cookbook Field; So is there a way to string two If statements together or should I be using something else?? If(IsEmpty(Cat Appliance);""; "Appliance Cookbooks" & ">" & Cat Appliance & ";" If(IsEmpty(Cat Ethnic);""; "Ethnic Cookbooks" & ">" & Cat Enthic & ";" Thanks! fuzzy
  • Create New...

Important Information

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