Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,679 Replies
10000 Topics
Z
Zach_Polen1New Participant
posted in Other Questions
Combining/summarizing tables in the same base

Hi, I am trying to create a “summary” table within the same base as the input tables (this is a template that will be copied). It looks like Syncing the tables is only possible if I do the syncing in a new base. But I am essentially looking for this concept within the same base. How could I get totals/sums from the table Option A, Option B, etc into a Total table? Thanks in advance for your help!

591
Ben_Young1
R
Robert_FrederikNew Participant
posted in Other Questions
Is there the ability to have existing records updated (with attachments for example) externally without being a collaborator?

Hey all. Setting up a base for a real estate firm and they would like to have property owners upload their own photos to an existing property record. Is there a way to have a non-collaborator/non-airtable user update their own record? I considered using a form, having the information come into a separate table, and then linking the records but that is proving challenging. Thoughts?

31
ScottWorld
G
Gustavo100New Participant
posted in Other Questions
Transfer color coding to Stacker?

Dear all, we use Airtable as our database and Stacker as a front-end for several colleagues. Our people love the colored drop-down data in Airtable. Any idea how to communicate the color-info through stacker as well? (e.g. @Sam_Davyson ?) Best regards, Gustavo

20
G
D
David_GerrardNew Participant
posted in Other Questions
Use unique values from field in one table as Primary Field in another

Hi all! I love the look of this template and want to do something similar: Product Roadmap Template - Free to Use | Airtable In my main table the Primary Field is all my potential dev stories. Each of these has an Epic value assigned. I want to make a different table where the Primary Field is all Unique Values from the Epic field in the other table. Then, I want to have all the stories grouped, or counted, or what have you in an additional field. In the sample it looks like they just used the text values of Alpha, Beta & Final, but as I will always be having new epics I’d like the field to be dynamic. Is this possible? Thank you!

10
D
V
Valdemar_TKnown Participant
posted in Other Questions
Typeform True/False as Checked or Empty (How to make it True False as is?)

Hello, We upload responses from Typeform, and typeform has some questions which are Yes/No but it seems typeform is returning for those answers True or False, and when they are uploaded to AIrtable the records are Checkbox and if it is true it is Checked and when it is false, it is not checked. How can we make it to be as True False rather than checked or not?

20
V
R
Ravi_NaguNew Participant
posted in Other Questions
Adding a search tool in datasheet

Hi there! I’m looking to integrate a ‘search tool’ in my Airtable datasheet. Something similar to what google has. We are consolidating all our data at one place to standardize & streamline our workflows. So that whenever a teammate wants to know anything regarding the business, they just go to the search tool, search for it and the data gets fetched! Thanks!

134
R
V
Vijay_chenKnown Participant
posted in Other Questions
How do I hide some sheets under the same base from colleagues with editor privileges

Hi Can Airtable do what I need

1512
V
A
Alexander_CelesNew Participant
posted in Other Questions
Mac App Still Requires Rosetta 2

I was under the impression that Airtable had abandoned their Mac app a while ago, but today saw that it had an update. However, even this newer version still is not Universal for running natively on both Intel and Apple Silicon Macs. Is there any sort of ETA on a Universal Airtable Mac app? I like having the separate app precisely so that it is not in my web browser, but would prefer a native app on my M1 Mac.

21
ScottWorld
E
Evan_McMahonParticipating Frequently
posted in Other Questions
Counting Specific Letters in words

Hi Everyone, I have a database of 10k+ words. My goal is to count how many times a letter appears in each of the words. For example: Apples contains 1 (a) 2 (p) 1 (L) and 1 (e) 1 (s) My original idea was to create 26 fields, 1 for each English letter. I can’t seem to figure out a formula that can do this. Secondly I’d like to then have a table that is able to take the most common letters and display the most common words of various lengths that already exist within my database. Is this possible?

132
E
G
Gareth_LottNew Participant
posted in Other Questions
Variable product pricing

Hi, I have a business where I set a product price based on a range of factors - so I don’t have a fixed price. Can anyone suggest how I can set it up so I can set a unique product price at Client Order level? Thanks in advance, Gareth Sorted it out already…

