Other Questions

Hi, i want to share a view to my employe, in a new base, from a general base. In this general base i have some partners. Is it possible to do a sync base with filter for my employe that he’s seeing only specific data ? iI don’t know if I’m making myself clear, thank you for your feedback.

How to make a base private in a shared workspace?

I’d like to be able to reorder fields, sometimes several at once. Presently, I’m clicking on a column and dragging it. Is it possible to reorder multiple fields at once?

In Interface - Is it possible to improve the amount of detail shown directly on a line chart? I’m looking for: -a point at every data point (instead of just a line with no points) -a label for a price at each data point (not just on hover over, but directly on the chart) -more frequent numbers/hashes on the Y-axis (my y-axis price) -also looking for the ability to not aggregate… -also looking for the ability to have multiple groupings -would also be wonderful to have similar functionality to the Charts extension where you can click on a point and open up the record from the Base… …any tips appreciated!

Hey AT community! Been working with Airtable for only a little while now and having trouble coming up with a formula that we will use in many of our tables. I would simply like to input an amount in a USD$ field and have it automatically appear in the €EUR field by multiplying it against an exchange rate (ie. 0.93) Often, we receive both currencies in sales or donations. In other words, if the Euro field is empty and the sale was in USD, we could enter the USD and exchange rate and have it calculate and populate the Euro column. Here’s a screenshot of the columns and what I’m trying to figure out. How would you suggest I do this? Thanks in advance!

So, one of the repetitive tasks that I have is to go back to a certain day when a receipt was made and find the USD to EURO exchange rate for that day – and then robotically and often zombie-like paste it into the record in Airtable. Here’s my question(s): WHERE do I find a site or a feed that I can pull the historic exchange rate from (which plays nice with Airtable) and HOW do I script it to look at the date and get that information? I’ve tried various sites and ways to do this and have not had much luck at all. I need more brains - your brains. (trying to stay with the zombie theme a little bit) :slightly_smiling_face: thanks in advance!

Hello! I was wondering if there’s a way to show current or specific previous date $ value of any cryptocurrency found at CoinMarketCap website. Any help will be appreciated. Thank you!

Hi! I’d like to push the latest collaborator comments in a record to a my main table/view so that I can see what the latest comment is without having to go into the record. My use case is that I want to be able to track comments/actions across my team at a summary level as its hard to track within each record. Thanks!

Hi there, Does anyone have an idea of how I can download a dashboard design off interface to pdf? I’m looking at generating specific reports for clients and have managed to create dashboards on an interface but looking for how I can download those reports as PDFs for my clients.

Here is an example of what I have. Each student has 5 choices in the answers. 15 questions, 30 students and 5 choices per question. I need to create a global pie chart for the percentages answered to each question. In the example: How often do you consider someone else’s Pain? The answers: Very Often, Often, Sometimes, Rarely, Not at all I need the poercentage of how many students answered Not at all or often etc

Hello! My main table consists in several projects (Rows), each of these projects have a list of items with a common price (I am using another table with the price list per item). I need now to display two things, first I want the standard values to be SUM up on the project and shows me the “Total Contractual Value” according to the amount of standard items added. Second, I would like to add a variation price on top of each item on the price list, but this number should be related to the project, not the Item, the contractual value will never change but the grand total per project can. Hope I managed to explain well, Thanks in advance for the help

Hello Airtable Community :grinning: I am building a production management base to track production of ONE PRODUCT comprised of MANY parts. Ideally, we would like the creation of an order to trigger ALL ITEMS on the BOM to subtract parts needed from inventory at once. Is this possible? Could someone weigh in on the relationships and formulas to accomplish this? Order records are entered manually. This is a high-ticket item, and the sales process takes months, so, that part of things will remain manual. Is this possible? Can someone weigh in on the relationships and formulas needed? In reading through many of the questions submitted and only see a way to manage many products vs one, and don’t see any that I recognize as doing what I describe above. I am reasonably skilled at Airtable, however, not so good at understanding how to make more complex relationships work. Thanks in advance for your input

I am sending emails using the airtable script and send grid, but I am not able to add attachments in the email. Is it possible?

Hi, I am trying to create a simple automation for a ‘date completed’ field that takes todays date and inserts into the ‘date completed’ field when a certain status is selected. It seems that New Zealand will not work correctly for this whatsoever though. The first issue is that the local selection for date formatting is not correct at all and shows the date as M/D/Y rather than D/M/Y. The second issue I encounter is that the date is always actually a day behind. It seems to show the date in GMT rather than NZDT even when I have tried to set it to NZDT. TODAY() shows 10/17/2022 even though today it is 18/10/2022. Can anybody help?!

