Other Questions

I use the invoice generator app when using airtable on my PC but cant get it to appear when I log in through my IOS apps. Does anyone know how to fix this? Thank you

I have a base with several tables that link. We are a horse show association and I’m trying to pull together either a view that I can share with my members or a report I can download to paste on our website. I have these fields Last Name First Name Horse Name Type Discipline Class Points Our members can earn points in any class. So I need a report that shows classes and the points associated. They may have 1 row or 100+ rows for a single class. I need to sum the Points for each class by name/horse name. They can also earn points in disciplines. Similar to classes, I need to sum the points for each discipline. Then I have a tricky one - our overall. It sounds like it should be easy, just the total number of points a member/horse earn. But we pull out one type of class for most members. If they show in both types of classes they can only earn points in one type based on what they select at the beginning of the year. This only affects the overall - all of the points combined from

Accidently the very important database was deleted (our backlog). Any ways to restore (ready to pay for the support if needed)?

Estimada comunidad, Esta es una invitacion para los hispanohablantes que quieran aprender más sobre AIRTABLE y sacarle el provecho que tiene esta maravillosa herramienta. Se ha creado un Taller de tres sesiones en el que recorreremos todo lo necesario para poder tener una productividad aceptable con Airtable. Este es un taller para personas que no tengan una aproximación al mundo de las bases de datos y que tengan necesidades de aprender nuevas habilidades. El taller es completamente gratuito y abierto a la comunidad de Airtable que hable español. Queremos hacer una comunidad de Airtable en Español suficientemente importante para que puedan darnos soporte en nuestro idioma materno, Las inscripciones están abiertas en el siguiente Link: http://www.digitalglue.co/inscripcion

Hey everyone, hope all is well, happy and most importantly safe :slightly_smiling_face: I’ve been using Airtable(AT) to plan my instagram content schedule and I’d like to export the content to my client for him to give his feedback. I’d like to ask does anyone have any experience in this ? Exporting selected base for people without an AT account to give comments on our Base? Thank you in advance for anyone who took their time to look into this :grinning_face_with_big_eyes:

Hi all I need to send a json payload to an integromat webhook using an automation triggered by a view but I can’t figure out how to prepare the structure of the array it needs. I want to loop through a table and then pass these records (containing one field) to integromnat. I can do it with a single value like this when I map PID to a field let data = input.config(); const returnPayload = await fetch(`https://hook.integromat.com/3gcj7g0zhntlwgkgm6crtdjo3i1jsvmu?PID=${data.pid}`); var payloadResponse = await returnPayload.json() console.log("done"); Has anybody done this before please? This is what I think I need the array to look like but I still don’t know how to add it to the webhook url [ { "name" : "Peter", "ID" : 1 }, { "name" : "Mike", "ID" : 2 } ] In which case the output will be a series of bundles, each bundle containing one array’s item: Thanks Claire

Hey crew! I’ve been wrestling with a problem the past few hours and have decided it is time to ask for help. My airtable database is setup with players and parents tables. Players can be associated with multiple parent records, and parents can be associated with multiple player records. I have created a zap that distributes the data from a form to my airtable database. The form asks if the person filling out the form is a player or a parent. That info is then used to filter the zap. If they are a player, the zap will only add/update a player record. If they are a parent, the zap will add/update a parent record, and then add/update a player record. So I’ve turned on my zap, everything seems hunky dory, I’m sucking back on a few beers feeling good about myself as I do my ‘final tests’. Much to my misery, I find out that I cracked open the six-pack a moment too soon. If a parent already exists in the database and is already linked to a player, when I add a new player through the form who

I have tables for Events, Contacts, and Schools. (There are about 12 other tables but not relevant to this) The Events are related to the Contacts (multi-select) The Contacts are related to the Schools (more than one student can be associated with the same school. My goal is a view or report that lists the event and the NUMBER of students from each school that attended the event. So it would show: Event Name, Number of students associated with School #1, Number of Students associated with School 2, etc. I tried using a rollup field but am lost on the proper setup. Any help with as many specifics as possible would be appreciated.

I am using the script from @Mike_Pennisi to send a single Welcome SMS to new records in my table. I tested it as a ‘Block’ script and it works great. But when I tried to use it in an automation, it throws an error. What is different about these two environments? Here is the error when I paste the script into the Automation script (Works great as a block script though!) ERROR: TypeError: output.markdown is not a function at main on line 58

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!!!