Other Questions

hi, i’m currenly trying to use integromat to copy data from one base to another. but when there’s a linked column. it copies its record id instead of its field value. i tried turning on smart link, but it still copies record id instead of its value. any help please?

I’m using Integromat to search Airtable. I’m trying to think through the logic of an Airtable search. I have weekly podcast episodes that I produce across several podcasts. In Airtable I have all future episodes listed up through 11/11/2020 (67 days away and a Wednesday since I release on Wednesdays). I want Integromat to search 56 days in advance of “today” (running the scenario on Wednesday’s). If there is a result of an already created record for that day, but not for the next week, I want it to give me those records so I can create new ones. Does that make sense? Doing some research it looks like I need an “AND” search: AND( {Publish Date} = {{addDays(TODAY(); 56)}}, ???) Thoughts?

I created a view and shared it; however, when they attempt to click on what I know to be a linked table, they are unable to do so. For instance, they can see the contact person’s name but can’t click on it to reveal the details it contains from the Contact table. What are my options to allowing this person read-only access to this main table while also being able to click on any linked tables?

Hello, I wanted to ask if it is possible to update the status of a record in Airtable when receiving a mail from the email of the record the first time. Also I would love to attach all incoming emails of a records email adress in a records cell. Is that possible? Thank you so much and sorry for being a noob. Best,Vinzenz

I want to be able create an automation where when the “Scheduled Pick Up” field is input with a date then it would auto create in the Table section for a scheduled event to show? Might be a calendar interaction? Some guidance would be appreciated.

Hi! I would like to ask is there a way that a Summary Table be created and automated. This Summary Table should be linked to other tables (four of them), so that when I add a new entry to the four tables, it would automatically be summed up and recorded in the Summary Table. I already used roll-up type in the Summary table, linked it to other four tables, but will still manually input the link to the Summary table. Is there a way that this be done automatically? Thanks for the help!

Driving me crazy … why doesn’t this work? PROMOEND is a date field. DATETIME_DIFF(TODAY(),PROMOEND,’months’)

I was wondering if it is possible that if a collaborator filters a list, then the rest of the collaborators do not get their lists filtered when they access the base. Would getting a paid version solve this problem?

Help - are there any formatting options when printing gantt to PDF? it’s automatically printing to portrait, which is silly for a long gantt chart. Thanks - A

When I try to scroll down through my base, it more often than not glitches and sends me back to the top of the base. To scroll down and edit records, I have to click on a record, scroll down a little, click on another record, scroll down a little more, etc. This usually keeps it from sending me back to the top, but not always. Is there a way to fix this?

The topic was closed as resolved so I created new post, wanted to list the formulas I used to get it done. https://community.airtable.com/t/anybody-managed-to-break-image-string-using-integromat/33085/4 Excellent, many thanks. I was trying to do this with Zapier and it works kind of OK but it required me to go to the CSV file created by Zapier and then specifically click on the concatenated cells for NEW line entries (do not select the whole column, just the new cell) and select “convert text to columns” which worked OK but requires many more steps. Thanks @ScottWorld the suggested @Justin_Barrett solution really helps and makes it nice. I had to fine tune it because the formula requires adjusting to the specific length of the image file NAMES. Picture files names LENGTH stays same for pictures taken within the Airtable mobile app but their length will vary for pictures uploaded e.g. from desktop. In my case I adjusted the formula to accommodate file names from about 1 - 70 characters.

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!