We have a pivot table to review a variety of reporting, but currently have 2 major issues: Months with no data are not being represented, making it look wholistic when in fact its not. IS there a setting im missing or a way to force empty months into the reporting? Column headers are getting squished making headers difficult to read. Is there a way to force same width for all columns? Or at very least to also take into account column headers as minimum width (not just the values)?

We did applied as a educational instituation with this account. How do I pay for the Pro plan as educator after the Pro trial?

I’d like to use this previous example as a foundation for this question. What if the value being rolled up isn’t a number/date, but a status? We are an agency business who has a number of clients, each with their own product(s) that we are presenting to other organizations. We log our outreach to these organizations on one table, and each log entry contains a date, a status (Potential, Pending, Ongoing, On Hold, Lead, and Not Relevant), and some text on the action taken in that record. Right now I have no problem sorting the entries on that table so that they are grouped by Org, then bu product, and the logs are sorted by date so most recent is first. I would like to, however, be able to pull up (for example, on the table that lists all the organisations we pitch to, see at a glance the most recent activity related to that product,

Hello all - I am struggling a little with filter condition groups. Basically I want to show records that match the following :slightly_smiling_face: Type is “Travel” Venue is A and Stage is 1 or Type is “Travel” Venue is B and Stage is 2 In other words - only ever show entries that are Type = Travel, then only show entries that are either (Venue = A and Stage = 1 OR Venue - B and Stage = 2) I don’t want to show entries that are Venue = A and Stage = 2 - and I don’t want to show entries that are Venue = B and Stage = 1 This always does my brain in! Any help appreciated - have tried several times!

Here’s the scenario: I have two tables I use for managing volunteer shifts: Roster Vollie Check In A number of people forget to complete the Vollie Check In and I have to chase them up every day. If it was a paid job there’d be the incentive of getting paid only when you complete your check in, but as it’s voluntary I’m left herding cats every day. What I want to do is either: Create a view that filters Vollies who haven’t completed their check in that then triggers a daily automation email reminder, or Skip the view altogether and create an automation that compares the respective Vollie field in each table for Today() and triggers the aforementioned automation. I haven’t been able to find anything to compare records in respective tables in the community forum. Thanks!

I’m not sure this is something that Airtable can do - but let me describe the idea: A customer fills a shopping basket full of items - so one field is “order contains” and it lists all the items contained. The items are in a separate, linked table, and have associated values in that table. I’d like to add up the values of each item so we know the value of the customer’s order. Each customer has a coupon which tells us how much they can spend. In a Best of all Possible Worlds scenario - that calculated value of the order would be compared to another value to determine if the customer overspent their allotted “coupon”. Is this doable? How?

I have seen that many people are requesting advanced permissions but haven’t seen my use-case if somebody could please confirm whether this is possible. I would like to know if you can allow user view/edit rights based on cell value. I’m very new to Airtable so perhaps there’s a good way of doing this without me thinking like I’m working in Excel! I’ll use the most simple example I can think of below. Company XYZ has sales team made up of East and West, users are assigned to each team in a table. Person A - East Person B - West Then there are prospects in a new table assigned to a Team and person. When adding a new prospect, the prospect should default to the team that the sales person is attached to. Prospect A - East - Person A Prospect B - West - Person B What combination of the following can I do please? Make it so that all sales people can view all prospects but only the team who owns the prospect can edit

Hi :raised_hand_with_fingers_splayed: , I need to share some projects with a number increasing of clients. For example, this client give an oppotunity to another. And I need the client could come back and indicates if the oppotunity is finally ok or not. In the long terms, I will have a lot of clients. Could you please tell me which is the more economic way ? Thanks for your support.

I’m struggling to import into tables/sheets that have a lookup field setup. I tried: import from Google Sheets import via copy paste download as csv > import via copy paste The “Account” is always disabled during mapping and has a tooltip “this field type is not supported” I found this similar sounding issue: Bulk upload interactions? Unfortunately I doesn’t specify the answer.

I would like to know if you can transport configuration and other application changes from one (source development) workspace to another (test, production etc) throughout production iterations (versions) without the need to build from the ground up in each workspace copy. Cheers Shaun

@Joe_Hewes saw a thread about sending data fromWordpress. Does Forminator work with attachments? Thanks