Date in Number Format
I have a case in which in excel I convert several date fields to the number formatted date in order create a unique numeric key field. Any suggestions on how to do this in Quick Base? ----------...
Forum Discussion
Hello Xavier,
Yes, I am referring to the Microsoft Excel date-time code. Here is an example of how I am generating a unique ID that can be used as a key field:
------------------------------
Adam Keever
------------------------------
Yes, I am referring to the Microsoft Excel date-time code. Here is an example of how I am generating a unique ID that can be used as a key field:
------------------------------
Adam Keever
------------------------------
Hey Adam - we would definitely suggest keeping our native key fields wherever possible both for functionality and performance. You mention wanting to handle import with updates, have you tried our "Merge Field" feature we rolled out earlier this year? Is there a feature gap with that?
------------------------------
Harrison Hersch
------------------------------
------------------------------
Harrison Hersch
------------------------------
- I was not aware of the "Merge Field" feature. I will test it out, thanks Harrison.
I use the "Merge Field" feature (guess I was so used to using it that I forgot I was using it).
For this particular case I would need to merge based on four fields to ensure a unique ID. That would be a nice enhancement feature; add a "Merge Fields" feature that allows the user to select a number of fields in a specific order and create an ID field by concatenating the selected merge fields.
------------------------------
Adam Keever
------------------------------