Solved

I need a formula to verify a single-line text field only contains productId's separated by commas with <=30 comma separated productId's.OK: <=30 comma separated 8-character productIdsNot OK: >30 productId's; <8 or >8 character productId's, not comma separatedexample (with 5 comma separated productId's)correct: B0D5FHXP,B0D86NWH,BCVPRWY7,DRKM1T5G,GK3DHGH9incorrect:7 productId's: B0D5FHXP,B0D86NWH,BCVPRWY7,DRKM1T5G,GK3DHGH9,H4VPMWY7,MRKM1Y6F5 productId's with missing commas: B0D5FHXP B0D86NWH BCVPRWY7 DRKM1T5G GK3DHGH97 productId's with semi-colons: B0D5FHXP;B0D86NWH;BCVPRWY7;DRKM1T5G;GK3DHGH9 

Hi there,I have a team of account executives and I'm trying to rollup the amount of revenue each person manages during a 12-month period. Revenue is generated on a per project basis. Each project has a start and end date and a monthly retainer fee, which are recorded in the project's record in my project table. I have a formula field ("Project Value") that calculates the total project value.I maintain a second team member table and I link account executives to the projects they manage using a linked record field. Some projects are managed by two account executives (and are linked to two account executive records as a result).The problem is that when I rollup the amount of revenue each person manages during a 12-month period, for projects that have two account executives attached, the rollup attributes 100% of the project revenue to both of the employees linked (rather than 50% to each). Can anyone point me towards a solution? Many thanks.   

Hi All,I'm migrating from Smartsheet to Airtable for Project Management and one thing that I am struggling with, that we rely heavily on for project management, is date / task dependencies. Setting this up in Smartsheet is easy and intuitive, requiring no formulas.Desired workflow:I want to set the Start Date, the Duration and task Dependency so that, if the Duration or Date(s) of a task change, the downstream tasks, as denoted in the Dependency field, will auto-magically update. I have reviewed this video several times and it makes sense and seems easy, but when I configure my fields following the instructions in the video, it does not work as expected.Set up:Table has a Duration, Start Date, End Date and Dependency fields.Dependencies are enabled and set up like the following:The table looks like the following:Expectation:In the Table image above, I would expect that, since the 'Get PB' task is dependent on the 'Get Bread' task, Start Date for 'Get PB' will begin  on 12/28/

Hi,I have a formula that almost works. I'm trying to make my primary field a formula where it looks at "Column A" and looks at "Column B". If a there's a value in "Column A", enter that value as the primary field. If there's a value in "Column B", enter that value in the primary filed. If there's a value in both "Column A" and "Column B", combine those two values and place a "/" between the two fields. The formula I have looks like this: IF(AND({Column A} != BLANK(), {Column B} != BLANK()), CONCATENATE({Column A}, "/", {Column B}),IF(Column A != BLANK(), {Column A}, {Column B})) This does work. However this formula is adding the "/" character to the beginning of "Column A" and at the end of "Column B" when there's only one value in one of the fields. The results look something like this:If there's a value in "Column A" but not in "Column B":12345/75326/23457/ If there's a value in "Column B" but not in "Column A":/93664/30483/54214 I tried r

Hey Airtable Community,I have a list of tasks, and I group them by project (which is a separate table). I also have a field in the project table, specifically a progress field, and I’d like to display this field alongside the grouped tasks in the interface.I remember I've done it before and I even have a screenshot I attach below. But I can't remember how it's done!Any help or pointers would be greatly appreciated!Thanks in advance!

Hi, How can I add multiple rows at once in a table. (This is a function that is super easy in google spreadsheet). AT only allows for one row at a time and I have to keep clicking on the Plus sign. Too much work. I wanna add 100 rows at once. Is that possible?

Hello,I'm learning how to pre-fill a form.  I really like it but it would be even better if I could prefill a form entry with multiple values/entries from another linked record.  Currently, it is only pre-filling the first value of cell.  The linked record in this formula is the Residents Column.I need them to stay selectable values, not text.  I can't expect the users to enter the text values exactly as they are written in the linked records. "https://airtable.com/---/form?"& "prefill_Job=" & ENCODE_URL_COMPONENT({Job})& "&prefill_Order=" & ENCODE_URL_COMPONENT({Order})& "&prefill_Teams=" & ENCODE_URL_COMPONENT({Teams})& "&prefill_Residents=" & ENCODE_URL_COMPONENT({Residents})& "&prefill_Description=" & ENCODE_URL_COMPONENT({Description})

Maybe this question has already been answered. However, I search for it and found nothing.I'm a new user. Is there a way to make kanban boards more colorful like adding background colors? It seems that kanban boards are mostly black text on a white background when using Airtable on the web. It would be easier on the eyes if the white background could be changed to another color of my choosing. I'd also like to change background colors for each category and each task if possible.Thanks.

When I linked field data from table A into the field on table B, I noticed that there were fields that created automatically on table A. that linked with table B. How can I stop this action? I only want data from table A to show in table B. Thank you : ))

