Show and Tell

This video guide shows you how easy it is with our tool, csvgetter.com:https://www.youtube.com/watch?v=uHMmYXBTbv0 

Hey all, I'm looking to chat with people who are currently embedding Airtable on their websiteI've been working on something that can give you more customisation options to embeds and would love to see if it's useful.

In order to assist a community member in accessing expiring URLs for their attachments, I've developed a new extension! Now, you can effortlessly retrieve the URLs of your attachments with just a click.Just a heads up, the Airtable makes the URLs expire for security reasons. As a result, the provided URL will only remain active for ~2 hours. Please make a note of this while using the extension.And here is the code to paste into your script extension!  const settings = input.config({ title: "Get temporary attachment URL", items: [ input.config.table("table", { label: "Table" }), input.config.field("attachmentField", { parentTable: "table", label: "Attachments field" }), input.config.field("temporaryAttachmentURLsField", { parentTable: "table", label: "Field to put URLs" }), ], }); let { table, attachmentField, temporaryAttachmentURLsField } = settings; if(attachmentField.type !== "multipleAttachments") { throw new Error("Attachmen

comment section is in infinite loading state.Replicated base to resolve.When it was cloned, the same phenomenon occurred again after a short period of time and four days.Is it an error in the air table itself...?

This guide shows you how to do this: https://www.csvgetter.com/blog/export-airtable-to-dropboxThe result is scheduled CSV backups of your Airtable data in Dropbox, with each file labelled with date and time. No code needed.

Hi there,TLDR: Copy JSON code below to create a custom Action and let custom ChatGPT answer questions and make charts from your Airtable data. 1. Motivation2. Creating custom GPTs and model instructions3. Airtable API Actions with Open API format 4.  Results, limitation & further materials1. MotivationAirtable has been slow in releasing any useful AI improvements, at least to the non-enterprise masses. I am still waiting on my Beta access.From what I have seen from the few announcements the focus is on quite simple implementations like text generation inside a field (here and here)  or text generation inside of a workflow (here).  Where I personally found GPT models useful was creating Airtable formulas from natural language prompts (hence here my personal plug for my chrome extension https://community.airtable.com/t5/show-tell/having-issues-with-airtable-formulas-try-hint-gpt-airtable/td-p/147394). I do prefer for AI to give me a starting fo

If you're looking to optimise your Airtable data exports, URL parameters are your secret weapon. These small but powerful extensions can be appended to your CSV Getter URL, enabling you to customise your Airtable data output. Read more about them here:https://www.csvgetter.com/blog/using-csv-getter-url-parameters-for-airtable-data

I'm new to Airtable and automation script.All I wanted is to save .pdf file which is generated from PDF Generator API. I don't know about the java script either. I got this script using AI and git hub. I am still getting errors can someone help me with it? the script is attached./*** PDF Generator API configuration (Replace with your actual credentials)*/const apiKey = '';const apiSecret = '';const apiWorkspace = '';const templateId = '';const url = `https://us1.pdfgeneratorapi.com/api/v3/templates/${templateId}/output?output=url`;/*** Airtable table and record config.*/const partNumberTable = base.getTable('Part Number');const saveDocToField = 'Print';// Get the record ID from input variablesconst partNumberId = input.config.recordId;/*** Find record from "Part Number" table*/let records = await loadRecords(partNumberTable, [partNumberId]);// Check if a valid record was found and handle potential errorsif (records && records.length > 0 && records[0]) {/*** Make PDF

I am developing software for car appraisers in Softr and have structured my database with five tables:Enduser (Appraiser) - Unique identifier: Email of the appraiserClients of the Enduser - Unique identifier: Email of the client (One appraiser can have multiple clients)Vehicles of the Client - Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)Appraisals of the Vehicle - Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)Payments for the Appraisals - Unique identifier: Payment number of the report number (Each appraisal can involve multiple payments)Is this structure appropriate? One potential drawback is that when importing data into related tables, I can only link one table at a time. Ideally, when I add an appraisal along with the vehicle's registration number, the system should automatically identify the associated client (based on the vehi

