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 Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
Hello. Thanks for any help regarding this.I have an integration running in Google Sheets where Amex charges are downloaded into a Google sheet, almost realtime. My goal is to create a connection so that when a record is created in Google Sheets it is copied into an Airtable base. I think it should be just one way from Google Sheets to Airtable.The challenge is that the integration between Amex and Google sheets deletes all existing records and does a full re-creation of ALL the records in the Google Sheet whenever a single row is added.I didn’t realize this when I created a Zapier Zap to create a new record in AirTable every time a record was added to the Google Sheet. Before long I had thousands of Zaps on hold. For example, in the Google sheet if one new Amex charge is added, for some reason it deletes the 500 existing rows and adds back 501 new rows. I asked support for that product why they do it, but I’m certain they’ll have their reason. Just haven’t heard back yet.So to make
Hiya! New user here, so forgive me if I’m being silly! I’d like to limit character input into forms to a certain length (let’s just say 32 characters for argument’s sake). The proposed form is for clients who want to submit product descriptions to an app (hence the need for character limits). Now I could go through and check each one individually, but it’d be great if I could just set a limit warning instead. I read this previous post: https://community.airtable.com/t/limit-characters-in-long-text-field/7353 but it still doesn’t solve the client-facing form issue. One thought I had was another app integration? I haven’t checked if this is possible yet, although I suspect I’ll fall into the same character limit problems. Has anyone got a suggestion or a neat way to make this happen? I’d be much obliged! If you don’t think it’s possible, please leave a comment saying so - it’d be great to know either way!
Hello, I have a base that has the date and time in one field, I have created another field and I would like to have that field enter the YYYY from the date time field using a formula. Would anyone know what the formula would be? Thanks in Advance!
I'm creating a form and need to create some conditions to separate our large inventory into categories. When I create the form view from the data table screen, and run a test the dropdown looks like the first snip below and appears to enter the data sheet with all of the correct information. When I add a new field and link to record, choose the same table, set up the conditional formatting and run the test, the dropdown looks different (second snip) and all of the information goes into the data table except for the name. As far as I can tell they are set up exactly the same way, the only difference is the Product ID field is automatically entered when I create the form view. Any ideas on what I'm doing wrong or how I can properly duplicate the product ID field?
I currently have a system created to track gear that comes to my warehouse and then leaves.I have different ways in where this gear arrives such as picked up by us, dropped off to warehouse by client, picked up by client from warehouse or returned by us. I have a field for each of those ways. most of the time when it is picked up by us it is also returned by us. I want each entry to automate being returned up by us when i choose picked up by us. Same for the other ones that are paired. What steps do I have to take to make it to where each time I make a new entry that this can be automated? I also do not want it to effect previous entries already made.
right now I have two calendars for my inbound and my outbound dates. I want them both to be on the same calendar
So I have a table called Investors. Say there are 300 records here. And I have a table called Companies. Say there are 100 records here. And I have a tabled called Individual Investments. It’s the intersection of Investors and Companies. An investor can invest in any deal they choose and invest any amount. So I might have, say, 2,000 records here (but obviously I wouldn’t have more than 30,000 — which would be if every one of the 300 Investors invested in every one of the 100 companies). In the Individual Investments table I list the Investor, the Company in question, and the amount they invested. We’d like to send a report to each investor that lists all their investments and how much they invested. I once figured out how to put this together in the Page Design block and I’m sure I can muddle my way there again (or come here for help) but I also want to email out this report as a PDF. And not just one big report showing all 10 investors what all 10 invested in, but a customi
Originally when we created our system, we used text fields to record the Call Time and Gig Time Span. Since we have the time zones already saved for each record, I am wondering if there is an easy way to do the following: Switch the Call Time Field from a Text Field to a Time field (without having to type the time zone every time) Switch the Gig time Span Field into 2 different Time fields for both previous records and current records, a Start Time and End Time. Similarly, I do not want to type the time zone every time. Moving forward, I would like to only have to type the start start and end time for an event in separate fields (not in the text box).If this is possible, these would save a ton of time and allow us to do better, more efficient work. Thank you for your help!
Good day.I have a “whole” staff table, with various “statuses” SOWs, Guests, and FTE. However, a newer table was linked to the base, with “special” contractor statuses. I need to have these “added” to the above Full Table, along with their statuses, etc. The whole needs to be the final source as it’s used across bases. How might I go about this?
I changed the primary field in a source table. I also want that to be the primary field in an existing synced table, but the primary field doesn’t change.If I go to “Update sync configuration” and then “Edit synced fields”, then select “Specific fields in the source...” it does not give an option to change the primary field, like you can when first creating the sync.I’m syncing a view from the source table, so I could create an identical, duplicate view there and then change my sync to point to the new view, but I worry about how that will impact all the lookups I have configured. Will I need to redo them all, even though the fields will actually be the same? So I’m hoping there’s a way for the synced table to use the new primary field from the source.
Hello community, I created a DB to collect startup informations through a form.To impose a synthesis, I need to set a certain limit of characters for “long text” question.I can not find a way to do it with Airtable form, so I am integrating a different tool.Nevertheless, it’ll be more practicle for us to stay inside Airtable.Any suggestion ? Best regards,Marco
During the keynote, the speaker showed an interface that had a interactive map with a list of records shown along side it. Is this a new feature or an existing one? How do I use it?
Hi, I am trying to set up renting hours for a local association and I am looking for the best way to do that.We have some outdoor material that can be rented by the hour. Would you have a smart suggestion for not having to write manualy 8 lines (8hours per day of renting) x 123 days (4 months of the summer) = 984 lines ?After we will see yo integrate that with a google calendar.Thanks
Hello, I work with ships and would like to create a grams/day formula which takes the date from our last interaction (order) with that ship to measure from. I cannot work out how to have it search for the previous record to take that as the date to give the days passed value for the equation.Anyone have any tips?
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
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.
