Solved

I’ve set up a base that tracks a specific team’s incoming trouble Tickets. The main Tickets table has a single-select field for Status, which can be ‘Submitted’, ‘Needs further details’, ‘Queued’, ‘In Progress’, or ‘Done’. I’m now working on reporting and management would like to know the full time it takes for ticket resolution, but also how long a ticket remains in each status before progressing.I can’t decide which of these approaches would be preferable: Have an automation create a new linked record in a Reporting table with a time stamp when a ticket is created, and then create an additional new linked record on the Reporting table for each subsequent Status update. Then I’d need to do a little more work to compile all of the records on the Reporting table that link to each Ticket (I’m assuming via a bunch of rollup fields). I’m hoping that stamp can also include the name of the Status that’s being recorded Have an automation create a new linked record in a Reporting table with a

I have a calendar viewI set it to show a checkbox field outsideBut it is seen as text, not as a V markAttached is an image  

Is there a supported way to update Script Extension code using an API? For example, have scripts stored in a GitHub repository, built using GitHub Actions, and then deployed to Airtable. Currently, my team have just been manually copying and pasting code they build locally onto Airtable, which leaves a pretty large hole for human error (even ignoring the tedium of such a task).I have a horrible workaround that I may use if necessary:/** * Fetches and executes the JavaScript file at the provided `path`. * This can be thought of like: * * ```js * await import(path); * ``` * * Except this bypasses CORS and directly injects the remote code. * Wildly unsafe. * * @param {string} path */async function fetchAndRun(path) { const response = await fetch(path); const text = await response.text(); eval(text);}const myExternalCode = "https://gist.githubusercontent.com/ZacHarroldPartum/fa0f6b6e707c8de3edf725ea0747bba3/raw/2f2fd47a248e8c3954727755ad35ac00193ef113/hello_world.js";await fetc

I am using the new form builder and want to filter the values of a dropdown field, Product, based on the value of another field, Designer, on the same form.Although I found the "filter records by a condition" option, I cannot see a way to use the Designer field's value as the condition for the filter. Any help appreciated.

I’ve set up a marketing base and part of what I’m using it for is creating UTM parameters. There are a few fields that are inputted via form, like campaign name and start date. Each of those has a secondary field in the base where the data from the first is made lowercase, special characters and spaces are removed, etc. Then those reformatted fields are all concatenated together into one field called ‘Calculated UTMs’. As is standard with UTMs, several of those different sections are separated by underscores.I’ve set up an automated email to send these generated UTMs to someone on our GA team, and I’m pulling in the ‘Calculated UTMs’ field, but it’s displaying the final UTMs incorrectly - instead of showing with the underscores, it’s removing them and using them as indicators of where to make the text italicized. The field is also shown in an interface, and the underscores are correct there. I’ve tried using asterisks and backslashes around that field name in my automation, but it’s no

