Builders Board

Hey,I need someone to create a script which basically does what the Create child records does but in reverse. So, I need to create a parent record from child records.The workflow would be as follows:We upload child records as CSV or XLSX into AirtableThe child records will have a column with an identifier which indirectly links them togetherBased on this identifier and some other information, we will need to create a parent record and link the child records to it.The scope should be pretty simple. We will also need to move over some more data from the child records, but it will always be the same data in all children, so taking it from one single child is sufficient. The only thing is to loop all children into the same parent creation so we do not create too many parents.If that is something you feel able to do, p

Hi Everyone,Blue Ocean Barns is seeking a full-time Airtable Database Coordinator at our San Diego location to help us build, maintain, administer, and expand our database as we undergo rapid expansion.  Please see our webpage for information about our company and the specific job posting here.Best,Mike

I need an Airtable expert to create an ERP for my company.Job Scope:Design, develop, and customize an ERP system using Airtable.Collaborate with cross-functional teams to gather requirements and ensure system alignment with business needs.Implement automation, data integration, and workflow solutions within Airtable.Train and provide ongoing support to users.Optimize the ERP system for efficiency and scalability.Stay current with Airtable updates and best practices.Prior experience with Airtable and ERP development is essential. Full Time in person at our office every day.Please feel free to send me your resume. Location is in Woodstock GA. 

Workshop on the use and possibilities of Airtable - hi I'm Samanta, executive manager at Ajor, a brazilian association focused in enhancing emerging media in Brazil. I'm testing with my team the use of Airtable as a tool for collecting external data (such as audience survey forms and feedback), internal data (program and project dashboards) and data visualization as well. As I'm not up to date with the tool, especially in terms of integration, automations and interfaces, I'm looking for someone VERY experienced in Airtable for a training cycle for the team. Portuguese speakers are preferred, but I might be able to get a translator (EN-PT or Spanish-PT) for the workshops. Contact: samanta.docarmo@ajor.org.br 

Unable to find an all in one solution to manage our middle term rental company in Spain two years ago we decided to create an Airtable base to do it directly. However, we are not programmers and we need assistance to transform it into a real ERP.We are looking for a programmer capable to set up our base with our missing functionalities to continue working with him/her on a monthly basis for maintenance purposes. What do we have?A base of linked very detailed tables of: property owners, clients/guests, leads, properties, rentals, suppliers, property expenses, tasks, etc. Occupancy calendarTeam task and cleaning management moduleRental contracts templatesConnection of our portfolio to our website (needs improvement)What are we missing? To be able to convert the rentals into invoicesTo be able to send contracts to owners and have them signed digitally through connection with a

EDIT: the issue turned out to be caused by Slack - see this postI use Airtable forms for my employees to submit reports in my business. Prefilling those forms with all of the relevant data is amazing as it speeds up the workflow, gives my employees a better user experience, and gives me cleaner data. I send these forms out to my employees in Slack using Make automations.I recently came across an issue with a new form. I was receiving employee submissions that were missing quite a bit of data that should have been prefilled. After a week of pulling my hair out, I finally realized the problem: many of the fields in this form have field names that contain a space character in the name e.g. "Checklist A". My URL prefill formula was using the `+` character to replace the space character e.g. "prefill_Checkli

I recently added two new scripts to my Automation Helper Scripts, based on recurring situations that I keep seeing in this community.sumTwoNumbers. This script adds two numbers together and outputs the sum. Use this script to increment a number field without using a formula field that just adds one to an existing field.useAlternativeValue. This script inputs a main value and an alternative value. If the main value is not blank, the script outputs the main value. If the main value is blank, the script outputs the alternative value. This script shines when you want to use an alternative value when the result of a "Find Records" action is blank.If you have already purchased my Automation Helper Scripts, you can get these new scripts by logging into your Gumroad account.These Automation Helper Scripts are fairly short. Most are on

Hi Community,Does anyone else experience problems with automations? my all current automations started failing around 7PM Berlin time.I getThere was an unexpected error while executing your script.it also doesn't matter from the script content. when rerun, it stays "In progress" and eventually fails.Regards,Nikolai

 

Hello Airtable Community,I am working on a project where I have three tables in Airtable:Trip Table: Contains all possible trips a participant can go on.Participant Table: Includes a multiple linked record field for trips that a participant is signed up for.Trip Junction Table: Holds individual records showing a participant and the single trip they are on.I am facing a challenge with setting up an automation. My goal is to automatically create a record in the "Trip Junction" table when a participant adds another trip to their account.Here's the scenario:When a participant selects a new trip in the "Participant" table, I want a new record to be created in the "Trip Junction" table that links this participant with the newly selected trip.However, I am unsure how to set up this automation, especially how to identi

Hi. Im looking for spanish consultants for possible remote services. Please let me know you sending me an email to jhammer@programavalentina.com Thanks Jessica

Hi everyoneI’m really pleased with this Airtable system I just built for project and team management. and launched in my store on gumroad today.It works by having two interfaces connected to the same base: one for the project managers, one for the team. The manager enters basic employee data, including their contracted hours, and assigns them to projects. Employees can then see the projects to which they’re assigned in their own interface, interact with each other through the chat, log any expenses their projects have accrued, and submit reports. They can also “clock in” and out again, which timestamps their entries and tracks this data with the time assigned by the manager for each project. When a project has multiple people ass

