Have other Airtable related questions? Post here!
Recently active
Hi all, newbie here - is there a way to create multiple columns in one go from a list of column title headers I have as a list? I have 60 + columns and have written the Column names down as a list (which can be also as rows in one column) and want to create all the columns in one go rather than one by one as it is time-consuming (all the columns are of the same type - text) . Thanks
I have a table that collects the likes of my products. Here the corresponding product is created with a linked record. Unfortunately, in the table of products the reciprocal links does not work and I can not retrieve the entry from the other table. Why does it not work? (i have done this many times and it has always worked)
HelloI have three tablesCONTRIBUTORS, with Name and other infoACTIVITIES, with Title and other infoCONTRIBUTIONS, with Contributor name (lookup), Activity title (lookup) and DurationThe latter looks likeAlan, Hackathon A, 12:00Melinda, Hackathon A, 10:00Alan, Presentation C, 4:00Now, I would like a field Total contributions in CONTRIBUTORS that sums up the Duration of CONTRIBUTIONS per Name. 😊This would show 16:00 for Alan, 10:00 for Melinda, etc.I got the result in a pivot table but I need it as a table field.I tried the following, which does not work. 🤔 🤔Total contributions (rollup) in CONTRIBUTORSLinked from CONTRIBUTIONS, field Duration, where Contribuor contains {Name}, aggregate SUM(values)Thank you for your help. 🙂
I posted a legitimate question about markdown/HTML. When I returned to look for the question, I couldn't find it. I looked under my Subscriptions and it indicates it was marked as spam.I contacted the moderator (via the notification at the top of the post) and have twice since then. I already received an answer from another forum but I am curious as to why this was marked Spam and also curious as to whether moderators are seeing those messages?Here is the question I posted.
HI! Is there anyway to turn off notifications for a member so that they are only notified if they are @mentioned?
I’m working on a trouble ticket table that keeps track of support for our users. I want to be able to track when a box was checked. So I have a “Followed up” checkbox field and I’d like to track the time from when the record was created to when the box is checked. I’m pretty sure I know how to figure out the difference in time with a formula but I’m having a hard time getting the timestamp of the box being checked. I can see the time in the expanded history view but there’s no way to reference it as far as I can see. Any help or workarounds are appreciated!
Hi,As an Absolute Beginner learning on the "Free" version of Airtable, I have a couple of questions on sharing:1. I want to share my base with other "free" collaborators - how do I do this?2. Once shared, can my collaborators update my Base or will they only have read access?3. If I upgrade, will I have to buy a licence for everyone who wishes to update my Base?Thanks,Geoff
Hello, I was lazy when we first started using Airtable and invited my team as workspace collaborators. Now that we're growing, we're creating some Bases that not everyone should have access to.How do I convert a user from a. Workspace Collaborator to a Base Collaborator?Is the process the same to switch from base to workspace?Thanks!
I have contact records in my primary tab (we’re using Airtable as a CRM) where the contact’s Full Name is the main record. Then in another tab, we’re logging interactions with the contacts, and have a column that links to the contact record in the primary tab. In our primary tab, we have a column “Follow Up Date” that looks at the interactions in the other tab and grabs the follow up dates from each interaction with that contact (also from the column “Follow Up Date”). Ideally though, we only want it to grab the most recent date. If you see in my below examples, the contact Brian has 2 dates in his follow up column. This is because there are 2 interactions linked to his contact, both of which have a follow up date. However, the only date we need is the June 3rd one, since it’s the most recent. Is there any way to add this as a condition? I’m not seeing it. Thanks! Tab 1 Tab 2
I see a few people have asked this question already, but I don’t see a clear solution in those other threads. I’ve embedded a form on our WordPress site, and added a redirect for when someone completes the form. However, it doesn’t work. It looks like it activates the pop-up blocker on my laptop (which is a default setting on a MacBook Pro I just purchased, so I’m assuming others will have that, too). It reverts back to the form instead of sending people who completed it to my thank-you page. Is there anything else I should try? Thanks! Another thread where this is asked: Embed Form in Website - redirect url not working Views I have a requirement to embed the airtable form in our website and redirect to a url when the form is submitted. However, when clicked on submit button the redirect url is blocked by pop-up blocker(enabled by default on websites). I used the sandbox attributes but still no luck. Am able to open the form in a new tab but that’s not my re
Hi,I watched the getting started in airtable webinar on Tuesday 25th July 2023 and they said they would email the link to the recording, which they haven't. I want to share the video with my colleages before a meeting with the sales team tomorrow. I can't find the link to that specific webinar on the website and if I click the links in the answers to this question that has been asked before, I just get the sign up page.Where can I find the link please?
I am sorting alphabetically the Primary Field which is a Single line text. It does not work. I have some data for this Primary Field that are duplicates and when I sort it, it should be right next to each other but it’s not. How can I fix this?
I have a long text field that may include newlines. Example: Where is Margaritaville? It’s in the tropics somewhere between the Port of Indecision and Southwest of Disorder, but no parallels of latitude or longitude mark the spot exactly. You don’t have to be a navigator to get there. Palm trees provide the camouflage, ocean breezes bring the seaplanes and sailboats, tourists and travelers. Passports are not required. Island music rules. No waiting lines for anything. There is a beach and a thatched roof bar perched on the edge of the turquoise sea where you can always find a bar stool. There are lots of lies and loads of stories. It’s a comical concoction that blends together like tequila, salt, and limes. Where is Margaritaville? It’s in your mind. When I use the translate block, the result has had its newlines stripped: Où est Margaritaville? C’est sous les tropiques, quelque part entre le port de l’indécision et le sud-ouest du désordre, mais aucun parallèle de latitude ou de lo
Hi!I'm building RMA system in AT. I'm creating Form outside of my table for manufacturers, but some manufacturers have their own RMA form. So I want to somehow recreate their PDF (use it as a template and add my fields from AT). Can I create Form by adding existing PDF (or photo) and just add my fields on top?Thanks.
Hi, How Can I batch add texts into a text field? Please see attached, how Can I add text "outdoor" into "Note" field under the exist texts?thanks
Is it possible to insert a chart or graph block into page designer? I can’t seem to figure out how. Any help will be greatly appreciated! Best wishes, Jason
Hi. I want to send a form to customers, for filling out their personal information and information of the product they want to return (but they are not sending it back yet). When we check their information and approve it, then they can send the item back to us. In this step I want to update form, by adding the field "tracking number". Is this possible?I already have a form, but I was wondering if I can update it, by adding extra field. To that I would get another field when the form is updated. I know that you can update info in a form using Fillout.Thanks in andvance
I want to create a single compact form where the top half of the screen is a tabular view of my Contacts table records and the bottom half of the screen is a tabular view of my Activities table records. Any given Contact record selected in the top view is the filter criteria for Activities records displayed in the bottom view. I know how to create linked tables and fields, my question is how I create this classic (old school) parent-child DB browsing view? Thanks.
How do I share an entire table with multiple views? I don't want to share the entire base or a specific view. I want to share the table within the base, and it has multiple views. This prevents me from sharing an table of information, without having to share a link for each view. The views I have designed make it easier to progress through helpful views of the information. There is no need for someone to get the entire base. And it makes no sense to give the person 10 view links for the same table of information, just presented differently. It also is less helpful to provide all the views in an "everything view"; which defeats the point of using the views in the first place which is to highlight relevant information. I don't want to have to create an interface either just to share a table.It is called Airtable, not Airview or Airbase. Why is it not more straightforward to share an entire table of views? Where can I find this feature? And if the feature doesn't ex
Hello everyone When I try to connect Twitter to Airtable it says: The account being added is already logged in. So when I log out of Twitter in my browser, it just logs me in a small window and it’s not really being added. What am I doing wrong? Thanks in advance.
So I was able to write out a simple formula in a table to see what percentage of the people in that row participated out of the total number of people in the table, but I had to manually enter the total number of people - the formula looks like this - ({# of Participants}/433)*100 It works, but the issue is that every time we have more participants, I’ll need to update the 433 number. How can I get this to update automatically every time a new person is added to the total? Thanks!
Hello community When you are creating a new record using a form, you can search for other records to be linked to the one you are creating (if you have a linked field). I have been reading the different previous posts and I understood we can only search by the primary field. So, in our company, we set up all primary fields as a concatenation of different data, let’s say “Location - Name”. In the search bar to identify the right record If I type Location A, I got all the results with Location A - working fine If I type Name A, I got all the results with Name A - working fine But if I type Location A and Name A, no more result at all Is there a way to search for several words or just letters in the search bar? Thanks for your help
I am trying to set up and “Address Field” that has the full address, ie: “1234 Summerset Dr.”. How can I sort that field A-Z without it just sorting by the number portion of the address? Thank you in advance!
I've seen variations of this question, but can't seem to find the best solution for my use case. (FYI - I'm on the Free version) I need to create sequential numbers based on a linked record. Example: Our "Jobs" table has all our jobs and their corresponding data. At times, certain jobs require a change order. The format we use for this is the 544-01, 544-02, 652-32, 652-33, and so forth. The first number specifying the previously assigned Job# and the second being the change order #. When using autonumber the numbers aren't sequential if a record in between isn't specified by a single select as a Change Order. Making our records seem scattered and really confusing the customer when they received change order 15 and the next one change order 18. Any suggestions?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.