Other Questions

Hi everyone, I am trying to sync airtable rest api with snaplogic but the tables in the airtable are not passing as required. can anyone help me with the query parameters used in rest api https://api.airtable.com/v0/baseId=apqwyehayywkzjerAnv/tables=demoocontacts ?api_key=keyxxxxxxxxxxxxxxx Is baseid , tables, api_key are the exact parameters? Does anyone know how to get data in airtable to snaplogic through the api?

I have an Airtable lookup field. In my test scenario it works correctly. I’m able to get it as an array and use it in module settings. I’ve cloned this scenario and in the new scenario it shows up as a text. Any idea?

I’m making a database of shared lessons. Each contributor will help with many lessons. Each lesson might have many contributors. Lessons have topics, description, age range, format, uploads. Volunteers have name, bio, and private contact info. I currently have a Public and Private view for Volunteers. How do I let the public (not signed in) looking at a Lesson easily go to the public view of the Volunteer, and vice versa? I can do it when signed in as owner, but I want the public to do it as well. I’m willing to create a guest account if that will work. Does this require a paid plan? Our budget is small, but we can probably afford the cheapest paid plan.

I have a base in Airtable where we create products for our Amazon account but there are hundreds of records to sift through. Each product has its own unique SKU that matches the Amazon product listing. I want to be able to download a report from Amazon showing all the products that are not selling and be able to take that list of products, compare/filter them to the products in Airtable and update the status of the product record. Is there a way to do this in bulk?

At the office where i work, we use airtable for almost everything. However, the current notifications when being mentioned in a record are terrible. Is there a way i can make airtable audibly notify users when they’re mentioned in a record or someone comments on them? I asked airtable directly but they said i could use mobile notifications which doesn’t make a sound on the computer and they also mentioned turning on the chime block. Which, doesn’t have that feature, only when new records are added. Can someone help me find a way around this? Recap, I want my computer to make a loud sound when i’m mentioned in a record.

I’ve got a table of collaborators. I’ve got a table of projects. And I’ve got a table of documents. Each document is linked to a project and a collaborator. I need to know how many documents are assigned to each collaborator, broken down by project. So Collaborator 1 has 2 documents for Project A and 1 document for Project B, Collaborator 2 has 1 document for Project A and 3 documents for Project B, etc. I’m trying to figure out how to do that. Any suggestions?

Dear community, I am new to airtable and would like your assistance on best practice on how to consume a json file and use linked relations within the airtables. i have a json file with structure like this: [ { "title":"first title", "publicationDate":"2021-02-02", "geo":[ { "country":"US", "lat":45, "lon":55 }, { "country":"UK", "lat":65, "lon":55 } ] }, { "title":"sec title", "publicationDate":"2021-02-02", "geo":[ { "country":"BR", "lat":4, "lon":5 }, { "country":"UK", "lat":65, "lon":55 } ] } ] Ideally I would like to have two tables: Pub and Geo. When inserting the above resu

Hi I have two fields that I am trying to use an IF AND statement on One is a date field {Rollout Date} and one is a checkbox {BU Code Updated} I want to write a statement that returns an “error” message when the date is before today’s date and the checkbox is {BU Code Updated} checkbox is unchecked - nothing needs to be returned if the date is after today and the checkbox is unchecked

Hi, I am Pro table premium with the annual plan. I would like to onboard one team to help me with my Airtable database data, but I don’t want to pay another annually; I would love to spend the other account as monthly due for only contract base. Now my question, If adding one collaboration, does that mean that I have to pay him annually as well? Or I do not understand the plan instruction yet. What would be the best solution in my case? I hope someone can explain to me. Thank you

We have set up several calendars for various streams. Now we would like to create a new ‘mothership calendar’ to be able to view all the events in the individual calendars in one place. Is there a way to do this without having to link to each event?

Here is an interesting integration I found. I use the Clipto app for some time although I am disappointed it takes them for about 2 years now to create an app for iOS. I thought the project is going to be abandoned but then suddenly they got this on offer now - a Zapier integration. https://clipto.pro/#/zapier So in this scenario you copy the text on Android device (copy menu) or computer and by doing so it would trigger a Zapier workflow, which could of course mean updating Airtable for instance. I could imagine creating a workflow that would enable me to fill in the Airtable directly by copying text while browsing a web page or looking at any document on a mobile device or computer. It could be I copy first the name, then the phone number, then email, maybe address etc… and the Zapier workflow could fill in Airtable for me. So I just wanted to share… I can’t tell you how it works though because I don’t have a paid premium Zapier account. Paid Zapier account is likely needed to get

