Ask the Community

I'm in the process of building my base for my business (I'm a literary agent) - I've recently discovered how useful views are and now have a much better sense of what I'm doing but I have a query and I'm wondering if there's a better way to set this up or if I really just have to duplicate these fields (I'm asking because i've seen a couple of posts that say you shouldn't ever have to duplicate fields...)So, my primary filed are the titles of each book under my agency. I then have views for the marketing info, the primary contract (in my case, UK) info etc.The two elements I'm struggling with are:1) Tracking international deals where there will be several countries which will each then need the same fields so that I can track for instance the contract info from the US, Germany, France etc - other than the language, the info I'll need to pull from each contract will have the same field headings. I could make this a separate table - but I'd really like the financial info to pull through

Good morning, does anyone know how to properly get the Bot Icon to work with Slack?The instructions are: "The name of an emoji available to your team (wrapped in :) or a URL."I typed in various emoji's, with iterations of : around the emoji, spacing it out, adding in ' around the emoji, etc.Can't get it to work.

When creating a custom workflow within Slack - the workflow builder fails.The 'Select a record' action returns the following: "Sorry, there was a problem trying to add your step."Even if I use a SEARCH query such as {Project Name} = 'Adelaide Street' like I would do in Integromat.Is this a slack problem or an Airtable problem?

I am willing to pay for the project if someone is able to show me how/set up the scenario relating to the following...I am trying to create a report from one of my records. The record has multiple fields with multiple linked records I want to display in one document. It's important the the document is also downloaded in word, so edits can be made if needed. I have make.com, zapier accounts.Page designer is able to accomplish the basic design I am looking for ( I have shown a picture below), but I am now wanting to automate this with a checkbox. I understand this can be done in make.com however I do not have experience with JSON (which I believe you need).I am willing to pay for the project is someone is able to show me how/set up the scenario 

How do I make a formula that turns a number into itself and all the previous numbers?I.E. the number in the field is 8The formula should turn the field into:1, 2, 3, 4, 5, 6, 7, 8Please help!!! Thank you 🙂

Using Gmail for sending emails through automations, has anyone managed to insert a checker that then tells you if the email was opened, viewed, correctly received, etc.?

I want to create an IF formula that converts a single select to a multiple select.For example, in column 1 I want the value 'Primary Care Physician' to turn into a multiple selection of 'Internal Medicine Physician' and 'Family Medicine Physician'. It seems like the default formula output is a single line text, but is there any way to convert it to a multiple select list so that the data is actually stored in a list format? 

Hi all,I've had some questions from my (project managers in higher ed) team regarding the brand new Date Dependencies feature, which overall is a big help and a good replacement for my previous formula field workaround.When updating predecessor dates to complete earlier than originally expected, dependencies do not shift earlier. Is there a way to make dependent start dates sticky to the predecessor's end date? Our current workaround after updating the task's duration is to delete all task start and end dates and start again with task #1's start date. Similarly, when adding a new task in the middle of a timeline, we've found that adding the task duration and adding predecessor links does not trigger cascading dates unless that task's new end date overlaps with its dependent.We're also interested in support for dependent tasks starting on the parent task's end date rather than the day after -- it doesn't look like this is supported within date dependencies.

Hello, fellow Airtable Fans! Has anyone figured out how to wrap text inside a day in Calendar view? I have long entries that must be viewed on a calendar. Thank you, kindly.

Hello AT Community, I am trying to write a formula that returns the number of years and days in between two dates. So for example, assuming {DoB} is 18 FEB 1994, DATETIME_DIFF(TODAY(),DoB,'years'),"y ") returns 30 which is correct.I would also like to calculate the number of remaining days i.e. between the last full year (18 FEB 2024 and today). The answer should be 14 however this extract from my Airtable formula (MOD(DATETIME_DIFF(TODAY(),DoB,'days'),365),"d"))) is returning 21.Can anyone tell me what I am doing wrong please?

Hi, I have multiple views of Timesheet data i.e. one View for each Employee.How can I email or send or export the respective View for each employee to that Employee please?ThanksKalpesh 

Hi All,I have one table containing Timesheets and have then created multiple Views of this i.e. one for each employee - how can I extract or export the sum of 1 column from each View please.This is so that I can create a summary of Time to Pay for each Employee.ThanksKalps 

Hello Community,I have to change Workspace Collaborators in the Organization, to Base Collaborators. Anyone knows if by doing this it triggers any billable change? Will Airtable charge us again now that they are Base Collabs? Thanks!

