Ask the Community

Hi everyone,I have what I thought is a pretty straightforward scenario I'm trying to implement, but I can't for the life of me how to implement in practice. We have a Web Team and a Marketing Operations team. Each team has its own base within the same workspace. The people in the wider marketing team submit requests to the Web Team to add resources to the website through a form in the Web Team's base. Once the Web Team has done all they needed to do, the Marketing Operations team needs to somehow get a hold of the record and do their bits and then update the record with some additional information. The views for each team are slightly different and at the moment I have a synced table in each of their bases, but they're not connected. I can't seem to create an automation from a synced table, and the automation in one table can't create or update records in the synced table either. So I'm a bit stumped. Any idea how I could make this work for both teams? Thanks a lot for y

I'm trying to improve the content calendar we are using. I have a Content Field, which is the full post that we're going to copy and paste into Facebook. I'd like to have a column that will pull just the first line of the post using a formula. Any ideas on how to do this? For example, here is a post that would be in the content field:🌟 Fun-filled Learning at Ditebogo Daycare in Video Informal Settlement! These awesome educators are all about hands-on learning experiences for their kiddos. Recently, they organized a super-fun day filled with science experiments, face painting, and, wait for it... ice cream! 🍦🎨🔬Speaking of science, do you remember playing with Oobleck as a child? It's that magical goo that can be both a liquid and a solid depending on how you touch it. Now, here's the best part - Ditebogo Daycare isn't all about keeping the kids clean and tidy all the time. Nope, they believe in letting kids be kids and learn through experience! &#128

Hello, I am trying to reduce the number of clicks that need to be used print a page designer record. I have set up the new button functionality to connect to the page designer to print, but once you click on it you have to click at least on 4 different windows before sending the item to print. Is there a way to use the scripting block to automate this process for you? I don’t know much about scripting so I might need to outsource the service but ideally when clicking on the button it would automatically send to print without needing to reset the dimensions of the page designer.

Hey guys !I'm using Pabbly to automate a process of generating documents with Airtable.Thing is Pabbly is creating PDF using Google docs and transferring them to Airtable, which works really fine.However, in the attachments, while the document has the good title in the viewer, the file name itself is automatically named "UC" without any prefix.So when I send it by mail, it displays errors, because it sould be "formation - Name.pdf"Do you know where does it mess ?Thanks for the help 

