Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Missing option in creating table with a number type field

Topic Labels: Scripting extentions
Solved
Jump to Solution
1567 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Andry
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I’m a new user on airtable and I would like to create a table which contains a number field type, but when I run the script, I got this notification :

image

We have a table A containing the list of clients we work with and each client has their own table. So when we add a new record in this table A, we are supposed to create a new table for this new client, that’s why we need this script.
In the part of script below, I have those lines that I think is the right syntax to create a new table for the new client.
const tableName = await input.textAsync(‘Choose the name of this new client’s table’);
const primaryFieldName = await input.textAsync(‘Enter the name of the primary field’);
const primaryFieldType = await selectFieldAsync(‘Choose the right type of the field’); // selectFieldAsync is a custom async function that prompt the user to select the type of the field

let tableId = await base.createTableAsync(tableName, [{
name: primaryFieldName, //
type: primaryFieldType,
options: getFieldTypeOptions(primaryFieldType), // getFieldTypeOptions is a custom function
},{
name: “Civ”,
type: “singleLineText”,
},{
name: “Name”,
type: “singleLineText”,
},{
name: “Siret”,
type: “number”,
}]);

async function selectFieldTypeAsync(label){
return input.buttonsAsync(label, [
{label: ‘Text’, value: ‘singleLineText’},
{label: ‘Multiline Text’, value: ‘multilineText’},
{label: ‘PhoneNumber’, value: ‘phoneNumber’},
{label: ‘Number’, value: ‘number’},
{label: ‘Email’, value: ‘email’},
{label: ‘URL’, value: ‘url’},
]);
}

function getFieldTypeOptions(fieldType) {
switch (fieldType) {
case ‘singleLineText’:
case ‘multilineText’:
case ‘email’:
case ‘url’:
return null;
case ‘phoneNumber’:
return null;
case ‘number’:
return {precision: 5}
default:
throw new Error (‘Unexpected field type’)
}
}

May someone help me with the right syntax on the creation of the Number type field ?

Thank’s in advance.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

When creating a number field, you need to specify the precision in the options for the field. The format is in the documentation.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

When creating a number field, you need to specify the precision in the options for the field. The format is in the documentation.

Andry
4 - Data Explorer
4 - Data Explorer

It works !

Thanks a lot. :winking_face: