Skip to main content
Solved

Increase number

  • Dec 23, 2020 1:20 PM UTC
  • 5 replies
  • 85 views

Forum|alt.badge.img

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}`)
View original
This topic has been closed for replies.

5 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Dec 24, 2020 5:56 PM UTC

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
  • Dec 24, 2020 6:13 PM UTC

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
  • Dec 24, 2020 7:39 PM UTC

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
  • Answer
  • Dec 24, 2020 8:25 PM UTC

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
  • Dec 25, 2020 9:53 PM UTC

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!