Other Questions

Hi everybody,I have a question regarding syncing multiple workspaces into one workspace. I then want to merge the data that is synced so that I get one database with experiments. It is constructed as follows:We now have 3 workspaces with experiments, one for email, CRO and socials. Now we want to have an overarching workspace where all experiments come together so that we have one large database. For example, we can collect all experiments from one campaign.Now I succeed in syncing a view, but it then becomes a separate tab in the overarching workspace. Is it possible to import all data into one table. Or should these be 3 tables and is it possible to merge all this data into one table so that we have one library.I'm curious if anyone knows a solution for this.Regards, Martijn

The title says it all! Time zone is Berlin. How can this be?

Hi all! My team has 3 tables that we use to keep track of events that have associated dates and times, including trainings, out-of-office holds, and planned travel time. I want to create a calendar view in AirTable that includes all 3 of these event types to make scheduling easier. I'm pretty sure that the only way to do this is to combine all 3 tables into a new table where I can create the views I want. What is the best way to import all of the records from those 3 separate tables into a combined table? Is there a script that I can run that will do the importing?Once the new table is created, will I need to create automations that will ensure that if a record is created or updated in the separate tables, it will be updated in the combined table? Or is there a better way to make sure that both places stay current?Thanks, I appreciate the help!

Can I get a notification anytime a collaborator adds a record? Thanks in advance for posting your question! When someone provides an answer, remember to mark their reply as the :white_check_mark: solution.

Airtable's API does not permit the import of all fields containing numbers or currency ending in zero to no-code platform Bravo Studio. Can someone provide me with any tips or insights on what might be happening?

On this view,I need to create groupings based on the Max Price and Listing Price.The amount should match, but when I tried to do the grouping it did not show the correct numbers.here's the current setup.  Here's the outcome.The Max Price Should be $280k but why is it that the Listing Price of $285k was included on this group which supposedly was not? 

Hello all! I am in need of some brainstorming. My organization uses grant funds for some of our programs and I am trying to figure out the best way to keep track of how much we have left and which programs they are linked to. In order to do that I have one table with all of our program information and one table with the information about the grant, i.e. how much we received. For most of the programs we only use funds from one grant, so right now what I have is on the program records table a field for how much grant money was used, then I link it to a specific grant and in the grant table a rollup and then formula field calculate how much of the money is left. However, on occasion we do pull funds from two grants for one program. This creates an issue as then both grants are pulling the same number from the program records table and subtracting the full amount from both totals, rather than the partial. I considered having two used funds fields in program records, but th

Hi,I'm trying to push date from an Airtable base to a document managment software, NetDocuments, using the latter's native integration software, ndLink.How do I set up an Airtable base as a ODBC DSN connection?Best,Harrison

It is not about Formulas, but Form was not an option for a label.I need to put a form, where I let people to pick a product. I want to create a dropdown menu to select product. After submitting I need to remove that product from options. So there is only one product for each who submitted. Plus ! Because it is obvious ! When they change their mind I advice them to file new form with remaining choices and just remove their first form entry.But cant avoid the manula data editing upon request so each time a new form si filed it takes the actual data from the sheet in airtable options.Please can you help me with that? 

Hi All, Wanted to ask for help on how I can approach this. I have 4 coulmns (A, B, C, D) - I want to check which columns are not empty. Example, A has a value (Apple), B, C are empty, D has a value(Orange) I have another column called Summary. I want to display columns that have value. In the example, I would like to display Apple, Orange. Your help is appreciated. Thanks!

Im using Retool with Sequin to link my airtable database to Retool and im trying to insert into a link field some data but i cant do it like how i would normally insert a field with a sql query

Hello, I'm not sure which category this would fall under. I'm working on generating an automated report based on our data. I don't want it to be too long, so under one filtered category, I only want the report to pull information tied to a checked-off box that was only checked off in the last 7-14 days. (I'd like to be able to change the date as needed) The checkboxes live in our subtasks field and are rich text. Is there a way to sort when these boxes where checked based on date? For example, in the screenshot below, I only want to pull the checked boxes with green, not the ones with red: Is this possible? Thanks a bunch! Thank you,Lindsay 

I would like to use airtable Forms to track Requests for Interpretation with my Architect. Here’s what I’m struggling with… I want to fill out each RFI with the information I’m requesting comments on. Each form will be a different request. Once I’ve filled out the Question, I want to share the form for the Architect’s Response. I only see ways to share the same blank form every time.

