Other Questions

Hi guys! So, I’m trying to do something that feels WAY more complicated than it should be. I have a view which groups records by week, then by type, then by status, and we use this as a dashboard to measure activity. However, we’d like a static report every Monday that summarises the counts in each of these dropdowns, otherwise we’ll need to manually ensure we check it every week and scrape the data on a Monday. I’ve tried roll-ups and count fields, but the way the base is set up means having a linked field just for this adds an otherwise redundant step into our users’ day. Even just the ability to do a rollup of things tagged as “content type x” within the last week would be better than nothing, but it’s seemingly not possible. It’s a long-term bug-bear of mine that it’s so weirdly hard to get record counts out of Airtable in an easy way, so any help would be appreciated. Thanks, Josie

I have a base where I track several daily routines to try to gamify the forming of new habits. Each row is a bunch of checkboxes and a date. Is there some way to count streaks like this? How many days in a row have I managed not to smoke for example :smoking:

Hi, We have a base that lists our staff calendar and we have approx 20 employees. When we duplicate the data for the next week, it is very cumbersome to keep the hours the same but change the date for each employee as they all work different hours. Is there a way that we can duplicate a previous working week and get the new dates populated in a more efficient manner?

Hi, How can I hide data in column for collaborators with editors role? For example, my table have columns A, B, C, D I want that editors can view and edit A, B,C columns But column D will be hide for them And only I as a creator can view and edit data in column D