I am using a formula to calculate a date in one field, and then trying to use another formula field to determine whether a contract is current, future, or expired using that date and another manually entered date field.  The field I'm using to determine if the range returns the wrong results if I use the calculated expiration date field, but if I use a manually entered field with that same date, the calculated range returns correctly.   ExpDate:DATETIME_FORMAT( DATEADD( DATEADD( LIC__EffDate, {Term (Mo)}, "months"),-1, 'DAYS'), 'M/DD/YYYY') ContractRange:IF(   ExpDate > TODAY(),   IF(   LIC__EffDate > TODAY(),    "Future",   "Current"),   "Expired"   ) ContractRange copy:IF(   LIC_ExpDate > TODAY(),   IF(   LIC__EffDate > TODAY(),    "Fut

Hello!I would like to tag some records based on the text content in a column (ie: if Title contains "Tour" tag Tours). Feels like it should be pretty straightforward but I can't figure out how? Thanks! For more context: I imported all of my team's events from Outlook and realized Airtable doesn't support the "Category" feature, so I want to add tags to these events so that we can break down the data. I figured I could probably do that based on title or other key words.  Thanks in advance!

When our students graduate they want to preserve the information that's in their Airtables. What is the recommended way to do this? I'm pretty sure there's an Excel plug-in that would allow them to dump everything into Excel and preserve it as a local file. Are there any other recommendations? Or is there a way to maintain access to their Airtables in perpetuity? On a related note, what happens to the students' accounts once they graduate? 

Is there a foolproof way to do this? I use CTRL-X and CTRL-V, but sometimes it works and sometimes it doesn't...and it may depend on whether the columns and views are arranged the same way between the source and target tables. 

Hi there, I think this question has been asked in other threads - but I didn’t find a straight answer to that. Is it possible to share an org chart app extension outside Airtable? I can’t find a way or workaround to do so - only downloading it as a pdf. It would be amazing to be able to have the same browsing experience (zoom in and out, collapse sections and so forth) but in a sharable link to be used somewhere else. PD: also adding a legend or some text would be nice too :slightly_smiling_face:

