2 Replies Latest reply on Jul 19, 2017 10:18 AM by beverly

    Number vs text field


      I am in the process of setting up virtual selections of records in a list. When records are selected, the information from the record is added to a return delimited list in a global field. Since there are returns in the list, I assume the field needs to be a text field. However, the information added to that text field is coming from a number field. When I use the information out of the list in a batch operation, do I need to convert it back to a number before using?

        • 1. Re: Number vs text field

          It depends.  FileMaker is very generous to us in handling of data types and you will love that until you hate it . . . I can't recall a time when I have regretted from using the GetAsText, GetAsNumber etc.  even if it only helps me remember when looking at code as what things are what and helps bring clarity to long forgotten code.

          • 2. Re: Number vs text field

            AFAIR, the multi-line key (what you are creating) can be number or text. I'd prefer number to be number (even with return-delimited list) for this kind of matching.


            I could be in error, so it would be most helpful to have the engineers verify this.