Other Questions

Hello, I would like to be able to synchronize the data of one of my pages on a single sheet. Is it possible that I can synchronize the data of one of my databases on a single sheet?

Hi, We are group that is fighting the take-over of the NWO criminal cabal. We intend doing this using a letter/email program, but for this we need an efficient Data Base, to stop doubling up and have an instant view (pie chart, bar graphs) to judge effectiveness and progress. I need urgent help in guiding me to construct such Airtable base and willing to pay for your help. I am absolutely new to Airtable, I will forward full description once I get some response Cheers:Franz:

To continue my setup in Airtable, I would have liked to understand how the Pro plans work: I discovered (by coincidence) that the price depends on the number of worspaces and the number of users (?) I read this in the help sections: “The cost of upgrading a workspace is dependent on the number of users who have access to any of the bases in your workspace.” I would have liked to be able to organize my data in several workspaces (equivalent to folders divided by interests or activities) AND the advantages of a Pro plan. But obviously I don’t want to pay a Pro plan for each workspace (6 or 7!) I am the only user of this data. What would be the best solution? Thanks in advance for any help or suggestions!

Currently, our mobile calendar view is showing Feb 2022, but the numerical dates are not properly aligning with the day of the week. Is this a glitch on our end or on the app itself? The same desktop calendar is perfectly fine. But mobile is showing that today, feb 8 2022 is a Saturday. Also, the monthly view of february is only showing from 2/9-3/22. Weird.

Hi, Is this possible with Airtable: Is there a way that I publish a form and user can enter certain value (eg. Name) and “form” shows them values for that value (eg. Last names related to the Name)? User starts typing a eg. Last name in a field in the form and during the typing the possible values (of course the ones in database) starts to show?

