Solved

I am from a company selling STEM supplies to schools. I have three tables:A “Material List” table with a list of materials we have in inventory An “Activity List” table with a list of our STEM activities. Each activity has a linked record field which is populated with linked records in the “Material List” table   An “Activity Material” junction table with the quantities of each material for each activity listed.  Desired Outcome of the Script:I’ve written a script that is intended to: Retrieve an activity record from the "Activity List" table using a passed record ID, whenever the list of linked Material records is changed. Get the linked materials for that activity. Compare the linked materials with existing records in the "Activity Materials" table. Delete outdated records of materials no longer linked to the activity. Create new records for materials that are newly linked to the activity, including setting the Activity and Material fields with appropriate record references

I would like to monitor when anyone changes certain field configurations (e.g. changes the field type, or edits a drop-down selection or similar) so that downstream dependencies can be adjusted or the change can be rolled back. The field manager seems helpful but doesn't seem to be proactive enough for this purpose.

Hi everyone! I'm trying to create automations such as emails and Slack messages to send reminders to my team to update certain projects (records) in a project management interface. When we were using data mode, I simply linked to the Record URL in the body of the message in the automation. Is there a way to link to a specific project/record in the record review layout? Or perhaps in the record summary layout?Here's a link to the video I sent to customer support. I haven't heard back from them and they suggested posting here. https://www.loom.com/share/d6166031e85e47afaf7e1311866f7b88thanks! Megan

I do not get Function Field as a choice in customize field selection- I get Number, Date, etc. Thanks.

Hello, I’m trying to wrap the text in linked fields but I can’t figure out how to do so. In the example below, the Name and the Doc Gap Descriptions fields are linked. In the original field, where the field type is Long Text, the text wraps and is fully visible. In the linked field, the text is cut off rather than wrapped. How do I display wrapped text here? I tried seeing if wrapping would happen in a printout using the print option of “Wrap long text onto additional lines as needed,” but that doesn’t wrap the linked text either. Thanks, Erik

I have a doozy of a formula problem and would LOVE some help. My base has a DATE field called {RR Actual Start Date} and a DATE field called {RR Complete Date}. Date format for both fields is Local (M/DD/YYYY). Default is off, Include time is off, Display time zone is off.I created a FORMULA field called {RR Time to Complete} in which I calculate the difference between the {RR Actual Start Date} and the {RR Complete Date}. All worked fine (and I’ll explain more below) until I tried to create a Rollup to average the values in the {RR Time to Complete} column and kept getting a NaN error no matter what.Here’s the detail:{RR Time to Complete} in holds this formula:IF(OR({RR Actual Start Date}=BLANK(), {RR Complete Date}=BLANK()), 0, IF({Raw_RR_Diff}<1, 1, {Raw_RR_Diff})). The output is formatted as Number with no presets and zero decimal places.The {Raw_RR_Diff} field is a FORMULA column that contains DATETIME_DIFF({RR Complete Date}, {RR Actual Start Date}, ‘days’). It is also formatt

We have an intake form to generate URLs with UTMs parameters. I have created a new form with additional functionality. During testing, I need both the old and new forms to work.My current Formula field concatenates the URL (Root Link) with the UTM parameters and values. There is also a check to determine if the URL provided in the Root Link field contains a "?". If it does, then the concatenation output is handled differently:IF(FIND("?", {Root Link})=0,{Root Link}&{Source Parameter}&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input},{Root Link}&"&utm_source="&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input})My new form has the option to create some additional link types based on content. If you choose that option, the

Hi guys,The easiest explanation of my problem is this:I have an orders table and I have a “Tags” field in that table (multi select) - one of the tags is “Awaiting Payment” When a customer pays, a team member will remove this tag. When this happens, we want to automatically leave a note in our Notes table.We already create notes automatically in other automations so are confident with that part, but the trigger is more of an issue?I’m thinking that maybe I need a “Tags Previous State” field to copy to?Not really sure, I appreciate any insight anyone can offer. 

Currently in airtable we have each project as a line item, and we have multiple columns that note milestone dates:Brief Start DateKick-off DateIn Market DateOut of Market DateIs there a way to create a gantt view (either in the base or in an interface) where each project bar is segments to show the different working phases of the project using the milestone dates above to create the segments?

