Other Questions

I have a database for students DStu, a database for incidents report DInc, one for communcation with parents Dcom and a database for social emotional report DSoc The DStu is sync with the three other database so we can add incident or social emotional concerns/interventions connected to one students or multiple students. I would like to create one more database which will combine: The student Any incidents related to him/her Any social emotional concern/intervention related to him/her Any communication to parents related to him. How can I do this ?

I think I already know the answer (tables aren’t the same as spreadsheets so you can’t copy cells, only records), but wanted to post in the off chance someone can suggest a possible work around. Trying to copy a formulated date from one table to another so I can produce a gantt for each record in my base. Table 1 has records of each project with various fields containing start/stop/checkpoint dates Table 2 I was using as the base for my Gantt with only two fields (start date, end date) Currently I have to copy and paste but am hoping maybe there’s a scripting with a map loop solution out there? Example: Table 1 Record 1: Project 1 (Name) Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date) Field 3 (90-day assessment - formula off of start project date) Field 4 (end project - formula off of start project date) Record 2: Project 2 Name Field 1 (start project - date) Field 2 (check-in with employee - formula off of start project date

Not sure if this is possible, but will try to describe what I’m hoping to do. We get monthly sales reports from a variety of partners (Excel and CSVs), and each are different in terms of the number of columns and column headers, but there are a handful of columns that are consistent (productID, unitsSold, Sales) that I’d like to combine together into a single table. My first thought was to create a base with a table structured the same as each partner’s report, then a master table that pulls those three common columns and merges them into consolidated columns. I’d then simply paste the new monthly data into these each month and the master table would miraculously update with the new data! But, alas, I’m realizing that’s not how AirTable works. Is there a way to do what I’m trying to do? Or do I need to combine the data outside of AirTable each month first and THEN bring it in as a single, consolidated table? I hope that’s clear(-ish) — thanks in advance for the help. Scott

I have text file following formate Name URL is there anyway i can import that text file info in two column

I had 5.500 records in a main table and this morning they’re just gone. That simple. No filter ou sorting issue, just no record at all. I recovered the table from a snapshot, but all the linked table and fields were lost. I can’t find a way to understand what was the cause of this problem and it’s making my team concerned about how reliable Airtable is. Is there a way to understand what happended?

2 part related question How to create a meaningful SKU number… I am not sure how generally SKU numbers are created, is it random or is it shorthand code based on the description How to generate barcode ?

I have added a number of records to a database of about 500 records in total. When I sort the base, by any field, it sorts the records in two “batches”. Less than half of them from A-Z and then the rest again from A-Z. It makes it impossible to check for duplicates and completely baffles me. There was a previous tip about deleting hidden leading spaces. I have checked for this and this is not the case for me, also that would not affect sorting on every field. Any suggestions?

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?