Skip to main content

Other Questions

Have other Airtable related questions? Post here!

  • 10,000 Topics
  • 40,688 Replies
10000 Topics
M
Mica_FisherNew Participant
asked in Other Questions
Formula for percent progress marking tasks as Complete

Hi everyone, I’m looking to create a Field where I can mark tasks as either “Complete”, “In progress”, or “Not started” based on the Percent Complete I have manually entered in another field. I’m using this formula, and it’s working for everything except Complete: IF({Progress} = 100, “Complete”, IF({Progress} = 0,“Not started”, “In process”)) I’m also including a screenshot. What am I doing wrong? Thanks! Mica

90
M
J
Justin_OakleyNew Participant
posted in Other Questions
Create link to another grid

I’m just looking at using Airtable to see if it will meet our needs for a community volunteering project. Am I able to switch to another grid and back again? If I can then can I automatically apply a filter when the other grid displays? Thanks

51
Rupert_Hoffsch1
E
Esa_IsmailNew Participant
posted in Other Questions
Auto Insert Date Based on Submitted Form

Hi All! I’m new to this community and hope to contribute as well as to learn from you all. I have a form created in Airtable. How do I create a formula so that when the form is submitted, airtable would insert the date of the submission automatically in a specific field I created beforehand. Thanking you all in advance for any assistance.

404
F
A
Alisher_AbdulloNew Participant
posted in Other Questions
Remove "Sign up" and Airtable Logo while sharing a private link

Hello.When I open the shared link on Wechat the Sign up and Logo buttons pop up and take away reader’s attention. It’s clickable. Is it possible to remove or replace it with my own website link and Logo. Please see the image for reference. Thanks a lot

00
A
M
Marc_MilotNew Participant
posted in Other Questions
Removing the "sign up" option when sharing a view via a private link

Is this possible? I would like to send a view to other people without the “sign up” option being displayed. Thanks! M.

51
A
N
Nurul_IslamNew Participant
posted in Other Questions
Text and Number Combined Unique but auto generated ID

Is it possible to create a auto generated ID in combination with text and Number…e.g. I need to generate some ID like OHBL20081/OHBL20082 Thanks in advance! Nurul

653
Dimitris_Goudis
L
Louis-Marie_LamNew Participant
posted in Other Questions
In a form limit the selection of an answer to one person

Hello, I created a form in order to book parking spots according to the dates. I would like to find a way that a parking space can only be taken once a day. If someone fills out the form and chooses the spot 1 for October 5, I would like the next one to be unable to choose this same spot and only be able to see the remaining spots. Is there a way to do this in a form? Thanks for your help Louis

101
Justin_Barrett
T
Tiffany_OneyNew Participant
posted in Other Questions
Year to Date formula

I need to create a Year to Date field that calculates YTD pay, but I am unsure of the formula to use. All help is appreciated.

101
Kamille_Parks11
T
Tristan_ScifoKnown Participant
posted in Other Questions
Zapier - adding new items to a "Link to another record" with existing items

We’re in the process of building out some serious zaps and need some guidance on what will happen if we use zapier to ‘add’ items to a “link to another record” field which already contains values. We have tables for both Clients and Meetings which are linked. Over time, multiple meetings are linked to existing clients. Often we can add new meetings and link just that specific meeting to an existing contact, HOWEVER sometimes we need to update an existing contact and link it to a new meeting (this is caused by the case of sometimes having one meeting attendee and sometimes having two, where attendee 2 is sometimes blank, so we need to run a filter before search/creating attendee 2 as a contact, and this happens after the meeting is already created). The issue here is that these contacts likely already have various linked items (meetings). So, my question is, do you know if you run a zap to “add” a new meeting ID to the linked meeting column of a contact, will this: a) overwrite all exis

10
T
N
Nicole_LeiterNew Participant
posted in Other Questions
Notifications to Slack not working at all?

I have been an avid AirTable and Slack user for years now. We use AirTable and Slack integrations for three separate bases; two are on a paid plan and one is not. A couple variations of such (update certain channel when something the entire base is changed; update certain channel when something in a certain view is changes, etc.) and they have worked MOSTLY perfectly. Until today. Well, Saturday, October 16, I should say. We are receiving NO notifications from either of the paid bases on any of the channels we have the notifications set for. I have tried deleted and re-enabling them, I have tried disconnecting and then re-connecting our AirTable and Slack accounts. I have successfully sent “test” messages to all of the channels from AirTable’s “send a test message” option. It has also posted in my Slack channel that the AirTable integration was configured successfully! And nothing, not a single thing, has come through today at all. And myself and my team rely HEAVILY on this integratio

