Other Questions

I’ve got a table of monthly subscription transactions, and I’m trying to find a way to report on new and lapsed subscriptions. New subscriptions would be a list of new subscriptions from the previous month Lapsed subsciptions would be a list of subscriptions that had transactions two months ago, but did not have a transaction last month. Currently I have to download the table to Excel, run a pivot table in excel of subscriptions along with min and max month for that subscription and then do a second pivot table of months and a count of subscriptions with min month equal to that month (for new subscriptions) and a pivot table of months with a count of subscriptions with max month equal to that month. Is there some way to do this via a pivot table or chart in Airtable?

Hello, hope anyone can help me with this question, I have 4-5 checkbox fields. I will name them for easy understanding of what I am trying to achieve. Checkbox 1 Checkbox 2 Checkbox 3 Is it possible by any means to “lock” Checkbox 2 and Checkbox 3 until the previous one(Checkbox 1) is ticked? And it continues, lock checkbox 3 until the previous(Checkbox 1 and 2) are ticked. Hope I can get some help :winking_face: Thank you

I managed to move my gallery to WordPress but I want to config it. Is it possible to make the window bigger? I tried to up to with but that didn’t work. Besides that there is an option to download the CVS and see the large version, I want to disable these features Is this possible?

How can I restrict the email field to one (1) particular domain - for example on my form: I only want to accept emails from @example.com how can I restrict any other email domains from being entered?

Hi - new here - this is probably an easy question. I did search the forums but perhaps not using the correct terminology. I am trying to create an aggregate view summarizing data from a form people are filling out on a website. They are selecting from a dropdown indicating their geographical location - there are 40 or so selections to choose from. I then want to count all the people that choose a particular region and display that data People who chose A = 23 People who chose B= 16 and so on… I am close…I have created a linked table based on the selection - problem is that the drop down field can only be a dropdown field (field A) - I cannot also link that field to the new table displaying the aggregate data. So my solution was to make a new field (field B) in the initial table and link that - it works, but only if I manually copy the value from field A to field B. So my question is - when someone fills out the form online, how to I make the Table automatically copy the entry from fie

I have added new records to my base, but editors cannot see them and I’m unable to see them when I move over to my mobile app (with the same logins as desktop). This happens sporadically - other records added in the same website session may appear. There is no difference between the records that appear and the records that don’t.

Hi there folks! I’m encountering this kind of issue with one of my private links to a specific view: The view I’m refferring to contains fields with links to records in other tables. When people use the private link to access the view, they’re able to see it, but can’t do anything when it comes to linked fields. I’d like to make them able to click on the linked record and allow them to read all the details of it. Is there any way to do it?

Hello, How can i get list of view use Airtable Api ?

I’m trying to create a Request For Quote & Pricing system that allows a salesman to upload an image and details of a product, sourcing team to add more details and invite 50 suppliers to login and see what RFQs they have and enter their prices without seeing each others’ data. All these prices appear to the sourcing team compiled on 1 sheet. Sales cannot see these ‘raw’ prices. Sourcing adds in a bunch of additional costs some of which are determined automatically based on details from sales’ initial request + a profit margin and send it back to Sales’ initial sheet where they requested. Is this possible in Airtable with invited users only able to see their column in a spreadsheet? Are the 50+ suppliers able to login and enter their prices without me having to pay for a user for each of them?

Hi! I was looking at airtable’s integrations and it says on the page that evernote is already integrated without the need for zapier or other 3rd party app. But I can´t seem to find it!

Hello everyone, I am new to airtable, have been trying out a possible solution for my company for a few days now. Currently I have a table created with all the data I need. I have just created multiple Views with the results I want each collaborator to see and edit. What I don’t want is for them to see all the Views I have created. I know this is not possible(or is it?), but is there any other I could possibly go around it? What I am trying to do is create a database of Cars(car dealership) that are ready to be delivered. But they go through a process(the one I am creating right now). That said, I have a single table with all the fields I need to be filled. I have then created multiple views only showing the data each department needs to fill. I just don’t want collaborators to see or edit all the views. I want each department to only be able to See/Edit their own View. IF this is not possible, what can I do to achieve such results? Thanks in advance, hope you can help me, Daniel

