Is is possible to have a button perform a script to input values into other cells all in the same table?. For example, if a field is set to button and you click the button, then do the following: In the Columns “Sales” and “Orders” place data from Column “Estimates”
Welcome to the community, @Smyth_County! Yes, a script can do all of that, and a ton more. Scripts have fewer restrictions that formulas. Are you looking for help developing a script, or do you want to learn how to do it yourself?
A great place to start with Airtable’s scripting setup is its own docs, which you can find at the bottom of the Scripting app window, or here:
The app has several example scripts that are fairly well documented, and which you can insert into the app quickly for interactive testing.
If you run into any issues with your scripts, feel free to post here for help!
Okay, maybe for the future I would like to learn how to do it myself, but for this particular project I think I would like some help developing this particular script.