70
N
J
Jeffrey_TufenkiNew Participant
posted in Other Questions
Counting number of commas in one string

Hey guys, first thank you for taking your time to read my question! I have a column where there could be from 0 to infinity amount of “Strings”, these look like this “, 20457-268, 28649-882, 28964-2899”. As you can see it starts with a Comma and every set of numbers (divided by a dash) represents something to me. Based on the given example, I’m trying to find a formula that will give me a number of the “Strings” you see, for the example I provided it should give me a 3. Since the numbers change and I have no control over them, and the last number never ends in a comma, I figured all I have to do is Count the commas, in the example given as you can see it starts with a Comma and the comma itself separates each string and the count should be 3 because it has 3 commas. Can anyone help me with this formula? Many thanks in advance!

1281
A
A
Allen_WixtedNew Participant
posted in Other Questions
Collaborator Cannot Add Records

I’ve added a new collaborator and she can see our base and edit records. She cannot however create new records. Where I have a +, she has a lock. I’ve tried changing her permissions via the table’s drop down edit permissions menu. I’ve tried each option for her on the workspace, editor, creator etc. I’ve also tried manually selecting her via the “specific users” option on the table. Any tips on how to enable her to add records?

132
A
P
Patryk_SulejczaNew Participant
asked in Other Questions
Autoadd date record

Hi, How can I add formula which autoadds date field to be +1 day to date field in previous record? I am working on content publishing base and want to automate publishing date field. For example: in record 1, my date field is: 10/13/2021 and I need formula which gives date 10/14/2021 in record 2 and 10/15/2021 in record 3. Thanks in advance!

90
P
F
Fionn_DelahuntyNew Participant
posted in Other Questions
Graph for only one group?

I have a base table in the following format, many groups each with tags and a count of the tags. I can currently chart the count of tags, but it shows all groups. I’d like to only chart one group at a time. Is this possible?

10
F
E
Elizabeth_SterlNew Participant
posted in Other Questions
Consolidating a current list of data (countries) in Airtable with one in an excel sheet, so missing countries can be added

I currently have a list of countries in one table but some are missing. I have a list of all the countries in an excel sheet that need to be added. I know there’s a work around to add the missing data by copying what you currently have with the excel sheet, but I can’t remember how to do it. Any suggestions? TIA!

191
Alexey_Gusev
G
Gleb_BarinovNew Participant
posted in Other Questions
Number to text (russian amount)

Hi everyone Can help me with script adaptive for airtable ? I need to the amount into text format Summary let table = base.getTable(“Test”); // column Amount = number // column Amount txt = text function number_to_string(_number) { var _arr_numbers = new Array(); _arr_numbers[1] = new Array(’’, ‘один’, ‘два’, ‘три’, ‘четыре’, ‘пять’, ‘шесть’, ‘семь’, ‘восемь’, ‘девять’, ‘десять’, ‘одиннадцать’, ‘двенадцать’, ‘тринадцать’, ‘четырнадцать’, ‘пятнадцать’, ‘шестнадцать’, ‘семнадцать’, ‘восемнадцать’, ‘девятнадцать’); _arr_numbers[2] = new Array(’’, ‘’, ‘двадцать’, ‘тридцать’, ‘сорок’, ‘пятьдесят’, ‘шестьдесят’, ‘семьдесят’, ‘восемьдесят’, ‘девяносто’); _arr_numbers[3] = new Array(’’, ‘сто’, ‘двести’, ‘триста’, ‘четыреста’, ‘пятьсот’, ‘шестьсот’, ‘семьсот’, ‘восемьсот’, ‘девятьсот’); function number_parser(_num, _desc) { var _string = ‘’; var _num_hundred = ‘’; if (_num.length == 3) { _num_hundred = _num.substr(0, 1); _num = _num.substr(1, 3); _string = _arr_numbers[3][_num_hundred] + ’ ';

11
Alexey_Gusev
Dean_Arnold
Dean_ArnoldInspiring
asked in Other Questions
Script Errors: 15 mutations per second, and Slow Run-Time