I have a table of events that all have a start and end time/date.  The start field is "Start Datetime"For example, I have event that has a start datetime of 1/1/2019 at 11:00am.  All in a date field.  1/1/2019 specificially we use as a generic fallback for old events that didn't have a date.  So we pasted in 1/1/2019 at 11:00amThese events are linked to those who participated in them.  And they have a payment amount noted.So I created a rollup field with the intention of knowing how much we paid out to those in the last year.The rollup seems to be capturing linked events which are clearly older than a year, however, and I'm not sure why.My rollup filter has the "only include linked records from the Events table that meet certain conditions", and then a filter set to only include Where Start Datetime is Within the past year.Then it aggregates by SUM(values).None the less, it

Hello! I am creating a form for a table (let’s call it Table A) which has fields linking to another table (table B) in the same base. When filling out the field on the form on Table A, the user can only see the data in the primary field of Table B. However many of the records in Table B have similar primary field data making them difficult to distinguish. Being able to see one (or multiple) of the other fields would be really helpful. For the time being, I’ve made the primary field on Table B a formula that merges the most helpful relevant fields from that table, but it makes all my Table B views very messy/ugly. I wish this formula could be in a non-primary field so I could hide it, but then my Table A form wouldn’t show it. Please tell me there’s something stupidly easy I’m missing! Is there a way for a form to reference/show any thing BUT the primary data? Or is there a workaround I can use with another table? Cheers, Nathan

Say I have a base with two tables, A and B, where the primary field of B (a single line text field with the name B_name) has values B, 1 and B, 2, and where A has a field, B_name, linking to B. And say I now want to use the CSV import tool to import a single record into table A: A_name,B_name A1,"B, 1, B, 2" When I import this using the CSV import tool, the correct links to B, 1 and B, 2 are not established. How can I either Format the CSV I’m importing, or Configure the import in the CSV import tool such that the correct links are established? Thank you!

Any Idea why the scripting block would give me this error?  I've seen let query = await table.selectRecordsAsync();used in other scripts.

Is there a way to link my Phone Number field to RingCentral so that when I click on the phone number it’ll make an outgoing call in my RingCentral app or give me the option to send a text?

Hi Does anyone know of a way to ‘Filter’ a ‘Date’ column by something similar to “this week”? Basically, I’m just trying to create a Grid View that shows - via a Filter - all enquiries that have been received ‘this week’ (which is from Monday through to Sunday of the week I’m looking/accessing the View in). Any help would be greatly appreciated. Thank you Stephen

I have the free version of Airtable and am trying to find where I can see my data usage per page. I was told to look for my workspace settings page, but I cannot find that. Also. I keep getting a message that I've exceeded my record limit, however I am still able to upload attachments. Anyone know where to find your data usage, and has anyone gotten record limit warnings even though you are still able to add attachments?

After a record’s field changes from ‘Stage 1’ to ‘Stage 2’ I need to print the record. When it changes from ‘Stage 2’ to ‘Stage 3’ I need to print the record in a different layout. The Page Designer Block seems to do a great job creating the print layout, but I don’t see a way to trigger it for the record I’m editing (instead of searching for the record within the Page Designer Block). I also don’t see a way automatically trigger these prints. Is it possible? Any advice? It seems like external tools like Webmerge and Zapier might be involved, is that the case? Thanks, Mike

Does Airtable have a simple search feature similar to the "Find" in Excel? Suppose a user is updating random fields in a 10,000 record mailing list. They need to quickly find a specific record based on varying criteria such as an unusual last name, phone number, address, whatever information might be available to find the record. In Excel this type of task is a no-brainer, what is Airtable's (hopefully) equivalent search functionality? I've seen the filter feature, that would be extremely tedious for random searches of this type. I'm new to Airtable, maybe the feature I need is right in front of me and I overlooked it. Thanks

Hi,Since yesterday, whenever I edit a cell, Chrome shows the `update password` po-pup. Is it just me?Only happens in AirTable.Any tips?

I have a database where I have a check box that’ll indicate that a material has arrived. Im trying to have a formular to automatically record the date the check box was checked. Sofar I’ve tried with the following. IF({Trim arrived}=1,TODAY(), BLANK()) The problem that the date follows todays date and dosen’t stay at the date the the check box was clicked. Is there a way record the date it was checked in in the formular field

Why are the other fields hidden? Is there a way to rearrange them and not hide them?The arrangement should be - Staff - Start Date - End Date - Leave Type - Leave Count