AnsweredAssumed Answered

Newbie trying to concatenate a field

Question asked by ronaldmonasterio on May 18, 2014
Latest reply on May 18, 2014 by ronaldmonasterio

Title

Newbie trying to concatenate a field

Post

     Hi,

     I'm trying to create a project number for time-lapse sequences. I want it to start with creation date field, then if the date already exists then I wanted to add a one. i.e. 00 mean only one, 01 = two sequences, etc. This will give each a unique number. So it need to search for any other records with that date. The final part is camera, that data is a pull down menu with four types of camera i.e. canon = 1, GoPro = 2.

     I added a graphic to try to make it clear.

      

     thanks

     Ron

dataBase.jpg

Outcomes