Other Questions

We are looking using a Timeline or perhaps Gantt to assess producer workload at a glance. I have a Gannt and Timeline working at a basic level but need additional detail.I would like our team to input milestone dates into the base spreadsheet for each project line, to have those milestones show and update in the project blocks in Timeline/Gantt. Is there a way to include Milestones from date columns in a spreadsheet?Thanks

My base is gone along with my spreadsheet. I emailed the support team a few days ago. Haven't heard back yet. Any idea how long it typically takes to hear back? 

Is this possible? I have too many tables!

Hi, I need help. I logged into my account and my spreadsheet is gone. I believe it was link to a team account which was deactivated which may have erased my spreadsheet ?! Is there anyway I can retrieve it ? I don’t see any options in my account portal. 

Hi Everyone, Is there an automated way to combine 3 lines into one? The context is that, we will have 3 different persons filling in 3 different forms to feed into the same table, but want to combine them into a single line. Dedupe is OK but we will need to do this 1800 times :frowning: And of course, there are a lot more columns than shown above. Thanks.

Hi there, i just subscribed to the Team plan using 96$ of credit that i had stored from the last few years.My question is, when my plan will be automatically renewed next year, will Airtable consider the credit that i will have by that time?Example:i subscribed today (09th February 2024) to teams, my credits are now 0$.If i will have 50$ in credit on the 09th February 2025, will Airtable use the credit to renew the plan, or i will pay the full amount?If i will pay the full amount, what if a unsubscribe and the subscribe again (as in the subscription phase i have been asked to use my credit as part of the payment)? Thank you for enlightening me

Hello,Yesterday I realized that I don't have a backup of my many bases.Quite worried, I then looked for a solution. And found out: Almost all of them are quite expensive, and some of them seemed awkward to handle.Now I would like to know how important it is to have a local data backup?Is it really possible for my data to suddenly disappear one morning? Perhaps due to some error on the part of Airtable, San Francisco?Or is all data backed up redundantly several times, as some providers claim? So secure that you don't have to be afraid?Marceting

Can I download my csv on a MacBook ? I don’t see the download popping up.

Bonjour,Je souhaite que mon collaborateur ne voit que les entrée de ma vue auxquelles il est assigné.Lorsqu'il clique sur le lien qui lui ai envoyé par notification il a accès à l'ensemble de la base même aux entrées qui ne le concerne pas.Merci pour votre aideEmilie

Anyone have experience removing someone from a workspace, then adding them back to a base? Will that erase timestamp, commenting, etc? I basically have everyone in a workspace and 75% of them are editors of that workspace. However, I need no one but myself to control entire workspace and all its members have access to only the bases they are assigned to. Thanks

Sync is not working!!!

Hello everyone, I have a base in which I have defined tasks with a start date and a deadline. Both dates are calculated from the start date of an event and a number X days before the event starts.In three cases the tasks have to start after the start date of the event which is why I used a negative number. The date is calculated without any problems, but these data records are not displayed in the timeline.Can anyone help me with this?Formula for calculating the deadline:Columns:Timeline: 

Hi All,I have a table for Employee Timesheets How Do I get a value from same table i.e. reference a record with same date + specific other field valuei.e. the timesheet table contains multiple records for same day...  I want to get the postcode for the previous job, which is determined by Job Order Number field...  I'm new to AirTable so please bear with me.ThanksKalpesh 

Hi Experts!My goal is to create an image carousel in HTML/CSS to embed in a website in order to view the image uploaded in an attachment field for each record. Something like Airbnb image gallery. The number of photos may vary so it must be flexible.I'm currently using Softr to display my item details in Airtable but the options to show images are poor and not very UX friendly. But I can embed code. I already do that with embedded YouTube videos and google maps.Right now I'm thinking to build a html code + CSS iframe with make.com that is feeded with Airtable attachments with the iterator block, and then copy to in a rich text field for each record, but I'll need a CSS HTML5 developer.Any other ideas on how to implement this?Thanks a lot for any suggestion!

Hi everyone, I have a collaborator with Creator permission who is unable to add attachments to an Attachment field. Is there a solution?Thanks in advance.

