Other Questions

Hello ~ We are having some INTERMITTENT integration issues with JotForm and Airtable. Although JotForm and Airtable are syncing properly using the 3rd party interface on JotForm, we have experienced a few (roughly 2%) form submissions that are not updating into Airtable. We haven’t been able to diagnose this issue very well b/c it is intermittent. It’s possible that Airtable is not updating when Airtable is not open on our browser window. In other words, when the JotForm receives a submission while Airtable is closed that record is not created. Does anyone have any experience with this issue? Just to be clear, we are creating records just fine 98% of the time with the same form being tested. Thank You! Eric D.

I have a tab that is used to register partner leads. It has a column that links to my partner tab, specifically a view that only shows the partner’s names. I have created a form where the partner fills it out, finds their partner name and adds it to the form. The problem is that when they click on Partner, it shows them columns that are not visible in that view. The only thing that I want them to be able to see is the partner names, no other column. How do I set this up so that they can’t see any of the other columns?

Hi all, I can’t find any sign of an answer so thought I’d try to community. I have got the hang of the Page Desinger block and even mastered multiple pages. However, when I go to print I lose all my formatting - specifically border and text weights. Am I doing something wrong or can Airtable not convert Page Deisgner to Print? This seems counter intutitve after having all the functionality to set weights. Any thoughts? Thanks Megan

Hi I had a view in one of my sheets and the view just went missing. I don’t know where it went. Do you know how to retrieve a lost view? not a lost base but a view within that table.

Sorry if this sounds like a dumb question… How do I make a spreadsheet? Like Google sheets? Air Table: I read it was like a spreadsheet but much better. All I need for the moment though is just the basic spreadsheet. I’m sure I’ll get round to using the more advanced items later. Thanks.

Hello, I’d like to know if it’s possible to post or embed a record from a page designer block to a website? For example, we use the page designer block to create a price list. Is it possible to post this as a pdf download link on our site so it’s always up to date automatically?

Hello and thanks for any help you can provide. I have a form built to have orders placed, we have a linked table of member shops, there are around 6,000 shops, Currently it only shows the shop names on the list. Many of the shops have similar names. Is there a way to get the dropdown list to also show the city, customer number, Owner name to help confirm which shop is ordering?

Hello all! Il wouldlike to add buttons in my dashboard to go on a grid or in another dashboard. Do you know if it’s possible? Thanks for your help!

I work with a company and we have 3 different airtable pro accounts. Is there a way to link them to one workspace so I can share and edit bases within this workspace and not get charged an additional feel even though the others have their own account?

I feel like this is a very basic question, but after I use table switcher (ctrl+J) to switch tables using the keyboard, I then want to be able to keyboard around the records and fields in the table I have just switched to. But at present I am ‘stuck’ and can’t get to the point where a field is highlighted, unless I mouse click on a record, which is what I’m trying to avoid. The only solution is to ctrl-F, type something and then hit enter when a cell is selected. From there I can keyboard around between fields and records in the usual way (arrow keys etc). It feels like the tab key should do this - ie move me ‘into’ the table - but it doesn’t.

I am really hoping someone knows how to do this, if it’s possible. My records have fields such as Name, Last Name, Email Address, etc. What I would like is to be able to send a Form to the attendees of an event, have them fill it out, attach a pdf and submit it. That pdf should then save into a specific column in the correct person’s row. Tying it to the person’s email address seems like the best way to identify which record to tie it to. And I’ve created a form that asks for Name, Last Name, Email Address and then the file. But how do I link the submitted pdfs to this column in my sheet? I only seem to have the option to either have a linked field, or an attachment field.

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