Other Questions

Hi, I currently use the CSV Import App to import an excel and use the “merge with existing records” to update values with current matches. However, I’d like it to recognize when certain matches are no longer in the excel that I’m uploading and thus delete rows in Airtable. So for example, If day 1, I import Then the next day, I import I want it to recognize that I’ve deleted “Walmart” and thus delete it from the existing Airtable. Any ideas as to how to do this?

When typing a tweet in a Long Text box, I start typing the @ name for Twitter, but it auto populates with the names of my collaborators in Airtable. How do I turn this function off just for one long text box? (I want to be able to tag them in the other boxes, just not my ‘Tweet Draft’ Box, because it causes problems with the format of the tweet. I realize I can copy paste the twitter @ for this, or use a different symbol, but I want to be able to cop/paste directly into Twitter, formatted perfectly.)

Hello! I have one AirTable database with three tables. The first two (Form Responses 1 and Form Responses 2) are synced with JotForm, and they show the responses from two separate forms I have created with JotForm. All of my clients fill out both forms. The forms have different questions, but both start by asking for the name and email. I would like for the third table to combine my clients’ responses in both forms (currently separated in tables 1 and 2) into one row. This would likely be through filtering by email. Is this possible? Let me know if screenshots would be helpful or if I can clarify in any way. Thank you!

Hi :slightly_smiling_face: Trying to create Google docs from Airtable record, but I am stuck with using link fields. Here is the explanation and would appreciate if you can help. Airtable base have three tables; Clients, Offer and Services. Offer and Services are linked and Offer can be linked to multiple Services. I have set up Integromat to create Google Doc from a template and I got stuck with listing all linked Services to an Offer. I user Iterator to extract all Services linked to Offers, but I don not know how to have them listed in Docs. It would always return only one Service in Docs. Then I added Array Aggregator, but It dos not output the records data that I need. Not sure how to continue from here… Below are the screenshots of the scenario;

I have been searching everywhere for a way to do this, but I have a table, named Categories. It is linked to a table named Bonuses. What I want to do is in my main form (and table) filter the bonuses available based on the Category selected. Is this possible?

Hi, I apologize in advance, I am sure this is an easy question, but alas. I am new to airtable and have a very basic questions- How do I when to create a table and when to create a dropdown? I feel like if i am going to reuse the data I should do a table, but I seem to have a LOT of tables right now and that doesn’t feel quite right. Thank you in advance.

Okay trying to do a bill manager and I have months listed and check marks for when a month is complete. I have put the day of the month in the date field. I would like to get the month off of the check marks and year as current year. Is this possible or am I asking for too much. Tia… Richard

Hi - We have signed up to the Pro Plan but when I try and set up emails I get the message “On your billing plan, you may only email collaborators with verified emails. See more plans.” Is this because we are still on a Pro Plan Trial and it is waiting to switch over in 2 days to the full Pro Plan. Can it be forced to switch over now if this is the case?

