Other Questions

Hello, I am sending an email out using SendGrid. I have a filed that is a link of multiple linked records. It strings them all together with commas between, which is really exhausting to look at, i.e.: “Day 1, Day 2, Day 3, Day 4, Day 5” I would like for it to be formatted as: Day 1 Day 2 Day 3 Day 4 Day 5 Any ideas? I tried turning on HTML in the SendGrid app, and used a REGEX_REPLACE formula to replace the commas with <br>, but that didn’t work. Thanks! Tom

I have a table with student information like name, class year, email, etc. I would like to create a form to ask them what their summer job or plans are. Is there a way to create the form so that the summer job question populates to the correct student’s record? I hope that makes sense.

Hello, Kind of unconventional question :slightly_smiling_face: I don’t know where to ask. I wondering if AirTable has a footprint in Europe/France ? And If there is Job Opportunities for Tech Evangelist ? What I underestand: There is a lot of Freelance. There is many startup using Airtable as a Backend. I’m asking this because I love AirTable (and NodeRed) for years and so may be if I could “work” on these topic it could be interesting. The drawback is AirTable is very easy to use and to understand. It’s not a pain like fake SaaS like Salesforce or SAP that requires a lot of integration.

Hello, I would create some records (companies) with their sub-records (employers). And so, if I have a record Company A, I would associate then their Company A employers like a CRM. Company A Employer A1 Employer A2 Employer A2 Employer A2 How could I proceed in Airtable? Thanks in advance

Hello! Is it possible to make different tables in one tab? So that these tables do not duplicate the same information? For example, I created a tab - called it “companies”. Now I need to divide these projects into categories and make a new table for each category to make a separate list, for example: new table - technology companies new table - commodity companies new table - financial companies But it’s important that these tables are on the same tab - don’t create new tabs for new tables.

I have seen various questions like this, but no good solutions. I am parsing text from an email into airtable and using the DATETIME_PARSE() function to extract it. I have tried many formula variations, but AirTable refuses to see the parsed time as the correct time for MY timezone. This is an issue because my next step is to turn this into a google calendar event via zapier. The best solution I can see is to add the time difference, however this is very complicated with daylight savings as I am booking events inside and outside of DST while being inside and outside of DST. The only way I can see to do it is to have a formula that adds a different amount to the time based on the event date and when DST is for that year, which will require yearly maintenance but I literally cannot find a better way. Any help is appreciated.

I am trying to edit the list of options in my single select list. When I open the editing portion of the field the space where I normally see the list of options (including “add an option”) has become so small that I cannot read any of the options that are there, and the “add an option” button is not visible at all. I am working on a MacBook Pro if that makes any difference. It feels like I just need to adjust the size of the window, but I can’t see any way to do so. This has been going on for two days. Any help would be appreciated.

I am new to airtable and trying to determine if this is the proper tool to create a product configurator for our website. I was wondering if anyone has created a product configurator before with airtable and can recommend a starting point or share a template they may have? We are not going to include prices which should make this easier. I am just trying to get an understanding of where to start. Our product is electric heaters so we would select a type (air heater) then Volts, watts, termination, fittings etc. After they select all the options we would want a quote created and sent to us in order to view it and quote them a price. Any help or pointing in the correct direction would be much appreciated!

I’d like to collect a sensitive ID number from my partners that I need for govt. reporting. I’d like to do this with a form view. (It’s not feasible to train partners to use 3rd party apps for encryption etc.) Some things I’m considering to increase security: The table is in a special base with limited access. The table includes 2 fields only, a customer number + the sensitive data field (no other identifying data is held in the same table/base) Once submitted, I’ll store the data in a document offline somewhere and delete the record. Are there other security concerns, features or user experience issues that I should consider? Thanks for any help!

Hi Airtable, When I duplicate the base from the universe, the script is not copied over!

Hi, I will need to separate the data from a “lookup” column nammed “Response (from SMS Responses)” which gives me the list of poll results as numbers (between 1 and 5 or a comment) : I tried formulas like this: LEFT({Response (from SMS Responses)}, 1) Or this one: LEFT({Response (from SMS Responses)}, FIND(",", {Response (from SMS Responses)}) -1) But I always come across errors, what could I do? Thanks in advance !

Hi, I’m looking for a way to replicate one Google sheet I’m using. It’s use to populate a table base on the user input. The user must enter our PO number or the client PO number, then a query fetch the data. User can use this table to send a email. Does anyone have a suggestion ? Thanks

