Ask the Community

Hi guys, I have created a "date field". 3:19 pm is my current time, but once I had it created, it showed the wrong time - 12:00am, I tried to click "use the same time zone for all collaborators> GMT/UTC", but the time was still wrong. I don't understand which step I had made wrong. 

Google calendars that are imported to Airtable - it looks like only 20 google calendars are allowed to be imported on a base. If we need more calendars on a base, then we need to create a new base? Is there a way to get more than 20 google calendars on a base? Please see screencast and pic attached

Hi everyone,I hope this message finds you well. I recently accomplished the successful synchronization of my Airtable base with my WordPress site using the Air WP Sync plugin. During this process, I also had to integrate Advanced Custom Fields (ACF).To map the content from my base, I utilized the custom field option within the plugin, and it worked seamlessly. However, when dealing with multiple selection type data from Airtable, I needed to convert it to checkboxes.Here's where I could use some assistance: I am unsure how to effectively utilize the selected options from these checkboxes. It seems that the plugin only compares labels, and I am unable to find any ID or value associated with the selections. I need to perform a verification of the received data but cannot rely solely on the label text.If anyone has experience or insights into working with the data received in WordPress through Air WP Sync, I would greatly appreciate your guidance.Thank you so much for your time and assist

Hi, I need help on the automation that I'm currently building. The section where it says "From name" on the Airtable Automations is not working. The email being sent is still the actual email address used, I want it to be the exact name of a person and I have linked the value on the section correctly, but still I'm having issues.. Hope you guys can help me figure out. Thanks in advance!

I would appreciate an option to limit the available times to schedule records to work hours (9 to 5). We can limit the dates shown to just weekdays, but available times are all over the date (2 am, 10 pm, etc.). This needs to be an option as someone may have events or projects outside of work hours or use the date field for something else. I have a manual entry date field for scheduling tasks on the calendar, and the UX is not optimized for selecting a time within work hours.

Hello, I need some help to find a solution for this task:I have two tables, on contain a columns called small, tall and month. The second table contains the columns small_december and tall_december.I need to write a script that looks for the record month of the first table and names of the columns if they contain the word, in this case December. if the condition matches the data will be copy from table 1 and bring it for table 2. 

Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com http://domain.com Column 2 Result in all rows of above domain.com

Anyone found a way to control the font size on Print View?

Hi all -I have a table that acts as a timesheet for the same users to submit hours each week.I use the 'Hours Logged' from Fig. 1 (which is an entry for that week) and add it as a lookup value to my table with my people names (Fig. 2). There's multiple entries in the Hours Logged in Fig. 2 as it should, but when I go to my main table, it doesn't show the 'Hours Logged Sum' for that week. Instead, it shows it based on all entries. Is there a way so that I can get the 'Hours Logged Sum' to show what the sum would be for that week like a running sum for each individual? As an example, how would I show that the hours logged sum would be: Hours logged = 3.0; Hours Logged Sum = 3.0; Max Hours = 40; Hours available = 37Hours logged = 1.0; Hours Logged Sum = 4.0; Max Hours = 40; Hours available = 36Hours logged = 5.0; Hours Logged Sum = 9.0; Max Hours = 40; Hours available = 31Fig. 1 Fig. 2^ Shows the running sum here, but it adds them altogether for every entry that matches the

Hello!Currently I have a button column linked to a column with a webhook. When I press this button, the webhook is triggered and the row informations are exported to Make.I want to get in a column, the number of times the button has been triggered (+1 each time).Do you have an idea ?Cheers

Hi everybody!I managed to sent emails from linked table. But now I ran into a problem. I have two linked tables, one for RMA requests from customers and another for a list of repairers with their emails. When I want to send a product to the selected repairer, I want it to be sent to an email that is entered in another table of repairers. This works, but many times it sends the same email to other emails that are in the same table (so it sends an email to the entire list of all emails in this table). When I was working on automation, I used lookup field of the email address of the srepairer from the second table and sent the email from the first table (customer requests, because it is related to a specific product and customer). In the automation for the "to" field, there is no way I can select anything other than a "list" of emails.. could this be the cause of my problem?I had sooo much trouble building the automation because in most cases it always gave me an error that "to"

I have two tables that are linked to each other: Candidate Table and Position TableEach candidate record has contact information (email) and is linked to a specific position record which also means that each position record may be linked to multiple candidate records. Each position record also has a status: Active, On Hold, Lost, etc.I would like to be able to send automated emails to all candidates linked to a position that has changed its status from Active to On Hold to update them on what's going on. What would be the best way to go about this automation?

Hi all,I am curious to learn more about what linked and un-linked data can be used in the 'Find Records' action in Automations. This happens frequently, and I am fairly sure that it is related to field data types. Linked record fields can only be used in certain instances, and lookup fields can only be used in others. Sometimes I have had to create 'String' fields through formulae to lookup other records. My ask: does anyone have any links to learning resources or documentation where i can learn what the limitations/benefits of certain field types are. We are managing the database through a front-end, and no fields are updated manually, so the vagaries of these data types and their capacity/limitations is quite a challenge!An example of my issue is included in the screenshots attached:For reference, I am working with 5 tables:UsersIn some cases linked to OrganisationsIn some cases linked to PropertiesPropertiesLinked to UsersIn some cases linked to LeasesUnitsLinked to Proper