Hey Airtable Community! For the past few weeks I’ve been trying to design the following process: A user submits a form entry. Depending on whether the user indicates if they’ve submitted an entry before and whether they want their entry used for a specific project, a formula field will produce a certain text string. 3.That formula field is added in curly brackets to a SendGrid HTML template, so that the appropriate text swaps in to each individual email, rather than me needing several different templates. This all works fine. I started running into trouble when I then tried to add hypertext. I thought I could get away with this by putting it directly in my formula (this is an example version): IF({Adaptation Switch}="Yes", "Text 1","Text two, and visit us <a href=\\"https://www.airtable.com\\">here</a>!") Of course, the slashes are there so that the quotations for the hypertext HTML don’t mess with the string formula. But when I then go to preview the email in SendGrid, i

I want to upload the photos I took to Airtable. How should I do that? thanks！

Hello, is it possible to periodically export our data from Moonclerk to Airtable? if there is a way, I would love to know.

Hi community, I have a Base for customers that is shared by several other bases using the Synced Table feature. Is it possible for linked records to be shown in the original table, as they are with the synced table? Example: I have a table of contracts with a linked customers field. I can see all of the contracts for a given customer when I open the synced customer entry, but it doesn’t show up in the original customers Base Thanks everyone!

Hi there! I am trying to devise a way to send an email with a recap of our sold inventory from the past week using Zapier. The Zap will be triggered upon a new record in a view. (Our sales manager will Audit the list from the past week, then use a checkbox to say it’s ready to go). Obviously, the number of units sold will change week to week, so I can’t use a static HTML table in my email. Ultimately, I’d love to end up with the same design I have in Page Designer - see below screenshot. (side note: I will be ecstatic on the day that Page Designer/other blocks integrate with Zapier - it would solve SO MANY of my problems if I could attach a page from Page Designer as a PDF to an email or to a record). Any ideas as to what sort of action steps I need to use before I build my email template? Thanks so much!

Hello everyone! I’ve created a calendar view (with correct dates) and shared the link to my Google Calendar. For some reason, the entry in my Google calendar is displaying 1 day late. It should display today September 25th and instead, it’s September 26th!

I am using the free version of airtable, just so you know before moving forward. I know you can simply look at your settings and whatnot and see the number of records is in your base. However, I want to display that number on a website that will change as the record count does. For example, I am running a database that can be viewed by the public. I want a message on my website that states something like, “number here objects in the database and counting!” I don’t know how to do script or anything so I figure I could use a COUNT formula or something and display that in a field, then embed that airtable onto the webpage. I know there is a count field function, but I am not wanting to count the number of linked records (you have to have linked records for the count category to work).

I have a central Airtable repository where records are managed. That repository is synced up to a second base. In that second base, whenever a record is added to the central repository, a new record is created in the second base in a tab separate from the synced data. All this works well. But what I’d like to achieve is the following: When new records are added to the central repository, I automatically assign them a Pending status. A new record is created in the second base with that status based on the sync. But when I update the status to Complete in the central repository, the already created record in the second base retains the Pending status, even though the central repository and synced data display the updated Complete status. Any thoughts on how I can resolve this? The automation I’ve set up to add a new record to the 2nd base whenever added to the central repository is demonstrated in the below screenshot.

Does anyone experience time zone issues when syncing date/time fields across bases? In one of my bases, I have many date/time fields that I’m syncing over to a different base. Those date/time fields have GMT selected in the original base. However, when these fields are synced across to different base, those fields became single line text fields instead. Thus, I have to use DATETIME_PARSE on them, so I can perform calculations on them later on. The following is an example of how I parse a synced date/time field: DATETIME_PARSE({Synced Date}, “M/D/Y h:ma”) I am in California, and I found out that my newly created fields may sometimes jump 7 hours forward or backward whenever AirTable syncs any new data, so I know that it is the time zone that is causing the issue. I’ve tried to manually assign the time zone on them but it doesn’t solve the issue: SET_TIMEZONE(DATETIME_PARSE({Synced Date}, “M/D/Y h:ma”), “America/Los_Angeles”) I’ve also played with setting the newly created fields wi

Hello All I work in the Marketing Dept and we have all day events in AT as records. After creating a calendar view and adding the iCal file to Outlook, these events show up as busy in the Outlook calendar blocking our entire day preventing us from scheduling a meeting with others. Is there a way to add the Calendar view to Outlook where the records don’t show up as busy as a default. Thanks

Hello…I am new. I need some help to do something… 1/I have a column B, with a currency field. 2/I have a column C, with % field. 3/I havr a column D, of number. 4/I have a column E, of % field. 5/I have a columm F, of currency. I need percentage of column C and E automatically. So if : Column B has a total of $100. IF I insert 10% into Column C. The column D should show me 90$. but IF i need to changes into Column D from 90 to 95$. then the column C shows me 5%. reflect both sides if i changed any value from column C and D. after that… Successive Discounts applied on column E. I insert 2% into colum E. Then column F will show me 88.2 (2% of 90 column D price) and the final price show me on column F. I.E. B=100$ C=10% D=90$ E=2% F=88.2$ if changes into D it reflects to C, if changes into Fit reflects to E. I don’t know how to create a formula which will calculate the discounted amount based on the price. I would be great to have some help on that! :slightly_smiling_face: Thanks,

Hello Airtable Community! I’m creating a form for people to fill out. When I view the information, I don’t want to view it in a grid (the style that looks like Excel/Google Sheets). I want to view each person’s entry like a card or face sheet and then when I click on them, I can see more information. Also… is it possible to share this information with my client by sending them a link? Thank you!

Hey :slightly_smiling_face: I would like to save sensitive information in AirTable. Do you know a way to encrypt columns? Thank you, Frank

Can I color dependency lines in Gannt view so they stand out? (Grey is terrible)

Hi, I have a team with multiple departments. I want all my departments to be able to edit and update Contacts from their respective bases. Is there a way to do this? Thank you.

Hello users! I have a budget model with a field that automatically calculates state taxes based on the price I include for a given product. In some cases, though, I am not charged any taxes, and my budget doesn’t allow me to leave it as “$0.00” - How can I adjust it so that I can modify the value to $0 when no taxes are charged? See attached

Hello everyone! I’ve created a calendar view (with correct dates) and shared the link to my Google Calendar. For some reason, the entry in my Google calendar is displaying 1 day late. It should display today September 25th and instead, it’s September 26th!

Hi all, I have an iPad and laptop that will be displaying a simple Airtable form for people to line up at an orientation event and physically input their details (name, email, mobile) to sign up for our newsletter. I have selected the option to redirect to the same form via its URL (see attached). While this is almost what we need, it still isn’t instantaneous and takes a few seconds (usually 3-5 seconds). Our alternative is Google Forms as it has this instant refresh feature, but I would prefer to stick with AirTable’s form rather than adding another step in the process. Does anyone have any suggestions to refresh the form instantly after one person hits the submit button? This could be a browser extension (but I have only ever seen timed auto-refresh, which is not ideal if someone is in the middle of inputting their details). I also have a Zapier account if that is of any help. This would save a LOT of time since 100s of people will be using this form, one after the other on two devi

Hi, I was experimenting with different ways to share a table with a client. I was quite alarmed when I tried “Download CSV”, and the attachments, many containing private/sensitive data, were uploaded to publicly accessible URLs by default without my consent. Is no one else as concerned as I am about this default behaviour? To my mind, unless explicitly stated otherwise, export/download should be exclusively to the local device. Uploading to public URLs should be opt-in. As it functions now, Download CSV is actually “Download CSV and Upload Attachments to the Public Web.” This is a security issue, especially since the user is not given the option to turn it off or even warned about it. Can someone please show me how to wipe/delete these attachments from the web? Thanks, SK

Hi community, I wish to copy-paste my field outside of Airtable in programs such as WhatsApp, Notes or Notion… However, the pasted text ends up with unwanted quotation marks at the beginning and at the end whereas in Airtable there are not visible quotations marks. This is the formula I’m currently using: CONCATENATE(‘Buenas tardes ‘,{First Name},’\n\n¡Espero que estés muy bien!\nComo te comentaba ayer, (…) manera interna.\n\nEncontrarás adjunto un showcase de algunos proyectos que hemos implementados recientemente con empresas tecnológicas.\n\nMuchas gracias por tu apoyo ‘,{First Name},’ y hasta pronto!\n\nAmaury’) Thank you!

I am trying to use Integromat to send data from Squarespace to Airtable every time someone places an order. In general, this works very simply, BUT some of the information I need is not available when I try to map the fields in Integromat - specifically the information from the product form. I run an afterschool program where parents purchase the program in Squarespace and part of the checkout process is filling in a product form with their child’s name, age, interests, etc. so that I can group the kids into the right afterschool sections. Is anyone familiar with this type of thing? I am trying to avoid what I currently do which is download the order info for each “product” individually (different days, times and ages) which seems to be the only way I can get the product form info in a squarespace download, but I thought maybe I could identify the specific product first, then feed that to the “watch transactions” trigger and get the right info into Airtable, but everything I have tried