Skip to main content

User Groups
Product Ideas
Events
Academy
Help Center

Create topic
Login

Home
Search

Solved

7466 Topics

Recently active

Most views Most replies

Phil_SalantNew Participant

asked in Other Questions

Can I create an Airtable view containing records not present in a “linked records” column?

I have a table with columns like: Name (Single Line Text) | Partner (Link to "Name") ----------------------- | -------------------------- John Doe | `Jane Doe` Jane Doe | (Empty) Bob Smith | `Mary Smith` `Kevin Smith` Mary Smith | (Empty) Kevin Smith | (Empty) Alan Stephens | (Empty) I’d like to create a new view for this table with filtering like: WHERE {Partner (field)} is not empty OR {Partner (column)} does not contain {Name} such that the result would be: Name (Single Line Text) | Partner (Link to "Name") ----------------------- | -------------------------- John Doe | `Jane Doe` Bob Smith | `Mary Smith` `Kevin Smith` Alan Stephens | (Empty) The challenge here is that on line 1 of my filter, I’m looking for “records with no records linked in their Partner column”, but on line 2 I’m looking for “records which are not found in the Partner column for any other recor

Lisa_weberNew Participant

asked in Other Questions

How Can I Export an Entire Base with one Click?

My base is huge. I need a way to one click back it up for my peace of mind. thank you.

Kendy511Known Participant

asked in Formulas

Formula sum different time format of all fields

I have 5 fields with different time formats which can be date, hours, minutes, seconds… ex: Field 1: 4 days Field 2: 2 hours Field 3: 2,5 days Field 4: 15 mins Field 5: 25 seconds Field 6 = sum (field 1 + field 2+ field 3+field 4+ field 5 ) with ‘days’ format Which formula I can use in this situation ?

Leslie_MillerKnown Participant

asked in Development & APIs

Help pulling info to create a HTML

I would like to fill a field that results in this HTML text The items in italics are Airtable fields within that Airtable table <!DOCTYPE html> <html> <body> <h4 style="text-align:center;">*Workshop Title* </h4> <p style="text-align:center;">*text Date Range Friendly* <br>*Text Bottomline* <br>*Medium* </body> </p> </body> </html>

Chris_GuthrieInspiring

asked in Development & APIs

How to get record ID of filtered record [solved]

Hi, I think I’ve figured out how to retrieve a unique record in my table using the following filter, but how can I get the ID of resulting query? let filteredRecords = query.records.filter(record => { let name = record.getCellValue('Order/Shipment ID'); return name !== null && name === range }); I’ve tried the following but am getting an error let filteredRecordsResult = filteredRecords.records[0]; output.text(filteredRecordsResult.id); Error: TypeError: Cannot read property ‘0’ of undefined

Ben_HInspiring

asked in Other Questions

Last Time a Product Type Was Ordered

I have tables “customers” “orders” and “products” Products has a multiple choice for product type. Orders is linked to the customer and the product with a date. I am looking for a solution to find the last time a product was ordered by a client in an overview/ filter/ group. Example: Product Type A “customer” “product name” “order id” “order date” “customer” “product name” “order id” “order date” Product Type B “customer” “product name” “order id” “order date” I would love to hear some ideas or if you know anywhere else in the form where it is discussed. Thanks in advance BH

Declan_PeachNew Participant

asked in Other Questions

Multiple Select Tags to comma separated values?

Hello, I’m attempting to use airable to manage a tag filtering system that feeds into a 3rd party database for my job. Problem is that multiple select tags seem to add an arbitrary space when converted to a string. This effectively eliminates its usefulness as our system cannot parse it. Example: Is there any easy way to get around this? Perhaps an extra formula step to remove the space after each comma? Thank you in advance!

Dominic_RannieKnown Participant

asked in Other Questions

Conditional IF with Date Check