I have three tables. People, Companies and a junction table. The junction table shows the relationship between a person and a company. Sometimes, a person is connected to several companies. I’d like to show that relationship. For example, This is People table This is Companies table Now this is the junction table that basically lists the companies’ employees… We can see companies are related/connected through people here. For example Joey works for both Scott Co and Keychron, Michael works for both ITC LLC and Keychron. What I’d like to do is to show how “Scott co” and “Keychron” has a relation because Joey works in both. As I’m working on this, I was able to show this relationship but it still includes the name of that certain company. like this: (notice how the “Scott Co” record still includes its name in the ‘related companies’ column.) I want it to lists all the related companies without including that said company itself.

Hello everyone, I this this a very simple question. Unfortunately I dont see this Option in my menu, as explained here. Airtable Support Creating a base share link or a view share link As an alternative to adding individual people as collaborators, you can create a read-only share link that allows anyone with the link to view (but not edit) a single view or an entire base. This a... I want a simple link as in google drive. View and edit WITHOUT Login/Account and everything! Thank you

We have a database in MSSQL … we would like to connect it to Airtable and retrieve the data in Airtable. MSSQL (source): Airtable (destination) What solution is the best, most stable,easy to use, affordable? We would like to refresh the data e.g. at least twice a day.

Hi community! I’m trying to learn airtable: am not a total newbie, but still struggle with formulas. I need a formula (I think) to add up billable hours. How do I tell airtable to ONLY add up hours from any given month? The contractor enters the billable time in a number field and the date on which the hours were worked in a date field.

I’ve built an app that allows users in my base to select a record in a certain table. I’m using GlobalConfig to store the ID of that record. However, when I first publish the app to my base I get an error because the GlobalConfig does not yet have an ID stored. So when do useRecordById, I get an error like this: “getRecordById expects a string” because there is no record ID stored in GlobalConfig, since a user has not yet selected one. When I tried putting useRecordById inside a conditional, I get an error because you can’t put hooks inside a conditional. What is the best way to get around this? Thanks!

I have a group of records called “Round 1 Tasks”, when these Tasks are marked as complete I would like to automatically hide those and display “Round 2 Tasks” and so on. I know I can do this via the scripting functionality but curious if anyone has ideas on how to implement this via filtered views and/or formulas. Thanks

Happy Sunday, everyone :slightly_smiling_face: Apologies in advance for not knowing all the correct terms when referring to objects, arrays, items etc. I was hoping someone might have either some direct support or links to relevant resources for how to extract specific pieces of data from within an array that is returned via the Data Fetcher app in Airtable. Data Fetcher has the ability to write formulas to transform fields before bringing into airtable. Here is a screenshot of the response received from the API on the field I’d like to extract from: And, a screenshot “zoomed out” up a level to show the overall structure of the response: The way this currently comes into Airtable is a field for each item of the object. For some downflow work I’m doing with Webflow this format isn’t practical and I need pieces of the data to come in as one field (and thus a multi select) What I’d like to do is extract the “tagName” field(s) from each object (i.e., product) returned and place in a

Hi all, Ive been using the map app lately and like it a lot. I am curious if it is possible to extend the functionality of maps slightly with two changes: Is it possible to have the map when in a side-by-side view somehow identify the pin when a record or multiple records are selected? Maybe make them bigger, put a halo around them, etc? Is it possible to add small labels on the map so you can see the name of each record without clicking on the records one by one? Or some similar solution? Thanks for any help!

Hi everyone, Any suggestions how to hide fields with empty value in gallery view? Thanks

So I’m in the legal field and I’m trying to track from different judges a percentage of damage that is associated to a specific body part. The goal is to be able to predict what % a judge gives on average for any given body part. The trouble I’m running into is figuring out the best way to connect a % to each body part. I currently have one Multiple Select Column for body parts, but I really need those body parts to have some way to be attached to a %. (I was currently just putting it down in a long text field, but that doesn’t allow me to track what I want to track). Any advice is greatly appreciated.

Hi, I am new to scripting. I want to set all the values of column(Duplicates?) to null. How do I do that? Here is my code but it seems that there is an issue with query.recordIds in line 3. The error is no overload matches. var table = base.getTable("Table 1"); var query = await table.selectRecordsAsync(); table.updateRecordAsync(query.recordIds, {'Duplicates?': null})

I have given the password to 78 people. I suspect hundreds are using it. Is there any way to tell?

:wave: Hey there! I have a Jotform that is populating an Airtable base via the integration in Jotforms App Directiory. Specifically this one But there are two fields that are not loading properly: Field 1: Jotform Field: Yes/No question. I am assuming it evaluated as a boolean expression - aka a checkbox. Airtable Field: Trying to map the yes/no question onto a checkbox I believe this is the right route because I have another Yes/No question that I mapped on to a boolean checkbox and its working just fine! Field 2 Jotform field: Long-text with enabled rich text formatting Airtable field: long-text This is mapped correctly on Jotforms side - but for some reason not a single response is coming through??? Any ideas or help? I’d really appreciate it!