Other Questions

Hi, everyone! I am working on the creation of a Recruitment Tracker, I’ve added the columns that are going to be filled by my boss, however, that information needs to be broken down per participant. For example, my boss would add that they need 5 salespeople. I need to find a way for it to show a record per position required (5 records in this case) with all the other information that was already submitted, but I’m not sure how to do it. Have any of you encountered the same need / problem? Thanks in advance!

Hello, I need some basic button scripting help if anyone is willing (at least I think it’s basic). I have two tables: Customers (parent table with all information related to the customer) ContactLog (child table showing all of the past interactions with the customer). In the ContactLog table I have the following relevant fields: CustomerID (linked record field type back to the Customers table) DateContacted (Date field type) ContactType (single select with options such as “Call”, “Email”, and “Text”) ContactResult (single select with options such as “Voicemail”, “No Answer”, and “Answered”) Notes (long text field type). Whenever we interact with a customer we add it to their contact log so that we have visibility across the company on conversations with customers. An example would be in the record for customer John Smith I add a linked record from him to a new record in the contact log with the DateContacted (8/11/2022), ContactType (Call), and ContactResult (Voicemail). I a

If you create a template in Airtable Universe and someone signs up and registers with Airtable for the first time because of your template, do you receive referral attribution for this new user sign up? I think this would be fair, and a great incentive for users to create ultra high quality templates and then publicly promote them on their social media, courses, marketing, email signatures, etc…

Just a small thing, but the change your password flow is a bit odd. If I see two boxes, I expect the first to be ‘current password’ (for validation) and the second to be ‘new password’. Either that, or they’re both ‘new password’ with the second as a confirmation. Airtable has it backwards! ‘New password’ then ‘current password’. This is odd, and caused me to go in circles. Of course I could just be an idiot but this could be a lot clearer.