Hi there. I am trying to write a formula ("Duration of Pending Repayment") that calculates how long an unpaid repayment is overdue.Essentially, it will be:If "Repayment Due Date" is not blankAnd "Repayment Received Date" is blankThen calculate Today-Repayment Due date. This part I got with DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')I cannot figure out how to do the If/And with blanks, not blanks. Any ideas, wizards? 🤓 Thank you in advance!  PS - Here's how the formula currently reads:IF(AND(NOT({Repayment Due Date})),{Invoice Issue Date},DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')) 

I am using fixed for my rescheduling logic for date dependencies in my project management base. The primary reason I am using fixed is I need to be able to create buffers between dependent tasks (i.e. tasks with predecessors). Let's say task A is request a copy of bill from provider and task B is review bill.  I know that task A takes minimal time so I set it to start today and give it a duration of 1 day. Task B is also pretty straightforward and takes one day so I also set its duration for one day BUT it takes up to 30 days to receive a copy of the bill and it's out of our control so I want task b to start 30 days after task A ends. In the timeline view addressing this is pretty simple. I just define a buffer value for the dependency of task a and b.The challenge I am having is that when creating a project using a record template I can add the task A and B along with making task A a predecessor to task B thus enabling automatic calculation of task B's start date b

Hi 🙂I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.Here is the picture from the table I want to retrieve the content from.I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. So every time ITEM = ITEM LV it should the update.The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.I setup the automation like this but it finds no records.Tks for the help

I have an automation that once an attachment field is not empty, it creates a new record in a different base with that attachment and a few other fields.Is there a way, that if the attachment field has more than 1 file, it will create a new record for each one of those files?

It would be incredibly useful if the Slack integration could send a message to a person pulled from a field in a table.As it stands, when using the Slack integration in an automation you have to choose (hardcode) the person(s) or channel(s) you want to send the message to.Use case: I have a table that syncs issues from a ticketing system. Each record has an "assignee" field. When a new record enters a view I want a Slack message sent to the person in the assignee field.

I have a table with a date field, an I want to link these dates to another table, but group them by month. This is so I can create rollups for monthly financial figures. I have tried to create an automation to auto fill in another field, using the date as its source and then converting the format to mmmm yyyy, from the usual dd/mm/yy. I then linked this field to the other table, but now the automation does not update it even if it runs successfully.Can anyone help solve this issue?

Hi there,I think I already know the answer to this but thought that I should ask. Is there a way for a user who has filled out a public form to edit the data that they submitted in the past? For example. If I have a form that invites people to provide information about their product which they do, is there a way for me to allow them in the future to "Edit" that information later if the price of description of the product changes?Thanks in advance. S

Hi, I'm relatively new to Airtable - still enjoying learning how to build neat things with it!I've noticed that when I'm testing my Airtable forms, my browser doesn't pop up the usual menu of autofill options for things like my name, email, address, etc. as usual. Is Airtable blocking this somehow? Can I un-block that? It certainly makes testing slower but more importantly, autofill helps users accurately enter common information, saving them time and reducing typos and other common errors. Example screenshot attached - starting to type my name doesn't offer to fill out the rest like it does on just about every other form on the web 🙃I searched Google and this community before posting but found almost nothing mentioning this, but got a lot of unrelated things since "Autofill" is often discussed in relation to formulxs [sic] etc. Sorry if this has already been asked.Thanks!-Chris

Hello,I'm trying to build a form where my team can submit a PTO request.I set two date fields, one for date when they want to start their PTO and one for their return date.So I would like to set the return date field to be after the start date.Is there any way to disallow people from entering the same or earlier date as their return date than their start date? I don't really mind how it's done (ie. pop up message, greying out any dates on or prior to the start date on the calendar), but just a way so that people won't be able to proceed to submit their request unless they put a date after their start date as the return date.Any input would be appreciated. Thanks!

Hi,The Typeform extension in Airtable is repeatedly failing to connect (screenshots at the bottom of this post). I have written multiple emails to Airtable Support but the responses are vague and not very helpful so far.I want to create a Typeform that pulls data from certain fields in Airtable, and displays that data as options for certain selection-based questions in my form. This is a less popular use case than simply sending Typeform data to Airtable, which is the focus of most other threads in the Support portal, in this community, and other third-party forums.Can someone quickly help solve this / suggest the best way forward? I click Accept on this page: but keep landing on this page instead of seeing a successful connection. 

Hello, I am attempting to create a “email merge” document template using Airtable that allows me to: Use rich text formatting (bold, bullets, etc. for email formatting), and Use reference fields in the text (for example “Hello {First Name}, your User Name is {User Name} and your Password is {Password}.” If I try to do this in Page Designer, I can do #2, but not #1 that I know of. If I try to do this in a Long Text Field, I can do #1, but not #2 that I know of. Any ideas? Thanks, ML