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.
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
I use a lot of linked records.Occasionally I have an issue where a [Record from table A] is deleted (by a user or automation with script) which triggers the deletion of a [Record from table B] it is linked to (by a user or an automation). Because changes to from [Record from table A] look up fields in Table B trigger other automations, these automations start running before Record from table B is deleted. However Record from Table B has finished deleting before the other automations have finished. This isn’t really a major issue, but it is an alert in airtable and my emails that I need to check to make sure something else isn’t going wrong. Is there a clever way I can simply check if the record still exists as a conditional action in running the automation? I realise this could be resolved by redesigning other automations, but that will require redesigning several dozen.
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.
Dear all, I do have a base with several tables in it of which HCO’s and HCP’s are two. HCO’s are Hospitals where HCP’s (doctors) are employed. I would like to be able to select and/or display hospitals based on whether or not certain HCP’s are available in a hospital (e.g. : display hospitals which do employ orthopaedic surgeons but do not have ophthalmologists available.Tried Airtable support, which came up with scripting. Please feel challenged to propose a non (or very, very, low) code solution for this! Thanks so much,MichielThe Netherlands
I need a form where clients can enter there data and as many fotos as they want taken directly with the ipad. In Airtable I need to make a entry for each photo taken.Example in Form i have.Name = Mr Example Email = lastname@company.com Photos = with ipad i make directly Foto A, Foto B and Foto CWhen the form is send the following entries must be done in Airtable:Entry 1 in airtable:Name = Mr Example Email = lastname@company.com Photos = Foto AEntry 2 in airtable:Name = Mr Example Email = lastname@company.com Photos = Foto BEntry 3 in airtable:Name = Mr Example Email = lastname@company.com Photos = Foto CThanks very much
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.