Work with your Airtable database via Siri. A bit advanced to understand maybe, but these are meant to act like “functions” that can be used separately like building blocks for your own shortcuts. It is intended to be very flexible and simple to make your own individual shortcuts from these blocks. After setting these main functions up, your custom-made shortcut can be something as simple as this: Example Using the Building block functions Main Functions: Airtable Vars - Holds your Api Key, name, and airtable app code. View Picker - Choose a table and view to get records from. Get Airtable Records - Main fetching function. Can get by view, table, filter by formula, sort, etc. Record Selector - Allows optional manual selection of returned records. Example Actions that use the above functions: Link Airtable Records - This is an attendance example. Choose 1 record and then attendees to link to a record field. Update Airtable Record - This is a “Mark Task Done” example. Ticks a box and logs

We've saved ourselves countless hours repurposing helper data from other projects; so we've decided to start publishing them.Months and Years data is for projects where we want to report on dates; invoicing, timetracking, sales, orders… it's everywhere. 

Are you tired of the cumbersome process of navigating through Airtable on your mobile device? We have exciting news for you! Introducing our latest companion app, designed specifically to enhance your Airtable experience on iOS.Streamlined Access with iOS WidgetsOur app introduces iOS widgets that allow you to quickly access the tables you need, right from your home screen. These widgets come in various sizes, including medium and large, and can display up to eight tables at a time. This means you can have your most important data just a tap away, without even opening the Airtable app.Quick Access from the Lock ScreenIn addition to home screen widgets, our app also allows you to open tables directly from your lock screen. This feature is perfect for those moments when you need to swiftly access your data without any delays. Upcoming Features: Siri Integration and Share Menu SupportBut that's not all! We have more features in the pipeline to further enhance your productivity:Siri Integr

Hey all! A few weeks ago I posted about the tool I built that lets you customize and embed Airtable data on any website.I've implemented the feedback I got from here (Thanks again!) and am excited to share a new template, the Wall of Love ❤️This template is perfect for showcasing testimonials, customers or anything that would fit into a masonry column layout. (You can adjust the layout to fit up to 5 columns)The template is free to use!All you need to do is, head to www.shareables.aiChoose the Wall of Love templates that you can plug your Airtable data into.Use the editor to customize it to fit your needs.When you're ready, install the iframe into your websiteAll feedback appreciated!Wall of Love Example 

Hi Community!We have the employee information on our Airtable.Also, we have some forms that they can submit, for example leave requests or overtime requests.It would be nice that they can see their own records they submitted in the past but it would be anooying to create one interface for each employee.Using the thrid party like Stacker might be the best option but we are wondering if there is any best way that they can see their responses for just their own somehow.We have different bases for Emplyee information and Leave request form/record but they are connected. Thank you,

Hi! We got great feedback from the community a few months ago and decided to go all-in on Airtable. Your can sign up for free, here: https://fillout.com/airtable/Fillout may be for you if want a) modern forms that match your brand  b) a form builder made specifically for Airtable c) advanced functionalityExamples of what you can do with Fillout + Airtable:🔗 Pick linked records (with filters based on form responses)Make multi-page forms (with conditional branching)Update records via a form📩 Make forms with email/phone loginSync single/multi select options from AirtablePre-fill fields🖼️ Embed your form anywhereDrag and drop customizable components (image picker, signature, file uploads, sections and many more)🎨 Style your form📅 Schedule with CalendlyAdd review steps👀 Add powerful hiding and validation logicFeel free to comment with any questions or feedback, I’ll be around 🙂

The following video shows you what you can unlock with Airtable and CSV Getter in less than 2 minutes.Check it out!https://www.youtube.com/watch?v=f4AREB8Bcak

I recently came across Airtable. So, I decided to create a tutorial on how to Integrate the Airtable API in an Angular application. I hope this is helpful to anyone trying to utilize the API within an application. Here is the link to the video on how I put everything together to create an Email verification application.

Hey all,While testing the OpenAI API and looking for use-cases with Airtable I put together this demo which creates a book summary AI for the items in your Amazon wishlist. What it does: - Imports your Amazon wishlist into Airtable (focus is on books for now) via Simplescraper- Summarizes, tags, categorizes and provides quotes for each book using OpenAICombined with an Airtable Interface it's a neat way to 'free' the items from your Amazon wishlist and make them a lot more searchable and organized. For example it's impossible to search for books by tag in Amazon, now it's easy.Here's the full guide and script:  https://simplescraper.io/blog/how-build-ai-reading-assistant-amazon-wishlist/Books are just one example. The format can be used to enrich any data that's in Airtable with OpenAI, and the code can be re-used for your particular use-case.Hope you may find it interesting/useful. 