I’ve built a custom scripting extension that I intend to launch from a record button, send that record’s ID to the extension, and execute my script. I configured the button to launch my extension, which it does, but I can’t seem to get it to register the ID of the record clicked. I’ve tried using both useRecordActionData and registerRecordActionDataCallback, the latter example can be found below:function CheckAvailability() { const [recordActionData, setRecordActionData] = useState(null); const callback = useCallback((data) => { console.log('Record action received', data); setRecordActionData(data); }, []) useEffect(() => { const unsubscribe = registerRecordActionDataCallback((data) => { console.log('Record action received:', data); if (data && data.recordId) { console.log(`Button pressed on record: ${data.recordId}`); // Process data here } else { console.error('No recordId found in actio

Hello, I am filtering out a view based on the value of a “single line text” field in which I search for a specific substring (E.G. “Backrow”) although I got presented also the records in which there is the same word but with different casing (“BackRow) and I don’t want that.Am I missing something or the filtering for “single line text” is actually case insensitive? If so, is there any workaround?Thanks in advanceFrancesco

Beginner here, first post - certainly not the last.  What I am needing seems like it should be simple, but the solution is evading me.What I'm looking to implement is a way to find the total number of rows (volunteers) from table A and write that into table B once a week so I can track the total number of volunteers over time.I have linked both tables but no matter what field I try to run the COUNTALL on, the result always seems to come back a 1.  Ideally, I'd like to use an automation so that this total is pushed to the history table once per week.  Sure could use some help here.TIA,Dan 

Hi community, I recently had to solve the situation where I needed to get URLs from hyperlinks stored in rich text formatted long text fields and put them in another long text field. Essentially, just showing the URL, not the hyperlinked text. I ended up adapting the "Convert attachments to URLs" script (posted by Alex Wolfe). I had found a post here, that used a regex expression but this seemed to only work for visible URLs. I never could get it to work for my use case. I'd love feedback on what I could have done differently/better as I'm sure I haven't thought of everything... or even may have just completely missed something obvious. Thanks!// Script settings - Click the gear icon for the Scripting app to surface these anytime // Surfaces options to select the table, view, and fields needed in the script let config = input.config({ title: '🔗 Extract URLs from hyperlinks', description: 'Extracts URLs from hyperlinks stored in Long Text fields with rich text

hello i want to make symptom and medicine database. where i select multiple symptome and common medicine shows. i have done relationship, but how to get common answer of multiple symptoms medicine . plz guide

Hi all,Seeing lots of posts from 2021 and 2022 about an inability to print from Airtable. When I go to print either a record review interface, or from the page designer, the generated PDF is an absolute mess.A lot of the posts say Airtable are working on it, so hoping that in the 2 or 3 years that progress has been made, or a work around solution has been found?If not, is it fair to conclude that printing from Airtable requires an external app and to factor those costs in when assessing costs for Airtable?Thank you,Ryan

Howdy all, I promise I really have looked at exisitng topics but there is information overload. Ideally I would like ot use ODBC driver to connect to AT to Windows via ODBC driver, I found several but they are all expensive subscriptions.  It seems AT may have its own ODBC driver now??  But I can’t find it anywhere in the AT documentation. What is the best extension or method to use data from multiple tables within a base, fill in essentially form letters WITHOUT using the extensions that you have to put the information boxes on the template.   The data I have for the body of the “letters” is sometimes several pages and I can’t find an extension that doesn’t chop off the rest of the text once it goes beyond the bottom of the information box or window we placed in the page setup.  We are printing the letters to PDF. Any suggestions for something that would act as “mailmerge” or is an annual ODBC sub to CCData or Devart the best way to go?? Thanks!!!

Hi All,I want to create a tennis league and publish it on my webstite which I created in Webflow. The database is to be dynamic, information will be added using a airtable form. There will be 16 players in the league and they will play each others. The goal is to get the current league table and ranking. On the page I want to display the results of all the players' matches (example - 6:2 3:6 7:5), the current position and the amount of points collected so far. Has anyone had a chance to do something similar? Thanks for any help and have a nice day 🙂

I have used SOFTR + AirTable to build a project management portal for my customers. The primary purpose of this portal is to have a common place for my customers to enter information that will be used in the video projects we build for them, so my customers must be able to login with a user (client) account. When onboarding a customer I need to create 3 records:The athlete record, which operates like the “company” record in a CRM The User account record which is a user in the softr platform The project record which is where the customer work will get done. It is linked to the athlete record and the user account record.The softr user table is sync’d/linked to a table in airtable called users.  Generally, I assume it is normal for the softr user accounts (clients) to be created using the softr studio interface. However, since I need to create ALL THREE records each time, I built an admin page in my softr app that contains each of these airtable tables, so I can create the requisite recor

Hello AT community,I am seeking advice, general or specific, on achieving frictionless label printing for employees using our base.Our current setup is fully functional, but the process is clunky for users. We have Dymo LabelWriter 4XL's set up at various stations, and we have labels designed in Page Designer. Our receiving station, for example, has a Receiving Interface, and labels need to be created for everything we receive.To print a label, the user has to click a button in the grid element of the interface for the line just received, which redirects them to the record in the underlying base (already a bad situation), then click a button that takes them to page designer, then click 'print' 3 or 4 times to get a label to come out.My background is in warehouse distribution, where our purpose-built warehouse management software would simply print a label as soon as something is received, that is the level of functionality we want to mimic, or come close to.So we are looking at 3rd par

Hi! I’m building an internal interface for my team to manage tasks. While I love the clean look of Interfaces, it’s frustrating that we can’t manually reorder records (drag-and-drop) within a list or table.In the base view, we can reorder records manually, but in Interfaces we’re stuck with sorting rules or creation order, and new records always go to the bottom.For teams using Interfaces to manage workflows (without exposing the full base), this feature would be incredibly helpful.Are there any plans to enable manual ordering or drag-and-drop within Interfaces in the near future?Thanks!

Anyone else have issues with numbered lists in long text boxes in their forms?For a numbered list I would expect: But I’m getting this:  

What does this mean?"cannot assign list of object to collection of complex types"I can't select any field values. And how do I make it so I can select it.  

Hi,I want to ask for Ideas to optimize AI Attachment Analyze workflowMy files are named with random group of chars.I created a table, where Attachment uploaded to ‘File’ field. There is AI field READ that analyze content of Attachment, and outputs a few parameters needed to categorize.For Example, it’s ‘Doc Number’, ‘pages’, ‘City’ ‘Doc date’, ‘Summary’. City is single-select. After AI filled this data, automation triggered, that puts each data in respective fieldThen formula field ‘New filename’ generates name according to this data.Then automation launched by ‘New filename’ renames a file and puts it to ‘Document’ field(i suppose that each record has 1 file only, if more, it gets only with first in cell. it’s OK)it all works OK, but since I don’t need 2 doc fields, I changed Automation so it renames file and puts back into the same ‘File’ field . But this triggers AI again.  AI gets the same data so nothing changes after that. But I don’t like that it makes second run. It’s not just

Ante todo, mucha gracias 🙏necesito que se cree un registro nuevo y se grabe de forma automática el correo electrónico de la tabla “usuarios” al campo email de otra tabla “test clientes” y no hay forma. Se crea el registro nuevo en la tabla pero no muestra el campo email. Me podrías ayudar.mil gracias 

Good afternoon,I'm trying to use Airtable automations to send an email to folks through my Gmail account. Airtable is directly connected to my Gmail account. The emails send successfully, but the problem is that when the email shows up in the recipients' inboxes, the sender name is just my first name in all lower case (e.g., "matt"), but I'm sending it on behalf of an organization. This is unprofessional and isn't what I'm trying to communicate to my recipients. So my question is:How can I change the "Sender" on these emails when using Airtable Automations to send emails through my Gmail account?I already confirmed my Gmail settings, my Google account settings, etc. Honestly, it looks like it's just pulling the info from my email address (e.g., "matt" from "matt@company.com").Surely there's a way around this???TIA,ML  

Bit of a messy title, I couldn’t think of a good way to phrase this question…I have a table that stores inventory items, each item can have one of three status’ “Available”, “Gifted” or “Sold”. I’m trying to create a view that only returns the name of an item where there are none with a status of Available. So for example the view shouldn’t return this item:But it should return this one Is this possible to achieve and if so, how?

I am reaching out here in desperation because the “contact support” feature in Airtable does not work at all in my workspace, across multiple browsers and devices. Firstly, my “Team” plan workspace has a base, and my base has a form. It is the only form present in the base.After the recent UI update, that form is not visible in the “Forms” tab on the top middle. The system pretends that my base doesn’t have any forms.However, I can still access the form via my bookmarked public link. Additionally, I can submit the form and it successfully will add a record to my base.I need to edit this form, but it is currently not possible to access the edit page of the form. Normally, I would reach out to Support about this. However, when I click the “?” icon on the bottom left and then select “Message Support”, it opens up a blank white rectangle on the bottom right of the screen that does nothing.I know from experience that this should be a chatbot interface. But instead, it is a blank white box t

Howdy, We recently turned on AI for our AirTable Workspace and I am impressed so far! It makes one-off questions easier to answer. For instance, the AI clearly answered my questions with an interactive display of the records. Very cool! The example above is a question that is more than a one-off question. This is something that I both want to run repeatedly AND use the found records to perform a scripted action. I am not yet familiar with AirTable scripting and hoped that perhaps AirTable AI could give me a head start. Unfortunately, I could not figure out how to properly ask AirTable AI to describe how my question could be turned into a the start of a script.  My question for the AirTable community is: If I have a question that I want to be able to run repeatedly (and/or take additional steps for a scripting extension or automation), can I use AirTable AI to help give me a head start for that script?

Hello friends , iam a noob airtable user , i’m in charge of a table that recieves data from an api in json format , the output is all in one line , so when i try to extract a value from a key using regex it does not work (it shows error) unless i use a website or manually fix the indentations and beautify the json text . is there anyway to fix this issue using formulas or some extension that iam not aware of ? Thank you