Other Questions

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?

Hey there. This isn’t really a ‘views’ question but there doesn’t seem to be a category for ‘just Airtable itself’ so it’s the best I could find. Until very recently, pressing Cmd + J to switch tables showed a list of my tables in that view. I could arrow-key up and down to select, and I think even re-order from that view. Now this brings up a search box with No matching tables until I start to search. This is vastly less useful. Was this an update, or is it a bug? Please change it back.

I’m having problems with the pre-created script app to convert URLs to attachments. It worked great this morning, but I went to run it again and the entire script has been stripped to the “Hello World” state. I’ve been trying to re-add it for hours now and if I’m lucky it just leaves me with the infinite spinning loop. If I’m SOL I get the “This page is not responding” popup. I’m used to the latter, as one of the other app blocks does this, but with enough “wait” clicks and patience I can usually get the block to start working (it’s the app to link records, if anyone is curious.) My computer is up to date (I just checked) and I use Edge on a Windows desktop. I also use another computer which is having the same experience. Same set up. Does anyone have any recommendations? Thanks.

Hi there, I have an issue where clients of mine using a form are using the date field to add a time in the past, which errors one of my workflows. Is there a way to only allow them to put future times in? Maybe an error check?

If many devices , like in hundreds fetch Airtable sheet data simultaneously, will there be an error, Or can Airtable handle this.?

Creating a Filtered and Grouped View within a Table Grid View is easy enough - however I’m now stuck with having this fairly simple/straight forward billing summary data stuck in my view - and I have no idea how I can easily/automatically get this summary view of data stamped into a monthly invoice at the end of each month. The below image shows two fairly simple fields, a customer name lookup and a summary of time spent with them per month, in this case just the past months work. But I’ve been unsuccessful in figuring out how to get this summary data out of Airtable and into the hands of those who pay the bills. This wasn’t a big issue when starting out initially, with my time split between only one or two customers. I used Page Designer for capturing the info initially. But the more customers I add to the list per month, the more of a headache this becom

Hi! I’m trying to get file contents from Dropbox, a reverse operation to the one in this topic: Export Rich Text Field as Markdown - kindly described by Bill French, a way to upload csv data from Airtable scripting app to a Dropbox file I’m using download api method HTTP - Developers - Dropbox > let dropboxEndpoint1 = "https://content.dropboxapi.com/2/files/download" > let dropBoxApiArg = { "path": "/" + currFilename } > let postOptions1 = { > method: "POST", > headers: { > "Authorization" : "Bearer " + appToken, > "Dropbox-API-Arg": JSON.stringify(dropBoxApiArg), > } > } > const postResults1 = await remoteFetchAsync(dropboxEndpoi

How to keep track of when was the last time I called this ph number and how many times before I have clicked the call button in the airtable view ?

Hello I am looking for feedback around how the Google Map integration works with Airtable. My goal is to type an address in Airtable, automatically populate the Google Map block in Airtable, then automatically populate a public Google Map embedded on a website. Is this functionality possible?

I have what seems like a very basic and common need for the Page Designer block, but it doesn’t seem possible without some kluge-y workarounds. I just want to confirm my understanding and see how others are addressing this issue. As we all know, from any given view of a table, it’s possible to print that view with all its unique sorting, filtering, column display, and other attributes. This is a quick and easy way to get your sliced-and-diced table into hard copy or PDF for sharing with others, but it has limited formatting capabilities. Helpfully, however, the little print dialog in Airtable tells us we should consider the Page Designer block to create “completely custom print layouts.” This sounds promising, and I have the Pro plan, so let’s go check that out. When I go over to the Page Designer block, I see that I can set up some very nice record-centric views using not only the data from the table I was in, but even other tables linked to the primary table. Th

Hi Im New to Airtable, trying to see if this can work for keeping my christmas light business clients organized and make estimates. The client organization is done and working great. What im trying to do now is replicate my estimate excel form I have been using for the longest time. I “Can” make it where all these fields scroll horizontally across the grid view however that is just too much to be able to use it well for imputing the information. If there a way to customize my view for the record that is more graphical where I can lay it out more like this? I have looked at the form view but that won’t do it. I have a lot of experience using file maker pro and that’s mostly graphical view interface, looking to be able to make something like that here. Any help is welcome thanks!

My company email domain was changed and now I can’t log in. I only used google SSO before and now I can’t access my account to change the address to update it so that it works with the new company email. Can someone from AirTable please help? Thank you.