Ask questions, get answers and engage with your peers
New here? This is a great place to start.
Get support directly from your peers.
Celebrate your Airtable wins.
Forge connections with other users.
Explore and RSVP for upcoming events.
Read the latest news from the Airtable team.
Hey guys, I’m using the “Insert Record As Grid” feature in Airtable (screenshot below). When I choose this, it lets me choose the columns I want included in the grid.The columns of the grid appear in the order of the dropdown list that appears.Where does Airtable take the order of the dropdowns? From a specific view?I want to order the columns differently but it does not work. I have lots of different views, so I don’t know which view determines the order of the columns. Would really appreciate the help! :) Thanks so much in advance!
I just opened up my own practice and am trying to avoid using expensive law firm management software. I have been exploring and tailoring the Law Firm Management template for my firm and so far so good. However my biggest struggle so far is setting up my Billing and Expenses table in such a way that it will produce a line item Invoice. I am using the Page Designer and Time Keeper Blocks and I know that ultimately the issue here is how my Billing and Expenses Table is set up, but I’m not quite so talented with spreadsheets/databases. I need to be able to have multiple time entries for a single Matter, but only one time entry per day. Each entry should list the Date the work was done, Description of the work, Time it took to complete the work described, Hourly Rate and then a Total amount of Hourly Rate x Time. I also need to enter individual line items for expenses (filing fees, payments to other professionals that assist on the case, etc.) However the problem that I am facing is that
Is this possible? I have multiple views which I use, but not all information needs to be displayed when I add a record through a linked record. Right now, it seems whatever view is at the top of the list in a table is the one that shows up when a linked record is used.
J’aimerais créer un champ dans une table qui permettrait de calculer le nombre de rdv réalisés pour chaque personne à partir des rdv portés sur un calendrier
Hello,
We are getting close to determining of going with Zapier or Make. I know very well the feedback about Make vs Zapier. However, the decision is more than just me. Either way, our team has a question on how to best judge how many actions or operations is enough?At minimum we’re quoted around 300k-500k runs. I can understand there is a number of variables at play.Some considerations:From an Airtable perspective on an Enterprise account with over 20 apps used across the organization for about 150 editors Considerations to connect Airtable with ServiceNow, MS products, and other financial tools Starting out with about 5 developers using the API solution Definitely be capitalizing on the AI offerings either hasIf anyone has insights on how to determine what is needed love to hear about it.
Okay, so it's 2023. Is it possible to update information in a record via a form and not delete data if the form field is left blank yet? I wish to allow users to update database information via a form, but I do not want the existing data in a field to be deleted if the user leaves a form field blank.Is there a way to achieve this in the Airtable UI and not third-party apps?Is it possible to add to the photos via this form submission instead of replacing all the photos with the update form? For example, photos 1, 2, and 3 already exist in the data. A user used the update form and uploads image 4. So it would update the data to have photos 1, 2, 3, and 4. As it is not, it replaces photos 1, 2, and 3 with just photo 4.Thanks for reading!
I have a table where there are potentially multiple images available:Two columns linking to other records, then One Lookup column for each of those to look up the image attachment, and then finally, One more column where I paste a screenshot, used for cases where neither of the other links are present.So there are potentially 3 columns which could contain an image attachment. If I were to try to build a sensible gallery or an app, I’d only want one image for many of the views, so I’d like to make a Best Image column.The rules are more or less:Does Source 1 exist? If so, use Source 1 If not, does Source 2 exist? If so, use Source 2 If not, use Screenshot If I try to do this using a Formula column, I end up with what looks like a URL to the image on dl.airtable.com, instead of it displaying the image. The docs do say that attachments can’t be returned from formulae. The thing it does return may be usable for a webapp still; I haven’t yet tried. At the very least, it isn’t viewable
I am creating a new module of airtable in make.com. However every time I try its uses the name of the earlier connection. I want to have a new connection with a fresh name. why is this happening?
Hello All, I have some fields in my database that are mandatory at different stage. I want to do a form with the first fields for the first time, and then send another form prefill and update the record. I do not see how to update. Is there a way to do it ? thanks
In order to compute a change in a value between a prior record and a newly inserted record, is there a way to get the most recent prior value for a field in a table?Assume table is sorted (e.g., by DateTime).Ideally with a formula something like the pseudocode below where the “Prior_Value” and “Current_Value” are a number, such as: an amount, a quantity, a weight, a height, a length, et cetera.Delta_Value = [Prior_Value_from_Prior_Record - Current_Value_from_Current_Record]Thank you for any and all suggestions!Rick
Hello community 😊I think I want to build an app that converts your paper documents into Airtable records. Just take a picture and it will fill out the corresponding record fields for you. But before building it I want to see if there’s interest. So, if this is something you would use, please let me know by filling out this form: https://airtable.com/appafp6Lmjx6JWTQT/pagXrEyUU67hnWu3Y/formIf you want to check out the concept video:
I’m looking for an experienced Airtable expert to help develop an MVP platform for a modular workflow and data tracking toolkit focused on operational delivery of sustainability or performance commitments. The tool is designed to support teams and suppliers in delivering on tiered targets (e.g. Bronze/Silver/Gold), track data and activity at project level, and surface both progress and recurring barriers. The front end will be built in Softr or a similar no-code interface to allow intuitive access for different user types (e.g. project teams, suppliers, funders). 🔧 Core Airtable Build Requirements: Projects must be able to select from Bronze, Silver, or Gold commitment levels, which trigger: Tailored workflow prompts Role-based task assignment Procurement guidance aligned to the selected ambition Data collection requirements (e.g. quantitative and qualitative inputs) Generation of performance dashboards (e.g. % progress, commitment met/not met) Calculations of efficienc
Can we *please* get an Airtable API that supports native stats operations? I’m tired of having to ship data *outside* of Airtable in order to get this information.
Hello, I am trying to write a script that will automatically match records. The Base set up is as follows. Table 1: Contacts. Table 2: Has. Table 3: Needs. Table 4: Matches. Contacts and Matches are self explanatory. The Needs table consists of “Buy Boxes” for real estate investors. i.e. Property type, max price, number of bedrooms, state, city, etc. The Has table is where new opportunities are entered. The goal of the script is to then automatically match new entries in the Has table with open Buy Boxes in the Needs table, then score the matches based on the number of criteria that match, different criteria will have different weights. Null in either Has or Needs table should not effect the result. I am having a lot of trouble with this, as there are many variables in the Needs section.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