I am looking at how to get a summarized version of long text. I am looking at some tools and many have API and are free but I haven’t compared how good they really are because that would be too biased to share it here (my text would be different from anybody else so likely difference results. If you summarize your text in Airtable - what do you use? I am looking at couple of tools like https://api.codeq.com There is only one that I know of that integrates with Zapier. However, no integration with Integromat. I am paying Integromat already and not ready to stick more money for Zapier since all stuff I do is in Integromat anyways. Zapier too expensive for what it can offer me. Here is the workflow with Zapier and MakeMySummary. Anybody else uses anything else? makemysummary.com MakeMySummary Summarize a video, podcast, webpage, blog, news, text or a pdf file. Zapier MakeMySummary Integrations | Connect You

I’d like help as I expand the complexity of my Airtable bases. Currently I use Airtable to manage different lists of people for my nonprofit. For example, team list, partner list, donor list, etc. These tables have lists of records with names and other fields like street address, email, etc. Our nonprofit is growing, so we want to begin utilizing external services to create online communities using services external to Airtable. For example, using a membership or e-course site like Kajabi, Mighty Networks, or Tribe. The problem is, I don’t want to have to manually update these Airtable lists in both Airtable and these external services. I have an AirTablr team list, but the community on Kajabi for example, would be identical to the AT list. Is there a way I can link these sites to Airtable, and use one database as the “parent” and the other as the “child” that just syncs to whatever the “parent” says? Preferably Airtable would be the “parent” and Kajabi or Mighty Networks the “child”,

Hi Airtablers, Starting my first attempt at using the Vega-Lite app, as I have some information that is not behaving using the Pivot Table app. I’ve used a Look-Up column, that pulls through Countries from a Multiple Select field on another table, so that the two data sets I need are connected. But the Pivot Table app won’t let me ‘Split Multiple Choices’ within the Look-Up Column. So, when I try to make the data into a readable format, the ‘Countries’ only show as various combinations of countries from each of the Lookup Column entries (e.g. “UK, USA, France”, “France, Germany, USA”, “UK, USA, Germany”. When they need to be split into “UK”, “USA”, “France”, “Germany” in the visual data.) I’ve moved on to using Vega-Lite in the hopes this can be solved, but this is where I’m stuck. This is the section relating to the x-axis: Is there a way to split the values from the “Country” column (the Lookup Column), using commas as the delimiter? And then grouping data for each country together?

I was wondering if anyone has advice on updating some fields in our system? We currently use Airtable to record a register of attendees for some community group work sessions we run. We are needing to see the countries of origin that are represented in our sessions, but due to changes during the pandemic this information was not always able to be collected. I would like to see if there is a way to gather this information as and when participants attend our sessions in the future through the attendance register we have set up. We take registration using a form that links to our participants list, which needs to stay exactly the same for ease-of-use by our staff. Is there a way that when a participant’s name is selected on the attendance form (using the Add+ field under ‘Student Name’, pictured below), a second window can open requesting their Country of Origin if the field for their record is blank? This would need to be separate to the form as there are multiple participants per sessio

What shortcut can I used to move forward and back from a long text field that has rich-text formating enabled? I usually use tab & shift-tab to move back and for between fields when I’m entering data. However, when I hit a rich-text field, the tab creates a tab within the field and doesn’t move forward. Is there a way to do this? Thanks!

Hello, I am trying to transfer a collaborator field from one table to another. It works perfectly for the other text fields but for the collaborator field it doesn’t work. "User (other)": { "id": user }, Doesn’t work Here is my code : let mainTable = base.getTable("Table 1"); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable("Table 2"); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for(let record of mainTableRecords.records) { let lookupValue = record.getCellValue("ID Customer"); for(let rangeRecord of lookupRangeRecords.records) { if(rangeRecord.getCellValue("ID Customer") === lookupValue) { let myName = rangeRecord.getCellValue("myName"); let user; if(rangeRecord.getCellValue("User") != null) { user = rangeRecord.getCellValue("User").id; } else { user = rangeRecord.getCellValue("User"); }

Hi, I have a database where there is a column Company and there are rows where companies are repeating. Is it possible to have kind a Kanban view, but when you select the “card” with specific company you can see all data (eg. comments on specific date) on one card and not “endless” cards for one company, each with different comments on specific date… kind of simple CRM tool?

With Shared view URL filters I am able to craft links so that I can basically look at the records dynamically, however I am unable to actually make any changes or edits to the views that I am creating dynamically. Is it correct to say that it isn’t possible to do URL filters with normal views? If so, I wonder why? It would be very useful to be able to create dynamic views where you can actually edit the records. Shared view URL filters for those of you that don’t know what I mean. Airtable Support Shared view URL filters After creating a share for your view you can add more filtering conditions to your records in the URL. For example, the URL https://airtable.com/shrsa57bWpEecPtzp?filter_Category=Brand%20identity w... I had no idea this existed until relatively recently.

Hello! I am currently putting call data from Twilio into Airtable to then transform and present via Stacker. Currently, I can put the call start time (datetime), the call end time (datetime), and the duration (number) from Twilio itself. I know there is the DATETIME_DIFF() formula, but the issue with this is that it produces an integer, where I am wanting h:mm:ss. I also know you can use the integrating formatting option that Airtable has on Formula fields, which works fine if I was only using Airtable. The difficulty comes in when I need to get this duration time into Stacker. Stacker does not do the same formatting option as Airtable and pulls in the duration integer (as seconds). Any ideas?

Hello all! I am entering in visitor information into airtables. I am entering their name, contact details, and what time they will require access. When I do a calendar view, it shows the date I have them arriving and the date they leave, but I want it to display the entire time they’re there. If I put in that they need access from 8am-3pm, starting on date #1 and leaving date #2, is there any way to automate this so that in the calendar view it displays their appointments on every date inbetween?

Hi Airtable community! Reaching out with a quick favor - I’m searching for someone for a Project Manager, reporting to our VP Revenue. Ideal candidate is in LA or SF with a lot of experience in project management, Airtable (duh), and startups. Would you happen to know of anyone who might fit the bill? Figured it’s worth a shot asking! Thanks so much and hope all’s well!

Hey Guys! Im trying to remove a text in the beginning from a lookup field, by formula. The text starts with "<div class="vaning"></div><div class="namn">" and I want to remove “<div class="vaning"></div>” in the beginning. I tried with the replace formula but only get error messages, does anyone know why? For example: REPLACE({field name}, 1, 26, “”) Thanks J

Hello!, I want to create an automation to send an email from outlook using Airtable. I have everything, and for trigger, I want to use the date of birth, but in the current year. I use a formula that I’ve found in another topic that is DATEADD( Birthday, DATETIME_DIFF(TODAY(), Birthday, ‘years’),‘years’ ) But I have one problem. A lot of dates, when the formula runs, instead of 2022, put 2021, and I don’t know why. Anyone could help me? I don’t know if it is a format problem or what Thank you

I am using airtable to plan several jobs and projects. I’m looking to add week numbers into the gantt chart and defined table views. For the gantt, they could be milestones? Is there any decent way of doing this please? Thanks in advance. Pete

Hello, I have two tables. One table the primary key is dates. Every entry is a new date. On the second table, I’m trying to show the list of dates so that it can show up for calendar view. Since when I connect tables it doesn’t understand that the primary key is a date, I use the dateparse function. However, if there’s 2 dates, dateparse doesn’t work. Is it possible to get multiple dates?

I am creating a base to control the reservations of a parking lot. I have the seats and reservations created, but I can’t get Airtable to prevent me from reserving the same seat more than once in a day. I have only managed that if the place is already occupied, it does not offer it to me, but if the entry is on a future day, it continues to propose it as available.

How can I automatically create a new row of data in airtable from my squarespace account with the product data, custom product form, data, and customer data?

I’m a total newbie to JavaScript, and pretty proud of myself that I’ve figured out how to connect to my company’s API to get store information. console.log(await storeInfo.json()); is displaying all of the JSON returned from the API call, but now how do I get that data out of the JSON? Example: CONSOLE.LOG :arrow_forward: (1) [Object] :arrow_forward: 0: Object 1. StoreNumber: “1234” 2. StoreName: “Joe’s Market” 3. :arrow_forward: StorePhoneNumbers: Array(2) :arrow_forward: 0: Object Description: “Fax” PhoneNumber: “800-555-1212” :arrow_forward: 1: Object Description: “Landline” PhoneNumber: “800-555-2121” How can I pull the store name and phone numbers out into individual variables that I can do stuff with?

I need to copy sets of data from Google sheets over to Airtable’s mulitselect field. I have successfully copied the Example A sets of data into a multiselect and it works. But for some reason Example B data copies only 1 set of data, not the entire data set. How can I achieve the same results as example A for example B. Example A contentIdComplete: 5ff7f3ea61d89c3d4f1a00f6,5ff7f40f4d6d0a37a3879004,601bdf764ac7ca3c4ae31211,601be02d58c9a36f26a0f9b8,60226b2bca657c6d5a43ccd1,60226d622a2f924017052bcc, Example B contentIdCompleteDate : 1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037,1616704037, Watch the Loom video https://www.loom.com/share/825d9c899c7c4762817030d95def3ad1

I’m creating a table to help develop products. I would like to have certain parts determine pricing. So if I’m creating bikes for example - each type of seat or wheel will affect the price. Example: Seat A = $50 Seat B = $10 Wheel A = $100 Wheel B = $200 Seat A + Wheel B = $250 Seat B + Wheel A = $110 The real one would have several more options, but that’s the main idea. Ideally there would be a “Wheel” field where you could choose A or B. Same with a Seat field. The Pricing would then calculate the total of whatever configuration you’ve chosen. Thanks for any help!