I have my database setup to create UUID when it creates a record for a customer. This is how the ID shows 5.8216e+15 now if i click on the field where this id resides i get this 05C82162-DCB3-3A42-BE8D-B287CAAD3A1C which is the long version of the UUID. So my issue is as followed, when i export my data to an .xlsx format, it will export it as 5.8216e+15 in my customers table which is fine, however i have a script that sets a variable to $customerid to customers:ID and dumps it into the history table as 05C82162-DCB3-3A42-BE8D-B287CAAD3A1C instead of 5.8216e+15 . Now this works believe it or not in the solution up until you export the data and reimport the data if you are upgrading to a new version of the runtime. Once i reimport the data, the connection between the data and the two tables is now lost. I dont understand it . Please help im stumped.
Two Tables :
Customers Customer ID Field Script sets the customer ID field = to this variable $CustomerID then sets History Customer ID field = to $CustomerID.
History Customer ID Field