Solved

Hi all! I know that I cannot currently link two bases, and I also cannot currently limit permissions within a base to show users specific data, so I’m trying to find a workaround to my problem and am stuck. I have a CRM built for our sales associates with various tables including Client Database, Interactions Log, Tasks, Transactions, etc. There is data I’d like my executive team to see that I don’t want visible in the sales CRM such as summaries of sales by individual person, # of new customers brought in by sales associates, $ amount in sales by person, etc. I want them to view their individual stats, but not have access to view everyone’s sales stats. But, I want to summarize that data to make it visible to the executive team. My thought was to keep my CRM base as-is, and create a second base titled “Executive Base” that would show/summarize the higher-level data. I attempted to make a zap that would create a new record in the Executive Base when a new record is added to the CRM bas

Hi there, excuse my ignorance! I am very new to Airtable and I am trying to set up a simple inventory system of moving hundreds of items (Props for a film) from one location to another. I have fields set up for the various locations as a checkbox. ie. “PROPS STORE 1”, “PROPS STORE 2” etc… If I move a prop from “PROPS STORE 1” to “PROPS STORE 2” - is it possible for the “PROPS STORE 1” box to automatically UN-check? Basically, I am trying to make it so that only ONE of the check boxes can be checked at any one time. So it is not possible to have an item in two places if a crew member forgets to uncheck a location box. By default the system will only allow you to choose one check box. Many thanks for any advice!