Hi all,I have previously used an integration between JotForm and Airtable to populate Airtable with submissions from a JotForm form. The integration was working fine as of last night; however, this morning, I made an edit to the JotForm form and now Airtable is not populating with any new submissions. I tried creating a brand new form and reintegrating the two platforms with a brand new table to see if the issue was specifically with my previous form or table, but the new form submissions aren't showing up in the new table submissions, either.Any guidance here would be appreciated! Thank you 🙂

Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.At the moment, I have this:  IF( AND( {Ind Doc}!=BLANK(), DATETIME_DIFF( NOW(),{Record Created}, "days" ) >13, DATETIME_DIFF( NOW(),{Record Created}, "days" ) <30), "YES", "NO" ) This works, but ignores the first parameter and returns "YES" even for records that have an attachment in {Ind Doc}(Sorry if syntax for the multi-line formula is incorrect, I'm only just starting to learn to write formulas like this)! 🙂 

Hi,I've got a scenario i'm trying to solve with the interfaces... To give you some background information: i'm working a a project which involves taking care of incoming documents: tag them with info like sender, assign them to the correct project and type of document (bill or letter), amount to pay, etcI created a table called "Document", a table called "Sender" and a table called "Project".The document table has a column "Sender", which refers to the linked table "Sender"The document table also has a column "Project", which refers to the linked table "Project"I created an interface which has a record view on the document table, which filters all "untagged" documents.When you click on a document from the record view... fill in the sender and the project... one should see a list of recent documents that have the same sender and project... in order to detect potential doubles (=same document sent twice). Is this doable with the current interface?So in short: I select a document, i

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Text column, so that the Long Text column will ahve clean but editable data for future use? While I can copy and past some smaller data sets, when I tried to copy and paste this column, I get a 'too large' error.

Hi. Is there a way to change the size of this element? It has resizing handles but I can’t get them to do anything. Thanks.

I have a base for many social accounts. I created a column in the base for emails. Records will have multiple email addresses (that I want to put inside the field for a record thats being created) for the main email providers - Google, Yahoo, Outlook, Webmail. Is there a way have many fields inside the cell labeled with the email providers (label1: Google label2: Yahoo, etc.) that I can input the email address for the record? The only way I see how to do this is to use the long text field type and just type everything in it. Please see snaapshot.

I have a table from the Strategic Planning base I am synching to a table in the Marketing base.I created an automation to create a record in the Requests table of the Marketing base when a record in the synched table contains certain data.  This is working brilliantly.However, if someone changes a field in the Strategic Planning base (i.e. due date) base, and the date is updated on the synched table in the Marketing base, I want the data to update on the Requests table too.  I cannot seem to configure the update record automation correctly.Help!!! 

Hello dear community. I’m starting to learn to use iOS shortcuts and watched a couple of YouTube tutorials and I’m trying to run a basic post function but this error shows up: {“error”:{“type”:“INVALID_REQUEST_UNKNOWN”,“message”:“Invalid request: parameter validation failed. Check your request data.”}} I created a blank document and just wanted to input a new field data. I copied the URL from de Airtable API and also I copy the API key. This is how I typed the ‘code’: I’ll appreciate any help with this simple starter use of integration with iOS shortcuts.

Hello!I'm trying to automate my email workflow using Airtable, but I'm encountering a limitation as I use AWS Workmail for my email service. Currently, it appears Airtable only offers built-in integrations with Gmail and Outlook.Is it possible to connect Airtable to AWS Workmail using the IMAP protocol, similar to how it integrates with Microsoft Exchange? This would allow me to automate emails directly from Airtable.I'd greatly appreciate any guidance or workarounds you could offer to establish this connection between Airtable and AWS Workmail.Thank you for your time and assistance.

Hi, I'm Planning to buy an enterprise plan, in some of cases i need to share my base to my clients which are paid for team plan, if i shared my base as an editor do i have to pay for them also.?Please confirm.   Thanks.Vinoth

We have a rather large table that needs to be updated/inserted with a datefield value from another table. This needs to be done only once.Table 1 is about 30K records.Table 2 is about 120 records.Table 1 (that needs to be updated) is linked to Table 2. I'm pretty sure there is a rather simple solution to this conundrum but I can't figure it out.

Hi, I was wondering if airtable offers securing a particular table in a base using a password. I want to use the table to store tokens and hence want it to have restricted access.  Any other suggestions on how tokens of third party services like Box can be secured safely in airtable?  ThanksChandrika