Other Questions

Hustling bookseller’s back. So I inherited thousands of books from my dad, and he, erm, didn’t have a lot of foresight when it came to the way keywords would be used in searches – especially not on Amazon, which has a standard set of keyword values that are permitted to booksellers. What I want to do is create a formula field that looks at Dad Keyword “AMERICANA #7833” and renders only AMERICANA, leaving off the useful-only-to-Dad random characters. Sometime he’d stick in letters, punctuation – I have no idea what he was thinking (but bless him, he knew how to find good used books). What kind of formula might work here? Thanks in advance to anyone who takes a crack at this!

I’m having a random issue and I’m not sure why. I have some forms in page designer and one of the fields is a formula that calculates today’s date, so when the letter/form is sent it has the right date at the top. For some reason, it is pulling yesterday’s date. I’ve tried refreshing and reloading the page designer forms, the whole website, etc. It still is showing the wrong date, but the formula column on the table is correct. Why is it pulling yesterday’s date? I’ve included some screen shots to show what I mean.

This was brought up a few times over the last couple of years, but it would be nice to have this ability to have this exposed on a form. This adds the flexibility to allow users of the form to add what is needed. If it could be turned on when needed that would be great!! :grinning: Or add another type of single and multi select that would allow this functionality.

Is there a way to query a range of records provided by the API? I’d love to be able to cache the first 500, then load subsequent records on demand. The current pagination flow makes this difficult since the offset seems to be unique to the time it’s called. I’m looking for something similar to this SELECT * FROM table limit 500, 600

Hi lovely airtablers! Just a quick and simple one I hope? How would I create a field that automatically denotes whether a record is a duplicate on a single field only? I have orders that share the same order code and I’d like to know which line items are part of the same order. This duplicate field could be a checkbox or a single text field and should denote all records that are part of the same order code. Any help would be gratefully received. Thanks Claire

Bookseller here trying to survive by listing on Amazon. I have lots of books that are so old ISBNs didn’t exist when they were published. For those books, Amazon offers what they call a “GTIN” exemption. So I have two fields: (1) a single line field called {Product ID}, which contains an ISBN if available, but is, otherwise, left blank; and (2) and a formula field called {Product ID Type}, which needs to contain “ISBN” if {Product ID} is NOT blank or “GTIN” if {Product ID} is blank. I have no idea what might work here. Fingers crossed that one of you do. :slightly_smiling_face:

Today is a HUGE day, and I’m very grateful for all of the hard work that the Airtable team has put into sync. Thank you. Now that this magical day is finally here, I’m wondering what the easiest and most reliable way to integrate a synced table into my existing bases. Currently we have the following (3) bases: Main Base MB - contains source-of-truth table for all projects called Jobs Consultant Base CB - contains information for consultants Internal Base IB - contains information for internal project management Both CB and IB currently have a subset of the Jobs table. That subset table was manually created in the absence of Sync. How do I most easily integrate the sync’ed Jobs table into CB and IB? There are almost 1,000 records in the subset tables in CB & IB that should now use the synced Jobs table instead. Thank you!

Hey Airtablers, I’m trying to create a base that tracks expenses and income, but between a few people. For simplicity, let’s just imagine it’s a cofounder and who just started an online business and we need to track our expenses (a 50/50 split), and our income (also a 50/50 split). For reference, here’s what I have so far: https://airtable.com/shrC0MHyoAl0PJoBV What I’m trying to build is a base where we can easily see and keep track who owes what. At the end of the month, we should do some reconciliation so that my cofounder’s expenses and mine are equal (hence the 50/50 split). I had a similar (working) setup on a LibreOffice spreadsheet, but I’m trying out Airtable for this to see if I can build something a bit more intuitive. (Gonna give the Form view a shot as well so we can enter these expenses more easily.) Ideally we’ll want to do some more advanced re

Hello. Two weeks ago I had introduced two newbie basers. It made me want to create a way to introduce new users to each other and airtable. Yet I wanted to influence people outside of vertical base talk. We are at an inflection point and I want people designing lives, community networks and inspiring each other. So I created an event! 600 People have signed up 14 Speakers 3 Vendors The event will be streamed live (if I can get it to work) and last from noon-5pm EST (GMT -4), this Friday, Sept 18, 2020. Chris Dancy

What time are the free trainings? Are they conducted in EST? I am in CST and would want to convert the time. Thank you- Tracy

I’m trying to develop a short survey that is also functionally a database? So ideally when people enter a longform text answer, they can also add a “category” to the answer that is a single select from a list. Then we need to sort based on that category, so the user sees their own answers sorted by the categories. I can design it pretty well in airtable, but can’t seem to fin a way to connect it to a website or form platform so that a user could use it from the front end effectively. Is this possible? TIA!

