All things TrackVia!

Read, write, comment.

This is a public Category  publicRSS

Product Question

    • Copy data from a column
      Product Question posted Oct 23 by Jason
      49 Views, 1 Comment
      Question:
      Copy data from a column
      Answer:

      Is there a way to create a column from data in another column? or to convert the result of a formula to text? i.e. I have one column of zips...some are zip and some are zip+4.  I can create a formula in another column to standardize, but don't want to duplicate all the data.  Any thoughts?

      Thanks,
      J

    Comments

    • You can use a calculated short answer field and our mid() function to retrieve just the first five digits from your zip code field and insert this in another field.  The formula for this would be mid(Zip Code,1,5) and you can read about this and other formulas in the Help.  Then you can click on the pencil icon next to this calculated field to convert it to a short answer on the Edit Database screen and remove the original fields.