UPDATE: Check out our new lightweight spreadsheet "Data Blaze". You can easily write to and read data from Data Blaze into your existing snippets. We support one-click import of Airtable data into Data Blaze. Check out this guide to get started.
Grab all record IDs from an airtable base and then select from one of them using a formmenu.
This snippet makes a list of all records from a single table in an Airtable base. It is recommended to look at the original snippet for better understanding of how this system works.
{note}{formtext: name=apikey} {formtext: name=base}{endnote} {if: apikey <> "" and base <> ""} {urlload: https://api.airtable.com/v0/{=base}/VWB?fields[]=Workflow+Title; method=GET; done=(res) -> ["url_response"=catch(fromJSON(res), "???")]; headers=Authorization=Bearer {=apikey}} Data received {records=catch(url_response.records, [])} Count of records received: {=count(records)} Form menu: {formmenu: values={=records}; name=chosen_record; itemformatter=(value) -> value.fields["Workflow Title"]} Fetching record data {urlload: https://api.airtable.com/v0/{=base}/VWB/{=chosen_record.id}; method=GET; done=(res) -> ["response"=catch(fromJSON(res), "???")]; headers=Authorization=Bearer {=apikey}} TC: {=response.fields["TC"]} Buyer Full Name: {=response.fields["Buyer Full Name"]}
If you have the record URL as: Sign in - Airtable, then base=appW0...Qc06, and recordid=rec...VtB.
For an interactive demo of Airtable's API, visit their API page and choose your base. On the left you should choose "VWB Table" and then "Fields", "List records" or "Retrieve a record". On the right you will see various outputs relevant to your base. {endif}
I am trying to use this snippet. As far as I understand I need to put API and Base Id. What else do I need to change in your snippet to work with my base id?
When I try to execute this snippet, it does not retrieve any records.
Do I need to change anything in following URL? {urlload: https://api.airtable.com/v0/{=base}/VWB?fields[]=Workflow+Title; method=GET; done=(res) -> ["url_response"=catch(fromJSON(res), "???")]; headers=Authorization=Bearer {=apikey}}
I am sorry but I hardly have any technical knowledge on how it works.
Happy to help And no worries of technical knowledge. You only have to change all occurrences of tables names and column names in the snippet.
In the particular line you sent, you need to change VWB and Workflow+Title in the command.
If I remember correctly, VWB is the table name and Workflow Title is the column name. (if the column name has spaces we change it like so: Workflow Title -> Workflow+Title)
Thank you so much Gaurang. This worked perfectly. I can properly retrieve all the records from airtable. I will get back to you in case if I need any help.
I wish I can understand all these codes and other technical things.
Hey Pratik, I think this functionality is the primary purpose of the linked snippet. If I run it I am shown multiple records as dropdown and I am allowed to choose one.
Yes I have also made a snippet for that previously
Notice carefully that this snippet has two urlload commands. The second urlload command will resolve additional information about the record id, which in your case are next to the "List of Directors".
As before, you'll need to carefully change the table names and column names to match your scenario.
Hi Gaurang, Thank you for this. I guess I understood this point and I have already achieved this.
However, if you see my last query I am trying to get a field which is relation column in Airtable. So I am not getting the value, instead it shows only the record id.
Any solution please
EDIT: I got this worked. Actually, I created another lookup column in Airtable from this relation column and fetched this new column in Textblaze.
I could successfully retrieve linked record (which has multiple records) as dropdown, the values are coming from another table. Now I want to retrieve related details of this selected value from another table? Any idea how can we do this.
After searching in forum, I got this working. @Cedric_Debono_Blaze's this post helped to locate the position of value in the list and I extracted the related information based on this location.
Hi @Gaurang_Tandon, I just realized that, this api is pulling only 100 rows from many. Are you aware about any such limits from Airtable side or may be from Textblaze side?
Yes, there is a 100 row limit from Airtable's side and we cannot override it I have tried to work around that using multiple urlload commands but it doesn't work very well.
Oh! that's sad.
Do you have similar solution for Google Sheet? This airtable snippets was ultimate solution for me, solves many of my problems. If we can do similar thing via google sheet, that would be great.
And no worries of technical knowledge. You only have to change all occurrences of tables names and column names in the snippet.
I have tried to work around that using multiple urlload commands but it doesn't work very well.