12
V
M
Matej_FaganelNew Participant
posted in Other Questions
Limiting access to published form

Hi, Is it possible to e.g. password protect published form? Regards, Matej

185
ScottWorld
Y
Yura_AbharianNew Participant
posted in Other Questions
How to redirect directly to my react app?

Hello all) I have a couple questions How I can redirect directly to my app (iframe) ? because when I’m using iframe link it redirects me to the blank page Can someone tell me please how I can read parent url from iframe?

40
Y
Y
Yusuf_JacksonNew Participant
posted in Other Questions
How can i automatically withdraw information from a long text column to create a link in a multiple select column

So I am inputting information into a “long text” column on a grid. At the moment I am then manually adding fields into my other columns of “multiple select” links. Is there a way that when I paste something into long text that it automatically adds links to things that I have approved from the long text section?

30
Y
M
Michael_LeverInspiring
asked in Other Questions
Link to field omits information

My question concerns missing information using a link field. In Table A is a field name: Property ID In Table B is a link field to Table A’s Property ID In table A I enter London 123 When I search in Table B’s Property ID for London 123, I can find it amongst the records but the 123 isn’t displayed. I have tried entering London-123 but it doesn’t make any difference. how should I enter the information in the table A field to ensure that when I link all the information is displayed in table B? tia

70
M
E
Elouan_DupleixNew Participant
posted in Other Questions
Synced on a sheet

Hello, I would like to be able to synchronize the data of one of my pages on a single sheet. Is it possible that I can synchronize the data of one of my databases on a single sheet?

00
E
F
Frank_DeutschNew Participant
posted in Other Questions
Mail/email Airtable base

Hi, We are group that is fighting the take-over of the NWO criminal cabal. We intend doing this using a letter/email program, but for this we need an efficient Data Base, to stop doubling up and have an instant view (pie chart, bar graphs) to judge effectiveness and progress. I need urgent help in guiding me to construct such Airtable base and willing to pay for your help. I am absolutely new to Airtable, I will forward full description once I get some response Cheers:Franz:

10
F
g_F
g_FNew Participant
posted in Other Questions
Question about workspaces / Pro / billing (single user)

To continue my setup in Airtable, I would have liked to understand how the Pro plans work: I discovered (by coincidence) that the price depends on the number of worspaces and the number of users (?) I read this in the help sections: “The cost of upgrading a workspace is dependent on the number of users who have access to any of the bases in your workspace.” I would have liked to be able to organize my data in several workspaces (equivalent to folders divided by interests or activities) AND the advantages of a Pro plan. But obviously I don’t want to pay a Pro plan for each workspace (6 or 7!) I am the only user of this data. What would be the best solution? Thanks in advance for any help or suggestions!

85
g_F
S
SHOP_GIRLSNew Participant
posted in Other Questions
Mobile Calendar

Currently, our mobile calendar view is showing Feb 2022, but the numerical dates are not properly aligning with the day of the week. Is this a glitch on our end or on the app itself? The same desktop calendar is perfectly fine. But mobile is showing that today, feb 8 2022 is a Saturday. Also, the monthly view of february is only showing from 2/9-3/22. Weird.

31
Ben_Young1
M
Matej_FaganelNew Participant
posted in Other Questions
"Call" relevant data from database

Hi, Is this possible with Airtable: Is there a way that I publish a form and user can enter certain value (eg. Name) and “form” shows them values for that value (eg. Last names related to the Name)? User starts typing a eg. Last name in a field in the form and during the typing the possible values (of course the ones in database) starts to show?

62
Justin_Barrett
I
itoldusoandsoInspiring
posted in Other Questions
Text summarizer - created a summary version of my text