Hi, I am a little confused with exactly how to write an IF statement that checks that all three of the following conditions are true: {Status} = “” {Replacement Required} = “Yes” IF(NOW() > WORKDAY({Date Created},2) I have the first two worked out, but when I try to add the third condition I am struggling to get it to work. Any assistance gratefully received.

Contact_Lights_New Participant

asked in Formulas

Adding IF formula to a column with an existing concatenate formula

Hey guys! I’m looking to add an if formula to the formula below. What I need is that if the “fixture model #”, the “bulb model #” or the “miscellaneous” fields are empty, the output of the concatenate funtion is “N/A” CONCATENATE({Name (from Orders)}," - “,”(",Quantity,") “,{Fixture Model #},” / “,{Bulb Model #},” / ",{Miscellaneous}) Thanks in advance!

Michael_LeverInspiring

asked in Other Questions

Reformat text on copy and paste

Using Devonthink 3 Pro, I can capture text from whatever source (eg websites, etc). then use a keyboard shortcut of my own making via Word Service, to reformat - stripping out all links, line endings, headings, bold, etc etc. What I’d like to do is copy and paste direct into a long text field in AT and have the field reformat it? Is that possible, and if so would I need to use a formula or script and if so what would the formula be and how would I go about it? tia

WidgeticKnown Participant

asked in Development & APIs

Cannot create table

Hi all! I’m trying to create a new table using base.unstable_createTableAsync following the example in the guide. This is the code I’m using - const fields = [{ name: "MyField", field: FieldType.SINGLE_LINE_TEXT }]; if (base.unstable_hasPermissionToCreateTable("MyTable", fields)) { await base.unstable_createTableAsync("MyTable", fields); // and create records } But I keep getting the error Uncaught (in promise) Error: Can't create table: invalid field config for field 'MyField'. Creating or updating options for undefined fields is not supported at this time. at Mutations._assertMutationIsValid (bundle.js:formatted:7299) at Mutations.applyMutationAsync$ (bundle.js:formatted:6813) at tryCatch (bundle.js:formatted:94903) at Generator.invoke [as _invoke] (bundle.js:formatted:95131) at Generator.prototype.<computed> [as next] (bundle.js:formatted:94956) at tryCatch (bundle.js:formatted:94903) at invoke (bundle.js:formatted:94997) at bundle.js:fo

JonathanBInspiring

asked in Formulas

Logging the "history" of a checkbox field with a formula

Hi all I’m trying to find a way to record, within a table, an ongoing “history” of when a checkbox has been checked/unchecked. The first stage is simple enough, e.g. a formula field that outputs today’s date when the box is initially selected - IF({Yes/No}=“1”, DATETIME_FORMAT(TODAY(), “DD/MM/YYYY”), “”) but what I then want is an additional field that keeps a kind of tally of when the box has been checked/unchecked, i.e. “Approved 03/07/2020; removed 10/07/2020; approved 13/07/2020…” etc. I think it will probably involve using a “last modified” field but I can’t work out how to make the “tallying” part of the formula, rather than just updating each time there is a change. Can anyone advise if this is possible to do? Thank you!

Taylor_JettNew Participant

asked in Other Questions

Form Headers display on different sized devices

Hi! Does anyone know the appropriate way to getting a form header to automatically resize depending on the device being used? Or which dimensions I should be using when I create the header for it to look OK on all sized devices? I currently have an image (that includes words) for the header of a form and while it looks great on a laptop, pulling it up on a mobile device cuts the image awkwardly. Any help much appreciated. Thanks in advance!

David_Gutierre1Participating Frequently

asked in Formulas

Running Countdown based on single select stage

Hello all! I want to have countdown (showing how many days left) based on the stage (a single select field) of a record. Each stage should take a certain amount of time to complete, so the goal is to see how many days left I have to complete a stage. Then once I change it to the next stage, that countdown is reset to the parameters of the next stage. I have parameters are mostly set by formula-based date fields that live in the table. So it would look something like this: If {Stage}=Stage 1, calculate difference between {date 1} & 14 days from {date 1} If {Stage}=Stage 2, calculate difference between {date 2} & 14 days from {date 2} If {Stage}=Stage 3, calculate difference between {date 3} & 28 days from {date 3} If {Stage}=Stage Complete, “Complete” I tried doing a DATETIME_DIFF inside of the If function, but have been struggling with errors. Seems pretty straight-forward, but I can’t figure it out… Any help would be great! Thanks in advance.

Sidney_MLNew Participant

asked in Development & APIs

Record ID showing on Appsheet instead of value

I am using Airtable as a data source for an app on AppSheet. Everything seems to work well except for values from linked tables. As shown in the image below, when a value is coming from a linked table, it is showing the record ID instead of the actual value. How can I fix this?

MixableNew Participant

asked in Development & APIs

Date format hints and question on localized date formats for users

I noticed the date value provided is structured as M/D/YYYY. Is this consistent across all users? Or does this change depending on regions? ie. D/M/YYYY for EMEA Airtable users, M/D/YYYY for US Airtable users, etc. This might be a new Feature Request, but it would be awesome if CellRenderer can provide an easy Field type toggle to generate more consistent “universal” dates. I would love to see something like YYYY-MM-DD being available.

Helen_VaskevitcKnown Participant

asked in Other Questions

Ical subscription link to calendar, adds ":" to each calendar event

I’ve got a calendar view in my base for which I’m using an ical subscription link to have it show up in my calendar app. For some reason, when I look in my calendar app, every single event has the character “:” added to the end the event name. (For example, “Meeting with Marcy:” instead of “Meeting with Marcy”.) There is no colon in the event names in the airtable calendar. Does anyone know why this is happening and how to fix it?

Luis_HMNew Participant

asked in Other Questions

Make commenters invisible to the others

I would like to share a base to several “commenters” that need to be unknown to each other. At the moment, seems like a commenter can see the emails of the other commenters to whom I have shared the base with. I would like that a commenter wasn’t able to see the others. Is there a way to achieve this? Thanks

Yaron_AvramovInspiring

asked in Other Questions

Getting the latest date for a linked record

I’m struggling a bit with linked records and getting the required data for them. Let’s assume that I have a contacts table that list different contacts by a contact ID. I have another table that I record every communication I do with a contact. The fields are: contact ID (same ID as in the contacts table), date, type, remarks, etc… Now, since there are various communications with each contact, there are many rows (or records) with the same contact ID, one for each communication. I want to add a field in the contacts table that would show the latest communication date for that contact. I couldn’t find any way to do that. What am I doing wrong? Thanks a lot.

Kamille_Parks11Brainy

asked in Development & APIs

No-Conflict Appointment Scheduler

Use Case: You have a table of stylists, therapists, technicians, etc. (“agents”) who perform any number of services, and customers are supposed to schedule an appointment with an agent to perform a service but only when that agent is available. While you think the No-Conflict Asset Reservations script is great, it doesn’t take into account your need to schedule an agent for more than one appointment per day. Solution: No-Conflict Appointment script by Kamille. An improvement upon my previous script, you can now schedule same-day appointments assuming those appointments don’t overlap. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings. Since there isn’t a datetime picker input type, I basically hacked my own using two conditional button inpu

MixableNew Participant

asked in Development & APIs

Does expandRecord() function exist for new entry creation?

I’ve been using the expandRecord() function call to provide a quick way to update content in my Block interface, but I would LOVE to use that flow for new data entry as well. Is that possible? I’ve read through the documentation and example projects and I didn’t see this noted. And expandRecord() does currently require a record to be passed to it.

Michelle_KingKnown Participant

asked in Other Questions

Newbie fail - blocks not showing in shared bases

Sorry I do search the help topics honestly - why is that I cannot see blocks - it is in a base that has been shared with me, the lady who has shared it is a pro user, I am a pro user, we work for the same organisation collaborating on the same base but because it’s showing as a shared base rather than in my pro workspace I cannot see the blocks :frowning: - any ideas? Coincidently when I share a base with her she can see the blocks whereas I just get an option to upgrade

Josh_CooperInspiring

asked in Development & APIs

Script to put current Date/Time into a Date/Time field with a button

So this is probably a dumb question, but I have hit a wall! How do you write into a Date/Time field with the current date in the locale timezone? I have tried the .toLocaleString() method and the console will output everything perfectly, but nothing shows up in the field. This is what I have. var rightNow = new Date(); var res = rightNow.toLocaleString(); table.updateRecordAsync(record,{ "Date/Time Submitted To Shipping": res }) Any help would be greatly appreciated! Update: I can get the Date/Time in a Date/Time field by using the .toISOString() method, but the time is 5 hours off.

Janet_YenNew Participant

asked in Formulas

How to track number of clicks to a link shared in a cell

Hi, I’m creating a table that includes links to external websites like facebook pages, instagram profiles, personal websites, etc. I’d like to track how many people click on each of the unique links. Is there a way to do that? Airtable’s Support team told me this is not a native feature. Anyone have creative ideas on how to do this? Thanks.

Jason_Burke1Known Participant

asked in Formulas

Formula To Return Age of Product in #.## format

Hello! I recently got into canning (and general food preservation). I have created a database which helps me manage my inventory levels of products I have canned (Example: Jars of: Carrots, Green Beans, Jams, Jelly, etc). In my table where I record batch information - I am recorded the date I created that batch of product. I’d like to have a column (called Age) that returns the age of the product (batch) in #.## format. For example: If I created a batch of product today, it’s age should read: “0.00” meaning its 0 years and 0 months old. If I created a batch 1 year ago, I’d like it to say “1.00” because it’s a year old. If I created a batch ‘days short of it being 2 yrs old’, I’d like it to say “1.11” because it’s 1 year old and 11 months. Any help would be greately appreciated.

1
...
257
258
259
260
261
262
263
...
299

Page 260 / 299

Badge winners

ScottPhillipshas earned the badge 5 Topics
LeadingAgeMENHhas earned the badge First Topic
vivaanjohn91has earned the badge First Reply
michele.imperialihas earned the badge First Topic
bustbrainlabshas earned the badge 5 Topics

Show all badges

Powered by Gainsight

Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

Login with SSO

Log in with Airtable SSO

Login to the community

Login with SSO

Log in with Airtable SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Platform Platform Overview Integrations Extensions App Building AI Connected Data

Solutions Product Marketing Operations Human Resources Sales Finance

Learn Airtable Academy Events Video Center Demos Customer Stories Webinars

Resources Partners Services Developers Community Templates Airtable Universe

Company About Careers Blog Status Newsroom Try Airtable For Free

Security API Sitemap Privacy Terms Do Not Sell/Share My Info Cookie Preferences