The export to PDF creates a very small print chart for a Project of 23 tasks spanning over 6 months. A. Is there a way to save the chart for viewing by all collaborators? B. Is there a way to split the print by dates? I need to be able to share this with my client and team.

Good morning! I just recently signed up for the Pro Version, and one of the main reasons was the Mapping Block. I am totally lost when it comes to setting up the API. Is this something I’ll have to pay for as well? I have no idea how to set this up and what it’s going to entail as far as ongoing use. Any help (in layman’s terms) is very appreciated.

I’m trying to create a “depended on by” column in a gantt that will automatically pull all of the tasks (text field) for which a given task is listed as a dependency (linked field). For example, if task 1 is listed as a dependency for 5 other tasks, I’d like this new field to automatically list those 5 tasks. Does anyone know if this is possible/how to set this up?

Can anyone tell me how to print out my hundreds of poems once I finally get them tagged and sorted into books? They vary in length from 4 lines to 140 lines. Page Designer seems to give me ONLY a fixed height field, nothing automatically expanding or contracting to show the whole poem and nothing to go to an additional page. I found this thread. Is this really a dead end? It seems like content management and printing would be essential features for Airtable.

Can you add a start date and finish date to the left side of the Gantt Chart this is really critical for a easy to read document for projects

Hi there, I’m using the new Gantt Block for product planning. Overall it is great but I’m having some difficulties with sorting. Here is the situation: I have a set of tasks grouped by workstream Each task has a start and end date I have a gantt of all the tasks, grouped workstream The order of the gantt is alphabetical by workstream, rather than by start date by workstream This means that the blocks appear all over the place. Any ideas to fix this so that the workstream with the earliest start date is at the top?

Hey Guys, I see this is a common thread but unfortunately I wasn’t able to find the solution from the answers here. I am trying to create a statement of account on page designer. I will need to upload an entire table from my bases but I can’t seem to do it. I can only insert one record at a time and this isn’t sustainable. What’s the best solution here?

Here is the use-case/workflow: Assume we have multiple workspaces and bases. In the desktop application, when user A wants to share the link to a base with user B, already a collaborator on the base, how can this be accomplished. On this browser it is simple. Copy the link from the address bar and share it. How can something similar be accomplished in the desktop application? The Share button has options that are not required for existing collaborators. Of course, the base name can be shared and that can be searched. But this involves multiple steps. Thanks!

I don’t see the sync related options in my (pro) account yet

Using Airtable Sync, you can sync records from a source base to one or more destination bases. To learn more about using this feature, read our support articles. To ask question about using Sync, post in the Sync community category.

Hello the community, I am an early new user of AirTable and just start to understand all the infinites possibility associated. I’m trying to build a database / directory of startups, with different associated variables: sector, development, turnover etc… Some data can be scraped directly from legal information sites about companies. I was doing this scraping with Google Sheet via the “importhtml” function. Is it possible to connect my Google Sheet scraping sheet with my airtable records? Is there a tool for scraping data on certain columns only? How can I update this data automatically? (form ? bot ?) Thank you for your help

Hello all, So I have am managing the covid recorded daily temps for a football club with multiple teams. I have the following tables: Teams (U16 etc), Players and Player Temps each linked 1 to many. I need to be able to add a record to Player Temps but from a list of players (Filtered and/or grouped) in the players table. Searching for each player individually as they come through the door is too slow. I could just create a daily set of records (list) automatically to record against but that seems a little ridiculous. This all needs to be done on the mobile app so in a grid view… I’m an experienced programmer “elsewhere” used to using master/detail layouts but this is my first look at Airtable. Any help very much appreciated.

I have products each product can have parts (name + quantity) or can be a bundle of parts (name + quantity). I would like to create a production planning for a week. I would like to create a view of all row material I need for the production of the current week. For example Product 1,2,3 are simple product, Product 4 is a bundle product consists of products 2(qty 1),products 3(qty 2). In the current week I need to create 10 products of Product 1 and 10 of product 4. The report should show me:product 1 10, product 2: 10 and product 3: 20 Is it possible to implement it in Airtable? Thank you, Sam

Hello, I am trying to use the calendar view. I have many formula fields that are calculating different dates. I am only seeing two of those listed here. Is this a bug? Or is there something in the formulas that is making it not appear as a date? here are the two formulas that do show up in the list: SET_TIMEZONE(DATEADD(DateOfReply, -1, ‘days’),‘America/Pacific’) IF(HOUR({DateOfReply_Pacific}) >=20, DateOfReply, PreviousDay_Pacific) And here is one that I need that isn’t showing up: IF(HOUR({DateOfReply_Eastern}) >=20, DateOfReply_Eastern, PreviousDay_Eastern)