Other Questions

Hi! I Created a Date field and used a formula field to output the day of the week because I’m hoping to get an output that reads something like, “Saturday, August 20, 2022” – When I use the concatenate function, the date formula changes from Friendly to ISO with time added. Time was not enabled on the date field. Is there some other workaround to get what I’m looking for? Thanks in advance!

Hello! I am interested in creating a Master Calendar that will allow individual freelance staff to access the calendar and input their availability dates. Each person can only be able to see their information, not the information another freelance individual has entered. I then want to be able to see all entries in my Master Calendar. Does anyone know how to do this? This will need to be a calendar they can access at any time to input or update their personal information. What is the best way for them to access it and for me to remind them to update on say a weekly basis? Thank you! I cannot seem to find specifics on this.

My goal is to detect overlapping usage of a resource on the same date and provide information of the respective overlapping record. For example: 2022-08-04-Resource1 User1 → Show User2 2022-08-04-Resource1 User2 → Show User1 I’m using an adapted version of the mark duplicate script to link records that share a matching string with each other and look/roll up information from the respective other. That worked fine until the growing dataset started causing script timeout issues (60s). Recently @Justin_Barrett taught me how to use REGEX extract. I thought to instead create a roll-up on the resouce and REGEX extract the records string out of it. Unfortunately, it wil

Hi! I’m using the Pivot Table extension to summarize my expenses per category/month. It works a treat: Better yet, when I click on the values on my table it shows me the records related to that specific value (the expenses related to that category/month). Almost perfect, but the information shown on the right side is not really helpful. I’d love to be able to see custom information like the Amount and Payee (both are columns on my table) in the summary of each record. I understand Airtable is choosing the info that gets displayed because they are the values used on the pivot table, but they are repeated and not very helpful. Is there a way to choose what gets shown there? Thank you!

Hello! Looking for help or to find out if this is actually possible. I am looking to pull numbers from a row in table A and paste it in table B in one current field. So in other words I want to transpose a row from table A into table B, If that is possible. Thank you in Advance

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 c

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 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, v

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.