Other Questions

Hi folks, I’ve searched for an answer to this and have yet to find it. Will consider hiring someone to handle this use case, too. My e-commerce platform allows me to create a number of custom fields that are essential for me to use in several ways, but it provides no way to edit them in bulk. In fact, it will only export those fields in a single cell like this: AWG=10;Color=Black;“Number of Conductors=4”;“Conductor type=Stranded”;CSA=YES;“Insulation=EPDM - Ethylene Propylene Diene Monomer”;“Jacket type=Thermoset CPE”; Not every product uses all the same fields, though many do. That means there is no consistent number of values in every cell. It could be several or 16 or …something else. Also, I don’t know why it puts quotes around some fo the value pairs but not others. It seems not to do it for short ones. Very odd. I would like to: Expand the one cell into columns using the value label before the “=” then populate the product row with the custom value that comes after the “=”. Edit

We are planning a conference with numerous workshops, each of which has a limited number of “spots” available. What is the best way to allow students to register until the slots are filled? We thought about using Forms, but we don’t know how to make the Form close automatically once the workshop capacity has been reached. Thank you!

I have a column “Company Name” that I want to check for possible duplicates. I love the Dedupe app, it’s very powerful but I need a way to highlighting the possible dupes without deciding what to do about those. I’ve seen some solutions but they all seem complicated. For now grouping by “Company Name” is the easiest way but means you need to scroll through the whole table.

Wondering if there is anyone workaround or app to achieve this? My ideal workflow is: User submits info via typeform Info gets logged in Airtable Database (table 1). Calculations are performed. A new airtable is generated (table 2) containing some info from table 1. Namely the calculation results Table 2 is delivered to customer with ability to edit as needed I know Airtable doesnt let you generate a new table automatically so wondering if theres another option Part 3 seems to be where AT breaks down

Hi! Just started to use AirTable and I like it very much! I understand that everything won’t be possible using this tools, so you have to be creative. But one thing that I can’t find, which I think should be there, is customizing/displaying more info in the week view in the calendar. Is that possible?

Our table can calculate our conversion % using a summary stat (% Filled). How can we make a chart using an app that will show this % change over time, since we want to see how our conversion rate changes over time.

Trying to figure this out…

I need to create a simple table which allows multiple people to enter their availability each day (everyday may be different). Everyone is located in a different timezone though and I want there to be a field which will display it in our native time gmt+7. Some ideas i had were Creating the time field, then another field which has their timezone + our timezone calculation, then parsing it into a new date/time field. Any help would be appreciated thank you

Hi, I created a form to share externally and had a private link I was using. A few days ago, I disabled that link but now need to re-enable it. I clicked into “Share Form” and the same link popped up, but when I click to open the form, it says " The private share link you tried to reach is not available. The owner of this base may have unshared or deleted it. Please contact them if you need access.". Is there a way to re-enable my previous link after I disabled it? I see there’s an option to generate a new link but have not tried that yet as I would ideally be able to use the previous one. Thank you!

Hello community I’m trying to add this function to the main column. This is the formula concatenate I use to show specific data. CONCATENATE({ :anger: Nombre Jugador},’ ‘,’|’,’ ‘, MID({ :anger: Año},3,2)) &’ '& { :star: :x: :heavy_dollar_sign: :older_man:t2: }& { :fire: }& ’ | '&{ :anger: Club 20/21} What I am looking to do is replace the star :star: emoji by :fire: when this column contains the emoji. And when doesn’t maintain the :star: emoji. Thanks in advance for your time and effort.

Hi:) How do I know if someone assessed a base? As i sent an invite and they assessed it, but I have no way of knowing it’s been assessed. Do I not receive notifications? Thanks,

Hi all (please forgive my amateur status & language) - I have two forms that feed into one base. Is there a way to tag the entries on the backend so they can be categorized separately? (For instance, some are coming through an application form, and others through an interest form.) We want the entries to be tagged based on which form they’re coming from, but the only tags we can see are based on what the user is selecting on the form itself. Thank you!!

Hi, I was wondering. Is it possible to track who clicks specific buttons? It does not appear as though the “Last Modified By” field records clicking buttons, but correct me if I am wrong. Alternately if I can’t track who clicked a button, can I restrict which users are able to click a button? Thanks!

