Other Questions

Hello everyone, I’m fairly new to Airtable, and I’m unsure how to accomplish the query(ies) I’m performing in a simpler manner using Airtable commands. The Base I have an API with two tables: Classes and Students. The Classes table consists of classes and all the students enrolled in each class. The Students table consists of students and all the classes each student is enrolled in. The Task A user searches for a specific student on the front end. Using Airtable formulae, I need to query the Students table for the classes that student is taking. (NOTE: I need to return the class names, not the record IDs/codes for those classes, which are unintelligible for the user.) Using those class names, I then need to ask the Classes table for the students associated with each class, again returning the students’ actual names, not their record IDs/codes. Finally, I need to return the original student’s classes to the front end, alo

Hi dear folks, I’m trying to build the unique ID for all the items that in our company, I’m thinking about how this request will be working through airtable, for instance, is there any way that I can build the ID like XXYYY001–XXYYY999, or anything like UUID? Actually, I’m learning how to build the database, so any suggestion help, I want to learn how you will plan the data on the inventory. thanks.

Hi- I have a free account but my boss is going to start paying for my account. Is there a way for her to be on my account and pay without me losing all the data on my bases? Thanks

Trying to count meeting dates that have passed, but it keeps counting empty cells. Can someone help or offer a better solution? IF({Meeting Date} <= TODAY(), “Yes”

MY SITUATION I have a base containing several tables: ‘Translations’: Using DeepL API this 10 row table converts the record contents under 3 distinct fields ‘header’, ‘subheader’ & ‘cta’ into 10 languages ‘Banner Orientation 1’: Has fields ‘lang’, ‘target-header’, ‘target-subheader’ & ‘cta’ etc) & 1000 rows Table ‘Banner Orientation 1’ has: 100 rows where the field ‘lang’ records hold the 2-letter code for the 1st language 100 rows where the field ‘lang’ records hold the 2-letter code for the 2nd language etc… THE PROBLEM All 100 rows for the 1st language contain the same record value for each of the 3 fields mentioned above (and the other 9 sets of 100 rows each share the same 3 translated phrases). So… table ‘Translations’ only has to do 3x10=30 translations ONE TIME. The alternative to these 30 API calls? If I translate each row record separately I get 3

I’d like to set up logic/automation so that when we win a deal and moved it into “won” category in our pipeline - that a new record is generated in our production table so that we can start planning for the project. Any ideas on how to do this?

My company, which has an enterprise plan, has a base, and tables for individual departments. Every day, my department will add one hundred records with attachments. When unfiltered, the table is very populated. The mobile app takes forever to load the table (view filtered to each day) and crashes every time a record is added or was updated. Could an admin repair the issue?

If I add records in iphone maually, I have to add one then quit and add another one. Can I add a new record directly in the record that I edited?

I have a database of names and DoBs. When someone turns a particular age, I’d like an activity to be created in our CRM. My table has a column called “is 55th birthday today?” When that’s = yes, how do I create a view such that “new record in view” will trigger my Zap?

Not sure if this is the best place to put this request, feel free to move elsewhere if there’s a better fit. I am looking at ways to use Airtable as a scheduler for transportation routes. I have a rough idea of how it would work but do not know how to use the views and data to make this happen in a way that would benefit my operation. Here are some of the things I am looking for: 1] Calendar or Gantt view by day: Since we would be assigning trips on a daily basis, I’d like to be able to use the calendar or gantt view to adjust on a day by day basis, using times of the day 2] Assign trips to drivers: I could have a separate table that contains all of our drivers, and then use drag and drop to assign routes to those drivers 3] Keep trip times set: Trip times would be set fields, as in if a trip is from 10am until 11am, it couldn’t be changed to a 1-2pm trip via drag and drop or anything else Ultimately I am looking at this drag and drop interface to assign

Hi, We are a non-profit that provides support to tenants facing eviction. We recently moved our hotline intake and database to airtable. We have created the base, and volunteers fill out an intake form when a tenant calls us facing eviction. Since we switched over this week, none of our form submissions are creating new records. We have tested the form link (both incognito and not incognito on Firefox and Safari) and records are created. However, hotline volunteers’ form submissions aren’t coming through (across 5 different volunteers). We’re also looking at the full spreadsheet and are not hiding any fields or doing any sorting. We’re worried that this might be due to the time a volunteer opens a form and when they submit. Usually, callers will speak with us for 20-30 minutes. We are diligently filling out the form and collecting information while we listen to their crisis. So from the time someone opens the form and then completes it might range from 10 minute

I want to sync certain fields in tables in the same base instead of setting up linked records. It would be much easier if this was possible. Does anyone know if it’s possible?

airtable = Airtable(AIRTABLE_BASE_ID, AIRTABLE_TABLE_NAME, AIRTABLE_API_KEY) api_endpoint = ‘xxx’ json_data = requests.get(api_endpoint).json() cryptodata = json_data[‘data’] records = airtable.get_all(maxRecords=1000) for r in records: for currency in cryptodata: if (r[‘fields’][‘name’] == currency[‘name’]): #print(r[‘fields’][‘name’]) records = airtable.update_by_field(‘name’, currency[‘name’], {‘price’: currency[‘metrics’][‘market_data’][‘price_usd’]}) Hello, I’m a newbie to Python. When the API transmits data to Airtable, the preceding code is meant to update the data in Airtable. Question: How can it only UPDATE if a name already exists? If there is no existing name, how can it ADD ONLY? This is the code I use to see if any are already in use: for r in records: for currency in cryptodata: if (r[‘fields’][‘name’] == currency[‘name’])

