Airtable Examples
 {
for (var _len = arguments.length, macroArgs = new Array(_len), _key = 0; _key < _len; _key++) {
macroArgs[_key] = arguments[_key];
}
var argCount = numArgs(macroArgs);
var args;
var kwargs = getKeywordArgs(macroArgs);
if (argCount > argNames.length) {
args = macroArgs.slice(0, argNames.length); // Positional arguments that should be passed in as
// keyword arguments (essentially default values)
macroArgs.slice(args.length, argCount).forEach(function (val, i) {
if (i < kwargNames.length) {
kwargs[kwargNames[i]] = val;
}
});
args.push(kwargs);
} else if (argCount < argNames.length) {
args = macroArgs.slice(0, argCount);
for (var i = argCount; i < argNames.length; i++) {
var arg = argNames[i]; // Keyword arguments that should be passed as
// positional arguments, i.e. the caller explicitly
// used the name of a positional arg
args.push(kwargs[arg]);
delete kwargs[arg];
}
args.push(kwargs);
} else {
args = macroArgs;
}
return func.apply(_this, args);
}){kind=icon}
A collection of sample SQL queries using the Airtable connector
Airtable has a pre-built template for a grocery list base. One nice feature to have on a grocery list is knowing when you last purchased the item. In Airtable, you can manually select or deselect, and add or remove notes.
One of the areas Transposit can help is automation. In this example, we are going to make a Transposit application that allows shoppers to uncheck some purchased items on the list and add a note with purchased date.
Create a new Airtable base from the grocery list template#
Go to the grocery list template and select Use template. This will create a new base in your workspace.
Add more items#
- Select the grocery list base you just created.
- Select the "Groceries" table.
- Add a new row with some milk variety. (For example, Item: Almond Milk, Brand/Flavor: Vanilla, Quantify: 1 Department: Dairy)
- Let's pretend we already did the shopping. Check all under Purchased column.
Get the baseId#
- Go to https://airtable.com/api and select the correct base
- The base ID can be found in the URL in your browser address bar. The URL will look like https://airtable.com/appPqRsgYQmpJ4wRQ/api/docs, and the part that begins with app is the baseID.
Step through Transposit#
- Fork the app https://console.transposit.com/t/transposit-sample/airtable_examples (find the Fork button at the top of the editor view)
- Add your Airtable key
- Add baseId to each operations. Parameters are on the right side of the editor.
- Select uncheck operation and click run. You can see your milk variety is now purchased with date, on Airtable.