Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,685 Replies
10000 Topics
J
Jason_CohenNew Participant
posted in Other Questions
How do I require a user to choose an option from the single select drop-down menu instead of manually typing in a record?

I have set up several “Single Select” field types, but editors still keep bypassing this by manually typing in data, many with typos and spelling errors, and its driving me crazy! Is there a way to force them to select one of the options I made available (like excel does) ? Thanks

253
J
A
Achim_BaurInspiring
posted in Other Questions
Lookup with conditional option?

I would like to lookup entries from another table. But ONLY if they have a certain value in a special field. Is this possible? Example: Table 1: Matchdays Table 2: Players In Table 2 players can either be “available” or “not available”. In Table 1 I want to ONLY list the names of the players that are available. Not ALL players that are linked to that matchday.

114
kuovonne
V
Vernon_FowlerKnown Participant
posted in Other Questions
Twitter profile clipper

Twitter’s web app was refactored and I’ve re-jigged my web clipper as best I can. This web clipper will take a Twitter user’s profile information into a table with fields for: Name Profile from page URL - to be trimmed Avatar Bio from selected text The refactored mark-up in Twitter web app means this clip action needs a little extra work. The steps I follow: go to someone’s Twitter profile eg https://twitter.com/khoi select the text on their bio click their avatar to enlarge it (this exposes a CSS selector for clipping the image, and appends /photo to the URL eg https://twitter.com/khoi/photo) activate Airtable web clipper action trim off the /photo from the page URL tidy up any undesirable new lines in the Bio text produced by @mentions or #tags Here’s the clip action recipe for Twitter profiles: { "schemaVersion": 3, "fieldMappings": [ { "fieldName": "Name", "fieldType": "singleLineText", "defaultValue": { "type

3617
E
U
user17New Participant
posted in Other Questions
When can I use interfaces features in mobile app?

when can I use interfaces features in mobile app?

61
Justin_Barrett
D
David_DunfordNew Participant
posted in Other Questions
Creating a view for client attendance count per month

Hi everyone, I am new to airtable and trying to create a view that will give me a ‘count’ of how many times a client attended a session in the month. I have linked the ‘client’ table and select all the clients that attended for each session. As can be seen, I have also added an ‘attendance months’ field so I can group by month. I am having trouble trying to structure one of the tables to provide the count for each client for the given month. Any help is appreciated, thanks.

31
Justin_Barrett
M
Max_FeesNew Participant
posted in Other Questions
Generate and Export contacts into VCF

Does anyone know how to export VCF files (contact cards) from an app in Airtable? I have seen previous posts but they are closed :confused:

80
M
S
Stavro_VictorNew Participant
posted in Other Questions
Time tracking per row and per month

Hi! I work at an Ad Agency and we use Airtable as a project management tool between all of our clients and creators. We specifically track each concept we are working on in a single row. We charge clients against a monthly hourly allotment of 30 hours per month. We are looking for an easier/ better way to track monthly hours per project per client. Some projects hop month to month and a designer may spend 5 hours in January and 6 hours in February. We need a way to track these hours in each month for each concept. Currently, we have 12 columns, one for each month of the year, for the designer to put the hours used per month per project. Some projects only last 1-3 months so it is kind of redundant to have so many collums. Ideally, I want one column that can allow a designer to input their total hours per month as needed vs 12 different collums

171
Hannah_Wiginton
J
Jamie_KellyNew Participant
posted in Other Questions
Uniform Ordering – Configuring Conditional Form Fields appearance with Lookup Items

Hi everyone, Basically, I’m putting together online forms for staff uniform orders for my organisation, a heritage organisation which manages over 80 visitor sites across the country. We have two broad categories of uniform sites – Formal and Casual. Formal is shirts, smart trousers, waistcoats etc — Casual is polo shirts, cargo trousers etc. What I’m looking to achieve is to have a form where staff can click on their site and the form automatically reveals the options relevant to them — so those who click “Site A” (which is a Formal site) see the options for shirt and waistcoat sizes, whereas those who click “Site B” will see options for polo shirts, but not for shirts or waistcoats. I have a Sites table that contains all of our sites which staff can select from. It includes addresses, management and whether the sites are designated as casual/formal. I even have the “Site type” (i.e. Formal or Casual) included in the Form’s table as a Lookup field pulling from the Sites table. The pro

