Solved

Hello, I would like to integrate an Airtable workspace to QuickBooks Desktop (2021), not online. I need automate the creation of multiple sales receipts. Does anyone know how to set up this integration?

Hi,I've seen issues opened about this two months ago but we're experiencing this issue now.I tried leaving the script for an hour and the state doesn't change, though if I run a test of the automation, everything works. The status page shows there are no incidents.I've also tried creating a new automation that only runs the following script and it still gets stuck -   

Hey GuysI have a dynamic datefield (updates thru automations) that begins from todays date and records 10 days ahead. Is there a way to write a formulafield that ranks the date with numbers 1-10, i.e so todays date is 1 and tomorrow 2 and so on? I could use that info for navigation in an app.Thank you in advance.Jesper

I am trying to combine the lists in two different single select lists into one.  I'm not trying to concat the fields.  Combine the lists together somehow.

The open url button field you can create always opens a new tab, and i don't want it to do that, is there any way i can modify the formula so it doesn't open a new tab? I can make a script field instead that stops this but i really don't want to spend any more time on this.

I have an automation that generates an email.In some cases the fields I want to include in the email are not set yet.I want to add a conditional statement to the email composition, something like "If {name} is set, include {name} followed by a comma, otherwise skip straight to the text." I can't see a way to do this in the automations interface.I know that I can add fields to the table to do this but I'm trying to figure out whether there is a way to handle this logic temporarily within the automation.  

This is my first post so please bear with me. I have a base that I am using to track content and for project management of a newsletter. Table 1 Newsletter shows the newsletter project and has fields for Month, Year, Content (which is a linked record field), Content Attachment, and a checkbox for completed. Table 2 is where I am tracking content based on 8 common sections, month, year, content attachment, point person, notes, and content created checkbox.  I have an automation set up that when Content Created in Table 2 Content is checked it updates the Table 1 Content multilinked records. When I update more than one Content Created in Table 2 Content it only overwrites the other content in Table 1 Newsletter instead of just adding the subsequent linked record. Once all 8 Content Areas are in that field, an email is triggered to several people saying all the content is complete and is ready to go in the template for the newsletter. Is there a way to have the automation u

Hello, trying to set an advanced filter and it's not working.  Thinking I'm perhaps missing something obvious?  Looking to filter for projects that I'm working on and which are not "done" or "abandoned" or blank in their status.  See screenshots of my filter and what is currently displaying on the base (currently still showing done/abandoned items).  Thanks for tips/suggestions!Alex  

Have a base that looks at deal flow, including anticipated close date and value of each deal.  While we can easily view our "pipeline" at any time, struggling to figure out a way to store that snapshot of data on a routine basis.  We don't store updates to pipeline as a record itself, but update the record to the anticipated value.  At the end of a specific month in the past, what did our pipeline look like in terms of deal value, grouped by when we expect it to close?  Used to look at accuracy (anticipated vs actual) of our project pipeline projections.   

I need help in linking four tables in Airtable with automation. Our art group publishes monthly shows where our members showcase their works. To streamline the process, I have created four tables in Airtable, namely Venues, Shows, Members, and Exhibitions.The Venues table contains information on the places where members have previously exhibited their works. The Shows table tracks the shows entered by the members, with each show tied to a particular venue. We also have a Members table that includes all the members who can enter data into Airtable. Lastly, the Exhibitions table allows members to enter their current shows.I have created a form under the Exhibition table. If a member enters a show that is already in Airtable, they only need to enter their name and find the show in list. If the show is new but in an existing venue, they can enter show information. And if the show is in a new venue, they need to enter both show and venue information.I have not been able to link the Shows ta

Hey all!Currently, I have a client database with start date {start} and finish date {finish} fields.Once I have added a finish date, I then manually update the {status} field from 'In Progress' to 'Done' - it is a single-select field).However, I'd like to automate the above process, meaning I'd like to automate the following:If {finish} is not empty (meaning a date has been selected and the project has been completed), change the {Status} field from 'In Progress' to 'Done'I've attempted to do this but the automation comes back as an error.I look forward to hearing any ideas!

Hello everyone! Thank you for taking the time to review my question. I am using the Airtable “Find Record” automation feature to find records based on certain conditions. Once the feature finds multiple records, it selects the “Top” or “First” record that meets the condition criteria. I am trying to have it randomly select from the results, rather than default selecting the same record that was on top or first. Does anyone know the direction to look in or the process to make this possible? Thank you kindly in advance!

For the last 20 hours, I have not been able to access Airtable through the MacOS Desktop App.  Out of nowhere, the pages are all broken as if the CSS is not working.  I only see broken text.I uninstalled, reinstalled.  Reloaded pages, nothing.Anyone have insights?

Hello all!As the subject suggests, I am trying to fill in blank cells under a certain column with "N/A" when a form input leaves the column blank. This is so that when I create an automated email, instead of "the part is     ", the recipient will receive "the part is N/A." I have tried to run an automation with when I change the status of the form input, a conditional record update will trigger but only if it is empty. However, I keep getting a testing error. Does anyone have insight into this? Thanks!