I'm working on a project involving the 'Schedule Campaign' table in Airtable and need advice on implementing a specific logic.Problem Statement:In the 'Schedule Campaign' table, users can add an investor and link multiple startups. This data is then used to create a Mailchimp campaign based on a template that only accommodates data for up to 6 startups. The challenge is ensuring that no more than 6 startups are added per campaign, as the system currently allows adding more linked records than needed.Current Ideas:1) UI Prompt: Add a text note in the Interface requesting users to add only 6 startups. However, this relies on user compliance and doesn't prevent the addition of more records.2) Airtable Automation Script: Implement a script to check each row for more than 6 linked startups. Excess startups would be moved to a new row with duplicated investor details. This approach involves scripting, which deviates from a pure no-code solution.3) Make Integration: Leverage Make to construct

Hi there, I'm having issues with formatting when pulling data from Airtable into Formstack Documents (integration via Zapier). Detailed explanation below.The Profile field in Airtable has a large body of text and is formatted with line spacing between each paragraph. However, when I create a document merge via Zapier into Formstack, the formatting is gone in the merged PDF. All the other content in the document is fine as it's part of the PDF template, whereas this Profile section is dynamic so it must be pulled from Airtable. Other fields are pulled from Airtable, but they usually only go over one line so I haven't noticed any line spacing issues.I'm not sure if this needs to be resolved via Formstack itself, or if it's the way I've set up the PDF template in Adobe Acrobat. Or perhaps something else entirely.Any suggestions would be much appreciated!

Hello community! I’m creating a table to manage a music school. To help with registration, I created a form and I’m quite happy with it. We want to give access to the form through our website so customers can register. I now need this form to be available in both French and English. My concern is mainly with dropdown fields. How would you proceed? Do you know of a way to avoid using a paying app? Thank you guys so much!

Hi. This seems like something trivial, but I can't seem to find any way to do this. I had synced two tables from a base to another.  During that time, various fields were renamed in Base A (the source table).  I noticed that the fields in Base B do not seem to get renamed as well, yet the sync remains active.  How can I know which is the fieldB name in Base B, which maps to fieldA in BaseA, without having to resort to guessing? 

I have a Date field (Date Asset Added) whose value is entered manually formatted like this:12/8/2023Another field (Date RM) contains this formula: DATEADD({Date Asset Added}, 0, 'day')  which outputs this: 12/8/2023.  12:00am I want to execute an automtion when these two values match, which they don't. So I tried using thiis: DATETIME_FORMAT(DATEADD({Date Asset Added}, 0, ‘days’), ‘M/D/YYYY’)) which outputs this: 2023-12-08T00:00:00+00:00  I think that DATETIME_FORMAT turns the date value into text. In any case, what formula can I use to get the value of the field Date RM to match the value in Date Asset Added? 

Hi there -- I'm using Airtable to build a database of jounalists on Meta's Threads. I've made a form so people can submit their details: https://airtable.com/appWgEz1pjYySqFTj/pagzqw2grYU9luJob/form My base consists of four tables: Journalists, locations, publications and beats. The form primary creates a new record in the Journalists table, but I'd like to use the same form to add new records in the other three when necessasry -- i.e. if someone works for a publication that isn't listed.Is this possible? With apologies if this has been answered before -- I did a search around but couldn't see anything relevant.CheersDave

I’m trying to automate an order ID. So when a new row is added, it is given an automatic ID. The existing ID from pre-AirTable looks like: LS000000 E.g. LS and then six zeros. The first order should look like LS000001, the next order like LS000002 etc Currently I use: Field 1 - AutoNumber (AutoID) Field 2 - Formula = CONCATENATE(“LS00”, (AutoID)) Which gives LS001, LS002 etc. It looks right when we get to LS001000 e.g. all 6 digits now present. Any ideas how to force the six zeros from the start?

Hello,I want to make an automation to send an email at a specific time. When I choose the trigger "at a scheduled time" and go to write the message of the email, I can write a message, but I cannot input any data from the base. When I click on the blue plus sign in the upper right corner, the only options are "actual trigger time," "expected trigger time," and "next trigger time" (pictured below). How can I pull data from the base, such as "dear [insert name]"?Thank you.  

Hello everyone, Please I need your help I would like to send out an email with two answering options referenced from my table in my base and the user should just be able to pick one option in the email with just one click and automatically the value are being transmitted into the base directly without opening the form. I don't want any form to be seen after pressing the button I just want it to be submitted automatically.What i have done is to create a form and write a prefill url formular that prefills the form with the option and an extra field that will also be prefilled that works only in the base but when i reference it in the email and preview it doesn't appear at all in the email.Would it be also possible for the form to be submitted automatically once the button is pressed ?I would really appreciate any suggestion or insight Thank you.

I want my automation to update the record when it is complete and then remove or delete any/all the attachments in a particular field, how can I do this?

Hello,Thanks in advance for any assistance with this.We have a ticket system whereby people submit by form an action and it's completed with a time stamp; with a goal of completing every request within 8 hours.Currently we determine if the time completed was within 8 hours of it being submitted and that generates a "1" in a formula column.  That column provides a percentage of the amount of 1's filled and gives us a service level.Recently I was asked to refine this solution to only consider submissions during business hours (Mon-Fri between 9am-6pm).This way, anything submitted outside of business hours doesn't count against the 8 hour service level until it's within spec.If something is submitted at 6:01pm, the timer freezes until 9am the next day given it's not a weekend.Alternately as long as something is submitted within business hours the timer does not stop even if it exceeds business hours or goes into a weekend.I'm hoping to get some ideas on how this can work within airta

I want to automatically copy a specific field from one table into another table. This needs to go to a specific airtable id - is this possible?