I have searched the community for an answer to this and I am beginning to think it isn’t possible. I am wanting to use the scripting app to generate unique lot numbers for products my company sells. To keep the lot number unique, I want to have a single field in a single record in a single table to simply keep track of the sequential number section of the lot number. I have had no issue accomplishing this using the scripting app and creating a new table in the same base. My boss really doesn’t like the idea of their being no security around that number, so I thought I might be able to “hide” it in another base and use the api to get and update it.
I have no trouble getting the value from another base, but I can’t figure out how to update the record with the new value after new lot number are created.
Here is the method I used to get the value in the other base using the scripting app.
let response = await fetch('https://api.airtable.com/v0/appXXXXXXXX/Lot/recXXXXXXXXX?api_key=keyXXXXXXX'); //console.log(await response.json());
Any ideas? Any other way to “hide” the number so it can be used but not unintentionally altered?
I appreciate the help in advance.