Other Questions

Hi! I’m trying to make an automation that will notify me when an entered record shares a field with other entries within a certain time. Essentially, we track issue tags and want to know if there have been 3 issue tags in the same state within a two week period (the state and receipt date are tracked as fields on the issue tag). My thought is to make a formula that counts how many entries within the past two weeks share a state with the given entry, and make that the condition for the automation. My question is, what formula (or group of formulas) would I use to look at other entries? I can’t seem to find formulas that look anywhere except inside entry that the formula outputs on. If I can’t do it with formulas, is there an app that will help me? Thanks

Hello, I am trying to connect Qonto (a bank) to Airtable. I made a first import from my Qonto external database to Airtable by mapping the columns with Integromat, and no problem. It has information like the VAT rate which is only updated later in Qonto database (the bank) So I would just like to map the two columns and update the data, but I can only find the option to map a cell (a record). I can’t find a way to update an entire column. Thank you for your help ! Quentin

In order to use Airtable Sync, do I have to Do I have to turn on the external publication of Share View Link in order to use Airtable Sync? I’d like to sync another BASE with Airtable Sync. In the case of AIrtable to Airtable, I need to create a Share View Link on one of them. If I set Access restricted to to a specific domain (@test.com) in Share View Link, it does not work with Airtable Sync. Can I somehow share the Airtable BASE without external users having access to it?

Hi community! Our team sometimes use non-eng text. (mainly Japanese lang) but using non-eng lang,does’t work line break on comment function. (Please see the attached movie) Here’s the status. ・eng "Shift+Enter"→line break work "Enter"→sent comment ・non-eng "Shift+Enter"→sent comment "Enter"→sent comment please let me know good info. thanks.

Using the Jira Cloud Sync, can airtable import “Order by Rank”? It doesn’t seem to work. Any other ideas on how to do this?

Hi! So I know there is an app to show how each field is connected. Where it will show if a field in one table is linked to a field in another table via a lookup or formula, ect. My database has a LOT of fields and tables, so I’m trying to consolidate some of the info and am digging into how everything is connected before deleting anything. My question is - is there anyway to see how the fields are currently being utilized in views for filters and groups, before deleting a field? I hope that makes sense! Thanks!!

Hi Airtable community, I am new to Airtable and looking to create an easy (not overwhelming) way to present all of the Tables/Tabs that need to be filled out by our clients. Currently, we have a number of Tables which creates many Tabs that have to be scrolled horizontally at the top. This is not ideal, as there isn’t a way to see all Table names at once. I am thinking of creating an Executive Summary Table which becomes the 1st tab in the list that has a Vertical list of Table/Tab names linking to the Tables/Tabs that way. However, I need help in creating these links. What do you suggest? Is there an easy way (automated) to create this Executive Summary? If not, how can I link to the Tables/Tabs themselves? Are there anchor links I can use? Thank you in advance!

I have some views where I have a lot of different single select fields that’ll automatically add certain values on record creation (by setting filters on those fields). I thought I’ll clean up the views and wrap them all in the new condition groups, however now the filters no longer add values into my fields. Is it me who does not understand the conditions groups? or is it a bug?

