Ask the Community

I am trying out Norton Secure VPN. I encountered two problems. Neither of these occurred with my previous VPN (NordVPN). I have a table with a single field that is “single line text.” The table is sorted on that field and “keep sorted” is selected. When I added a new entry, it was not sorted into place, but rather stayed as the final entry in the table. When I tried to input a new entry in a more complex table via a form, a blank entry was added, without all the information that I entered on the form. Has anybody else experienced these problems, possibly with a different VPN? Thanks, Hershel

I am using ArrayUnique(values) as in a rollup field and then referencing this in a make.com scenario to output to a Word document. This works, but the output is a bit unfriendly.Products Acer_Vero B7_B227Q,Acer_Vero B7_B277,Acer_Vero B7_B247Y  I have tried changing the formula in the rollup field to something like ARRAYUNIQUE(values)&" - " but it has no effect.Is there a way to format the output to make it a little more readable - the ideal would be separate lines. EDIT: I have found how to add spaces etc usingARRAYJOIN(ARRAYUNIQUE(values), ', ')but is there any chance of adding a newline character (13) ?

For context, monitoring product listings on Amazon.I have 4 tables:Brands, with a lookup field to ASINs, from CatalogCatalog (containing ASINs), with a lookup field to OffersOffers, showing every offer on each ASIN, where each offer has a Seller ID, a lookup from Storefront Profiles.Storefront Profiles: Contains Seller ID.I'm trying to count, at Brand-level, the number of unique sellers associated with their ASINs. I've tried all sorts of counts and lookups, but can't get the right number. Either counting, duplicates, spaces.So far I have:In Catalog: A linked record to Offers, showing all offers per ASIN, with a lookup to show the active sellers.In Brand: A linked record to Catalog, showing all ASINs per brand, with lookups to show the offers and active sellers.Brand - 'Active sellers' - shows unduplicated sellers. Using COUNT(ARRAYUNIQUE({Active Sellers})) in a formula gives me 0.In Brand: 'Sellers' - A rollup of Active sellers using ARRAYUNIQUE(ARRAYFLATTEN(Active Sellers))

Greetings devs! First post here after doing a bit of googling to no avail… I’m looking for an example of how to upload a zip archive to an attachment field. In the documentation there is mention of attachment objects but no mention of how to create one pro-grammatically. Any sample code or general guidance would be helpful regardless of language although Python would be greatly appreciated! Cheers, Jean

I am trying to write a formula field that will summarize the responses of three separate single select fields (Prototype 1 Cost Status, Prototype 2 Cost Status, and Prototype 3 Costing Status) so my costing team can have an idea of what proportion of the current prototype stage is "Meeting Target" or "Not Meeting Target". I'm finding this difficult because if we move from Prototype 1 to Prototype 2, we will need the response from Prototype 2 to override the response for Prototype 1 (as shown in the attached png) and so on for Prototype 3. This is what I have been able to draft so far: IF(  AND( {P1 Cost Status} = BLANK(),    {P2 Cost Status} = BLANK(),    {P2 Cost Status} = BLANK(), BLANK()IF(  AND( {P1 Cost Status} = "Green - Meeting or Exceeding Target",    {P2 Cost Status} = "Green - Meeting or Exceeding Target",    {P2 Cost Status} = "Green - Meeting or Exceeding Target", "Meeting Target")IF(  AND(

Is it clear to anyone if a team of 7 for example, can pool all of their Airtable AI credits together and use them even if it is just one user who is pressing "Generate" each time? I have read all of the documentation + reached out to Support and they have not yet answered this seemingly easy question.My guess would be that you could but want to make sure before we put into production.  

