Hi @JCoop and welcome to the community.
The Airtable Pipe that can be installed is really just a starting point to demonstrate some features that can be done with a Pipe. Nearly anything that can be done via Airtable’s API can be done with a Pipe. Often it requires just learning the API methods Airtable uses.
Before I answer you your quesitons specificlaly it’s important to keep in mind that at this time a Pipe works ona 1-to-1 relations. Meaning, there’s no way to show lists/tables using a pipe unless you have the record ID for each of those records saved within Tadabase. This can get a bit confusing.
For example, if you have a record inside of Airtalbe and within Tadabase you have the record ID, you can show the Tadabase Record (which contains the Airtable Record ID) and at the same time pull in data from Airtable. You can not (yet) show a table of records directly from Airtable (or any API).
Searching for a record can be a bit tricky, but I believe its possible by structuring your URL using something like this: https://codepen.io/airtable/full/rLKkYB
If you want to display that data from the result in a details page you can do so as follows:
- Create a table with a field called “Search Term” and a field called “Airtable Record ID”
- Create a form with a record rule that searches Airtable for the search term provided and saves the record ID to the Tadabase record.
- Create a Submit Rule in the form to do to the details page of this newly created record
- Use another Pipe to retrieve details about a record based on the record ID saved in step 1 inside of a details component.
You can then also create a form with custom fields that can update Airtable values, but it would require you to create a new API call for each form so you can pass only the relevant data that must be updated.
As far as updating Tadabase from Airtable, this can also be done in a pipe, but might be easier using Zapier or Integromat so it gets updated in real time vs when the record is displayed/edited in Tadabase.
This is a bit advanced and if you’d like we can connect you with a partner that can likely assist with getting this set up.