Update (2022-02-11): The stylesheet is now designed to be used “out of the box” to restore the look of the original expanded record view. (Unfortunately, I’m working off my memory of what it looked like so it may not be an exact replica.) Here’s what it looks like by default: Or, if you prefer the new expanded record view design, you can select the “Current” preset and make some tweaks (below: column layout, zebra stripes, type-based field coloring, compact linked record view, expanded whitespace, variable field width): The code for the expanded record view has been completely overhauled. Due to the number of tweaks, instead of grouping rules by function, they’re now defined based on the view’s HTML structure. There may be some new bugs, but thanks to the new structure, changes will only affect the full expanded record view (and not the mini expanded record view in Timeline views, for example). Setting up Stylus: Install the addon/extension (Firefox) Stylus – Get this Extension fo

Good day community,Is it just me or I can't seem to load my Airtable bases? Thank you

Hi all!This has come up in a couple recent threads (and I was PMed on the topic) and I thought writing a summary collating all the information on this topic might be useful for future users.You (yes, you!) can automatically format Airtable data into shareable and saveable .ics files. This isn't sharing a whole calendar, but rather discrete events. It requires a fairly straightforward Make.com automation, a bit of text file editing, and a file hosting platform integrated with Make (I know Google Drive and Dropbox work). Here's the overall Make layoutTo start with you need to understand that a .ics file is just a plain text file formatted in a machine readable way. This blog post provides some specific instruction. In your desired Airtable base, you should make sure to have start time, end time, event title, event description, and an attachment field.Create a Make scenario tied to that Airtable base (you can pick how it triggers). Then add the "Compose a String" tool, pasting i

Hi you, 💚I had a question - why do Airtable bases need to be this visually unappealing? I know Airtable is loved for its functionality first, but I felt I could so something about it. So I launched Icons just to make it a bit more pretty: https://airtable.com/marketplace/blkQR3ZxqdeVppXgL/icons-silver-tazaThere was a challenge in working around Airtable limitations, but I think I did an OK job navigating these, and ended up with something actually usable. I hope people find it valuable so I can continue adding more icons & visuals.    

I had a need to develop various types of Airtable to Google Cloud Firestore syncs. Still need to create more types and fix some issues, but I figured I'd share what I have so far with the community. It's easy to use and works just as advertised for me.https://github.com/antquinonez/Airtable-Firestore-SyncFULL_REFRESH: Deletes all existing data in the Firestore collection and replaces it with the current Airtable data.REPLACE: For each record in Airtable, deletes any existing records with the same primary key in Firestore and inserts the new record.UPSERT_CHECKSUM: Compares each Airtable record with existing Firestore records using a checksum. Updates Firestore if there are changes, or inserts if the record is new.UPSERT_CHECKSUM_WITH_DELETE: Similar to UPSERT_CHECKSUM, but also deletes Firestore records that no longer exist in Airtable.VERSIONED: Creates a new version of each record in Firestore, marking the previous version as not latestVERSIONED_SET: Creates a new set of all records

Hello, dear community. I hope you can help me solve this issue I need to address:I have a table with a list of students and another table with a list of tasks, each with a corresponding status column. I need to create a task list where each student can update the status of each task.The status should not be mixed with the statuses of other students, but rather each student should be able to mark their own status for each task.

Hello Airtable Community Moderators,@MaddieJ, @leah_ackerman @selenawang , @Evan_Purcell @Rosalind_Lutsky ,Recently, we've seen an increase in spam posts across various categories. These posts often disguise themselves as responses to genuine questions or issues, making it challenging for users seeking real help to find the needed information.I want to acknowledge the fantastic work the moderators do to remove these posts promptly. However, this situation can sometimes overshadow genuine queries, causing delays in responses and creating unnecessary doubts among users.To help combat this issue, I suggest implementing additional verification measures for new community members. For instance, requiring users to have an Airtable account or exploring other verification methods could help in filtering out spam accounts and maintaining the quality of discussions.Let's all stay vigilant and report any suspicious activity to help maintain the integrity of our commun