Hi, Does the block-chart respond to the filter settings in the table? I want that my sales chart only show the results of one district, but if I set the filter for that district name the table responds with the filter but the chart doesn’t. Any tips? Robert

I plan to make a database of transactions between users. In that case I can easily reach 1.200 rows, this means only 35 users making 35 tx between each other… this is nothing. Even 50k is too limited: only 200 users 200 transactions each. Am I understanding correctly the “Records” limit? Thanks. Javier Bonet

Hello All! I am new to Airtable…I would like to use the Kanban view to write my email content; however, the order in which I want to write the copy is getting messed up with the ordering of the fields. For example, in the Grid view I added a Preview Text field to the right of the Subject Line field. However, when I open in the Kanban view, the Preview Text field appears down towards the bottom. Is there any way to rearrange the order of fields within the Kanban view? For some reason, I’m not able to add screenshots or links here )-: Thank you, Laura

I want to share a database that I created with other people - not my own personal version with my data, but allow them to enter their own data in their own version of my database. Is this possible?

I’m using a Kanban view. When opening one of the records, I open a linked record from another table. How to I control which fields of that related record are shown vs hidden? It seems random.

Hello. I have an idea of an objective I would like to accomplish using AirTable, but I am uncertain which AirTable functionalities to leverage to complete the desired objective. I would like to be able to use the information I have inputted into several linked tables in a base to generate and export reports, spreadsheets, etc. What is the best way to do this? I know that I can export the information in the AirTable as a CSV file, but, when doing so, all of the linked information is left behind. What would be the best way to generate/export a report that includes all of the information in a given table, as well as the information linked to that table? Thank you.

I have a Page Designer setup for a table, when I change the table to another, all elements has gone! Is there a way to use the same Page to a different table with the same field structure?

Is there a way to initialize fields of type Created Time and Modified Time from existing records of an imported sheet? That way, those fields will be correct for imported records and will be automatically updated as we add and edit subsequent records.

Hi, maybe some of you already faced this kind of need and can provide some helpful insights :slightly_smiling_face: Our team is looking to document feedback we’re collecting in meetings and interviews with clients. We currently have a base that has a Features table (that surprisingly includes all our features, their status, collaborators etc.) and a Customers table (that’s just a list of customers, their launch date, and a link to features they’re requesting). We’re looking to add feedback from customers, that would relate or link to both existing table (to see all feedback on a specific feature, and all feedback from a specific customer), and preferably would include both a calendar of past and future meeting with customers. I would really like to separate each comment so we can see all feedback on specific feature and customers. Thanks

Is there a way to autofill a field from prior values in the same column?

I’ve been playing around with a template that doesn’t quite meet my needs for weeks, and trying to develop one from scratch. I could use the hive-mind help. I have a product table linked to a vendor table. I am looking to have public users submit a form (ie make an inquiry/purchase) by clicking on a product tile rather than a generic form that then forces them to choose a product from a dropdown list of all products. Zapier should be able to generate the communications between buyer and seller. Any templates out there? Any designer/developer want to help walk me through a plan? Thanks! Stu

Hello, all. I’m tinkering with the Batch Update block, in order to update values in a single-line text field. I’m looking to append text either to the front or end of the field’s existing values. Is there a way to reference a field’s existing value in the “New Value” box? So if the field I’m updating is “Name”, I would write something like [Name] & "_AddThisText" …or does the Update Value process only update to literal text strings?

Hi everyone! I’m new to Airtable and would like to setup an automated email reminder that triggers 2 days before a given deadline date placed in one column of an Airtable base. Ideally, this date could either be a new record or an updated existing record, triggering the same email reminder 2 days before due. And the email reminder would include all the pertinent data from other cells in the deadline’s row. I really liked a similar feature in Google Sheets called “Remind” but it’s not functional anymore. Thanks for your suggestions@!

Love this block, but it’s difficult to get a bird-s eye view (which is the point of a Gantt chart) due to the white space between the items. I’d suggest 3 levels of “compactness”: Ultra Compact, Compact, and Normal (what it’s like now).