Ask the Community

Hello fine people!Here's what I have and am trying to do... any help would be greatly appreciated!!Customers order a product from us and can choose a recurring subscription - either once a month, three months, bi-annual, or annual.What I'd like to do is have an automation of some sort that would recreate this record so I can add a calendar and have those records show up in the calendar based on the next shipment, creating a new record in my "New Orders" table.Thoughts?

3 dias atrás meu formulário e passou a aparecer essa mensagem de erro cada vez que tento abrir uma landingpage do formulário.Formulário indisponívelEste formulário atualmente não pode aceitar novos envios.Erro: pgl6Y04zOhM7uVuI5 / Erro: pglP0mXbLsfF4KZJn

Hi everyone, I have some set of records that need to be duplicated. At my surprise, there’s no option to “Duplicate” when more than two records are selected. I cannot duplicate by hand because the base is quite heavy, there’s too many records to duplicate and it could cause a lot of errors. Is there a way to do that (a block, a script, an integromat scenario…) ? Thank you

I have the following tables within a base:ProjectsTimesheets, with each record linked to a single project and a single task type (single select field)Estimates, each linked to a single project and a single task type (single select field)I'd like to be able to compare, ideally in a table and chart (multi series line chart?) in an interface, the amount of hours spent on a particular task type versus the amount estimated for that task type. There may be time spent on a task type that did not have any hours estimated for that task type.What is the most efficient way to do that?I could create conditional rollup fields in the Projects table for each task type, but then I'd be on the hook for creating new conditional rollup fields if I ever create new task types. This is the kind of scaling limitation I'd like to avoid, if it is even possible to avoid it. Any ideas?Thank you!

Hi thereI'm trying to set up a base to record relationships between several data sets, specifically: Segment (eg academia, corporate)Sub-segments (eg lecturers, library, researchers) Use cases (eg data management, author screening)Use case groups (eg planning research, managing research)Products (eg Pear Software, Banana Software)I'm not sure how best to set up the base to show their interconnected relationships. For instance the sub-segment of Lecturers, which is part of the Academia segment, uses Pear Software and Banana Software when they have use case of Author Screening, which is part of the use case group Planning Research. Another sub-segment might use Pear Software and Banana Software for different use cases, or they might have the same use case but Peach Software and Grape Software are better for them. Each segment and sub-s

I wish to use a series of icons to represent the status of a record in a base. How best to do this? If I add a small image in an attachments field it works, but the image becomes a clickable link and opens the image file - not what I want. The icon must be a static element. If I use a "Single Select" field I cannot import my icons.I would appreciate any guidance.

Can anyone recommend a license-free icon library compatible with Airtable Formulas and Interface Text fields? I see them used in templates, but would love to have access to a complete library.

Hi, I love these kind of icons used in table names and fields. How can I find icons like these, especially with this style? Is there a page for icons which Airtable supports?

Vague but important product feature idea 17786It'd be great if we could get a form of breadcrumbs for naviagtion when viewing records, and their subsequent child records.ie) If I am in my record view for Projects, and click into a Task (Linked, Child Record) then into a subtask of that task, it'd be great to be able to see this reflected in a top Nav Client ABC / Project 678 / Ross' Task / Ross' Subtask 46 I know it wouldn't work for all scenarios, but it'd be SO powerful for this type of multi level App buildingRoss

Good afternoon! I’m working on gmail automation and inserting $ amount fields into the content of my message. I’m using the following formula and noticed that the trailing zero is missing for an amount: CONCATENATE(‘$’& ROUND({Daily Rental Fee},2)) Missing zero: How can I get the zero to appear?

