Creating fields by importing from Excel

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
Hi, I want to import from Excel to create new fields in a table, which I can do, however is there a way to control the field type it creates ? (I am not importing data at the same time, just using Excel as a vehicle to create the fields) Thanks.
Photo of Mike Woodcock

Mike Woodcock

  • 90 Points 75 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,290 Points 50k badge 2x thumb
Yes, during the import dialogue screens it will guess at your field types, but you may override Quick Base's guesses.
Photo of Mike Woodcock

Mike Woodcock

  • 90 Points 75 badge 2x thumb
Hi Thanks, I understand, however that is very manual, I am looking to create a large number of fields mainly as numeric rather than text so would like to control this directly from the import. I am hoping there is a way I can define each column so it automatically "guesses" as Numeric. Hope this makes sense.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,290 Points 50k badge 2x thumb
if you do an initial upload or a few rows with dummy values which are clearly numeric, then the fields will be guesses as numeric.

Then the real import will already have the fields created and will map to those field names.
Photo of Mike Woodcock

Mike Woodcock

  • 90 Points 75 badge 2x thumb
Hi, Thanks,  I did think about that as a solution, just need to work out the right way to do so and not impact anything. I am tinkering with an existing live DB, never designed to do what is needed now :)

Many thanks,  food for thought.