I created a database but not the way it is suppose to be, so now I created one with the same fields but it is relational now as i did not know how to build one. So, now I need to move all the data into the new one. Can someone tell me how, i saw something about syncing but I cant find a way to do it. thanksRose

Hello,We run a residential real estate sales business and have our office lead interface set up with the “current user” permission level. We’re encountering an issue where users in teams (e.g., lead agents, co-agents, and admins) can’t view and manage leads assigned to other team members, even though it's relevant to all parties involved.For example, we assign leads to the main sales agent, but if the agent is out of the office, we want to allow their co-agent or admin to view and accept the lead on their behalf. The team members currently get notified of new leads via and automation where they are cc’d into an email, but they currently can’t access, accept or manage the lead in the agent's interface as its only visible to the lead agent.Is there a way to set up team-based user permissions, or link team members one another so they can access each other’s data without creating separate interfaces for each agent or team? For reference, we are on the Enterprise Scale plan, so we should ha

Hi 👋How can I get the average of the top/bottom 20%? For example, I have this table:Name | Sales Sabrina | $10 John | $5 Maria | $20 Ann | $100 Ben | $5 Sabrina | $10 John | $5 Maria | $20 Ann | $50 Ben | $1I want to see:Top 20% (average sales from top 20% sales): $75Average: $23Bottom 20% (average sales from lowest 20% sales): $3 Thanks!

Am i missing something?  I prompted omni to make a new dashboard page with a custom element to view my rental inventory in the netflix style (like we were shown in the announcement zoom).  I asked it to create each row by the ‘type’ field and to show certain data when hovering over the thumbnail.  Maybe that part was too big a request…It created a standard gallery view of all my stuff…  Nothing really ‘custom’ about it.Anyone have success building custom elements with omni?

I’ve got a base with an “Event Finished” formula field that works like this:IF(DATETIME_DIFF({End}, NOW()) < 0, TRUE(), FALSE())It resolves into a checkbox, and I use it to filter out finished events from admin list views. My base currently sees about ~15-20ish events a day, which have times attached, and the folks that need to monitor the views have told me they find it really annoying when finished events aren’t filtered out of a given list view.And it works fine! I could be using IS_AFTER rather than DATETIME_DIFF, but otherwise, it does the job. However, I know NOW is a function to avoid. Its inaccuracies aren’t a big deal to me (if the formula clears out an event 15 minutes later than it should have, that’s not the end of the world), but its computational cost is becoming more of an issue. I assume NOW continues to recompute for every record, even those that are well beyond completed at this point. I’m trying to optimize things so NOW gets called less, so here are some question

Hi Must say that the pre fill form app that @kuovonne wrote is extremely useful. Thanks for taking the time to write it!! Airtable Prefilled Forms - Apps - Airtable Marketplace Prefill forms with field values on Airtable with the Prefilled Forms app. Quick question though. Some of my text fields are VERY long with formatting etc. is that still going to work when being sent via a query string? Seems to so far but I would hate it to break.

I have created an automation that sends an email with text and numbers. The numbers are pulled from two dynamic fields. One field is a percentage and the other field is a currency. However, the percentage and currency formats aren’t making it over to the email (sent by Airtable). Looking for input on how to format the numbers into percentage and USD currency. 

Airtable Community, I am looking for AI use cases for Project Management. We at Kalypso use Airtable primarily for Project Delivery. We manage health reports, Stakeholders, Assumptions, Schedule, RAID, Scope, Deliverables, Meetings, Etc. Most of the AI use cases I have seen demonstrated are more Marketing focused. I am looking at the AI Plays for “Operations” and some of those are helpful. I am hopeful others in this community have found or innovated for Project Management, or “Operations” use cases, to benefit from AI and are open to share. Regards,Jason Knighten

Background: I have a feed that inserts data into an Airtable base using the API. Sometimes the feed inserts non-printing characters into one of the fields.Specifically, it inserts the UTF-8 Byte Order Mark (BOM), EF BB BF, in the middle of a string. The field it gets inserted into is a URL field.The BOM isn’t visible in Airtable, but when we try to use the link, we get 404 because of the %EF%BB%BF in the middle of the link.For example, the link as displayed in Airtable would be something like “https://community.airtable.com/topic/2341”, but what is actually stored is “https://community.airtable.com/topic/%EF%BB%BF2341” . Searching for %EF%BB%BF in Airtable using filters or automations gives no results.Question: How can I search for and remove the BOM from field values where it appears?

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