2 Replies Latest reply on Apr 2, 2010 11:09 AM by hbj

    creating a field whose data is parsed out of the data in other fields

    hbj

      Title

      creating a field whose data is parsed out of the data in other fields

      Post

      Hi everyone!

       

      I've got a database of images, which have a creator field, a date field, and a location field, and an incrementor.

       

      I'd like to be able to generate file names for the images based on text from those fields.

       

      So for example, if the creator is first name Joe and last name Smith, the Date is jan 6, 2010, the location is Boston, and this is the 4th picture he took on that date in Boston, I'd like to be able to have a field that generates a filename like "JS01062010Bos4.jpg".  So that for the data input on the photos, the filename generates automatically based on the data.

       

      Make sense? 

       

      Any idea the best way to do that in Filemaker?

       

      Thanks!