I am looking at how to get a summarized version of long text. I am looking at some tools and many have API and are free but I haven’t compared how good they really are because that would be too biased to share it here (my text would be different from anybody else so likely difference results. If you summarize your text in Airtable - what do you use? I am looking at couple of tools like https://api.codeq.com There is only one that I know of that integrates with Zapier. However, no integration with Integromat. I am paying Integromat already and not ready to stick more money for Zapier since all stuff I do is in Integromat anyways. Zapier too expensive for what it can offer me. Here is the workflow with Zapier and MakeMySummary. Anybody else uses anything else? makemysummary.com MakeMySummary Summarize a video, podcast, webpage, blog, news, text or a pdf file. Zapier MakeMySummary Integrations | Connect You

162
I
M
M_LInspiring
posted in Other Questions
Help Syncing AirTable with External Site

I’d like help as I expand the complexity of my Airtable bases. Currently I use Airtable to manage different lists of people for my nonprofit. For example, team list, partner list, donor list, etc. These tables have lists of records with names and other fields like street address, email, etc. Our nonprofit is growing, so we want to begin utilizing external services to create online communities using services external to Airtable. For example, using a membership or e-course site like Kajabi, Mighty Networks, or Tribe. The problem is, I don’t want to have to manually update these Airtable lists in both Airtable and these external services. I have an AirTablr team list, but the community on Kajabi for example, would be identical to the AT list. Is there a way I can link these sites to Airtable, and use one database as the “parent” and the other as the “child” that just syncs to whatever the “parent” says? Preferably Airtable would be the “parent” and Kajabi or Mighty Networks the “child”,

90
M
J
Joanna_ParkerInspiring
posted in Other Questions
Vega-Lite - Splitting x-axis labels pulled from a Lookup Column using delimiters

Hi Airtablers, Starting my first attempt at using the Vega-Lite app, as I have some information that is not behaving using the Pivot Table app. I’ve used a Look-Up column, that pulls through Countries from a Multiple Select field on another table, so that the two data sets I need are connected. But the Pivot Table app won’t let me ‘Split Multiple Choices’ within the Look-Up Column. So, when I try to make the data into a readable format, the ‘Countries’ only show as various combinations of countries from each of the Lookup Column entries (e.g. “UK, USA, France”, “France, Germany, USA”, “UK, USA, Germany”. When they need to be split into “UK”, “USA”, “France”, “Germany” in the visual data.) I’ve moved on to using Vega-Lite in the hopes this can be solved, but this is where I’m stuck. This is the section relating to the x-axis: Is there a way to split the values from the “Country” column (the Lookup Column), using commas as the delimiter? And then grouping data for each country together?

110
J
J
Joanna_ParkerInspiring
posted in Other Questions
Updating Empty Fields Through a Form

I was wondering if anyone has advice on updating some fields in our system? We currently use Airtable to record a register of attendees for some community group work sessions we run. We are needing to see the countries of origin that are represented in our sessions, but due to changes during the pandemic this information was not always able to be collected. I would like to see if there is a way to gather this information as and when participants attend our sessions in the future through the attendance register we have set up. We take registration using a form that links to our participants list, which needs to stay exactly the same for ease-of-use by our staff. Is there a way that when a participant’s name is selected on the attendance form (using the Add+ field under ‘Student Name’, pictured below), a second window can open requesting their Country of Origin if the field for their record is blank? This would need to be separate to the form as there are multiple participants per sessio

62
J
Y
Yewande_FaloyinNew Participant
posted in Other Questions
Shortcut for moving between rich-text fields

What shortcut can I used to move forward and back from a long text field that has rich-text formating enabled? I usually use tab & shift-tab to move back and for between fields when I’m entering data. However, when I hit a rich-text field, the tab creates a tab within the field and doesn’t move forward. Is there a way to do this? Thanks!

10
Y
C
Cyril_SchwartzNew Participant
asked in Other Questions
Script to transfer and update collaborator field

Hello, I am trying to transfer a collaborator field from one table to another. It works perfectly for the other text fields but for the collaborator field it doesn’t work. "User (other)": { "id": user }, Doesn’t work Here is my code : let mainTable = base.getTable("Table 1"); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable("Table 2"); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for(let record of mainTableRecords.records) { let lookupValue = record.getCellValue("ID Customer"); for(let rangeRecord of lookupRangeRecords.records) { if(rangeRecord.getCellValue("ID Customer") === lookupValue) { let myName = rangeRecord.getCellValue("myName"); let user; if(rangeRecord.getCellValue("User") != null) { user = rangeRecord.getCellValue("User").id; } else { user = rangeRecord.getCellValue("User"); }

160
C

Badge winners

Show all badges
Terms & Conditions