Hi,I use a formula field to build a URL to prepopulate a Fillout form, and I send the link via an automation -> Gmail send. The formula looks like this:"https://user.fillout.com/t/random?email="{email&"&name="&name&"&id="&RECORD_ID() When sent out in a mail this becomes a clickable URL. I would however like to have as a "friendly name" clickable link instead. This I know can be done with the [Click here!](https://domain.com) syntax, but I can't figure out how to work that into the formula. Anyone know how to do this? Rgds, Björn

Hi, I have been trying to solve this, and I'm curious if there's a solution. Please see attached screenshot. I'm trying to add a contact within a form in a new interface that I built. How can I achieve this? I can't seem to have a + sign for users to add new contacts. It only gives me the option to choose existing contact. I want to add a new one from there. Any suggestions? Thanks!!!

HiI am very much new to AirTable so this may be a beginner’s question but I would appreciate the help very much. I try to describe the situation in detail below.Context: I am setting up a more efficient lead generation & reach-out tool for sales purposes, automating some manual tasks such as data scraping & email generation. We have 3 email templates that we use, depending on the product that we want to advertise, plus we send to two types of contacts - English or German speaking (i.e. up to 6 different email templates)Goal: I want to set up the process, so that once I have a Contacts table filled, I manually define for each contact which kind of email they should receive and in which language. Then those emails, based on the templates, with personalized tokens (i.e. Hello {Name}, ….) are stored in a new table “Personalized mail”. (then I will use that data to input to Make.com and send these email drafts to my O

I want to launch the first version of my product which essentially let's the practitioner connect their Google calendar, manage their availability at the backend and their clients can book the call from the available slots. Each practitioner can only see information concerning their practice aka data privacy is essential;. How can I go about building a multiuser login without adding them as collaborators? If you're an expert and can help me build this, please reply here. Happy to onboard a consultant who can help build this.

Hey all, so I am trying to create an automation to send over a slack message everytime there is a new record, but for some reason it is not showing the tagger suer properly.I have a table with all the users D05XXXXXXI tried with just the following formats @D05XXXXXX, <D05XXXXXX>, <@D05XXXXXX>.And none of the seem to work. Any ideas what may I be doing wrong in here?

Hi,Is there a way to create a download a CSV button to the interface for users to be able to export the record or list details as CSV? if it can be done, How do I do it?Thanks

I have created a ticket system and have now created an automation that should change a status after 2 days. Unfortunately it doesn't work. I have a date field that contains the date of creation and a condition that if the date is 2 days ago, the status should be changed to "2 days old".

We have a large team and many tables. Each department has their own table "queue". Obviously someone minding the SMS queue does not want to see the paid social queue first and so on. Is there a way for users to change the tab order based on their personal preferences and not be forced to use the base default tab order of all the tables?

I have a table with information about kids on a team I coach. I have a field for their birthdates and use that to calculate their age divisions. I’d like to use a calendar view to show upcoming birthdays, but the calendar view based on their birthdates doesn’t work, of course, because their birthdates aren’t in the current year. Is there a way to do this?

Is it possible to request results from the REST be sorted by the createdTime (which is returned on the payload) without needing to add a new column to the table? i.e. right now if I pass createdTime to sort, I get back an error: [Error: {\'type\': \'UNKNOWN_FIELD_NAME\', \'message\': \'Unknown field name: "createdTime"\'}]

Currently, all rich text formatting is removed in Lookup fields. It would be so helpful if rich text formatting (especially hyperlinks) is carried over into Lookup fields!Airtable, please support this function! 

Hello, I set up an automation to check a record within a certain timeframe from the job date, and if the record field was not up to date, then an email would be sent to the two people in charge of that data entry. It is basically:If the job date is 7 days from now, and the field X is showing Y, then send an email to Bob and Jim that says "enter this data". I have attached screenshots of the set up. I can't work out what I have done to make it think it must send the same email 500 times. Any help appreciated. I am new to automations

I have an automation I am trying to create to loop through days in a record.  Basically the record I get includes the start and end date of a time period.  I would like to loop through from the first day to the last day and create a day record for each date.  Something like:StartDate = 09-28-2024EndDate = 10-01-2024The loop would create dates in my Dates table for 09-28-2024, 09-29-2024, 09-30-2024, and 10-01-2024. I've figured out how to do this in a script however my current plan does not allow for script execution so I'm wondering if there's a way to do this outside of a script.  Any suggestions would be appreciated.

I chose the project management template that came with interfaces with various pages. They are very helpful and I have up to now only needed to do minor changes. However, in removing the placeholder data and starting to add my actual data it seemed to have "unlinked" the people section, where the interface is set up to pull task data for whatever user is currently accessing that page. It was showing me a random placeholder person, but I do not know how to make sure it associates a "person" record with the account accessing the base/interface.My initial thought was to just add a dropdown to filter the data based on the user chosen, but I seem to have no way to do that. Navigating the interface editor within a prebuilt template interface is unendingly frustrating and confusing, and none of the documentation seems to match what I'm seeing.Is there a way to link records to a person/account instead so this feature works properly?

Hi there,  I'm pretty new to Airtable so forgive me if the answer is straightforward. I'm trying to set up the following automation:  When an entry in table B has Field A = X and Field B = Y then update Table A, Record Z, in Field "Dernier numéro de facture" by changing its value to {Dernier numéro de facture} + 1 (so incrementing its value by 1) What should I enter in the Field highlighted in the image attached? I tried {Dernier numéro de facture} + 1 but it outputs a "Could Not parse number" error although last invoice number field is a # Number. Thanks!