Other Questions

Hi I am looking for a way to change negative amounts to positives and visa versa. Am currently doing in excel and moving over but wondering if possible in Airtable? Can anyone help please? Thanks, Maria

I’m setting up an Integromat integration to watch for Google Form responses and create new Airtable records accordingly. I’ve got pretty much everything working with the exception of one field… In my Google form it’s a multi-checkbox answer for the instruments people play, which (I believe) returns a comma-separated text string - or possibly it’s already treated as an array, I’m not sure. The values from that need to go into a Multi Select field in Airtable. The values in both the Google Form and the Airtable field are identical. From what I’ve found, I think this is going to involve some kind of array parsing, but I just cannot figure out what I should do in Integromat - their own documentation on this is not at all clear, so I was hoping someone here would be able to help me out.

Hi, I’ve been very interested to improve the efficiency of using Airtable. I wish we could use different bases for each department in the company but most of the work is getting done on one big (lots of tables) base. Hence, I am trying to find a good workaround. right after I saw the new ‘personal views’ section which is pretty cool, I started thinking about two things: being able to have the same feature for each department and being able to hide/show the tables. ex: we create a table in a separate base that holds the name of the collaborators and the departments they belong to. then we sync it with the main base. when we set up a department/group view, the views we added to the list will be shown by the people who work in that department only. In the meantime, if we can have (like edit permissions feature for the fields) ‘hide’ feature and we can select the departments which don’t need to see the selected table (when ‘select all’ is used, it’ll be hidden to everyone, when

Scenario 1 (Consolidating data across multiple bases) How can we combine common data from bases (assuming they have different number of columns and different information) into a single table that acts as the single source of truth? If not, what is the alternative for combining data from different bases into a single source of truth? Scenario 2 (Consolidating data within a base) How can we consolidate and merge data common information into a single table within the same base? Assuming I have to use “Linked Records” to merge data, is there a way to “mass populate” link records instead of manually selecting each record?

I’m about to bring on a couple of users for a base that I’ve developed for them. But I’m a little confused about how to manage this. I want these new users — let’s call them Ann and Ben — to have their own individual accounts. I want them to have to log in with separate passwords, so I can get the right values into the “Created By” and “Modified By” fields, and so that they can see each other as users when they’re writing targets ("@BenBenson", etc). If possible I would like to create the accounts for them, so that I can assign them passwords. (This is something I can do as a FileMaker developer. Is this even possible with Airtable? Is there any way to be sure that users have reasonably strong passwords protecting their accounts?) And I want to be responsible for paying for their accounts. #1 and #3

Hi Community!! I am trying to change a few fields to summarize the checked boxes that match a specific criterion (same campaign name). I have a table that shows the statistics of our campaigns (first screenshot). I am currently updating the MQL, discovery call booked, Demo booked, etc. fields manually on the “Stats” table according to the data on the “Contacts” table (second screenshot). I tried solving it using linked records, but with no success… Any ideas on how to solve this? Thank you!!!

Hi, I have a design request form for my coworkers to submit the dates they would like for their project to be designed. Is there a way they can select multiple dates that are not connected, like 8/3, 8/5 & 8/6? Right now I have them filled in as a single line, but ideally I can see it in the calendar view with the dates selected.

Hello everyone Is anyone else having issues displaying a calendar from Airtable within Outlook Exchange? I’m trying to to sync a calendar view with my work email, which is on outlook exchange server and I cannot get it to display properly at all. I took the “Sync to an External Calendar” link from the shared view tab for my calendar and followed all the proper steps to link it with my exchange account. When the calendar shows up it’s completely empty. This was working a few months ago but stopped working for me at the top of September. Has anyone else had similar issues?

Hi everyone - question here. I run a hostel that has different types of rooms. I have a table set up with a realtime feed of new bookings coming in. I have another table set up with room specs. I want to use the second table to analyse data in the first, for instance revenue per room type, which I can then combine with the SQM of the room for example, to see what room type works best. How do I filter and display revenue per room type (or avg stay, or whatever else) from one table into another? Free hostel night in the center of Prague, Czech Republic for anyone that helps me out here! :slightly_smiling_face:

Need to make a summ of Checkbox’s in Table 1 and release in Table 2.

Is there anyway for me to block some dates from being choosen in a date field?

So, let’s say I have a column that holds the total amount of revenue from each customer in a given month. That column is set up so that the total “Sum” at the very bottom of the table shows the revenue of all customers for that month. Is there a way to pull that total, the one at the bottom of the table, in to another table so that I can have a single table that output’s the totals by month…like a summary table? I would like to use this summary table as a nice easy way to share the monthly totals with the team. Does that make sense?

Hello, Big hope to resolve my problems here, for the last few days, I face this problem, so my goal is to create a shipping slip using an integration of airtable module - google doc - google drive - airtable I have finished changing the shipping name, address etc using airtable record data and converting it from docs file to pdf, but when I need to replace the barcode image ( from barcode images which generated using integromet barcode generator on other scenarios) I always failed to get the image ID ( I have followed the tutorial to change the ALT TEXT ) or event try another way by using google docs get content of document I still cannot find the ID of my images can someone help me with how to change the image in google doc replace image with new

Hello all. I’m trying to append the value of a specific field to the end of a URL that’s opened by clicking on a button field. For example, I have a field called ‘Deal ID’ and it has different values for each record. Example - Deal ID = 123456 URL = www.google.com/ What is the URL formula for if I wanted to append this ‘Deal ID’ on to the same URL for each record. I tried “www.google.com/{Deal ID}” but it didn’t work. Thanks Dan

Is there a way of adding “mock” collaborators to a base? (show name without having to send out an actually link to someone’s email) I am creating a project tracking base and would like to add mock collaborators until I am able to release the base for others to actually see and use.

Greetings Airtable team! Since it’s launch, I’ve been using Airtable Interfaces to create a companys with report, using charts and other options. However only pie and donut charts are working and returning with data, other charts like bar (which is the one I need) do not work and only return empty. I believe no information was incorrectly filled, since when I choose another type of chart it works. Anyone having similar problems?

My goal is to automatically create different page with the information I want to show to the client and then have the link shareable. is it possible in some way? Particularly I need to show a map component and the information of the record. Do you have in mind some solution?

Hi all, I would like to depict different Date ranges in the timeline view (e.g. like this example pic from Excel): However, I struggle to find a solution. I do not necessarily need the timeline view but I have a lot of projects who all have the same setup (x different stages with follow in a more or less defined sequence): Does anyone have an idea how to realize such an overview? Dividing each project into 5 subcategories and then using a Ganttchart seems to be extremely labor intensive. I would even be happy if I could have a simple continous timeline from start to end as offered today with milestones depicted in between at dates X, Y and Z. Like this example:

Hi everyone! I am currently importing data from a CSV sheet and I am trying to see if there is anyway I can sync the two so that when I add new rows to the CSV sheet, it automatically updates on Airtable. Is this possible and if so, how?

Hi! I am currently working on creating a base for some of our clients but the information needed for the records is housed in our database. Ideally, I would like to transfer the information from PostgreSQL to Airtable to make sure everything is accurate. Is there any way this is possible without using Zapier/integromat? If it is possible, will this solution offer continual updates or just a one-time import? Has anyone used PostgreSQL or some other platform like periscope to add information to their base? Thanks!

How do i remove and just gets the record_id form the record. without having to pick it let url = “https://hook.integromat.com/jdvimkhmxdtt5x7u5fomjh09hpxxxxxxx?recordID=”; let table = base.getTable(“Opslag :floppy_disk: ”); let view = table.getView(“Opslag som skal laves”); let record = await input.recordAsync(“Vælg opslag”, view); await fetch(url + record.id);

Hi guys! We are thinking on using airtable forms massively. Do you have any experience on how it perfoms? We are expecting 10.000 replies in one hour. Thank you

Hi community, I need your help. I have a concatened formula who find 2 result on 2 colums + text I just want to add this condition : if you have 1 or 2 result missing, display a bank field. This is the formula : CONCATENATE("Diamètre : “,{Diamètre},” cm / ",“Hauteur : “,Hauteur,” cm”) The 2 column : “Diamètre” and “Hauteur” Thank’s for your help Matthieu

I try to organized student in to each classroom. I have create main student information and field them to each class. Now I want to create new tap and show student information by classroom. Is it have anyway to do it or only can use Grouped by field in the main student information?

Hi everyone, I’m new here but already in love with Airtable. I need your help to solve my problem. Here is the case. I’m Product Manager and I’m responsible for prioritization. I want to involve everyone in the company to this process, by giving them a possibility to set their priorities within their department. To achieve that, I’d like to share with them their own table → which will be a sync table from my master table. This table includes every solution we’ve mapped so far. Here is an example: They can’t modify anything here, because it’s a sync table, but I would like them to set priorities. Nothing from among ratings (stars) or votes (number of votes) doesn’t work, because this way of prioritization results in the end that “everything is very urgent” or several of features are rated with same number of stars. So I want them, to prio