Other Questions

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

I’ve got a table that lists our customers and who the primary contacts are at each. I’ve gone back and forth between (A) including the person’s name, email address, and phone number all in one cell and (B) that info in separate columns. I can see pros/cons with each approach and am interested in your thoughts/best practices. In approach A, I have the field type as long text, and it doesn’t look very elegant in the table view, as all the information gets jammed together (e.g. John Smith john.smith@domain 260-123-4567) Regardless of your thoughts about the first paragraph, is there a way to format the information so it looks nicer in the grid view.

Hello, in Page Designer I’m displaying linked records in table mode. A look-up of a single select column doesn’t display as a value but shows instead the ID of the single select value. I’m using a formula field to turn the single select column into a text string as a work around, but wondered whether this is this expected behavior?

Hey guys, We need to great a record in airtable that contains a graph like here in the image: We use airtable as our website database And we need to visually see graphs based on each record in the table (exactly as the image above) How do we do that, Any creative ways you can think of?

Hello. How can I set Timiline/Gantt scale by time in a day. This is a screenshot of Notion.

I have a table for physical addresses and a formula field to convert linked records to an array. Below is an example of the array. “Main Residence: 123 Main, New York, NY 10001”, “Office: 789 Left Ave, 3b, New York, NY 10001”, “Vacation: 456 Right St, New York, NY 10001” How can I extract or leave only the address for the office? If there is an office, show the address and if not, leave the field blank.

Hey , I’ve embedded the Gallery view to my website. Can I change number of cards from 3 to 6? Thank you :slightly_smiling_face:

I made a payment but did not link it to a workspace. The payment has gone through and the card has been debited. But, i did not realize it was unlinked. Don’t want to ‘lose out on subscription.’ Can you please guide me how to remedy this and link it to an existing or older workspace. Thanks

Hi there, I’m new to the Airtable and absolutely love it so far! However, there’s one task that I can’t seem to wrap my head around as it’s a bit difficult to understand the logic behind it, including the correct formulas/linking techniques needed. I will explain it in simple terms: Base: Baskets Table 1: Basket 1 Table 2: Basket 2 Basket 1 contains: apple banana orange pear Basket 2 contains: apple banana orange Basket 2 to Basket 1 match is 75% (3 out of 4 fruit match). I need to calculate and store the result in a record of Basket 2 table that says “75%” (percent field type) that basically means “Basket 2 matches 75% of Basket 1 contents”. Please note that fields in each table are defined as text, not as numbers. So I will need to find the strings that are true for both tables and then calculate the match %. I understand that some calculations, comparison and formulas have to be involved. I just can’t seem to understand how to link Basket 1 to Basket 2 (or vice-versa), and how t

Hello, HELP! Working with a base containing formatted currency fields but when downloading CSV, the resulting import into MS Excel, converts the currency fields to TEXT. Is there a way to override this so that currency remains as a number field? Thank you in advance Kind regards, Sally

We currently use a Formstack > Zapier > Airtable integration for dozens of forms, primarily because the Airtable form just doesn’t offer the functionality we need (logic, field validation, custom emails/notifications, branding, etc.). We deal with hundreds of users of varying technical abilities so ease of use for the end-user is paramount. All of our forms involve image uploads which are then added as attachments in Airtable. We used to use Google Drive for the image storage but this resulted in some sporadic problems with the images not being added in Airtable. So we ended up just using Formstack’s native storage on AWS. This has worked flawlessly for a few years. However, Formstack will be adding some security measures which will require additional authentication which will only allow Formstack users to access the files. This won’t work for our purposes and will probably break the existing integration with Zapier. Our options are to go back to using Google Drive and manually a

I have a packing list table and a list of trips, which are linked. I want to be able to add 50+ things to pack to a trip at once. What I can do is select all the things and then paste a linked record of a trip to the linked field. However, once there are already links, such paste will overwrite them. What I want to do is to append a trip to many things to pack at once, without touching existing linked trips per thing. I moved from Notion to Airtable, cause I thought that airtable being more of a dedicated database app would be able to do that, but I’m failing to find such an operation. Am I missing something?

Is there any good workaround to specify a global filter that applies to all shown tables or views? The idea is that a user needs to work with multiple tables/views and applying a filter to each of them (changing customer, for example) is quite cumbersome. Any ideas? The alternative we are using is using a different base for each customer, but that doesn’t seem very efficient and requires to apply changes in multiple bases.

Hiya, a colleague and I are working on the same airtable. There is a view available to him but it doesn’t appear on my list of views. Any clues how I can find that view? Thanks in advance!

Hi guys, First time using Airtable, been trying to set it up for a nutritionist clinic and I ran into an issue. Hope I can receive some guidance here. I have to tables table1 has user_height, user_weight and user_bmi (calculated based on the height & weight) table 2 has the bmi ranges min_bmi, max_bmi, bmi_status. E.g. min_bmi = 1, max_bmi = 18.49, bmi_status = underweight min_bmi = 18.5, max_bmi = 22.9, bmi_status = normal min_bmi = 23, max_bmi = 27.49, bmi_status = overweight min_bmi = 28, max_bmi = 100, bmi_status = obese In order to retrieve the bmi_status, the calculated bmi needs to fall within the range of min_bmi and max_bmi. How do I join table1 and table2 to get the bmi_status? Is it possible? Expected output: table1: user_id, height, weight, bmi(calculated), bmi_status (extracted from table2)