Other Questions

Need the assistance of some brilliant Airtable minds. My parents are dealing with quite a few health issues. My dad has Alzheimers :cry: . I want to create a digital dashboard like Dakboard but need to avoid monthly fees. Wondering if anyone have any solutions, suggestions, on how to build a digital dashboard that utilizes Airtable? MagicMirror2 looks like it is beyond my skill set. I created an Appointment Scheduler where I can add their appointments and then created a view that shows upcoming appointments and another view that shows past appointments. I would love to have the upcoming appointments in the digital dashboard. Dakboard looks easy to use but there is no mention of it integrating with Airtable. If you of you kind brilliant folks have any thoughts, I would love to hear from you! Many many thanks :smiling_face_with_three_hearts:

Hello! How to add hours from one column to date from another column and get the result. Formula DATEADD ({Matchday date}, - {Date / Time}, ‘hours’) in Date / Time I write 2 hours, but for some reason the result is 5 hours, instead of 2! Help)

is it possible to connect the tracker view to another table in the same base? so that it collects the status infos from table 1 (grid view) and sorts and shows them in table 2 (tracker view) many thanks

Hello there, I am new with Airtable, I’ve got an idea I would like to make happen for my Real Estate client on Webflow. Basically, I would want to make a base where her prospects and related connections would be able to fill out there available times & dates. This will be incorporated into Webflow’s CMS with the help of Zapier. I was not sure if you can have a feature of the form where the client could make new fields for the availabilities. Thanks

I was trying to make some changes to my AirTable workspace and ended up messing it up so my records and tables are no longer functioning properly. Since I made these mistakes, I am now trying to revert back to my latest snapshot workspace (11 hours) ago. However, everytime I restore it back to this version, it saves in a new airtable base rather than replacing my main one (which is what I want). Please let me know if you can help!

I’m having a strange problem in Zapier where searching for a record in Airtable doesn’t give me access to all of the fields on the record that is found. I’ve tried everything I can think of, but for some reason only values from a subset of the fields on the record are available in future steps in the zap. I have confirmed that the API key I’m using belongs to a user that is a creator in Airtable, so no issues with permissions. It looks like only lookup and formula fields (maybe?) are fetched and made available in future steps. Has anyone else seen this issue and found a solution?

Airtable Not Working by anyone?

In my usage of Airtable, I have records that I email to certain individuals in our company. **Is it possible to send a record to a customer’s mobile number and them still be able to see the full record?? If not, is there a possible workaround to help make this happen?? Thanks, Dominic

Under “collaborators”, I am shown as the owner along with the message “This workspace also has 1 base collaborator not represented above”. No other collaborators are shown. How do I find out who is this other (hidden) base collaborator?

Hello! I created a Follow the Money map via google cloud API on airtable. Is there a way for me to obtain an embed link for the map for our Squarespace website?

Hello, I’ve just started using airtable and I’m wondering if there is a way to quickly add records in Kanban view? Basically, right now, I have to click on the add record button, which opens a dialog each time and it makes it less easy than just adding your description for Task 1 + pressing + adding your description for Task2. Seems like the only way to do it is to go to use grid view and shift + enter? Why not just enter? In my opinion adding records should be effortless in any view

Hello community, I’m somewhat of a newbie and I’m perplexed… I had created a table and shared it with the collaborators. I also had a colleague share some tables with me. Now it looks like I can see the tables she’s created, but I’m missing this particular table. I just had a colleague reshare the table with me and now it’s showing in “bases shared with me” and I’m still listed as a creator. I’m wondering why this happened and how I can avoid it in the future… Has anyone experienced this?

Hello community, I’m somewhat of a newbie and I’m perplexed… I had created a table and shared it with the collaborators. I also had a colleague share some tables with me. Now it looks like I can see the tables she’s created, but I’m missing this particular table. I just had a colleague reshare the table with me and now it’s showing in “bases shared with me” and I’m still listed as a creator. I’m wondering why this happened and how I can avoid it in the future - it scared the crap out of me… Has anyone experienced this? Table disappeared

Currently, I have my data in multiple tables (20) Each table has the exact same table structure. Please dont tell me to put all data in same table. I can’t do it. & I don’t get much time to go into each and every table to check which leads I have to followup on. I need a way by which I can view all the records that have the status ‘Negotiation State’ in all the tables to be displayed in one place so I can be more efficient with my work. I make chnage in this view and the chnage should be implemented at the original table. I see in other softwares like Asanas the pipeline thing is built in. How can i make my airtables more efficient ?

