Jump to content

Search the Community

Showing results for tags 'text'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

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 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
  • FileMaker Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. Hi all, I am constuffulated trying to find why a particular text field will not print its contents. The contents are visible in both Layout and Browse mode and the Object Visibility is NOT selected to hide when printing. There is no Conditional Formatting applied and the "Hide Object When" condition is not activated. I have placed a duplicate of the field in the header and the data shows there for the selected record but it does not show in the body. The second screenshot is Browse Mode and the third is Preview Any help appreciated
  2. 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.
  3. This is probably one of those questions which separates me from people that make money as developers and those that don't (that would be me). I have a simple script that compares two variables. The variables are populated with text (Peoples Names). Basically, if the the two variables are TRUE (the variables are equal) I want to stop the script. Despite the two variables being equal - the IF continues. I have noted when I use the same numbers to populate the variables - the script works as expected. Please tell me Filemaker is smart enough to evaluate text in variables. Below is the my
  4. Hello FM Mavens, I would like to be able to change an attribute (happens to be the size) of a selection in a text window with a script. (Basically, as if moving the size selector from the Formatting Bar into a button on a layout). I created a script that cuts the selection, puts it in another text field, makes the change, cuts it out and goes back to the original field but by then the insertion point is gone. I can manually paste it back of course. I wonder if there is a way to remember the insertion point somehow and make it a so the paste step uses it. Thanks Asu
  5. Text manipulation plug-in adds new script steps and online help for FileMaker Pro 16.Alphen aan den Rijn, the Netherlands, November 13, 2017–Troi today announced the immediate availability of Troi Text Plug-in 4.5 for FileMaker Pro 16.What is Troi Text Plug-in?Troi Text Plug-in is a very powerful tool for dealing efficiently with text in your FileMaker Pro database. All from within FileMaker you can:- Customize spell checking*- Parse XML text into fields- Get (unique) lines and sort words and lines- Combine sets from 2 text fields: - get all lines that are the same - get all lines th
  6. Hi all, I'm an FM novice who has a functioning database, and I'm trying to add layers of functionality to it. One feature I'm trying to design is a script to search through a Gmail outbox with certain keywords. In URLs, "%" translates to "%25". Filemaker appears to do this automatically - In Gmail syntax, you need to write "in%3Asent" to have the Gmail search bar contain "in:sent" which searches my outbox. Here's my current code for Go to URL: This "%" bit translates to "%25". I've tried "\%", I've tried creating a string, x, then having it open x, but no matter what I cannot
  7. OK I admit it ... I'm stumped. I'm not a FileMaker professional, merely an enthusiastic tinkerer. I'm trying to create a feedback system where a series of standard questions are checked. Based on this, those questions answered 'yes' are combined together and those answered 'no 'are ignored. I have created 2 fields per criteria, 'Preset text' and 'preset question'. So ...Preset message = (if preset question 1 = yes, include ‘preset text 1’ else, blank){cr} (if preset question 2 = yes, include ‘preset text 2’ else, blank){cr} …. (if preset question 10 = yes, include ‘preset
  8. Hi All, I am trying to parse text from a Job Card Items table into the related Job Card and not getting the correct result.. as the Items in the Job Card are completed any anomalies have to be reported on the Job Card and with up to 50 items in the Job Card Items there may be more than one anomaly to report, (very rarely more than two) . If the Findings field is empty I am just inserting the Variables but when the field already contains data I am using this to parse the text: Position ( JobCard::Findings ; ":" ; 1 ; 1 )&¶ & $ProdName &" "& $ItemLocation & " " &
  9. Troi Automatisering releases Troi Text Plug-in 4.0.1 for FileMaker Pro 15 June 22nd, 2016, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 4.0.1 for FileMaker Pro 15. What is new in version 4.0.1? Version 4.0.1 is further optimized for use with FileMaker 15. In this version we made description and type-ahead information available for all functions of the plug-in. This extra function description will be shown in FileMaker Pro 15 in the Specify Calculation dialog box when you type a
  10. Hey all, I'm trying to debug a de-duping script I have which runs after importing records. The script works by sorting the imported list by a match field, iterating through the found set and marking any record with the same match field ID as the previous as a duplicate. It mostly is working fine except in this one case which has me stumped as the values of the strings in each comparison are different but the condition tests "true". In the following code example when I run a comparison on the a1 and b1 derived values, c returns "1". If I use the static a2 and b2 values, the condition tests
  11. Hi Forum, Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation: IF(Order_Number = "PT00*", 1, 0) Thank you for assisting, Miss-Amen!
  12. I'm struggling to remove quotation marks from a symbol/operator such as this: "<" I have tried Substitute (Text; "\""; ""), as well as Brian Dunning's custom function RemoveSmartQuotes (text). Both works in the field of question perfectly with normal text, such as {hello "world"} ends up being {hello world}, but ho matter what I run "<" through, the quotation marks remain untouched. Any ideas?
  13. Hi everybody I have an error using scriptmaster 4.42 release when I try to convert a pdf file into text. I have no problem with 4.201 release. The function reurns ERROR and SMLastError is set as "java.lang.NoClassDefFoundError: org/bouncycastle/cms/Recipient" My function is defined as "import java.io.IOException" & ¶ & "import com.itextpdf.text.pdf.PdfReader" & ¶ & "import com.itextpdf.text.pdf.parser.PdfTextExtractor" & ¶ & ¶ & "if( fm_filePath == null ){ throw new Exception(\"File path required !\")}" & ¶ & "if (new File( fm_filePath ).exists()){" &
  14. Troi Automatisering releases Troi Text Plug-in 3.5 for FileMaker Pro 14 August 10th, 2015, Alphen aan den Rijn, The Netherlands--Troi Automatisering today announced the availability of Troi Text Plug-in 3.5 for FileMaker Pro 14. What is Troi Text Plug-in? Troi Text Plug-in is a powerful tool for for dealing efficiently with text in your FileMaker Pro database. It adds the following functions to FileMaker Pro: - Parse XML text into fields - Combine sets from 2 text fields: - get all lines that are the same - get all lines that differ - and other combinations - Get (unique) li
  15. Hello everybody I'm trying to convert number to text en dutch but it doesn't work i had some problem with the calc field when i m trying ( some are good but other doesn't work) is there someone that can help me to resolve this little problem cose i m not a dutch person I join the file that i made to be more clear In advance thanks u cardinal2txt NL.fmp12
  16. i want to import into filemaker from a text file which is a result of a http request. (in filemaker 11!) actually, what i get back from the http-request in a browser is a simple OK 1204888105 now, if i do this via filemakers script step “Import Records” and XML Data to be able to write a http request, i get the obvious error: XML parsing error: invalid document structure Line Number: 1 Column Number: 1 so i was wondering, if there is a possibility to write a XSL style sheet, that can help me grabbing this text into a record. a style sheet, that presents this short text to filemaker as XM
  17. I have two text fields, text1 and text2. Text2 is a product summary, consisting of the first paragraph from text1; text1 is a product description and varies from record to record. I set up the following to automatically populate text2: text2=LeftWords ( text1 ; Position ( text1 ; "all words left of the first paragraph symbol" ; 1 ; 1 ) ) The problem I'm having is what goes where I typed above "all words left of the first paragraph symbol". How to tell FileMaker Pro to find and recognize text control values? For example, many word processors would recognize ^p^ as a paragraph ma
  18. Hello, I am a FM newbie and have been scouring the web for an answer to this problem: I want to eliminate the text within parentheses in a string, but I want to eliminate all instances: ORIGINAL STRING: This is a test of the (emergency) broadcast system. (It is only a test). Remain calm. DESIRED STRING: This is a test of the broadcast system. Remain calm. Can anyone help? Also, is it possible to tie the function or script to a field so that when the ORIGINAL string is put into the field, the field does the conversion automatically? thanks very much in advance,
  19. Hi there,  I have a database where i have some related tables with different information regarding an order. I want to create a customized email for the customer with a standard text, and some variables that will vary, depending on which record they are related to(different costumer data, order data etc.).  Is this possible?    I get a lot of errors when i try to customize the email this way - do i need to make "" or () in order to include more than one field in the message?  Or is there another way to do this?  Thnanks in advance,  Mike
  20. Hello guys, newbie intern here. I am placing a .text document inside a container. I am trying to grab the text out of that container without doing so manually, can anyone help me out?
  21. Hi Everybody, I have a text field with a text that contains normal and red-bold characters, I would like to count the number of characters with bold style. Could anyone help me to do this operation with a function? I am trying to do an script that extracts the portion of normal text to calculate the length and then calculate the number of total characters minus normal text. What is the best option? a function or an script? Thank you very much, Wardiam
  22. 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
  23. I got bit yesterday and today by a basic issue. I was using the Data Viewer to write and test ExecuteSQL. The context was an old part of a solution I had started in 2006. I was having trouble with JOIN. I checked syntax and could find no errors but constantly had "?" returned. I knew the problem was related to the JOIN because the queries worked fine without it. Well, I'm embarrassed to admit the problem was this. The parent table had an auto-enter serial PK type number. All the child tables had an FK field but the type, for some reason, was Text. FM allows this as a match! Of course SQL does
  24. Hi, I'm getting some output from a vendor called Fillz and it's coming to me in text form as follows. I'm running a pricing script on their server. (Note: I have put a return between record sets though there isn't one in the real output. There are 7 "records". The first number is the SKU (Stock Keeping Unit) I want to see the info as follows (in FMPRO) I just don't know how to separate it out. SKU: Base Price: Condition: Floor: Sales Rank: Total Offers: Lowest Six Offers ( If I can separate out each of the lowest six offers into separate fields ie: (Lowest Six Offers P
  25. I have a checkbox set with 30 'topics' for children's games. Some games can include any topic, so I want to check all the boxes. I created a script with 'Insert Text', and listed all the topics as per the value list. which does the trick nicely to select all the topics with one button. However, as the database grows, I think of new topics, and I don't want to keep updating the value list, then this script etc etc... Can I use the data in a value list as the text to insert in an 'Insert Text' script. I have tried without luck. Thanks so much.
  • Create New...

Important Information

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