Other Questions

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 then I realized I d

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's including linked events from more than a year ago, but only those older events tagged

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

AirTable seems to have made a change to the sync implementation in a way that has crippled a critical support process/automation we have in place. Based on the fact that this support article was updated today and one of our sync fields that used to be a Lookup (and on which downstream logic relied upon) is now a text field, we can only assume that a breaking change was deployed with no advance notice.Anyone else experienced this or have any issues as a result of this?

I’m pulling in Google analytics data to one table in a base via a 3rd party extension, it includes a column with a pageview number and another with the corresponding URL. On my other tables on this base I have the URL already in a column. I’m looking to pull in the pageviews by matching URL in my other tables and cannot figure out how to do this. Any help would be appreciated. Thanks!

I am about to embark on a large research project with the Royal National Institute of the Blind and one of the requirements is that the format we hand over our research should be fully accessible. Given there is going to be a lot of research findings I was hoping to use Airtable, but is it accessible? Thank you J

When I am in a base and click the "Share" button in the top right, when I start typing a name under "Email invite", I get a bunch of auto-complete suggestions of people I don't know and aren't in my organization (some are from Gmail, some are from corporate domains we don't have any business with, like GSK).Where are these email addresses coming from? It kind of looks like a database leak of some sort. 

I have to get approval for all software on an annual basis. The software request form now requires the name and phone number of a support person from Airtable before I can renew for next year. There are no exceptions to this rule. Does anyone have a name and phone number I can put down for this?I will never actually call this person. I just need something to enter on the form. I know the official answer is that Airtable doesn't provide phone support, but I will have to use a different product if I can't find real contact info for an Airtable support person.