Hi Airtable community! I have a base structure where: The first table is a list of email projects linked to a second table of tasks The second table contains all the tasks for the email projects in the first table, grouped into “send” dates A third table with a template of email tasks that are the same for each email project I’ve implemented a script so I can generate the email template tasks with the click of a button within the first projects table: let projectsT = base.getTable('Marketing Projects'); let tasksT = base.getTable('Project & Individual Tasks'); let taskTemplateT = base.getTable('Email Task Template'); let project = await input.recordAsync('Pick a project', projectsT); if (project) { output.text(`You picked ${project.getCellValueAsString('Name')}`); output.text(`Creating tasks for ${project.getCellValueAsString('Name')} ... please wait`); let taskTemplateQ = await taskTemplateT.selectRecordsAsync(); let projectTasks = []; for (let task of ta

I have been able to implement the script that sorts linked records by A-Z/Z-A or by if the field name itself has a number 1-10/10-1. What I really want to be able to do is go one step deeper and sort by an ‘order number’ that is in the linked record itself. Can anyone point me in the right direction? For reference, I am using an automation to bring in records that are in order on another table - but even in order, the automation doesn’t bring them in the full order in which they are in the linked table for some reason.

Hello Airtable Community, Does anyone have experience with Airtable and accessibility? Is Airtable accessible to visually impaired users who use a screenreader, magnifier, refreshable braille, or other technology to interact? I’ve done a search and don’t see anything in the community except a link to a thread that’s been archived. Any guidance is appreciated. ~ Aaron

I already managed to make a postal code based lead distribution to specific agents. My challenge now is to work with credits and subtract 1 credit from every agent who received a lead. Does somebody have any idea how to fix this?

:wave: Greetings! I’m a long-time Airtable user and have created an airtable application to manage micro-communities we call Villages in Seattle and Boise. :chart_with_upwards_trend: The Organization: We are launching our nonprofit this month (VillageCo.org) with a mission to provide tools and support for teams to organize micro-communities in their workplaces, neighborhoods, and families. Our platform will be free and offered on the Airtable store. :question: The Ask: We need help with our platform! Could you donate some time as a volunteer to help us out? Our platform committee meets every two weeks to review assignments and discuss issues. :page_facing_up: The Project: We’d like to bring the platform to a beta version that includes some documentation. As we’ve already iterated the product several times, there are many older fields, views, etc. that need to be removed. We also have a list of feature adds & tweaks that we need help implementing. As our target user

I am trying to retrieve data with pagination, but its not returning the value. export default async function fetchData() { let data = [] base('table-name-here') .select({ pageSize: 3, view: 'Grid view', }) .eachPage( function page(records, fetchNextPage) { data = [...data, ...records] // fetchNextPage(); console.log(data) // this shows result as expected return data // this doesn't work }, function done(err) { if (err) { console.error(err) return } } ) } when I call this function from frontend I can see the values from console.log statement, but it doesn’t return the data array.

Hi, I was wondering, is there a way to know when someone precisely has open an email sent by automation? Thank you!

Hello- I am trying to add in a concatenate formula in here that when the drop down is selected as in APPROVED FOR PRE-PRO, THE STATUS IN FORMULA WILL READ PRE-PRO-APPROVED FOR PRE-PRO not just PRE-PRO. SWITCH( {PRE-PRESS STATUS}, ‘APPROVED FOR PRE-PRO’, ‘PRE-PRO’, ‘’, SWITCH( {FINAL PROOFING STATUS}, ‘APPROVED FOR PRE-PRESS’, ‘PRE-PRESS’, ‘’, SWITCH( {SUBMITTAL STATUS}, ‘APPROVED FOR FINAL PROOFING’, ‘FINAL PROOFING’, ‘’, SWITCH( {DESIGN STATUS}, 'APPROVED FOR SUBMITTAL', 'SUBMITTAL', '', SWITCH( {PROJECT STATUS}, 'APPROVED FOR DESIGN', 'DESIGN', '' ), 'DESIGN' ), ‘SUBMITTAL’ ), ‘FINAL PROOFING’ ), ‘PRE-PRESS’ )

Is there a problem using a formula field in another formula field ? I have 2 calculated fields that I want to derive from 2 number fields. The 2 raw number fields are {Seeds per g} and {Plan2023}. I derive an {adjusted Plan} field using 1.1*{Plan2023}. I then want to derive the {wt of seeds required} field using {adjusted plan} /{Seeds per g} but this gives an error for every record. Even if I make the {wt of seeds required} formula something really simple like {adjusted plan}/2 or 0.5*{adjusted plan} it gives all errors. I can make the formula just = {adjusted plan} but as soon as I do any numeric operation on it it gives errors.

For the past week or so, when I update the category of a record in my Kanban view, the record no longer automatically moves itself to the new category that I assigned it to. It still remains under the old category. If I manually refresh the page, it shows up in the correct category, but only after I manually refresh the page. This used to update on my Kanban view automatically. Is this a known bug?

(Sorry if this is wrong group, but I found no other more suitable for this very basic question.) The questions really says it all. With the desktop Airtable app, are databases stored on the local computer (Mac, in my case) or only online?

Hi all - any suggestions out there for best way to do periodic (e.g. monthly or quarterly reporting) for an investment portfolio where things like cost, value would change from period to period, as would additions/deletions to the company records? I am referring to the data (not the visualization/reporting) of the data. Would I need to duplicate the base and simply have a series of bases, each for a different period? thanks!!

I have a list of URLs that I pulled from GA that I want to pull into my publishing process that’s tracked in Airtable. I have every piece of content on the site contained within its own card in Airtable and part of the card data is the URL. Is there a way I can take the whole list of URLs from GA and search for all of them at once? I want to use that function to quickly pull the cards I need into an August content plan. I know I could find each corresponding card one by one, but it would be nice if I could find them all at once and then flag them all for the August content plan in one swoop.

Hello, Airtable hivemind! :slightly_smiling_face: I want to embed a table view from my base within an announcement post in a private Facebook group/community. The Airtable part is easy, it’s finding info about how to make it work at the Facebook end - or whether embedding an iframe in a post is actually possible - that I’m having trouble with. Rather than get even more dazed and confused exploring Facebook for devs (as a non-dev!), I’m hoping the much less daunting Airtable community can help. Many TIA for any wisdom! :pray:

I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to be GMT. I don’t see a way to correct this because switching the datetime field to GMT for all collaborators produces bogus times that cannot be used for local dates. Is there an operator to add in the formula that corrects the glitch from the source datetime field, or is there a way to “lock-in” the time in the base so that GMT doesn’t muck things up?

I have requirement where I need to make link between two tables based on some conditions through code , Is this possible ?

In Filemaker I was able to set my field names to list alphabetically or in creation order or in custom order. Is there a way for me to have my field names list alphabetically?

I’m using a “record review” layout in interface designer to allow our team to review categories assigned to objects. I can’t seem to make the category field editable in the interface, even though I have no trouble with this for other fields. I’m wondering if you just can’t do that for lookup fields? Background: We have a table with all the items in our system. We also have a form that allows our wider team (who do not have airtable accounts) to assign categories to those items, then a lookup field in the main table to display those category assignments. We want the internal team to be able to use an interface to approve and, if needed, revise the category assignments. I am hoping that the interface can display all the items in the main table, whether they’ve been assigned categories or not, so I picked the record review layout and connected it to the main item table. I can display the category field (which is a lookup field connected to the form table), but I can’t make it editable. An

Hi everyone, I’m working on a table where there are two checkbox fields (yes and no) for each record (employee). I would like to track the total number checked on each checkbox field from all the records. So the total amount of yes and no selected by the employees. There are 100 records (employees) in total. Does anyone have a way to achieve this? Thanks for the help! -S

I saw that there was no solution to this in early 2021 (Is there a way to check if a script is run from a button field or the script app itself?). How about now?

Hi everyone! I’ve been building a calculator for B2B price quotes in Airtable. The idea is to put all the necessary info in a form and then display the end result. Since Airtable cannot add formula fields to a form, I’ve made a simple 2-page web app in Softr. The first page is the form, the second one displays the result. This is where the issue is: I cannot set up that the second page will pull up the result from the same record as the input on the first page. Has anybody else done something similar? I’m also not married to Softr, perhaps there’s a better way of doing this.