I have a table that has two fields. We’ll call the table Table One and the two fields Name and Diameters (note the plural form). The name field is a simple string. The Diameters field is a list (or array) of values. As a simple example: Name: “Widget”; Diameters: “1, 2, 3, 4”. Now, I want to create another table – we’ll call it Table Two. Table Two also has two fields: Name and Diameter (note the singular form). What I want to do is create a unique entry for each diameter in the Diameters field in Table One. So, Table Two would look like this: Name: "Widget; Diameter: “1” Name: "Widget; Diameter: “2” Name: "Widget; Diameter: “3” Name: "Widget; Diameter: “4” In other words, I want to loop over each value inn the Diameters field in Table One and use that value to create a new entry in Table Two. I am not sure, though, how to do this. Do I need to use the Scripting Block? Is it possi

Hello, I am trying to link records in a single table to each other to manage a referral program. Here’s what I’m trying to achieve: Jim refers Beth, Bill, Jane. In Beth, Bill, Jane’s records - you can see that they were referred by Jim. In Jim’s record - you can see that he referred Beth, Bill, Jane. Right now, I can only figure out how to reflect this relationship one way. So, Beth, Bill and Jane’s records reflect that they were referred by Jim. But, I am not able to figure out how to get it to show up in Jim’s record that he referred 3 people. Thanks!

HI all, For work, we support a lot of clients and do the same work for them on a yearly basis. We are managing all of this in one base. In the base I have the following tables A table that lists all of our clients A table that tracks our contracts for each of these clients (contracts are renewed annually) A workplan table that has the template for the work tasks that we do each year. While I have my workplan template, I want to be able to automate this list of records for each new contract that is added. Example: For client A’s 2020 contract I need to do tasks A-Z For client A’s 2021 contract I need to do tasks A-Z For client B’s 2020 contract I need to do tasks A-Z etc. I am getting stuck on how to best set this up to automate or script so that I anytime a new contract is created in table 2, I get the automation of the template tasks created in Table 3. Does anyone have any ideas on how

I have 2 tables: Review, Config. I want to break the Review table to more view with filter. I expect another user only to view a part of the table. How can I do that? I have research about the permission of base. I can add a view, add a filter, and block the view or change permission for anyone. But this user can remove filter by way duplicate the view and remove filter to see all records. I wonder this is a huge bug with permission. Besides, I have a Config table includes some keys and API endpoint. I expect only me can see the table. Hope somebody can help me. Thank you very much !!!

How I can delete a user without losing data they have entered in certain bases? I am new to Airtable so this may be a simple question! Thanks!

Does anyone see why we there couldn’t be an option to group Kanban stacks by a lookup field from another table (possibly synced), when the multi-select option for linking to the table is turned off? I believe this should satisfy the requirement that each item on the Kanban can appear in only one stack, but also allow stacks based on lookups from other tables. Thoughts and comments before I make an official suggestion. Cheers, Steve A.

Is there a way to restrict a field to X characters, especially in Form view?

I know this is probably a difficult question and is case by case, but with the addition of sync I am debating on what to do. I am trying to decide if I should rebuild my base into separate bases from scratch or try to clean up/restructure my current base? Or maybe even just wait a bit to see how the new sync evolves? My current base has many tables that link together (Jobs, Contacts “employee & customer”, Customers, Cities with various tax rates, Holidays, etc.). I have probably 20 different tables in the base. When I built my current base, I was learning a lot as I was building it and now feel I can build a more efficient base if I were to start from scratch. My current base has one table (jobs) with close to 25k records and over 300 fields, which won’t open on iOS app and causes it to crash (spoke with Airtable and nothing can really be done to make work as is due to size). This jobs table will certainly evolve over the 50,000 limit and I will have to start

Hello, I am new to Airtable. Is it possible to display an image/embedded it in Airtable forms? I am not talking about the standard logo/header image. What I would like to do is display images based on if a field was filled or not. Thanks for a your response in advance :grinning:

We have a field called Brands and we’d like to filter out several brands from showing going forward. Instead of adding each brand name as a filter itself in the View, we tried playing around on filtering out by creating a new formula field, and add more brands as we go into that field formula, to no avail. Here’s the formula - https://gyazo.com/6065751e7ed3d0b7f8a1ea2b7e3f5940. What’s being done wrong? Thanks for your help and time!

Hey - I have a somewhat specific question for a project management tool I’m trying to build (and I’m pretty new to Airtable, so this is evading me!). (1) On my Overview Tab, I have a list of Projects my team is working on (2) On a Second Tab, I detail out clients that each project pertains to and where they are in the process of onboarding (Step 1, 2 or 3, which are mutually exclusive and represent a work flow through our process). For example, Client A is part of Project X and is at Step 2 of the process. (3) Back on the Overview Tab, I want 3 columns to represent Steps 1, 2, and 3, linking back to the Second Tab to which clients are in each Is there a way to do this? I’m having trouble linking this up. Using a less abstract example: Project X pertains to Client A, B, C, and D. The client are at the following steps: Client A & B are on Step 1 Client C is on Step 2 Client D is on Step 3 I’d like columns on the Overview Tab t