Other Questions

Hello all! I want to intergrate in my airtable project a custom block create by a user. For that I have to go to “Remix for Github” option to copy/paste a github link but I can’t find the “Remix for Github”. Can you help me please? Thanks!!

I work in a real estate office and have created a base to track sales of all the Realtors for the company. So far I have it set up to automatically calculate commission amounts as well as keep a running total of pending sales volume and closed sales volume. I have tables created for the various transaction scenarios, which are all linked back to an “Agents” table which stores information on each agent, such as their current commission level and a running balance of their sales volume. So far everything is calculating perfectly but the agents are set up on a tiered commission plan which means they have the potential of moving up to a higher level. Right now my tables are set up to calculate a commission based on the current level each agent is at, but if someone moves to the next level, how can I structure it to where it will calculate at the new commission level without changing the sales that were previously entered? Any suggestions are greatly appreciated!!

I’m looking at using a Gannt chart to adjust dates of projects as needed. If I drag dates further out, the tasks that are dependent on them move appropriately. If I then drag to an earlier date, the tasks that were dependent DON’T also move to an earlier date. WHY??? To make things even weirder, if I drag one task that is dependent on another to an earlier date, it forces the tasks ABOVE to move back which doesn’t seem like that should be a thing (aka a subtask is forcing the timelines of higher tasks). Any thoughts on how I can make this work better?

As you can see from my screenshot, I have a weird behaviour with my formula. It converts 2019 into 2020 for an unknown reason… Here is my formula to calculate the number of days between the download of an App and the moment where a user make a specific action. As you can see, sometimes, the user made this action multiple times, so I must use an other formula to get only the first 10 characters so I can compute it with the download date… FirstCallDateSingle : DATETIME_PARSE(LEFT(CONCATENATE(FirstCallLookup),10),‘AAAA-MM-DD’) DeltaInscriptionVsFirstCall : DATETIME_DIFF(FirstCallDateSingle, { :calendar: Created At​:writing_hand:t2:}, ‘days’) & " Jours"

Hello all, I’m trying to set up database that shows the relationship between boat brands and boat dealers (i.e., what boat dealers sell which boat brands) and I’ve run into a confusing problem. One of the records in the boat brands table switches between 2 names - Sea Bass and Robalo - and I have no idea how to fix it. The brands are not duplicates nor are they associated in any way. How can I fix this? This issue is affecting the data my boss needs to help move forward with a project. Thank you!

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.