Other Questions

hi is anyone here using Resource Planning - Airtable Universe this one as a base? I am playing around with it but dont understand certain things how is Planning (Globals) tab used? I am trying to see how much are certain resources available in given week - how do I do that? How can i assign resource to a project but for a partly duration? i.e. if the project is 1 months but one resource only needs to be assigned for 2 weeks? Thank you for your help!

Hello - I’m a Recruiter and use Airtable to keep track of candidate interview processes etc, but how do I add a second process to an existing candidate without duplicating the candidate record? For example, I have a candidate interviewing with 1 company but now she’s interviewing with a 2nd company, how can I add that row without putting the candidate details in again?

Hi, Is it the way to change a record from “Single Select Column” (EG.: going from record “YES” to record “NO”) in bulk action after selecting all lines needed to be update ? I have like 100 records to change and want to avoid having to do it one by one. Thanks

Hi All, I am testing if airtable will work better than excel. I have a “helper” column in my table that concatenates data from three other columns (ex: “date”&“city”&“person”). I would like to be able to use this helper to lookup data from another table (there are a finite number of “helper” strings, so the lookup table lists all of them and the corresponding return data). So I can use formula to create the string in the current table but when I change it to a link reference the concatenate formula disappears. Is there a work around? Can a column be both linked and be populated with a formula? Thanks! Please let me know if you need more info Art

Printing 500 pages takes houres!!!

(topic withdrawn by author, will be automatically deleted in 1 hour unless flagged)

Hi all I created a bunch of bases and invited collaborators to these and I now have to create 10 more bases that need the same collaborators. Is there an easy way to add these existing people to the new bases without having to invite them again? Thanks Claire

I got a bunch of values fro each collaborator in my base which I need to summarise pr month. Down the ‘Y-Axis’ I got my collaborators. My problem is I can’t get the ‘X-Axis’ - the month name to sort properly (see below). Ideally I just want the month name showing, but it seems I can only sort those in alphabetical order. Then I tried to add the month number to the month name in the hope it’ll sort on the month number, but as you can see December for some reason comes between July and September. Is there no way that I can just sort the month names from Jan → Dec?

Which video file types are supported for attachments? When I upload a “.mov” file, and I view it, it says it’s unsupported and I can’t view the video. I can only download it. But with “.mp4” it’s fine.

Hi All, I am currently working on leave submissions for the company I work for and I am trying to set up auto emails for approved leave. Currently I have all the information in however, when it is anyone apart from me getting approved I am getting an input error? Anyone know what I’m doing wrong? Thanks for the help! JA

I have about 80 items to select from in a multi-select column. Is there any way to export these items? I want to add them to a new table.

Hi all, My automation is meant to send reminder emails to users containing a date field and a formula field. The fields below and circled in red in the image are not displaying in the email. Next Year = {Current Year} + 1 -> current year is a number field Target Renewal Date = static date field I’m confused because the Contract End Date field is the same format at the Target Renewal Date field and is displaying just fine. Any help or advice is greatly appreciated. Thank you!

I am seriously about to pull my hair out. I have an automation set to create a new record which is triggered when another record enters a view. All is going swimmingly until i try to get the automation to copy the UPC field to the new record. I’ve tried formatting as a number, text, single select… I have other fields that are also formatted in a similar nature, and they are copying over just fine. I don’t see any other characters in the cells. I might seriously launch my computer across the room!!!

Hi I have a set of data that looks like this Person | Category Text A ; Chemicals B ; Aerospace C ; Chemicals, Biotech D ; Chemicals, Aerospace Would it be possible to build a Multiselect into Airtable and tag the categories using a multi select field type automatically? I have 280 lines to tag and this can take up a lot of time :slightly_smiling_face: Thanks for your help!

Hi! I have two Dates columns, “START” and “END” that specify the start and end dates for a particular task. I have another column that has a WORKDAY_DIFF formula that calculates the working days between these two dates to determine how many days it will take to accomplish this task. However, if “START” and “END” were across different months, how would I separate the working days spent by month? For example, if the “START” of the task was 10/30/2020 and the “END” of the task was 11/5/2020, the WORKDAY_DIFF between these two dates is 4.0. However, how do I specify/separate the WORKDAYS spent in October (1.0) and the WORKDAYS spent in November (3.0)? Is there a formula, or way I can structure my table to identify how many days per month a task will cost?