I can create a chart app or a pivot table app but I would like to create a chart from a pivot table view. Does not necessarily have to be an ‘app’.

Hi, Almost everything is in the title :). Is it possible to display data from different table in a same chart when there is no link between these tables ? Thanks, Yann

So I have a list of companies and their products. In order to let users add companies and products, I have to have a record for each. Example: Is it possible, in card view, to show only one card per company, but have all that companies products on that card? As opposed to one card for each record? (Having 10 Company A cards with one product on each card). I need random people with the link to be able to add companies and products and the above grid view is the only way I can figure out how to do it with a form. So that it goes from this: To something like this:

Hi, is there a way to add a customized sort to a view? I have 2 fields, start date & end date. Id like to sort by start date if the current date is <= start date, otherwise end date should be used. Is this possible with Airtable? Thanks.

Airtable team, I’m a novice user and have benefitted GREATLY from Airtable. I am currently the only Airtable user in the company and I use it for planning tasks for production in a manufacturing facility. Nobody else sees this calendar, yet. I have reached a point that I need to be able to put the Airtable Calendar View up on display on our factory floor on a 50" 4K monitor, for the rest of the team to view. Especially for when I’m on vacation or otherwise not at the facility. However, it’s imperative that this is a “View/Search Only” access. I don’t want anyone accidentally moving anything, or having access to AirTable using my login credentials. I definitely want them to be able to scroll through the upcoming weeks, and perform searches for various criteria. I just need to be sure that there cannot be any edits made to any of the calendar entries, and no new entries added. How can I do this?

Since 3 weeks we try to connect to typeform tools & the platform is very slow or even not accessible at all. Anybody knows sth about this? Thanks

Is it possible to embed an html code block to the Page Designer? I can’t find a thread about this. Thank you!

If I remember correctly, there’s Chart Apps that show something like heat map instead of regular x y charts. I think I saw it in Github? But can’t find it anymore. Does anyone remember / know? Thanks Daniel

Good morning everyone, I have a question for managing multiple projects. if I set up my space by dividing the tabs by: Projects-Task-Managers-and counting hours, when a project ends, can I “freeze” it and not view it anymore? working with many projects that last one or two months I need to keep track of all my projects but I don’t want to delete the records every time a project ends. I just want to “freeze it”. Thanks in advance for your answers

Is it possible to get people to sign agreements using Airtable?

I have a lookup field giving me three different states: “act”, “belong” and “commit” How can I count how many times “act” is in this lookup field? If I use COUNTALL, I just get the total sum of states in this field. How can I just count just “act”? Regards, Tor Martin

I’m importing data from a CSV with a nested appearance like this: Food Group Food Fruit bananas apples oranges Veg kale squash Cauliflower I need to flatten the nesting to look like this: Food Group Food Fruit bananas Fruit apples Fruit oranges Veg kale Veg squash Veg Cauliflower Presently I’m using a complicated formula in Google Sheets before importing. Can this be done in Airtable instead? Thanks very much

Hi, Has anyone successfully used the ‘flatten’ transformation described here: Vega-Lite Flatten Vega-Lite - a high-level grammar for statistical graphics. Vega-Lite provides a higher-level grammar for visual analysis, comparable to ggplot or Tableau, that generates complete Vega specifications. Vega-Lite specifications consist of simple... to transform array data that’s in an Airtable field? I’m trying to transform some data without having to specify the field names ahead of time, so I’m wondering if I can somehow represent it as an array. This is a bit of a kludge, because there isn’t an ‘array’ datatype in Airtable (AFAIK). I suspect I might have to manually specify the format somehow, because just putting it in a text field like this: [1,2,3] doesn’t seem to produce the results you might expect.

Hello everyone! Right now I need to create a CRM system for an organization I work with. The point is that each project has several statuses (e.g. order received, pending order, editing etc.). The part I stucked at is that each part has two dates linked to it - planned date of delivery and actual date of delivery (to control the timing of each stage). Could you please advise how to provide the most optimal solution in Airtable, thanks!