I have three databases from which I need to set up the proper sync: Database Students 20-21: list of all the students from 2020-2021 school year (including field school year 20-21, unique student ID and photos (attachment) Database Students 21-22: list of all the students from 2021-2022 school year (including field school year 21-22, a unique student ID and a field Indicating if a student is new. (no photo yet) Database Students All Years: I would like to sync the Database 2020-21 and then the database 2021-22. This database is not syncing the field “New student” as this database is to collect information through the year. the field School year becomes “Last Year enrolled”. Problem : avoiding duplicates I would like to be able to sync the 2 first databases with the third one and avoid duplicates. For now if student ID xxxx is in database 2020-21, and he is re-enrolled so he is also in database 2021-22, then I have two occurrences in database All years. How can I sync the databa

Hi, I’m trying to create a line chart representing a cash flow with Vega Lite. In my main table I have record that are cash transactions with a date and an amount (either positive or negative). I want to display my bank balance for each month: in February I want to have January + February and not only February. Does anyone has an idea on how to do it ? Thanks Here is my vega code: { "$schema": "https://vega.github.io/schema/vega-lite/v4.json", "title": "Solde mois par mois", "width": "container", "height": "container", "mark": { "type": "line", "point": true, "tooltip": true }, "encoding": { "x": { "field": "TECH Cash flow date", "title": "Mois", "timeUnit": "month", "type": "nominal" }, "y": { "field": "Cash Flow (pondéré)", "aggregate": "sum", "title": "Solde bancaire (€)", "type": "quantitative" } } }

I am new to using airtable and I need to create a new view. We use airtable to log annual leave and sickness requests. I need to set up for annual leave requests for 2022 - any tips greatly appreciated

I have an airtable base and a wordpress site. Playiit I want users to somehow be able to mark records in the database as their “favourites”. Ie each user will have a different set of “favourites” to any of the other users. I am not sure how I can achieve this. Can I use the “Use this data” functionality somehow to achieve this? If a user does use the “Use this data” functionality is there some way I can keep their base updated with changes in my base? Any help is much appreciated

I have a Pro plan with Airtable. I cannot seem to find anywhere what it costs to create a new base. We currently have 6 different bases linked to the account. Is there a limit to how many bases I can create? Thanks in advance.

Hi, I have this PDF report (opens a Google Drive link to the PDF) that I need to recreate in Airtable. As you’ll see, I need to set up some sort of if statements to “count these records if its value for this column is this, this, or that” and then summarize those counts in various ways. I am going to try working with COUNT-IF formulas and grouping to show summaries, but I still need to allow users of this base to pull these reports only for certain time periods. I have looked at Page designer, Pivot table, and miniExtensions Form to summarize this data, and I have not been able to figure out what I’m looking to do. Can someone help? (I tried reaching out to the support team and all they did was send me basic intro walkthroughs to the product which were not what I was looking for at all).

are there any examples of scripts that add a new record? i built a script that updates a field on a record when the email exists. now i want to modify it to add a new record if the email doesn’t exist yet. i don’t see any examples and not sure what the syntax is for adding records. thank you!

Hello, Do you know what is the formula to remove text after a coma? I tried to convert the Excel formula LEFT(A1,FIND(",",A1)-1) to something like LEFT({Name of field},FIND(",","{Name of field}")-1), but without success. Thank you for your help!

I’m using AirTable for project management. I have a table that has all of my projects. One of the fields is a tasks field which shows the individual tasks (linked record from the tasks table) which are associated with that project. Is there a way for me to filter which tasks show up in this tasks list? (e.g. if I want to show the remaining open tasks)

I have a form that allows a User - selected first, to then select 8 items individually. I want to make sure the user never selects the same item twice by adding conditional logic, but I can’t seem to do that on a choice by choice basis per user. The perfect functionality would be to say if Form already selected X eliminate it from the choices on next selection and so on. The conditionals only seem to be on the entire table not the form directly. Any ideas?

Using the built in bug tracker template, when ever you create a new row, e.g. by hitting the plus at the end of the table, it gives you a warning that “record moved” and re-orders all your existing bugs. This makes it unusable, as you cant track anything with other people, e.g. can you give me the status of bug number 2. To make it worse, the number of the new bug is random: sometimes it creates the new bug as number 1, and renumbers all your existing bugs, sometimes it creates the new bug with a random bug number somewhere between 1 and the total number you already have, for no apparent reason. a) is this normal. b) is there any way to fix this? New bugs should always have the number n+1, where n is the current number of bugs, and existing bugs should NEVER have the number changed. To make it worse, if you change the view (e.g. by priority or by “all bugs and issues”) tickets get different ids.

I am trying to create a ‘Find Record’ Airtable Task in Zapier that finds a row based on the values in two columns, {USER ID} and {TAGGED RX}. The USER ID should match the value in a previous step and the TAGGED RX should equal 0. This is the formula I am using, but it is creating an error: {USER ID}="{{29838037__user__user_id}}"&"{Tagged Rx}=“0” Is there a mistake in my code? Thanks you!

I’m very new to Airtable and spreadsheets generally. I’m wondering if it’s possible to find a template that I can modify to my needs. I have a touring performing arts company and want to be able to budget more confidently. Our expenses are highest if we just do a “run-out” (one gig) versus a multi-week tour. Some expenses are regardless of how many weeks we are away. We have ongoing expenses (like office space) that we incur whether we tour or not. I’d like to be able to plug in number of days of a tour to figure out my expenses so I know what our weekly nut should be if it’s a one week tour or a 9 week tour with a one week pause in the middle (we’d fly the cast home but put the equipment in storage). Being able to look at a variety of scenarios like that would be so amazing, but I can’t find any templates that seem like easy to modify bases. Might you have some suggestions? I’ve used Airtable for other uses that take advantage of calendar, social media scheduling possibilities, etc. M

Hello everyone, I am trying to use Airtable as a way to automate corporate communication on various social media. The Twitter integration seems to be working fine, but I don’t see anything that would allow me to post to LinkedIn, which is the most important social media I am using. I tried using #zapier “company update” function to create my posts, but I am encountering several issues that I can’t find solutions to. The @mention someone doesn’t do anything. I’m guessing nothing can be done here, similar to Twitter, but it’s worth mentioning. Now to the core part: I would like to attach a video to my file, just like when I post a video on LinkedIn by uploading it. I can’t seem to find how to do that, as the Zapier “preview - image” field doesn’t seem to support video files. Even if I give up posting videos and focus on images, all I can get is for them to appear as “previews”, as mentioned by the field name. This leads to the image being cropped and generally not aesthetic. Is t

Is it possible to save a webpage as a pdf? it doesn’t seem to be possible with the native web-clipper, any alternative solution?

Thanks in advance for the answers. I need your help, please. I work in HR and I have a Safer Recruitment table in Airtable and I have created the form to be sent to new recruits. It asks for a persons details, work history, and educational achievements. For the work history, once they have entered their latest job, it asks if the person needs to add another entry. (Company name, job title, your responsibilities, etc) Now without adding 20 fields for each entry if the person has had that many jobs, is there an easier way to do it. I know that 1 form populates the one row in the table but I am flummoxed how to obtain the multiple entries. Looking forward to your responses

Hi! Is it possible to change the background color of Gantt view? It is set at Gray and i need a brighter color to separate working days and weekends (Yellow would do fine) Thank you