Skip to main content
Solved

Increase number

  • December 23, 2020
  • 5 replies
  • 34 views

Forum|alt.badge.img
  • New Participant
  • 2 replies

Hi

I wanna script a (+1) button, somehow (like) button… to increase (or decrease) number in a filed

For example, When I click this button, the filed X become (10) instead of (9)

Thanks

Best answer by kuovonne

Happy Holidays

const config = input.config({
    title: 'Add 1 to a number field',
    description: 'A script that lets you increment a number',
    items: [
        input.config.table('table', {
            label: 'Table',
        }),
        input.config.field('numberField', {
            label: 'Number field',
            parentTable: 'table',
        }),
    ]
});

const record = await input.recordAsync("Pick a record", config.table)
const currentNumber = record.getCellValue(config.numberField)
const newNumber = currentNumber ? currentNumber + 1 : 1
await config.table.updateRecordAsync(record, {
    [config.numberField.name]: newNumber 
})
output.markdown(`Updated ${config.numberField.name} for ${record.name} to ${newNumber}`)

5 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • December 24, 2020

Welcome to the Airtable community!

Do you want to hire someone to write this script for you?
Are you hoping that someone will write this script for you for free?
Are you trying to write a script and need help debugging it?


Forum|alt.badge.img
  • Author
  • New Participant
  • 2 replies
  • December 24, 2020

Welcome to the Airtable community!

Do you want to hire someone to write this script for you?
Are you hoping that someone will write this script for you for free?
Are you trying to write a script and need help debugging it?


Yes I can hire someone, I just not sure if that possible.
I know little about coding


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • December 24, 2020

Yes I can hire someone, I just not sure if that possible.
I know little about coding


Yes, this is quite possible with a script. Several people in this community (myself included) write scripts for hire.


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • Answer
  • December 24, 2020

Happy Holidays

const config = input.config({
    title: 'Add 1 to a number field',
    description: 'A script that lets you increment a number',
    items: [
        input.config.table('table', {
            label: 'Table',
        }),
        input.config.field('numberField', {
            label: 'Number field',
            parentTable: 'table',
        }),
    ]
});

const record = await input.recordAsync("Pick a record", config.table)
const currentNumber = record.getCellValue(config.numberField)
const newNumber = currentNumber ? currentNumber + 1 : 1
await config.table.updateRecordAsync(record, {
    [config.numberField.name]: newNumber 
})
output.markdown(`Updated ${config.numberField.name} for ${record.name} to ${newNumber}`)

Forum|alt.badge.img
  • Author
  • New Participant
  • 2 replies
  • December 25, 2020

Happy Holidays

const config = input.config({
    title: 'Add 1 to a number field',
    description: 'A script that lets you increment a number',
    items: [
        input.config.table('table', {
            label: 'Table',
        }),
        input.config.field('numberField', {
            label: 'Number field',
            parentTable: 'table',
        }),
    ]
});

const record = await input.recordAsync("Pick a record", config.table)
const currentNumber = record.getCellValue(config.numberField)
const newNumber = currentNumber ? currentNumber + 1 : 1
await config.table.updateRecordAsync(record, {
    [config.numberField.name]: newNumber 
})
output.markdown(`Updated ${config.numberField.name} for ${record.name} to ${newNumber}`)

Happy Holidays!

This Worked great…

Thank you!