I work where following up with my clients are essential. Right now I have 3 columns in the table that. I'm trying to link together using IF Formula and it's not working so looking for some help here. First column is "Last Contact Date" which is in "Date" format and next one is "Schedule follow up" which is in "multiple selection" format with 1 day, 3 days, 1 week, 2 weeks, 1 month, 2 months, 3 months 6 months, 1 year. Last column is "Next contact day" where I'm trying to use IF formula to calculate the new date for me and they give me the new date for me. So below is what I have and right now, it's keep saying N/A.Not sure where I went wrong or how to fix it. Please advise how I could fix this. Thank you so much in advance. IF({Schedule follow up}="1 Day",{Last contact date}+1,IF({Schedule follow up}="3 Days",{Lat contact date}+3,IF({Schedule follow up}="1 Week",{Lat contact date}+7,IF({Schedule follow up}="2 Weeks",{Lat contact date}+14,IF({Schedule follow up}="1 M

Hello community, I would like to add a record ID to the end of a URL using a formula field. It would look like this:https://www.movementplus.app/course-overview?recordId=Record-Id-Goes-HereCan anyone please help me achieve this?Thanks in advance!

GoalOur organization is hoping to move our annual application off of a very expensive custom third-party contractor's system (which we have to messily export CSVs from to upload to AirTable, then engage in substantial data cleaning due to issues in how the contractor's system structures data). The goal is to move the application to our org's AirTable Workspace directly. We're exploring ways to handle this smoothly, so I'll talk through the overall workflow/how things work now first and foremost, then talk about some of our initial thoughts about how to achieve this with AT, and then finally I'll talk about the things I'm not sure how to do (or if they can be done at all).Upfront, I am hopeful all this is achievable using AirTable Forms, but some things I've read elsewhere suggest that Interfaces might be a more appropriate tool. I'll use the term Forms from here on out, but answers with instructions for achieving our goals with an Interface or other built-in AT functionality are totall

Hello AT community! I have a table that automatically syncs to a Google Drive folder on regular intervals that was working until a few days ago.  Now the automatic sync fails and when I manually kick off a sync with "Sync now" I get an error message saying "Unable to sync new data". If I go to "Update sync configuration", my Google Drive source is inactive and an error message reads "Unable to sync this source. Unable to sync new data"Nothing has changed with the configuration of the Google Drive and I am able to connect to it just fine outside of AT using the same credentials.  I have tried connecting to a different Google Drive folder as a test, but I get the same error.Any advice on what else I should check to resolve this problem? The error message doesn't give me a lot of information about what could be going wrong.

Hi! I am trying to set reminders through the Slack automation when my clients have birthdays. (The day before one of my client's birthday, I get a Slack reminder to send them a gift card). However, because year has to be included in the date, I am not getting the automation to work (for example, my client's birthday was Aug 3, 1990. I can always change the year to 2023 so that the automation works, but then I would have to change it to 2024 for it to work for the following year.) I do not to see a way to omit year in this automation.  No luck from the Airtable support team. Does anyone have any ideas?  

I'm running an API POST script and I'm trying to utilize the id that is returned in the response.This is the key piece of the script. var postOptions = { method: 'POST', headers: myHeaders, body: formdata, redirect: 'follow' }; let response = await remoteFetchAsync("https://xyz.com/...", postOptions) .then(response => response.text()) .then(result => console.log(result)) .catch(error => console.log('error', error));I get this response. I'd like to then reference that id returned.CONSOLE.LOG "{"id":29644,"progress":0,"current_line":null,"status":"created","created_at":"2023-09-12T09:30:39-07:00","started_at":null,"ended_at":null,"file_url":null}"I've tried this, but I get an undefined error.console.log(response.result.id) 

Hello! I created a base automation that sends a Slack message to task assignees the day before their task deadline arrives. When I tested this automation, it fired in the middle of the night (makes sense, since this automation is date-based). Does anyone know of a way to control the time of day that a Slack message fires through a base automation?Thanks for the help!

Hi 🙂I have a formula field "TASK" that checks if there is value in fields or not.  It looks like this;IF({Fuel L}=BLANK(),CONCATENATE("• Add fuel tank", '\n')) Now, I want to have another multiple-select "CLEAR" field that clears the TASK value if the corresponding value is included in multiple select fields. For example {Fuel L} is blank, but in the CLEAR field "Fuel L" is selected. This setting should not show   "• Add fuel tank" in TASK field. I tried with FIND(), but I should use something as not FIND()... I would appreciate help to accomplish this. Thank you,Pjero

Hello.  I lead a marketing team that has enabled two-way sync between several team bases and a master base. The issue is that we aren't able to make any edits in the "master" base at all.  All changes have to be made in the supporting bases.  Now, we know from our Airtable builder session that we can't add rows in the "master", but we should be able to make adjustments to content i.e., status updates, etc. Any suggestions about how to fix this issue?  

Hi,I have 4 tables in my base:StaffGroupTeamDeliverablesThe Staff table has a linked record to determine a person's Team/Group.  The Deliverables table has a linked record to determine what staff is working on a deliverable and a lookup value to show their group & team.  The Team table has a rollup field with all Deliverable key values.  Note for complex org structure hierarchy and the need to look at what a group is doing vs what a team within a group is doing, I can't create a simple Option list in Staff with all possible Group/Team combos.I'd like to create an interface where I can see what deliverables a given Team is working on.  If I put in a record selector for the Team table, I can pick a specific team and get the list of deliverables.  However I see no way to expand the list into a record picker.If I start with a record picker and link it to the Deliverables table, I don't see a way to create a filter that restricts the options to the Teams values.

I have had a personal account for years and use it regularly to catalogue a high quantity highly importnat personal information. I opened the app yesterday and the login details no longer work, suddenlty returning the message that my email isn't associated to an active account. My account has seemingly been de-activated with no warning, no explanation, and seemingly no option to re-activate it. I wrote to airtable support to explain this very clearly and they sent me back a template email saying I should use the help centre (which I'd already tried) and declining to address the issue. I even said I'd be happy to pay to upgrade in order to regain access to my account. What is going on?

I have a zip code field and only want 6 different zip codes from over 20 different ones I have in my data source.I have successfully pulled those with the condition field use 'or'  but I also only want the ones that have an active customer  check marked.  when I place this as the 'or' field it then pulls all the other zip codes I do not want.  I am unable to place an 'and' condition successfullyI have resorted to grouping the active and inactive customers of each selected zip code but I want the inactive and active to be on separate reports (spreed sheet results) not oneWhat am I doing wrong with my condition codes? In this view, show records WhereZip code =    orZip code =    orZip code =    orZip code =    orZip code =    orZip code =    orZip code =    orZip code =  

I cannot figure out what im doing wrong.. I want to update the table "TENANTS" when the record in the table "tenants (this syncs with tenant base)" is updated. I keep getting an error on the last step "Received invalid inputs." .Any help would be appreciated!  

Hey, I want to create an automation where when a new record is created, I want to wait for 90 mins and then proceed to the next step.Is there a way of doing this with script or something else?

Hello,  I am currently building a form. It will be required to be logged in to filled it in. I can see that form says "Your email will be recorded when you submit this form." Is it possible to add this email to data set without user entering it manually?  Or to have a field email which will be auto populated by Airtable based on the logged in user, and will not be editable? Thanks 

I have a base for timesheets. I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t write down the answer as a decimal or let me format it. So my formula is -if({status}=“on”,qty,if(and({status}=“lwop”),“0.00”,if(and({status}=“rdo”),”8.00”)))And for any of those combinations it comes out like eg 9 or 9.5 for “qty”, 0 for lwop and 8 for rdo Can you help me format into same format as my other column and formula examples. 

Hello, I have a list view with multiple tabs. I would like to change the default tab to not be "All records" but another one instead. I have tried to reorder tabs (to put "All records" at the end) in order to achieve this :- I successfully managed to implement the desired behaviour on my personal account (different base / interface)- I didn't manage to do it using my current account. There is apparently no way to change default tab...Are you aware of some specific behaviour that would differ depending on account (and maybe plans). That would be very surprising but I don't find any suitable explanation regarding this discrepancy.Thank you for your help!

Check out these web clippers for Instagram’s web platform! One clips individual profile information, and the other clips individual post information. I’ve been using it to keep track of tattoo artists that I like. See the way my base is set up here! Here’s the clip action recipe for individual IG profiles: { "schemaVersion": 3, "fieldMappings": [ { "fieldName": "artist", "fieldType": "singleLineText", "defaultValue": { "type": "pageTitle", "opts": null } }, { "fieldName": "url", "fieldType": "url", "defaultValue": { "type": "pageUrl", "opts": null } }, { "fieldName": "bio", "fieldType": "multilineText", "defaultValue": { "type": "cssSelector", "opts": { "cssSelector": "div.-vDIg"

I'd like to be able to link records together in the same table, and view connections easily!In my test base, I have a table that lists different talks. Some of them reference others, so I made a "Link To Another Table" field called "MENTIONED REFERENCES". This allows for linking a record to any possible children records. But not vice versa.I want to be able to see this link when opening a child record, to check what parents records it may have.e.g. based on the above pic, if I opened Talk E, the new field should say that it is linked to - Talk D- Talk FIdeally it'd be a field that lets you click on any Linked Records too, not just text.I don't know if this is possible in Airtable. Is it possible to use a "LookUp" field? Or resort to Automation or scripting? Haven't had a successful result yet.Here's a mock-up of what I'd like to have. (done in Microsoft Paint :P)Any advice would be appreciated! 

 I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula.  However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR.  I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either. IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD') any suggestions on what to try next?

Hi,I have a base that includes a text field where users may share malicious URLs. I want the URLs in the field, but I don't want them to be hyperlinks - as I don't want our team clicking on them by mistake. Is there an easy way to remove URLs being clickable from a text field?