Airtable Applicant Tracker
 {
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}
Layer permissions on top of an Airtable applicant tracking base, allowing interviewers to see only specific information.
Airtable has a pre-built template for an applicant tracking base. One of the important requirements of an applicant tracker is limiting access around who can see feedback. In this case however, Airtable’s sharing model is designed around sharing access to the entire base.
One of the areas Transposit shines is the ability to layer fine-grained permissions on top of other data sources. In this example, we are going to make a Transposit application that allows interviewers to see only applicant information where they are an interviewer.
Create a new Airtable base from the applicant tracking template#
Go to the applicant tracking template and select Use template. This will create a new base in your workspace.
Add an email address to identify each interviewer#
- Select the applicant tracking base you just created.
- Select the “Interviewers” table.
- Add a new column named
Email(uppercaseE) of typeSingle line text.
Note: For testing purposes, set the email of one of the interviewers to the Google account email you use with Transposit.
Get the baseId#
- Go to https://airtable.com/api and select the correct base
- The app 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 withappis the app ID.
Step through Transposit#
- Fork the app https://console.transposit.com/t/transposit-sample/applicant_tracker (find the Fork button at the top of the editor view)
- Add your Airtable key
- Note
populate_applicant_infois the deployed operation. That's the operation your hosted application will call. Test the operation by adding thebaseId(see note above that for testing you will need some Interviewers with your email). - Go to the link for the hosted app, and see it work
- Note you can limit access to your application, under Authentication
- Be sure to set the correct
baseIdin the hosted app