82
Hannah_Wiginton
J
Joe_SabadoNew Participant
posted in Other Questions
Show app only when sharing (hide view/table)

Hello. I’d like to share an org chart app but I don’t wan’t the corresponding view to be visible to the viewer. Is this possible? Thank you.

11
Kamille_Parks11
P
patrice_embryNew Participant
posted in Other Questions
Typeform to airtable - options not available

I saw another question here about this, but it had no answer. I have multiple choice questions in typeform, and when I try to map them to multiple select, I see the fields listed but they’re grayed out. It only happens sometimes and I can’t figure out why it doesn’t work all the time. The answers I’ve added in airtable match typeform exactly. This is a huge blocker for me!

10
P
C
Christian_CookParticipating Frequently
asked in Other Questions
Referencing Other Entries?

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

93
Hannah_Wiginton
A
Andrew_StulacNew Participant
posted in Other Questions
Typeform field matching

I’m integrating Typeform with AirTable and all is working great with most fields but not with single-select and multiple-select fields. Documentation states these AirTable fields map to Typeform fields that are Multiple Select, which is what I used. When mapping these fields in my block, I can enable my AirTable select field but the equivalent fields in Typeform are greyed out so cannot be selected. Any help would be greatly appreciated. Thank you.

31
P
Q
Quentin_PiganeaNew Participant
posted in Other Questions
Update All Column datas and not a Record only

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

00
Q
T
TsubasaNew Participant
posted in Other Questions
In order to use Airtable Sync, do I have to Do I have to create a Share View Link to use Airtable Sync?

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?

30
T
S
stationNew Participant
posted in Other Questions
Comment doesn't well non-English

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.

20
S
J
Jessica_CoteNew Participant
posted in Other Questions
Using the Jira Cloud Sync, Can airtable import rank if it is set in the filter?

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?

00
J
J
Jayme_RichardsoKnown Participant
asked in Other Questions
Can you see which views are utilizing a specific field for filters or groups?

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!!

320
J
S
SevenRootsNew Participant
posted in Other Questions
Is there a way to easily create an Executive Summary table that links to all of the other Tables/Tabs?

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!

122
kuovonne
Kim_Trager1
Kim_Trager1Brainy
posted in Other Questions
Group conditions does not enforce single select fields?

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?

63
ScottWorld
N
Nadege_BOINNARDKnown Participant
posted in Other Questions
"Conditional" Junction Table?

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 particular program, for that particular client contract) and the p

72
N
E
Ellie_StrandNew Participant
posted in Other Questions
Importing Airtable template from another user

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

695
Kamille_Parks11
A
Andrew_DaviesInspiring
posted in Other Questions
Locking a view to be shared via a link

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

162
A
B
Balint_PatakiNew Participant
posted in Other Questions
How can I add percentages to airtable dashboards?

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?

911
Kamille_Parks11
R
Rodrigo_FloresNew Participant
posted in Other Questions
Unique Values to show on Dashboard or Interface

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

220
R
S
Simon_WarrenParticipating Frequently
posted in Other Questions
Calendar Schedule using Gantt View with Date Triggers

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 could access some more information, maybe who the Auditor will be and what type of Audit will be conducted. Hope that makes sense, I am used to Excel but as my company is cloud based and wants better deployability amongst remote users, wants to develop tools in Airtable. Thanks, in Advance, Simon.

135
Kamille_Parks11

Badge winners

  • Certified Airtable Admin
    CK11_2has earned the badge Certified Airtable Admin
  • Certified AI App Builder
    CK11_2has earned the badge Certified AI App Builder
  • Certified Airtable Builder
    Ludo_Pairehas earned the badge Certified Airtable Builder
  • Certified AI App Builder
    MaddieJhas earned the badge Certified AI App Builder
  • Welcome
    durettihas earned the badge Welcome
Show all badges
Terms & Conditions