Mass format change of 40 fields at one time

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need to change 40 fields all from text format to checkbox format. Is there a way to change these all at one time or do I need to select each one and change to Checkbox individually?

Photo of Alan

Alan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
Fill in your dbid and array of fids and paste this into the console:

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=504


Here are the fields codes to use on the D0 parameter:

<select class="addNewFieldSelect" id="D0" name="D0" size="1">
   <option value="0" style="color: #999999" selected="">Select a field type</option>
   <option value="TX">Text</option>
   <option value="LD">Text - Multi-line</option>
   <option value="TC">Text - Multiple Choice</option>
   <option value="SL">Multi-select Text</option>
   <option value="NM">Numeric</option>
   <option value="CA">Numeric - Currency</option>
   <option value="PC">Numeric - Percent</option>
   <option value="RT">Numeric - Rating (0-5)</option>
   <option value="DT">Date</option>
   <option value="TM">Date / Time</option>
   <option value="TD">Time of Day</option>
   <option value="DU">Duration</option>
   <option value="CB">Checkbox</option>
   <option value="PH">Phone Number</option>
   <option value="EM">Email Address</option>
   <option value="US">User</option>
   <option value="FV">File Attachment</option>
   <option value="LK">URL</option>
   <option value="XD">Report Link</option>
   <option value="IC">iCalendar</option>
   <option value="VC">vCard</option>
   <option value="PR">Predecessor</option>
   <option value="" disabled="">------------</option>
   <option value="TXV">Formula - Text</option>
   <option value="NMV">Formula - Numeric</option>
   <option value="DTV">Formula - Date</option>
   <option value="TMV">Formula - Date / Time</option>
   <option value="TDV">Formula - Time of Day</option>
   <option value="DUV">Formula - Duration</option>
   <option value="CBV">Formula - Checkbox</option>
   <option value="PHV">Formula - Phone Number</option>
   <option value="EMV">Formula - Email Address</option>
   <option value="USV">Formula - User</option>
   <option value="LKV">Formula - URL</option>
   <option value="" disabled="">------------</option>
   <option value="TXL">Lookup - Text</option>
 </select>

Three new ways to use QuickBase:

1) Headless using CasperJS and PhantomJS
2) Voice Activated using AnnYang
3) Command Line
using the Console

Using the GUI is so last month.

https://www.youtube.com/watch?v=zDWu9kdVW6c