Hi everyone,quick announcement that I'm building an Airtable Scripting Course for NoCoders, launching before the end of February.This course will compress what's I've learned from writing 1000s of scripts in Airtable over the years. Please sign up here if you're interested 🙂https://airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3ZbBest,Rupert  

Hi everyone,just wanted to share my latest video featuring how to connect to the ChatGPT API without using third-party automation platforms (Zapier, Make, ...).Hope it brings value and would love to get feedback on it!https://youtu.be/pEbU1geuF8I?si=jTyJ6ryNwPVwjS-mCheers,RupertPS: If you're interested in learning how to write scripts in Airtable, please add your name and email here: https://airtable.com/appkftPsXAM2dpUwQ/shrKweL66AExgD3Zb

Hi all,I have written a guide showcasing a quick and easy way to have a chat with a GPT chat bot (Perplexity) about live Airtable data. Check it out!https://www.csvgetter.com/blog/enable-airtable-ai-analysis-with-perplexityLet me know what you think.

I don't know why I didn't think of this sooner, but Airtable is a perfect platform if you want to set up a simple message board for a team of people. I built this interface to do just that.You can post messages, reply to conversations and edit your own messages. One automation and a few tweaks to the settings and you can allow users to edit or delete their own messages, but only reply to those posted by others. Conversations are added to an ongoing "log" with each message so you can easily keep up with any discussions.

Hi there! If you love to keep track of your plants, landscaping, or gardening, this database might help you out! This base includes all the plants we used to landscape around our home. It includes a gorgeous Gallery view of all your flowers and shrubs. ​I took a picture after each flower and plant was in the ground. The best part was I did it all on my phone using the app. ​Fields included are: Plant Name Season Type Plant Type Plant Picture Area Planted Instructions Image Sun Watering Notes Date Planted Record Created Date Plant Status ​ I’ll be adding more info in blog posts soon. Go to hannahwiginton.com and sign up for my newslette

Looking for someone to help create a stock and ordering systems for our shops to use internally. the idea is for them to do a stocktake and based on the day of the week and the par levels that are set for that day if the week, their stocktake will automatically push an order to our central kitchen to prepare their order. opportunities for other developments are available.

Hello all,I have 2 different bases one for Employees and one for Equipment.  I have synced the Employee table to the Equipment table to assign Employees to different pieces of equipment linked to the sync data.  I see the new fields in the synced table in the Equipment base, but I don't see the Equipment showing up on the Employee base.How do I get it to sync back to the original base? and show in other tables that based is synced to.Thank you in advance for all your help.

Hello, In my Airtable's "PEOPLE" Table, we stored many people's name records—more than 15,500 records. I aimed to identify those name records whose spelling is the same as any particular person's name. I developed the following scripting codes using the Scripting Extension in Airtable. When I tested it with another table with a small number of name records, less than 10, it worked well. However, when testing the code with a table with many people's names, the script's running was not complete. This issue could be related to the large number of records in the Table. Please note the following regarding my "PEOPLE" Table: 1) Table name: PEOPLE, 2. Primary field name: English Name, and 3. "Duplicate Name" is a checkbox field, which means if a tick is created for any name, that name has more than one record. Please see my scripting codes below://Read our tablevar table = base.getTable('PEOPLE');var query = await table.selectRecordsAsync();//Identify

Greetings, Airtable Community!Have you ever wished for a quick way to turn a list of birthdays into horoscopes? Well, now you can, right here on Airtable with just a few clicks.🌟Check out this quick demonstration:All you need to do is head over to your Airtable base and search for the "Astrology Calculator" extension. Install it, and it’ll seamlessly convert birthdays into horoscopes. 🥳Feel free to share your experiences or ask any questions right here, and here is a link to the app! https://airtable.com/marketplace/blkEIUSBWaQ0hBB3O/astrology-calculator

Posting this in case this can help anyone solve an issue or in case there is anyone who can think of how to do it better. I was asked to create a corporate event calendar that housed all 5 corporate event calendars in a single base and included 3 specific items:Enforce all event times have a time zone of PSTAllow easy All Day or Continuous All Day MeetingsCreate recurring events that can be created daily, weekly, bi-weekly, monthly, quarterly, semi-annually or annually. Additionally there was a caveat that one calendar type needed to include weekends while the others did notTo solve for this I created a single table called Internal Calendars and included the following fields:Event Occurrence - Single Select that allows the user to pick the type of scheduling for their event(s): All Day, Continuous All Day, Conference Event, Recurring Event and HolidayStart Day - Date field used to select the date an event will start.

I am trying to use Airtable to consolidate all the ways we manage your ad inventory (we are a publisher of websites). Ideally, I would like a form where ad sales rep can enter all information when a campaign is booked, and see in a calendar view what’s available or not. Once entered, the campaign would trigger deadlines (for client to give brief; for writers to create content; for client to give final approval, etc…) and notifications and reminders would be sent. If you have experience with this kind of thing please respond here.

Good day Airtable Community,Are we expecting any maintenance issues / downtime during the Christmas season? So that I can set my expectations on what will happen for next week? Thanks

Airtable has just released a popup to allow cookies on all embed views making my app not usable anymore....Each time I refresh the page, the same popup is displayed !How can I get rid of this popup allowing cookie ?Thank you for your help!