So GIFs working on synced view on laptop but not on android. But if view is a shareable link they work? Same data.At mo I created a button back to original as want to edit on phone but mystified why not working. Sure it worked before on Pixel phone but now on Samsung. Any thoughts anyone?

Hi there ! :grinning: I’m very very new here, on Airtable, so to begin gently, I’ve come up with the idea to build a DB regrouping all the info I have on the pets I lived with (dead and alive). But I’ve got a DATETIME_DIFF() formula difficulty. On my base, I’ve created kind of a summary table with all the general info concerning the pets (Species, race, gender, etc…) On this table, I’ve got a field Date of Birth (DoB) and a field Date of Death (DoD). What I would like to do is to create a field that would give me the actual age of the pet (if still alive) or the age of the pet when it died, on same table, if possible :winking_face: . Reading the help documentation and many topics here concerning the DATETIME_DIFF() formula I found this : DATETIME_DIFF(TODAY(),{DoB},’years’) Which works perfectly for the actual age of the living pet. And… DATETIME_DIFF({DoD},{DoB},’years’) Which works perfectly for the age of the pet when it died. If I get it right, I would need to create a IF() nes

Hey there, Is there some way to count the number of entries in a Lookup field in the same table? I have a Lookup field called ‘Roles’—it references another field on the same sheet called ‘Movies’ and spits out a list of acting credits associated with those movies. I need to count how many credits there are, but the ‘Roles’ field doesn’t appear as an option in the Count drop-down. Is there some other way to do this? A formula maybe? Any help appreciated! Thanks! Jez

I have been building a income and expense tracking base for myself that has evolved from a Google Sheet. Thus far I am loving the Airtable features and am anxiously awaiting a plotting solution. I have a question about implementing main categories and sub categories. For each expense I have defined main categories and sub categories. I have currently implemented this by creating separate tables within my base. One for main categories and one for sub categories and then linking to them within my main table. My problem is that my design requires that each sub category belongs to only a single main category however I have to manage that manually as I do not know how to explicitly restrict that relationship. Thus far it works as I am the only one that uses the base and know which sub categories belong to which main category. I would however like to share the input responsibilities with others in my family and also make the base available as a more general solution. Additionally it would be

Hi everyone, may I know how or if it's possible to create 2 columns below a single field? Or 2 columns below a single cell?  

I feel like I'm either being stupid or something odd is happening regarding LIST VIEWS.In my Interface, I can add a LIST VIEW and add levels and it works fine.  My table has a Providers Table at the top, linked to Payroll Table, linked to Transactions.  works as expected.BUT, in my Providers TABLE, when I add a LIST VIEW and try to add Levels, it ONLY shows the ability to add levels ABOVE, not below, like it does in the Interface.  There are no levels ABOVE, as Providers is the top. Why does this work fine in Interfaces but not in table views???

We are currently using Airtable Team and have  a billing question. So our team devolved 2 interfaces. 1 for managers and another for HR. Managers are only collaborators in the manger interface. would we still be billed the full amount of 20 USD per collaborator even though they don't have full access? 

Hi, Zapier pulls in employee leave when its added to a google calendar. Employees can take time off in half-day increments. If the start date is 21st Feb 2020 2pm and the end date is 24th Feb 6pm that should come out as 1.5 days holiday. (date diff ingnoring the weekend). I think I can see how to add in UK holidays but is there a good way to take the time of day into account so a morning or afternoon is counted as a half day? Thanks!

Hi, I have a table with a single select field called “Status” that has 3 values (Pending, Refused, Granted) I want that every new record to be receiving default “Pending” value and i also want to be able to change it afterwards to either Refused or Granted. Thank you

I have several tables in my base.For each table, I import, on a monthly basis, an Excel spreadsheet.Every time, every single time, I have to re-map all the necessary fields (15-20 for each sheet), even though the format/layout of the spreadsheet hasn't changed.I want to know how to avoid having to re-map every time I import an Excel spreadsheet. I want Airtable to remember the mapping it used for that table the last time I imported an Excel spreadsheet.I am NOT looking to import CSV data. If I wanted to do that, I would use the CSV Import app. I don't. I want to import Excel sheets.Can this be done or not?