Other Questions

Question: Here is my formula: IF(AND({ITEM DESCRIPTION}),{ITEM DESCRIPTION} & " - " & {TASK TYPE} & " " & {TASK NAME} ,BLANK()) I need a - if the task name is filled in the drop down field to separate from the task type, but if the task name is blank, I don’t want the - at the end of the task type - make sense? ITEM DESCRIPTION - TASK TYPE - TASK NAME But what I don’t want is ITEM DESCRIPTION - TASK TYPE - , when the task name is blank, It would read ITEM DESCRIPTION - TASK TYPE Thank you!

I have several linking records that involve student teachers, what school they are working in, and what times they are teaching. What I want to do is compare one student’s availability with another student’s availability. I started with this: But I would like it to look something like : I thought about using a formula on my first table to create the information : ` IF(Student=“Student 1”, “Yes”, “No”) However, that returns “No” for everything. How do I set this up so that I can compare two or three students’ availability while eliminating all the extra information? For instance, if want to compare student 1 or student 3, I don’t want to see student 2’s information. (I am actually dealing with 12 students on 5 different days.)

I have 3 tables. Table 1 has data on associations (ie-condos). Its primary key is association id Table 2 has a secondary key of association ID. Table 2 has a field for meter id and meter location. and usage amount , time period etc. Table 2 is where the user will type in the usage data for the correct meter when he has the utility bill. I created a 3rd Table,also with a secondary key of Association ID. This is because for any location, the meters (and meter IDs) are replaced periodically so the meter IDs will change. Of course the meter location stays the same. Table 3 has the meter Id, meter location and date placed in service So in Table 2 I want the user to be able to select , only for his association ID, the meter location that has the most recent date of being placed in-service. Table 2 should be populated with the meter ID associated with the selected meter location. Hope this is clear. Not sure how to implement TIA

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