Hi first time scripting in Airtable and its a bit difficult so any help would be appreciated.
I am using a button to run an automation to create a new record in a table. I then want to set a value in this new record to a USER INPUT value. This USER INPUT would be prompted when clicking the button.
Automations cannot prompt a user for input. You can create a new field for the user to enter values that the automation uses for its input.
If you can run the script from scripting extension (not an automation or interface) then your script can get user input using input.textAsync() or one of the other input methods available in scripting extension. It is documented here.