When I try to open Airtable on my iMac, running MacOS High Sierra 10.13.6, it opens as a completely blank window. No information is displayed, When I first installed it, it ran fine. I am using the latest version of Airtable for the Mac, 1.4.5. Any ideas why this might be happening? Airtable runs fine on my iPhone and Surface Pro. And two of my friends running Macs use Airtable with no problems. Thanks for any advice. Carl

I am looking for a way to convert a table (ideally, automatable on field update) in this format: Project ID Impacted Team(s) 101 1, 2, 3 102 2 103 1, 3 to this format: Project ID Impacted Team 101 1 101 2 101 3 102 2 103 1 103 3 so that I can filter on multi-select fields (comma delimited values) in BI tools such as Tableau. I’ve seen this format referred to as a “join lookup” table in a previously used application. Tableau Desktop alone cannot do this via split & pivot as pivoting on cal

Hi, It would be really nice if I could have a 3rd field shown at the intersection of these two others. For instance, the countertop in the powder room is called “Topus Concrete”. Instead of a number, I would like if that name could be displayed instead of the quantity. I know you can click on the numbers to see all the records that it’s referencing, but in terms of printing this out and having it handy, the name would be far more useful. Any options for this?

What’s going on with quality control at Airtable this week? First the table picker and now this: C’mon people. Do some testing before you push to prod.

Hey all, we’re using https://syncinc.so/ to access Airtable from retool, where we use SQL to work with Airtable tables. We have two table connected by a Link field and we need to set the Link field via SQL. Normally it’d be something using foreign key, but I’m not sure how to achieve it here. The SQL code would be this: UPDATE table1 SET link_field_to_t2 = ( select array[t2.id] from table2 t2 where t2.email = 'email@email.com' ) where id = '<some_ID>' When I try to run this, I get: permission denied for table table1 Is it possible to achieve what I’m trying to achieve?

Hello all, After 10 days off work, the team have returned today to an issue. When a clients record moves to “New Appointment” view, it triggers 2 zaps with zapier. One sends a text with details of the appointment and the other sends a confirmation email to client. Both zaps use fields from airtable in the body of the text. Today, this has simply stopped pulling the airtable fields into the body of text. So both text and email are triggered, but neither contain the data from airtable. I have just identified that either Zapier or Airtable have changed something. For example, a field that was originally “First Name” is now showing as “Fields First Name”, “Telephone Number” is now “Fields Telephone Number”. This is how it is showing in the zapier “Set up Action” step when sending an email in outlook. I am going through and changing the fields on this zap and many others that also appear affected which is time consuming and frustrating! I expect

That’s it, simple as that. There’s currently a ‘Quarter’ and a ‘Year’ view and I’m currently working out a schedule that’ll take somewhere just between there! A ‘Half year’ view would be really handy. (Or an arbitrary zoom would be even better.)

Hi There, I’m struggling to figure out a formula (if there is a suitable one available), and wondering if anyone can help. I have a spreadsheet to track subscriptions and when the next orders are due to go out - these are done at regular intervals; either 4-weekly, 6-weekly, 8-weekly or 3-monthly. Rather than having to update the next due date of the subscription for each order I would love to have a formula that can automatically update the next due date based on the start date e.g. if the order started on 01/07/21 on a 3-monthly subscription, then it would be able to update the next due date to 01/10/21. I would then like it to continue updating automatically, so when we get to 01/10/21 it would automatically update to 01/01/21. Is this possible? Or anything similar that doesn’t require it to be a completely manual process. Ideally I would like it to be dependent on the subscription frequency e.g. 4-weekly or 3-monthly from another column, however if this is not possible, I

Hi, I have a table with sub-categories where I want to be able to choose, from a multiple-select list, the lowest level and auto populate the higher level, e.g. if I choose “Banana” I want the higher level to automatically become “Fruit”. I have managed to do this with an IF-statement, but my solution doesn’t give such a user-fiendly filtering option. The IF-statement I have created returns the statement as a string, so when I want to filter the category I manually have to write in “Fruit”. I would instead like to filter it by selecting “Fruit” from a list (as you can do with for instance a multiple-select list). Is it possible to do this when autopopulating a field? Thank you in advance!

Is it possible to have an audit/history view of just one data field, but across all records? Want to keep close control of changes to one field in all tables in a base. Thanks!

Hello everyone! I am trying to create a simple rollup field that counts the number of check boxes from a linked table for attendance purposes. I create the rollup field like this: You can see that Abdelnasir and Aamir both have at least one check mark for attendance: However nothing changes and the rollup field shows zero: I’ve literally done this exact same thing before and it worked fine, but now I cannot figure why this time it is not working. Any ideas? (Note: I’ve also tried this with the Count field to no avail) Thanks! Justin

Tell me it ain’t so… When I’m searching on Airtable homescreen, it will only show results from a Base’s text, which is so limiting. How can I do a global search of content text? Or does it not yet exist?