Other Questions

Hi! I am trying to do what I believe is a simple and common task, but I can’t find a way to do it. Let’s say I have a table "Expenses" and another one "Income" I want to bring the data from the Expenses table and the Income table in the same "Page Designer" but obviously I don’t know the "height" of either table in advance as they change month by month. Is there a way to position one block below the other automatically? Thanks in advance!

Hi there, I’m new to the AirTable platform and community. We’re a digital agency and I’m looking to deploy AirTable as the central platform to manage all our client projects. I’ve set up a project tracker that is working nicely, but I would like to give our clients the option to receive automatic SMS and email alerts when their projects change status. I have integrated with the Twillo API but can only see a way to send SMS messages to a batch of clients manually. Is there any way to achieve what I need (ie create a series of Templates in Twillo and SendGrid which then automatically trigger to the client once certain rules are met. Ie. when a project changes status to ‘in development’, AirTable checks if the client has ticked the SMS and Email alert field, then finds the SMS and Email template for the ‘status change’ and sends it to them? Any help from the community on this would be amazing! All the best, Owen

So our student organization uses airtable to organize members and sponsors. I was wondering if there’s a way to quickly and easily send a massive email to the emails we have in a workspace. We have a lot of contacts and a small staff so we’re trying to find the most efficient way to send emails.

Hello, I use airtable for a recruitment activity. I already have a candidates database in airtable. I want to give the possibility to futures candidates to come on the database and be recorded in airtable. I already connected my typeform to the airtable (in a basic way, proposed by typeform). It works. When I fill the typeform, it creates a new line in the database on airtable, this is ok. But if the candidate already exist in the database, I would like to avoid the duplicates. I would like that airtable recognize that the candidate is already in the airtable database and not create a new line but update the existing information concerning this candidate. I was told that Zapier could solve this problem. I tried to do it through Zapier. I don’t know how to use the part “customize record”. Thank you for your help,

Hi Airtable! I have a bit of an unusual request. I have a base that has been set up to track duplicate records. I have the free plan and I probably won’t use the Pro Plan. I wondered if someone can make a video on how to setup linked fields and Rollup fields with formulas for this base. I have the base already setup, I just need a clear, instructional video on how to do this. I also have the original base setup too. It should not take very long. Thank you, Mary Kay

Hello, I am wondering if it is possible to embed a Shopify Buy button in Airtable cell

There is no KanBan view available in the iOS app, and the user is told to use the web browser to see this view. Unfortunately there is a persistent dialog on the web home page after you log in redirecting you to use the iOS app. Does any one know how to solve this? Thanks in advance

This question was asked by another user in February but was closed without an answer. It does not seem possible to move cards between stacks in the KanBan view on an iPhone or iPad at least. Surely this is a basic requirement of the KanBan view? Is there a tip or trick? Or is it something that the broad user base do not need? A reply would be appreciated even it is to confirm that the answer is “no”. Thanks in advance for any help.

Hi there, I would like to be able to post a link between records, in 2 different tables, that goes from A(Record X) -> B(Record Y,Record Z …) B(Record Y,Record Z …) -> A(Record X) To ease navigation, haven’t been able to figure out how to do it, Is there any query parameters I can use to filter the gallery? Both galleries have public sharing Thanks in advance

When I import the Airtable data as external collection in Adalo it skips some cells. I then have to add data into each cell and then import them back. Some times it works and sometime it doesn’t. It is very frustrating doing this back and forth. Does anyone has faced this issue and how do I resolve this.

How can I count the number of groups in a table?

Hi, Quick question. If I have a base, on a Pro account, and I want to invite 5-10 collaborators, that they don’t have a pro account, do I have to pay for them to collaborate? Cheers FJ

I have catalog data I want to publish with more than 1 record per page flowing page to page. Help! TY T.

Hello! I’m trying to start the 14 day Pro Trial but I can’t find out how to start it anywhere. When I signed up, I was automatically placed on the free version with no option to choose the trial. Upgrading only gives me the option of paying for a Pro subscription, but I would like to try it before committing. Is there a specific URL I need to visit, or do I need to make a new account that’s signing up for the trial specifically, or is there something else I’m missing? I checked the relevant FAQ entry but it had no information on this topic.

I have a table that tracks costs incurred at different dates and I’m trying to make a report with the script block that lets the user select a week number witch will then show only show the costs incurred in that week. I have formular field on my view that converts the date to a week number. I tried to filter a RecordQueryResult let weekSelector=[] for (let record of costQuery.records){ let week = record.getCellValueAsString(costWeekField) let personId = record.getCellValue(costStaffField)[0].id if(!weekSelector.some(obj => {obj.getCellValueAsString(costWeekField) === week})){ weekSelector.push(record) } } let weekSelect = await input.recordAsync('Choose a week', weekSelector) However that does not work, as the primary field does not show my costWeekField. I tried to make just an array of week numbers,

First and foremost, I absolutely love airtable. I’ve searched the forum for my answer so I’m looking for a pinch of clarity. I’ve got a “meal plan” with 6 separate meal groups (meal 1, 2, 3…) take “Meal 1” for example. 3 food items in meal 1 but the user can select different items from the attached “food list” if they’d like. I’ve got everything good to go except for the removal of certain editor permission in the food list table. Can I allow someone the editing rights but restrictions on the user: typing, adding records to the food list table, accidentally deleteting a record or toying with formula peramiters. Just simply selecting records in the food list table. One likely workaround is using notifications when a user/collaborator makes and edit. I’ll be using that notification regardless but would feel much more confident if I can avoid user/collaborator mishaps. Thx in advance for any input in this regard

Hi AirTable Folks - I’m making liberal use of the CSV Import function. However I just unfortunately over-wrote some data I did not intend to. After reading through the data, I realized my mistake. I tried using “undo” but AirTable is not undoing the import through the undo function. Is there some way to undo a block import into AirTable?

Is there a way to only let specific people see a table within a base? Thank You!

Here is what I am trying to do. Table 1 has two fields (date, # widgets) Table 2 has two fields (date, total widgets) Table 1 has 4 records. Here they are: 1/1/2020, 2 1/1/2020, 5 1/7/2020, 1 1/7/2020, 1 I want Table 2 to sum up all the widgets by date. So I would want Table 2 to show… 1/1/2020, 7 1/7/1010, 2 How can I do this? I would manually add the date in Table 2 and the Total Widgets field would automatically add up the # Widgets field from Table 1 based on the date. Is it possible to do this? If so… how? Thanks so much!

Hi does anyone here experiencing slow in airtable especially when you change your view? I just want to know the cause or if there’s anything need to upgrade

Hi there, I’m doing an IFTTT to Airtable integration, which creates recurring tasks. The only challenge I’m facing is adding the current date. IFTTT passes a date as “August 08, 2020 at 09:31PM” which Airtable can’t use. So I’m looking for other solutions. One possible solution is using Automation and Scripting. Any new record created in view runs a script that adds the current date to my “Date” column. Can anyone help me with this script? Or suggest another way of adding the current date, without changing the Date field into a formula field - since I input most dates manually. Cheers, Subir

Using SendGrid, is there a way to have a Good {morning, afternoon, evening} tag based on the time the record is created? Or will this require more hidden fields to accomplish?

When I select creation time it will show both the date and time. I only want to show the time portion. How would I do this?

I am the only user on my AirTable account. I utilize a large storage plan on Dropbox. Is it possible to link the Attachments from AirTable directly into this Dropbox as opposed to having to purchase an additional storage plan at double the subscription cost from AirTable?

Basically what is said above. I have a huge database already in Airtable and recently received a massive spreadsheet. In the spreadsheet there are linked documents and I was hoping to upload the whole thing, including attached documents, into Airtable. Does anyone know of an easy way to do this?