Solved

Ok first this is the set up: 1 table base 7 separate table tabs with individual table names Using react and the npm airtable package I am making a call in the api to retrieve 1 record by its ID. const base = new Airtable({ apiKey: Key }).base(id); const table = base(‘table name’); const recordId = 'recordidfromairtable'; table.find(recordId, function(err, record) { if (err) { console.error(err); return; } console.log('Retrieved', record.id); }); This works and returns the record. However it seems if you change the table name you are searching on as long as it is a valid table name it still returns the record even if it sits in a different table. Now whilst this is a functionality we are looking for i.e. a search on all tables in a base. This doesn’t feel like this should be working. i.e. if the table name doesn’t contain the recordId then it should fail but it still returns the record regardless of the table you are searching? After reading various documentation searching al

I’m trying to use the --remote feature of the CLI to install my Custom Block into another base, but it doesn’t seem to be working. I’m not sure if I’m doing something incorrectly. I went through the process of “Install a block”, “Build a custom block”, and saved the appID/blkID, leaving an empty and uninitialized block Then I ran the CLI commands, with apparently successful results: But my block remains uninitialized. I’ve tried refreshing multiple times, and I’ve tried running the CLI commands again, and it doesn’t look like it’s done anything. I tried running just $ block release as well (not specifying a --remote), and my default installation of the block was updated (tooltip indicates “last updated” with today’s date). So it appears it is only the remote option that is not working as I expected. @Kasra @Michelle_Valentine

Is there a way to create a Dropdown Menu inside a custom Block to filter by own configured Airtable Views? Airtable Airtable | Everyone's app platform Airtable is a low-code platform for building collaborative apps. Customize your workflow, collaborate, and achieve ambitious outcomes. Get started for free. I’am not quite sure if this is what would work for my case. Is there any Example Demo/Code for that? Thanks!