Hi there, I adapted the below script by @Justin_Barrett. Everything was working great until I added a few hundred new records to the ‘TaskLog’ table. The script now throws this error: Exceeded quota of 15 mutations per second at main on line 20: let result = await table.selectRecordsAsync() In addition, the run time is now 23.8/30s - also an error for my purposes - as any run time that goes over say 6-seconds will make the script unusable. Can anyone tell me exactly how to edit the script to include batch processing or another solution that will solve the two errors at hand? Ideally, the script should be able to quickly search through thousands of records in the TaskLog table in order to mark the ones that match the Account ID from the first step of the automation (inputConfig.AccountID) Here is the script: // Remove all existing markers (ie make all Task Log records 'current' value null) let TaskLogTbl = base.getTable("TaskLog"); let TaskLogRcds = await TaskLogTbl.selectRecordsAsyn

90
Dean_Arnold
I
ianonlineParticipating Frequently
posted in Other Questions
Help sync primary field

Hello, I have one table and would like to sync the primary field with the primary field in a second table. I tried this by creating a synced table, but the only bases available are the example bases. I moved my table to the example bases workspace, but my base still wasn’t available. Is it possible to do this? Can anyone help? Thank you.

275
Justin_Barrett
J
Jack_LuNew Participant
posted in Other Questions
Why so slow if I want to import data with 20k records?

just an excel with 20k records. i tried to import from excel, soooooo slow. i save it as CSV, and import it again, still very very slow. so far, still not finished. which way i can choose to import it?

91
Justin_Barrett
C
Cheryl_JacksonNew Participant
posted in Other Questions
Moving one file

As I reorganize my workspaces, I am wanting to move a handful of files from one workspace to another. The files have attachments. Is this possible?

21
Justin_Barrett
E
Eric_NEMONew Participant
asked in Other Questions
Sync table format issue

Hey there, My production team is using one base to handle our production. (supply, suppliers etc) One table in this base is dedicated to our PRODUCTS. We have one column for price (currency type). An other table, in this same base, is dedicated to VARIANTS. It is simply a linked record to a PRODUCT and a size. The price is “looked up” from product, and thus is showing as a currency type on the variant record. On the other side, the SALES team is sync the VARIANTS table from production to another base (SALES) to get a list of all of our product. To create a sale in the LINE ITEMS table, they pick a VARIANT from the synced table in their base. They write a quantity. And obviously the quantity should be multiplied by the VARIANT PRICE to have the line price. My problem : in the synced table (in SALES base), the price is shown as a TEXT. (“€60.00” for instance) And I cannot manage to make the formula work. I tryed VALUE({price})*quantity but it says #ERROR! It seems like sync records con

230
E
F
fiveheadNew Participant
posted in Other Questions
How can I only show a fixed # of rows in a view?

Here are my criteria: Display a limited # of events (10, for example) to website viewers, using the “Embed this view on your site” functionality. The list must be dynamic and not static. To that end, the Airtable view I created makes it easy to filter out expired events and sort by end time in ascending order. Help me, Obi-Wan…!

402
kuovonne
J
Jethro_AcenasNew Participant
posted in Other Questions
Adding Holidays to Calendar

I’ve searched here and google searched for a way to add holidays to the calendar. It is for staff time-off. It would be nice to see holidays in the calendar view, along with staff time-off requests. The main question is, how do I add holidays to my calendar?

1603
kuovonne
F
Filip_ChocianowNew Participant
posted in Other Questions
Copying the value from Summary Bar

I know that values from the Summary Bar cannot be used in formulas, but I would like to be able to at least right click and copy-paste them. Right clicking on the summary bar does nothing and left clicking only allows me to change what value is displayed. Am I doing something wrong here? Is there perhaps some add-on that would allow that? I am using Mac if that makes any difference.

103
Justin_Barrett
S
ShoutandEchoNew Participant
posted in Other Questions
Importing .csv Into Specific View

Hi! How does one import a .csv into a specific view? I understand how to import a .csv into a table and select how to map fields for import, etc., but I don’t see a way to import data into a specific view (i.e., not the entire table). For example, I have a table where I do not want some rows overwritten by a new data import. I can easily filter these records/rows into a view where the only visible rows are ones that I DO want to be overwritten with new data. Does that make sense? Thank you!

81
kuovonne

Badge winners

Show all badges
Terms & Conditions