I have a membership base in which I want members to review and update their data with a Form.I have a formula field which opens the form with  pre-filled recordsI created an automation to find records in a viewAnd then used Send an email to send form to users to fill upThis send one email to 3 users for 3 pre filled formsHow can I send 3 emails, one for each member with corresponding pre-filled form?  Eventually, I would like to send about 200 emails.Thank you, Myrna

Hi everyone!I am currently setting up a database to calculate how long a project has been active.This means I'd like a formula that calculates the difference between (a) the start and finish dates or (b) the start and current date (if a finish date has not been specified).I know of formulas that can do either of the needed functions, but not one that is conditional and selects which calculation is appropriate for each project. Hopefully someone might be able to help me out? Thanks again!

I need to duplicate an interface but i can only can duplicate a view inside the same interface, is there a way to duplicate the whole interfaace?

I have tried a ton of suggestions but I am not figuring this out.  And I thought it would be a simple auto-parsing formula.I have an interface that allows our team to enter a new task/call record into our task tracking base (see pic below)I have a field that is Date-Time field that when an entry is created, the person adding the entry (through an interface) selects the current day/time when they start the task. (There is a lot of behind the scenes processing that happens with this information)I want to be able to auto-populate a Date only field based on what was entered in the Date-Time field. Right now the Date and Month field are manually updated by the person filling out the entry.  (I want to remove this manual set of steps)I also want the Month field to auto-populate the Month field - so again we can present the what happened in the month (Closed, Open, Pending tasks)Reasons: We can have dashboards and the DB Views that organize/present what happened on each da

In my automations under action types, I see that the run script option is not available. Two questions:What can scripts do? Are they for example capable of making HTTP requests? And what scripting language is supported?Why is this action not available? All the way down the list there are a few integrations that are unavailable because I need to upgrade to pro or enterprise, as the icon clearly indicates. This doesn't seem to be the case for scripts? 

I have three tables: Projects, People, Contracts.When a request for a new Project is submitted, multiple People are added to the 'Talent' field.I would like to create an Automation that then creates a new Contract for each of the People allocated as Talent.Thank you in advance. I hope I've explained that sufficiently, I'm new to Airtable! 

Hello All,After discovering Airtable through a colleague in a similar area, my office has been using it to manage temporary staffing. Despite the trend towards (and admitted usefulness of) low-code and no-code third party solutions, I am lucky to have a formal computer science background and as such have found the ability to weave varying levels of hard code into my organization's platform in a way that (mostly) integrates well with extant declarative tools and elements uniquely useful.Getting to the actual issue at hand, I am putting together a solution through an instance of the scripting app to run on the press of a button that takes select fields from the input record, concatenates them into a large string, and hashes them into a (semi)unique password to be used in a separate email validation process.Collision is a non-issue and the hash has no need to be cryptographically secure, but it is important that the resulting value, which is stored in a plain text field, remain immut

Hello,I am interacting with AirTable Template to learn: https://www.airtable.com/universe/exph2Hba4WdowOR1X/ux-research-insights-database?explore=trueI experience the challenge while grouping by multi-select field. I end up with different combinations of groups containing the same value.For e.g. I do have: "Audio", "Audio + Audio", "Audio + Onboarding" (please see screenshot).I would like to have "Audio" as one group and "Onboarding" as 2nd group. I am fine with the fact that they will contain exact same record.I understand the relations between the tables, however can someone guide me how to build it in a different way, so that I can have "unique" Groups? I still would like to use multi select (not single select).Cheers,Karo 

Hello Everyone,TLDR:  Can I populate the {to} field in the "send an email" action with a conditional list of email addresses?I have a user accounts table with typical user account stuff (name, email address, etc.).  In that table there is a single select field to describe each user's role within our org. I would like to send an automated email to everyone who matches a specific user role when certain record triggers fire.  I.e.  "When a record is updated, send this email to all users with the role of {team leader}".The list of users will not be static over time.  Thus, I need automation to read the record data at the time the trigger fires, and fetch the appropriate email addresses for inclusion into the email {to} field.We are on a pro account.  TIA

I have a column that has a list of counties and they all have the state abbreviations next to them. Is there a way to remove the abbreviations with a formula inside of airtable? 

Dear friends, I need again your help.I am creating a database in which I will add information about patients with a specific disease. In a main table, I will summarise the most relevant information about each patient, and each row will correspond to a patient (record) with a specific ID number. In another table called "visits" I will add data about all the outpatients visits (each per row with a specific date). Each patient on the first table can have more than 1 visit but each visit can be associated only with 1 specific patient. I correctly linked the 2 tables, and now in the main table, I can see all the visits for each patient. What I need to do now is to visualise in a field of the main table specific information contained in a specific field of the "visits" table. In detail, I need to visualize the status of the disease in the most recent visit of that specific patient (disease-free, progression, regression). I tried creating a rollup field and using the formula MAX(values)