I have the below formula, which I had support creating. I now need to add one additional rule. I would like to add that if todays date is after {Next Renewal Date (from X Customers)} then the cell should read STAGE 5 - Closed. I have attempted this in the 2nd formulae below and it works but it is also putting ‘Stage 5 - Closed’ against all the dates that are in the future too, which is wrong as todays date is not after these dates in the future. Hopefully this makes sense, help would be greatly appreciated as the guy that normally helps me is OoO now for 2 weeks! Thanks! Original formula: IF( AND(TODAY() < {105 - Stage 1}, {120 - Stage 0} <= TODAY()), “STAGE 0 - New Renewal”,IF(AND({105 - Stage 1}<=TODAY(),TODAY()<{30 - Stage 2}),“STAGE 1 - Discovery”,IF(AND({30 - Stage 2}<=TODAY(),TODAY()<{14 - Stage 3}),“STAGE 2 - Proposal Sent”,IF(AND({14 - Stage 3}<=TODAY(),TODAY()<{7 - Stage 4}),“STAGE 3 - Forecast/Commit”,IF(AND({7 - Stage 4}<=TODAY(),TODAY()<{Next R

Made a post which was immediately flagged. Surprised as my post seemed pretty routine, nothing inflammatory. Reviewed the guidelines and noticed: "Please respect that this forum is owned and operated by Airtable, and as such, we will remove any posts promoting the use of other services as a replacement for Airtable. It says I have 15 minutes to edit my post. I tried editing, but it’s greyed out, even when I click the edit icon. I removed one sentence requesting alternate tools. I then reposted. Flagged again. What’s going on? Never had this issue when posting before. Did a search and found this topic: ‘Flagged’ posts. Seems like this issue still exists. How to contact a moderator to overcome this hurdle? Thanks!

I’m not even sure that this is possible, nor how I would go about it. When I create a new client in AirTable, I need to create several views in several tabs for that client (those views are for different people in the company). Is there a way to script this as automatic or as a script block? Thank you!

I’d like to strip the domain from the email address. It can be done with RIGHT, LEN, and FIND in Excel but I’m having trouble translating it to Airtable. Can anyone help?

When restricting a share and requiring a password, does the user need to enter the password once, and that user is remembered as “authenticated”, or do they need to enter the password upon every visit? (I’m embedding the view into a web page)

Hello, does anyone know how i can view the line items/response entries in data form? We sent out a survey via airtable and want to analyze the summary for each question. Ideally we want to see the percentage of each response. Similar to how Survey Monkey shows us the percentage and the number of people that made that selection. Ex: 50 people out of 100 said “yes” 50% etc. Is there a way we can view these numbers in airtable?

I added some people to my worspace but they don’t appears in my column “collaborators”, in this column the unique option to add is me (creator of table). How I can put enable my collaborators?

We are having a problem sending rows of data to a couple clients. This works in all instances except for two cases: In one case, we send 1 or more rows (right-click on the row and choose send all selected records. We select the “send a copy to myself” option. For one client, they do not receive the email and we do not get the copy. For a different client, we get the copy that we requested but they do not get their copy. In this case, I forward the email that came to me, to them, and it gets there no problem. Both clients claim they have no filters or blocks on the airtable or our domain. They fact that we do not get the requested copy in once instances is very odd. Even if the client was blocking and/or filtering those emails, I should receive my copy. Has anyone run into anything like this? Thanks, Matthew Moran

Hello, I had changed the “Edit Field Permissions” to “Specific Users”, because I did not want people changing information in a specific column. Unfortunately, it seems like it restricted people from making any changes to the entire table, so I changed it back to editors and up. My co-workers are still have problems making changes to the table, like moving columns or rows around. They were not having this problem prior to changing the “Edit Field Permissions.” What could be the problem?

When I have recently shared a view (with commenter access) to one of my personal email addresses, the first time I click on the link it takes me to the view I want to share. The second time I click on the link sent, it opens up my whole workspace with access. What am I doing wrong?