I am very new to Airtable, and am after help with the script block. What I would like to achieve is exactly what has been given as an example here. This is what I have written: let lineItemsTable = base.getTable(‘Order Line Items’); let siteOrdersTable = base.getTable(‘Label Orders’); let productsTable = base.getTable(‘Product Inventory’); let siteRecord = await input.recordAsync(‘Select a Site’, siteOrdersTable); if (siteRecord) { let labelRecord = await input.recordAsync(‘Select a Label’, productsTable); if (labelRecord) { let quantity = parseInt(await input.textAsync(‘Quantity’), 10); let recordId = await lineItemsTable.createRecordAsync({ ‘Job’: [{ id: siteRecord.id }], ‘Item’: [{ id: labelRecord.id }], ‘Qty’: quantity }); let allRecords = await lineItemsTable.selectRecordsAsync(); let record = allRecords.records.find(record => record.id === recordId); output.markdown(Added new Label Item: **${record.getCellValueAsString('Description')}**); let addAnother = await input.buttonsAs

I have a base with columns (fields) in a given order horizontally across the page. I want to move some of these columns so that the are in a different order across the page. How do I do that?

The Background: My kid’s school needed a Daily Health Survey that parents/faculty/staff/volunteers need to fill out every day, and I said I would help and now I’m stuck. I created a JotForm which dumps data into an Airtable base, and I use automations to create one big table that has all the individual pieces in it. The raw data goes here: https://airtable.com/shri5YgdoGt16lZGH The automations create this: https://airtable.com/shrgmvNxk4fWEwlYX The Problem: the principal of the school would like to be able to print out a sheet of paper every day that has the names of the students/faculty/staff/volunteers on it and their clearance statuses. So: Pablo Picasso - Cleared Zoey Beckmann - Not Cleared etc This is a great use for the Page Designer Block (I think), but in order for me to do that, I need to figure out a way to automatically link all of the records for each date to a single record in another table, and that’s where I’m stuck. Any advice? Thanks so much.

Small bug in the user interface: Can’t sort the list of workspaces in the left column (the list is under “Find Base and Workpace” field on the left). I try to drag up and down workspaces (dragging the name) but it refuses to stay where I drag it. The list is not alphabetical but I want to sort it in my own order. The 6 dots ::: show and allows dragging but the order goes back to previous order or the order becomes completely mixed up. The issue is same online (Chrome) as it is in the app (MacOS)

guys, why did the empty post appear?

Hi, I’ve gotten all other fields to pull the correct info from Table A into Table B when triggered, but for some reason the simple text field is not pulling and showing up. Any ideas if this is a bug?

Hello, I’m trying to have a couple of “children” tables (restaurant, hotel, coffee shops) with the same colone format (name, adresse, contact info) all gathered in one “mother” table. The idea would be that when we add or modify a reccord in the “children” table, it adds or modify the same reccord in the “mother” table automaticaly. Its like my “mother” table is a mirror of my “children” tables. If anyone knows if its possible I would love to have a tips because i haven’t cracked it.

I would like to create a workaround for the issue that Linked Records are not available in Automations. I am collecting lots of URL inputs from colleagues via the web clipper. For a number of reasons I want to link the records to another table automatically, using a script. The idea would be to trigger the script using an Automation. In short: I want the title of the Calculated site to be copied into the linked record field Sites I feel like this should be fairly simple but I’m not able to dig into JS :confused:

Hello, Thanks in advance for reading my post. I have a table which includes a list of equipment, and then I have another table that contains dates of bookings (a booking is per day), location of booking and other fields. I would like to be able to see on the first table the last location of a booking and it’s date. Is that possible to do?

Hello, I am working on various automations for my use case, but don’t have previous experience with json or the airtable api. I’ve created a multi-step automation that relies on a couple of scripts to link fields in various tables. I am sure there is a cleaner way to do it, but overall it works when individual records are created. However, I have realized that when I batch upload a group of new records (as will be a likely use case moving forward) I run into a script error stating that the query for selectrecords has exceeded the max of 30. I would love some help figuring out how to modify the following script. I have two tables: Contacts; Companies When a new record is found in Contacts, it is supposed to search Companies and then create a link automatically if a matching record is found. I modified a script I found elsewhere in the community. Here is what I am currently using. //Define the table and query let cmpTbl = base.getTable(“Companies”); let cmpQuery = await cmpTbl.selectReco

As you can expect, I am using a function field to manipulate a time field; two issues appeared gmt zone went crazy inside the new form field language for dates now are shown in english. Two solutions came to rescue: For issue # 1 I can use: DATETIME_FORMAT(SET_TIMEZONE({date field}, 'America/Bogota'), 'dddd, MMM D, YYYY h:mm a') for issue #2 I can use: DATETIME_FORMAT(SET_LOCALE({date field}, 'es'), 'dddd, MMM D, YYYY h:mm a') They both work perfectly INDIVIDUALLY, How can I combine these 2 formats inside one single formula.

I’m looking for a formula that can help me add the numbers 1-6 to records, looping. So: Row 1 - 1 Row 2 - 2 Row 3 - 3 Row 4 - 4 Row 5 - 5 Row 6 - 6 Row 7 - 1 Row 8 - 2 I’ve thought about using the autonumber field and then trying to extract the number 1-6 from that, but I’m genuinely at a loss.

Hello all, I am new to airtable but I feel like it has a lot of potential in order to manage my employees. What I want to achieve is fairly simple: I want a list of all my employees (easy to do) I want a list of all my worksites (easy to do) a) I want to assign my employees to certain worksites and then be able to see on a calendar which employees is available for an upcoming project. b) I want to be able to filter that calendar by employee and / or by worksites For example, Daniel is working on project 1 in September and December Roger is working on project 1 only in September but on project 2 in November and December I have an upcoming project in November and want to see which employees are free in October What would be the best way to go about successfully implementing step 3 in airtable? I found a couple of templates but they seem to be too complex for what I’m trying to accomplish. Kevin

I have a weird issue I’m not sure how to solve. I can’t seem to wrap my head around it. I have a base with three separate tabs. The first tab is for all project information, the second tab is for “due diligence” tasks, and the third tab is for billing. I’m using Zapier and linked fields to try to do the following: When a new project is created, I want to trigger the creation of a list of tasks in the due diligence tab, and then a list of billing breakdowns in the billing tab. The list of tasks and billing breakdowns is the same for each project. I’ve set it up in Zapier and I’m running into a problem. I’ve tried it two different ways. When the new record is created, I update the record so the linked field in the project tab is populated with all of the tasks. When I do this for more than one record though, it doesn’t create new records on the linked task, but instead keeps the same records, just linked to more than one project. I have it set up to group by project and then by task cat

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?