Create new column via script/api

[IT_Admin]

I found multiple posts stating we can’t create new columns/fields on a base but then I also see posts like the following two where the script looks like it’s calling a create() method. Are we able to create new columns/fields through a script?

Does TypeCast only work on Create? What about Update? API

Does typecast only work on .create? What if I want to update a mule-select field in update? base('Sites').update([ 79 { 1 "id": recId, 2 "fields": { 3 "siteStreetAddress": {!!placeDetailsObj.street_number ? place…

Fix for INVALID_VALUE_FOR_COLUMN for single line text column API

Here’s a repro case for a table with column “SingleLineText” which is of type single line text: var Airtable = require('airtable') var base = new Airtable({ apiKey: '<your key>' }).base('<your table id>') base('Table 1').create({ 'SingleLineText': 123 }, function (err, record) { if (err) { console.error(err); return } console.log('created', record.getId()) }) base('Table 1').create({ 'SingleLineText': '456' }, function (err, record) { if (err) { console.error(err); return } consol…

Use case here is checking two view and automatically creating any fields that exist on table 1 that doesnt exist on table 2. Would also be nice if we could then adjust the automation actions to automatically grab any newly added column/field and it’s value.

[kuovonne · Accepted solution]

IT_Admin:

I found multiple posts stating we can’t create new columns/fields on a base but then I also see posts like the following two where the script looks like it’s calling a create() method. Are we able to create new columns/fields through a script?

The code in your links is for creating new records/rows, not creating new fields/columns.

Currently it is not possible to create new fields/columns using the REST API. It is possible to create some new fields using Scripting app (but not automation scripts). Custom apps can also create new fields with selected field types.