I wanted to know if Airbase provides the capability of sharing specific documents (PDFs, Google Docs, Images, etc.) with specific people outside the team (i.e. Clients) so they can provide edits, feedback and review? My agency needs a tool that manages the gathering of feedback and edits through an easy to collaborate platform. Currenlty we use SmartSheets but there have been issues and limits. Thanks in advance.

Hi, is this possible to add an ‘Other’ option in single select type where user’s type in the options via the Form? Thanks.

I looked at On2Air Actions to see if it can help where Zapier and Integromat can’t. I am looking into integrating Airtable with eBay and Amazon. I need the integration to go the other way. Right now Zapier offers only downloading data from Ebay. Same goes for TradeGecko, Airtable Integrations | Integromat. It can’t send to eBay. Specifically I need to send new listings to ebay and amazon. So I am wondering if On2Air is potentially a helpful solution to get the job done easier rather than have somebody custom-develop an integration between Airtable and ebay/amazon.

Is there a way to see the history of view configurations? I have a view which had multiple settings and someone in my team must have re-configured it with realizing it was an important view. It was set up 3 years ago and I cannot recall all the settings I had in place. I need to revert it to previous settings, but do not believe this is possible in Airtable.

Hi guys, I am using gitpod.io as a primary development, as I run block run command in terminal when the port 900 is opened the gitpod environment exposes it as an external address like, https://9000-abc398a6-bb4b-4109-a7aa-31028842e9a8.ws-us02.gitpod.io/. When I try to add the following url into App URL field the following error message appears: App URL is missing the port number. Please check your terminal and try again. I believe there is two changes that need to be done for the gitpod environment works with block development. First, allow to start the local server without HTTPS as gitpod only proxy to http exposed ports in localhost Second, allow the gitpod exposed url to be entered in App URL field Thanks

Is there any way to enter numbers as exponents in scientific notation into Airtable? For example, we get readings from some instruments in exponential format such as 4.67e6 or 4.67x10^6 as in 4,670,000, but in order to avoid people making errors translating 4.67e6 to 4,670,000, I want them to be able to enter in the number the way it shows up on the instrument: 4.67e6 or 3.42e5, or whatever.

I’m trying create an externally facing site that does two things: Allow site visitors to input data into a form (I think this can be done with Airtable Forms) Once a visitor fills out the form, I want them to be able to search my database of records (I don’t want them to see the entire database, just their search result) Is there a way to do this?

Hi, Here is what I would like to do. I have a table T. This table has 3 views: TV1, TV2 and TV3. I know I can share publicly any of these views. But what I would like to share TV2 (and TV2 only) with joe@email.com. That means Joe needs an airtable account to access TV2. Is it possible? Thank you.

We need to be able to create a form that updates certain fields in a given record - not overwriting what is already in there, but adding to it. It appears that this cannot be done within Airtable but I hope I am wrong (or that there’s a simple add-on that can help). The adding-to aspect of this is vital for our purposes though. Can anyone help?

Hi, I’m new to Airtable. I want to create a form which has some fields prepopulated. The value in this field will change every day. eg. Initial stock is 28000. 22000 is current stock which is prepopulated to one field on form. 500 are sold. When form is next opened 21500 should appear. Is this possible? Can form pull values from linked base? Can an airtable form do calculations within the form? eg. 500 sold, 200 given away, 200 written off. 900 to appear in a different field and 900/22000*100% to appear in another field. Does anyone know of form options which will do the above? Formfacade with formranger addon seems closest solution but not really what I’m looking for. Conor.

Hallo I have created a field which is linked to another table and it all works well. Question is can I control HOW MANY show up in the small pop-up table from which I am picking th records? By now I have a title + 4 fields for every record. Can I simply have a title and maybe 2 field showing more content ? See below link with example: _https://dl.airtable.com/.attachmentThumbnails/66203571efb33d02293d4ead6d08b4de/605b6dfb Thanks Luca

The problem with the “bar chart” (which is more accurately a column chart) is that for long labels, they get cut off. Anyone know of a way to generate an actual bar chart (horizontal bars) from a data series?