I’m having some trouble using a Script Setting input field when building a new record using CreateRecordAsync. Any help would be appreciated! Thanks! I keep getting errors like this Field ‘orderEvents’ does not exist in table ‘Inventory & Order Events’ at main on line 318 Here is my setup const config = input.config({ title: 'Replenish Script', description: 'This utility/script acts like a form for choose information about the coming replenishment', items: [ input.config.table('eventsTable', { label: 'Inventory & Order Events', description: 'Choose Inventory & Order Events Table' }), input.config.table('locationsTable', { label: 'Locations Table', description: 'Choose the Contacts and Vendors table' }), input.config.table('measurementsTable', { label: 'Measurments Table', description: 'Choose the measurements table' }), input.config.table('productsTable', { label: 'Products Table',

hi, i’m currenly trying to use integromat to copy data from one base to another. but when there’s a linked column. it copies its record id instead of its field value. i tried turning on smart link, but it still copies record id instead of its value. any help please?

I created a view and shared it; however, when they attempt to click on what I know to be a linked table, they are unable to do so. For instance, they can see the contact person’s name but can’t click on it to reveal the details it contains from the Contact table. What are my options to allowing this person read-only access to this main table while also being able to click on any linked tables?

I was wondering if it is possible that if a collaborator filters a list, then the rest of the collaborators do not get their lists filtered when they access the base. Would getting a paid version solve this problem?

Hi. Noob alert! This is my first attempt at formulas of this nature. I am trying to concate an address (Street 1, Street 2, City, State, Postcode, Country), separated by a comma and space (", "). However, most addresses I enter do not fill the ‘Street 2’ cell, which results in an additional ", " in the formula outcome. I have spent hours trying to correct this and cannot figure it out. I would be grateful for any assistance! Thank you. Here is an image of the issue: Here is the fomula I am using: CONCATENATE({Street 1},", “,IF({Street 2},’’&{Street 2}),”, “,{City},”, “,{State},”, “,{Postcode},”, ",{Country})

I got a bunch of values fro each collaborator in my base which I need to summarise pr month. Down the ‘Y-Axis’ I got my collaborators. My problem is I can’t get the ‘X-Axis’ - the month name to sort properly (see below). Ideally I just want the month name showing, but it seems I can only sort those in alphabetical order. Then I tried to add the month number to the month name in the hope it’ll sort on the month number, but as you can see December for some reason comes between July and September. Is there no way that I can just sort the month names from Jan → Dec?

I know I’m overlooking something here but I can’t figure out what that is. I’m trying to create a Publishing Status field using nested IF statements. So far, I’ve only tested the first few statements, but I can’t get anything other than step 1 to show. I still need to add all of this: IF(Done =NOT(Blank()), “step 15”, IF(Published =NOT(BLANK()), “step 14”, IF(Uploaded =NOT(BLANK()), “step 13”, IF(Accepted =NOT(BLANK()), “step 12”, IF({Client Approves Draft} = NOT(BLANK()), “step 11”, IF({Draft Delivery URL} = NOT(BLANK()), “step 10”, IF({Senior Draft Review} =NOT(BLANK()), “step 9”, IF({Internal Draft URL} =NOT(BLANK()), “step 8”, IF({Client Approves Outline} =NOT(BLANK()), “step 7”, IF({Outline Delivery URL} =NOT(BLANK()), “step 6”, IF({Senior Outline Review} =NOT(BLANK()), “step 5”, IF({Internal Outline URL} =NOT(BLANK()), “step 4, IF(Author =NOT(BLANK()), “step 3”, IF(Article =NOT(BLANK()), “step 2”, IF(Article =BLANK(), “step 1”)))))))))))))) But right now I can’t determine where

Hi there! I’m an Airtable noob, but a spreadsheet lover. I’m trying to create a formula (Switch looked like the best), that will create custom dates based on the “Task Name.” It involves date math based on “Original Publish Date” field which is a date. Here is a rough example of what I’m trying: SWITCH( {Task Name}, “Create Illustration”, DATEADD({Original Publish Date},-14,‘days’), “Generate blog post and schedule post”, DATEADD({Original Publish Date},-13,‘days’), “Create snippets for social media”, DATEADD({Original Publish Date},-12,‘days’), ) I’ve tried paranthesis around dateadd and end before the comma. That didn’t work either. Is this possible? I see other formulas that seem to work.

I’m not sure why this one isn’t working, because I’ve tried copying and pasting from another base where this formula DOES work. I’m trying to write an IF statement for the Gift ID. If “Donor Account” is not blank, GIFT ID should pull Donor Account after the date. If it IS blank, it should pull Company. This is my starting point, but it’s telling me it’s not a real formula. (DATETIME_FORMAT({Date of donation}, ‘M/D/YYYY’) & " — ") & IF(Donor account, Donor account,Company) Thoughts?

I am creating a catalog of sheet music for some musical groups I play in. It has a main table with all the usual information to be expected (title, composer, arranger, etc.) plus some additional info, such as alias names and associated works or titles. All the information is either directly stored in the table, or is in a linked table (composers and arrangers, for example). The alias and associated works are useful. Some examples of these associations are: The title, “It’s the Hard Knock Life”, also has an entry in the associated works field indicating that it is associated with “Annie”. The title “Ukrainian Bell Carol” has an alias entry as “Carol of the Bells”. The “Hallelujah Chorus” has an associated entry indicating it is part of the oratorio “Messiah”. The point of all that is to indicate how useful this information could be in searching. For example, when searching for a specific title, I would also like the associated/alias fields to be searched for the same title. Now, I

Hello, I have started using Airtable recently and I find it quite useful. I am trying to create a structure as below: Company [All the companies that I worked/work with] ==> Project [All the projects that I have worked/working] ====> Tasks [All the tasks for different projects] To achieve the relation, I have used ‘Link to another record’ field type. I am able to relate Company table with Project, Project table with Tasks. On the Tasks table I am able to see the Project they are associated with, but on the Tasks table, I am not able to display the Company associated with the project for which the tasks are. Can you please guide me how I can establish this structure?

Is it possible to present the number formatted by grouping the thousand, like “100,000”. It just displays “100000”. Excel gives an option: “Use 1000 Separator (,)” This is found in cell format, under # format.

Someone else on the team created a Dashboard using the Maps blocks. I am a Creator in the AirTable and anytime I go in, I do not get a map or settings. The Owner sees the Settings and map just fine. Any ideas as to what the issue is? Here is what they see: Here is what I see:

I’ve switched around the order of a few columns in grid view but this isn’t reflecting on Kanban. I would have expected the order of questions/columns to sync up no matter what view I’m in but this doesn’t seem to be the case. Help?

Hi Folks, I need help writing a formula that returns only data for this week related to a release date I know this formula works IF(WEEKNUM({Release Date})=WEEKNUM(TODAY()),“this week”,“NOT”) However, it still shows me content released for the next year same as this week. I only want to work on the current year not all years in my view. Thanks, A lot for your time

Hi all, I’ve been struggling with the SET_TIMEZONE feature for about 20 minutes now and frankly I’m over it, so I’m coming to you all. I’m trying to display the times that some orders were made in the local time zone of the person that made the order. I have three columns: Time Zone (which is the local time zone of the buyer), Order Time & Date (CET) (which is my time zone. all time stamps arrive in CET), and Order Date & Time (Local) (which is the field I am trying to calculate). I have set the following formula in the last column: IF({Time Zone}="Alaska",SET_TIMEZONE({Order Date & Time},'America/Juneau'),IF({Time Zone}="Hawaii",SET_TIMEZONE({Order Date & Time},'Pacific/Honolulu'),IF({Time Zone}="Eastern",SET_TIMEZONE({Order Date & Time},'America/Kentucky/Louisville'),IF({Time Zone}="Pacific",SET_TIMEZONE({Order Date & Time},'America/Los_Angeles'),IF({Time Zone}="Central",SET_TIMEZONE({Order Date & Time},'America/Mexico_City'),IF({Time Zone}="Mountain",SET_

Hi, for my academic research database I’m trying to write a formula that will automatically extract a four-digit number from a cell (i.e. extracting year from a citekey). For example (Citekey --> Year), Downs1965NonmarketDecisionMaking --> 1965 Welborn1968BureaucracyAnthonyDowns --> 1968 Any ideas on how I might be able to do this? Thanks.

This is probably so easy, but I just can’t get it to work. I hav 13 columns that are using a formula to extrapolate a comma separated list from a single column. That works great. I am then trying to use a new formula field to look across all 13 and put the result of the last column that is not blank. (i.e. if column 1 has text then check column 2. If column 2 is blank then column 1 in field if column 2 has text then check column 3 and if 3 is blank them column 2 and so on. the columns are called item1, item2, item3 and so on. Thanks in advance

I have a simple date in my table and I simply want to have the name of the weekday displayed (e.g. in another column). Does this work with a formula?

Not sure how to describe this one… I have a primary field in one tab of Publications. Each publication has a Pub Date column. In another tab, I have Last Name as a primary field (of authors) and want to create a column that tells me the most recent publication they were attached to. If I use Roll-Up with max value, I can get the pub date itself (1/12/20) to appear rather than the name of the most recent publication the author is attached to. So I think I need a formula that would produce, instead, the most recent Publication the author is attached to. Any thoughts?

Hi, I work for a charity that distributes surplus food to members of the local community for a small weekly fee. I use Airtable to keep track of, among other things, how much each person pays each week, versus how much they should’ve paid. I use two linked tables to track this - one on which I record each individual transaction, and another that uses rollup fields to add each member’s transactions together so I can see each member’s history at a glance. I’ve set it up so that the Rollup table shows me how much (if anything) a member owes us in total, but the actual maths for that is done in the Transactions table. At the moment, one food delivery costs £3, but we’re about to increase that to £4. My trouble is with how to get Airtable to reflect this change. If I just change the formula for the amount owed from {Packages delivered}*3 to {Packages delivered}*4 then it’ll re-calculate every member’s payment history and tell me that everyone is £1 per week in debt, so I’m hoping there’s an

Hello! I’m new to Airtable but not databases overall so I have a little bit of knowledge in how to write a formula. I can’t seem to work through this one though. I have the need to be able to recall certain clients for scheduled services. I cannot for the life of me figure out how to write this formula. I need the formula to calculate off the “Scheduled Date” forward 275 days but only when the “status” is not marked as “complete”. I have no earthly idea how to make this work. Thank you all very much for your help on this - I’m sure it’s pretty basic and I am overthinking but…I’ll learn it all someday!