Hi,I have a formula that currently works 90% of the time which finds the number of days between a date range for a given month. The issue is, when the end date, ends in the month I am looking for, example below Oct the formula is correct (row 1, 3 and 4 in the image below). However, when the end date includes BUT does not end in the given month (example: row 2 or 5 in the image below) I get 30 days. I want it to show as 31 days because the date range is inclusive of Oct 2024. Any suggestions? Here is the formula,IF(AND({Start Date}, {End Date}),IF(AND({Start Date} <= DATETIME_PARSE("10/31/2024"),{End Date} >= DATETIME_PARSE("10/01/2024")),DATETIME_DIFF(DATETIME_PARSE(MIN(VALUE(DATETIME_FORMAT({End Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/31/2024"), "X"))), "X"),DATETIME_PARSE(MAX(VALUE(DATETIME_FORMAT({Start Date}, "X")), VALUE(DATETIME_FORMAT(DATETIME_PARSE("10/01/2024"), "X"))), "X"),"days") + (MONTH({End Date}) = 10),0)) 

Hello,I'm looking for a way or formula to set the records vertical within a cell as I show you in the attached image. Bests,L

Hey guys,I am trying to calculate out hours for our personnel worked on projects each day. We only have the start and end dates of projects, we were not tracking hours individually so this'll be a rough estimate at the end of the day. Here what I'm working with:Project Tracker table: This is the hub for all the project information including the start date and end date for each project. It links to the personnel table through a crew linked field.Personnel table: Contains all the information about a person.What I'm looking for:I need to calculate from a persons allotted 8 hours how many hours were worked on each project for each day. These hours will be split evenly to total 8 hours. The final numbers would show us:- Person total hours per project- Project Total hours from all personnelHere's a visual of what I'm thinking (not how it would look in airtable) Hopefully this makes sense. Please let me know if anyone has any idea on how to accomplish this.Thanks!

Hello community,I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.Is it there a formula or a scripting that can help me have some structure like in the attached image?Thanks!Leandro

Hi,I am new to Airtable.I am trying to create a simple form. In which, I have a multiple-select field.I want to pop up a text input box, when "Others" is selected from among the choices. How do I achieve that condition?

Dear allCould somebody tell me how to extend the height of row header in Airtable.Thanks alot

I am looking up a field from another table but it comes in as a text value. I would like it to be clickable like the linked fields so I can jump directly to the record. Any ideas how to do that?

Test

Hi everyone,I'm pretty basic with Airtable, but have been using it for years.I have created this base with an interface that explores the New Zealand Maths curriculum. I now have a resources page, which is fed by a form so that teachers can submit resources to support areas of the curriculum. What I am wanting is a way to show specific resources based on the current record that they are looking at on the MATHS interface page, ie, filter the resources page to match what the current user is looking at.Can I add a button to do this, or include the filtered resources in the actual math record? I don't want to individually have to do this for each record, some way of doing it globally/dynamic would be great.

I have an automation email that I am trying to include a personalised fallout form link inside the html of the email. The other html features like the header image as well as the dynamic link to pull in first name works. this is the code for the personalised link. Access Your AccountPlease don't hesitate to contact me if you have any questions or need assistance.  <a href=" invoice link "> December Invoice </a>(see attached image of true setup)  Invoice Link works as expected when I click it from the table. What happens when I send a preview of this is that is links back to the airtable base. Invoice Link is a formula, so I thought that was the issue, and duplicated it into a single line text filed and got the same result. Any hints on how to correct this?Eric 

I've shared a Read-Only link to an interface with a coworker but when he tries to access the interface he gets a message that says "Unable to request access to interface". He tried deleting his account and recreating it, but he's still getting the same message. I can't see any reason why he wouldn't have access. I even got an email about the $10 credit I received when he joined. Why can't he access the interface? I'm on the Team plan, in case that matters. I've got roughly 18 collaborators, most of whom are read-only. Thanks,Kelsey

Hello, we have had 422 errors in our integrations suddenly, when trying in post man everything works correctly but from the VB.NET application the same record gives error 422, this is happening in several integrations from different databasesEdit: for now all api integrations are working fine, check yours

I learned that we can do employee surveys by creating a form view. We’ve got a number of questions added to the forms, but there are other questions I’m considering. I don’t yet want to put them in the form. Is there a way for me to add a sort of note-to-self in a form view to remind that, “hey, here are a couple of additional questions you might want to consider?” If I was looking at a grid view, I’d just type those in a cell.

Hi all! Is there a way to remove these in forms AirTable Favicon AirTable URL (create a custom one?) Change the submit button color I’m trying to create brand consistency and these items above are making it difficult! Thanks :slightly_smiling_face:

Hello- Under the PRO plan, it has a check mark next to it that says custom branded forms - “Customize with your logo and brand, remove Airtable logo”. Where do you do this? Thanks! Scott

Hello everyone,I have a complex use case that I would like to implement in Airtable.I have a table “Projects” where projects can be created via a form. Among other things, the form must specify how the project affects our strategic goals. So we have 6 fields with strategic objectives where the user can rate 1-10. “Strategic Objective A”, ‘Strategic Objective B’ etc.Now these strategic objectives can change from year to year. However, I would like to know for each project on the basis of which objectives we defined the prioritization at the start of the project.I would therefore create another table where the objectives are recorded annually and the prioritization of the objectives is recorded in another field.Now I would like my interface (project overview) to display the objectives/priorities for each project that were defined at the start of the project, even if our general strategic objectives have changed in the meantime. How would you set up the base and create the  link

Is there a way to customize / change the favicon and / or the AIRTABLE URL! Screen Shot 2020-05-18 at 3.01.49 PM|690x236

Hi I am trying to figure out how to remove the NaN value when the formula is 0/0I need it to reflect 0.  I have tried IF() and IF(And( formula's but I cant seem to get it to work current formula is {Surveys Recieved-MGR}/{# of Managers} Does anyone have any solutions?Thanks !

Hi Airtable Community!Problem: I'm having trouble adding a linked record to multiple records without erasing the data that is already in the cell.ContextI've got one table of studies, and another table of people. Each person can be linked to any number of studies in a "Contacted" field. Sometimes that field is empty, if that person hasn't been contacted yet, and sometimes it has a few linked records (studies) in there already.If I contact 50 people, I want to add the study I contacted them for to their record. If I copy/paste the study to the cell, this overwrites the existing data , so if there were 3 studies in there to start, I'll erase them if I paste in the new study. What I triedI made a field that concatenates the study name I'm adding with the study names already in the "contacted" field, and it comes out as text. If I then paste the text into the "contacted" field, voila, I have all of the records, or so I thought! Turns out this just makes NEW duplicate records of all of