Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
8 years ago

Copy all data from one field into another field within the same table

Trying to create a key field in a table that has not unique ID. Thought I could create a Formula-Text field to combine Lat and Long. Then copy this combined value into a new field and use the new fiel...
App builders
Ask about Quickbase functionality
Formulas and functions
RubyKapil2's avatar
RubyKapil2
Qrew Captain
8 years ago
I will try it. Thanks.
I didn't concatenate because I was worried at some point the combined value would no longer be unique. How many decimal places to strip off? I have the entire Long and Lat value in there separated by a space using the List function. Reason I used space and did not use another symbol like  - or / is when I exported to CSV, then I noticed it changed the value of the combined data to some single value (like it was doing a calculation).