Hello everyone ! Let’s see if someone can help me :slightly_smiling_face: As you will see in the image attached, I have a bit of a complicated setup for one of my clients. It’s a distribution company for television programs. Programs are produced using content from different partners. Each partner has a specific share of the pie for every program sold (that’s handled !) When the company sells to a client, a contract is drawn and it has n programs sold (handled !) Each contract can have n installments and therefore n payments (handled) Partners having some shares in the programs are only paid when my client gets paid. I have the repartition between the different partners on a percentage basis (i.e. partner A, on this program, gets X% of what we sold it for, partner B will get Y%, etc…). What I now need to do is, for EACH payment made, create a sort of junction table between the partners (one record per partner for that par

I want to import a template made by another user. It was created in Airtable. The user says another person successfully imported it several months ago, but she cannot remember how to do it herself. I don’t have access to the other user. Can someone help with this? Thanks in advance

Hello I am slightly confused on locking views. I would like to have a Gallery View filtered to show only certain records. The name of the gallery view will be the same as the records the filter is set to display. I would then create 6 more gallery views to show the other records (with the filter preset accordingly for each view) I see I can lock the view so that only I can edit it - but for some reason, that doesn’t seem to be affected when sharing a view via a link (without the user needing to log into Airtable - which is important). So when you look at the view via the link, you can click filter and change the criteria of the filter (which would mess things up). Or am I missing something? Thanks in advance, Andrew

How can I add percentages to the dashboards on airtable? For example if I have two elements giving certain values, and I want to get a percentage between Element A and B and put that percentage in its own box?

Hi everyone I have a base for student enrollment to courses, but sometimes they sign for a second, or more courses so, in some cases i have duplicate entries regarding country, name, mail etc. I want to build a new table to filter just unique values to show statics on a dashboard or interface. How would you suggest to work this? Please, anything would help. Im thinking in lookup fields or synced tables… :thinking: Thanks, Rodrigo

Hi, I have created a Gantt View to represent a schedule of Audits. Currently completing one Audit per month. Despite my newness on Airtable I seem to have something that looks like a planner, and what i would like to do next is create some information for managers to quickly appreciate the planner, e.g. a dashboard or App. #1 So in my picture you see I have a Today Line, and you can see the next Audit is in Jan22 Management Systems Manual, so is it possible to have some Dashboard style indicators, e.g. Next Audit “24” days Audit “Management Systems Manual” #2 Further to this what would also be nice is if I click on the coloured box on the Schedule and I cou

I am interested in the ability to provide access to editing certain columns and selections (for example, add only a certain type of data, by filter). The most correct decision is to give access to the view, but the local editing of the view is impossible, judging by everyone so far, although this issue was actively discussed a year ago, perhaps there are alternative ways (entering data through the forms will not work, it is necessary for a person to be able to work with sampling in a tabular form)

Perhaps I am missing something, but I am trying to use the “notifications” list as a kind of inbox to go through all comments that are directed at me. The notifications dropdown (attached) is problematic in several ways for this: Multiple comments on the same item result in multiple notifications. I can’t mark notifications as “read” in bulk. The notifications don’t disappear from the list after they’ve been read. Is there some setting or command I’m missing? Is there a better way of managing notifications? Is there a better way of doing what I’m trying to do?

Hi, I have a fairly large database and I was able to build an app based on it. My app is getting attraction thankfully but I have an issue that, if persists, might turn the app useless! The database is in Arabic and performing search in Arabic in Airtable is not the best. sometimes it works and shows results and sometimes it tells you no results found even though I know for sure that the keyword I searched for is there. I’m not talking about the search block which doesn’t support arabic but basic search using the search icon in the base. I was a bit ok with this in the beginning when all my work was in Airtable but the fact that this limitation (bug?) extends to the Airtable API is frustrating. Now this issue exists even if you want to use, say, Softr (Which I’m using.) Is there any workaround here? I don’t want my app to turn obselete because of such an issue. UPDATE: After posting this, I performed a certain search and fou

Howdy, I’d like to have two columns: A. Features Used by Customer B. Features Not Used by Customer Both columns currently have the same multi-select answers in them. When I add features to column A, I end up manually selecting all the other features to show up in column B (“not used”). I’d like column B to automatically display any features that weren’t selected in column A. This was posted a couple of other times, but I couldn’t find an answer: Display multi-select items not selected and Show un-selected options from multiple select field in a separate field Can anyone help? Much thanks!

Hi Everyone, We are current pro plan customers with a base of ~10K records. This data needs to be reviewed and enriched by a contracting firm that we are hired to do some work for us. They are (independently) also pro-plan customers of Airtable. I wanted to share this base with them by e-mail, but I don’t want to pay the monthly fee per user (there will be ~15 new users if that’s the case) since they are already pro-plan customers (and we could just as easily “send” the base over for them to do their work). Is this a supported use case within Airtable? Pranav

Use-case: As an airtable user/developer, I would like to invoke one custom script from multiple buttons within the same table and my custom script’s logic determines next steps to execute from the invoking button’s identifier. Does Airtable’s API (or workaround) currently support this functionality? I’d like to avoid creating multiple scripts for the same action and I’m not “there yet” as far as creating more robust custom apps. I attempted googling various phrasings of this question as well as referencing the Airtable help docs (and API docs) related to the custom button feature but could not find anything for certain so I thought I’d ask here!

Base Temporarily unavailable. I’m on Pro Plan. How can this be fixed?

“This base is temporarily unavailable. We apologise for the inconvenience.” this is the error message received on a Pro plan workspace

Hey, What I’m trying to do is expire a record after 24 hrs. I have created a view and filtered it by “start date is after 1 day ago”. It works but I don’t know if it’s 24hrs or 1 day ago based on the date? If the latter, a record may not be live for 24 hrs. Does that make sense? So my question is: How many hours is in an Airtable day? Or, should I try to achieve this another way? Cheers

Anyone else having trouble uploading to attachment columns right now? Sometimes it’s fine, but most of the time I can’t use my automation to email them, or the attachments are just deleting themselves.

Hello all, I want to display my Event Start Time and Event End Time as ISO 8601 format. I need it in this format so that when I export the csv and import into Adalo (no code app builder) that it will accept the time and date format correctly. The “Local Start Time” field is the airtable user’s local time. They input the time there, then select the Event time zone. The “Event Time Zone” field has a formula to show the correct time in that time zone. I want to also create a column to show the “Event Time Zone” in ISO 8601 format and with the correct UTC offset. I need this because I need to export this airtable and import it into Adalo as a csv. I saw a user “Kuovonne” do something similar, but I can’t figure out the formula to get the correct format and utc offset. This is the output that Kuovonne showed that I am looking for.