Other Questions

Hi, I was wondering if it is possible to split a row which had been populated with data using a multiselect, into separate rows. e.g. I would want to create 2 lines for Campaign “Client 1||3” one for “Driver 2” and one for “Driver 4”. Similarly for the 2nd Campaign I would need 3 lines. Not too phased if in same or different table - although different table may be easier. TIA.

Hey! I’ve seen this stock chart in the Airtable marketplace, but I can’t figure out how to add multiple Y-axes, does anyone know how to do that? How my base look like: cln.sh

Hi folks! I have a question regarding password protection for Share link views . I wonder if it’s possible to create dynamic passwords for sharing links. I want to restrict access to share links but I want to give different password for every user. It’s possible? So far I know you can add a single password, but it’s possible to create several passwords for just a Share link? Hope you can help me, Thanks!

Hi, How can I sign in/out between different oneDrive accounts for attachment linking in records? I notice once I signed in to a oneDrive account, there is no option to sign in to a different account even after I have signed out oneDrive account. Thanks!

When I paste the link to my airtable form on facebook or whatsapp, the message should display some content (at least the top part) of my form. If it is all about airtable branding then how can I get people interested to answer my survey??

Hi Community, i’m extracting the date from the below string 27909270100235 = 1979-SEP-27 using a formula below DATETIME_FORMAT(RIGHT(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),4),2)&"/"&RIGHT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)&"/"&IF(LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)>50,“19”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2),“20”&LEFT(RIGHT(LEFT(ARRAYJOIN({National ID#}),7),6),2)),“DD-MMM-YYYY”) the result is ok, 27-sep-1979 but I’m trying to get the age by further calculations/formula but it seems it doesn’t recognise the date above to make further actions and I realised that the formatting tye in the field doesn’t recognise it too, and received below message Blockquote Your result type is not a number or a date. Formatting options are currently only available if your result type is a number o

Is it possible to place form fields side-by-side instead of having everything in one long scrolling form? If not, this needs to be a thing.

We’re a small hotel, so I have a Contacts Table, and all my Guests are updated … I’m not sure how to link to automatically. I have a linked field there, but i need to select it manually … shouldn’t there is an automatic way of doing this? When the reservation comes in the guests’ email and name is given … so … can’t I just use an ‘if this than that’… type of thing?

Hi, is there a way to connect several fields. I have several fields: dress name, dress style number, dress retail price, and dress wholesale price. Is there a way that when I enter the name of the dress in that field, the base can fill in the other fields with the accompanying information?

How do I find out when someone has completed my form and submitted answers? I did a test run and received zero notifications after entering my information. I need to see the data after people have completed these forms.

Hello Airtable gurus, Not a native english speaker and already awake for 18hours so my explanation might be bad My primary field is a concatenation of 3 fields… Is there a way to use Zapier and link a record by only using that data has a partial match from any of the 3 concatenated Primary field? I mean when assigning a linked record manually, we can just type anything and if it matches the primary field, the record shows up right? Is there a way to replicate this via Zapier? image|700x493 I tried but I get this error unless it’s an exact match Context: I want to use Typeform as a customer registration form . I have 2 tables, Customers and Addresses. I have to separate the Address table so i can assign multiple address to customers and be able to just choose a PRIMARY

How can I create a formula to set a reminder every interval of X months for a period of P time? For instance for the second column, create a reminder on 6/1/2021, 9/1/2021, 12/1/2021, 3/1/2022

I am trying to upload a pdf to airtable. It was working fine. Today, I am facing a weird situation where pdfs are getting uploaded and suddenly disappearing from the table. This behavior is random. I couldn’t find any solutions to fix this issue. Could you please help me with this?

I have a set of data that contains first name, last name, timezone, and email address. I’d like to create automatic groups of 3 based on time zone (each participant needs to have the same timezone per group) and then somehow (hopefully in an automated manner!) communicate the peer groups with their first, last, email to each group. Anyone have any ideas for how this could be done with Airtable? Thanks in advance!

I have a table that tracks every donation made to our charity, which includes the title of the fundraiser to where the funds were donated. This is triggered by each new donation. What I need to do is find a way to AUTOSUM the donations by the fundraiser title. The stick in my widget is that this number will be constantly updating as more donations come in. Currently, I can group by single select and see the AUTOSUM for each fundraiser. As new donations come in, this number automatically updates. Gorgeous. Since I need that number to use in other places, I’ll need that value to inhabit a single record. What I’ve tried to do is create a NEW table to do a ROLLUP. My issue with this is that I need to manually add each new donation to get an accurate snapshot of the current SUM. Since this value will be used in client-facing data, it has to be up to the

I wish the field order in dedupe was useful. Putting them in order of creation is not helpful when you have hundreds of fields.

you can’t merge a calculated field so why to they appear in the “Dedupe” app. In my case I have scores of calculations so using dedupe is difficult because I can’t hide those non-mergable calculation fields.

Hello, I am in the process of trying to map an existing Google Form to Airtable and I am not having much success. I’m doing a test drive to just understand the process so I can then build out a larger form and automate it. At the moment I’ve only included two fields: Google Form: Name (Short Answer) Test (Multiple Choice) (“Option 1” is the only choice available") Airtable Col. 1 (AutoNumber) Col. 2 Name (Single Line Text) Col. 3 Test (Single Select) (“Option 1” is the only choice available") I’m using an app called Form Director to do the automation: #; App Field; Form Field; Valid short_text Name; short_text Name; done short_text Test; radio_button_checked Test; done

Is it possible to access new fields added to a synced table or records linked to the synced table from the source table?

Hello - I’m using page designer formatted on an 8.5x11. I’m using the table format to display a long list of inputs. The problem I’m running into is the list extends beyond the length of the sheet and I can’t figure out how to continue the cutoff information in a secondary table on the same sheet. It feels like I’m missing something straight forward. Thanks in advance!

I own a music lessons studio and the software we use (WellnessLiving) reports revenue per lesson and instructor pay per lesson in two separate reports. I’m hoping to find a way to match up a lesson record that contains the revenue for that lesson with a separate lesson record that contains the instructor pay in order to see my gross profit. In essence I have two sets of the same data (e.g. two entries for a 30 min. guitar lesson from March 28 at 2:30pm) that both contain different data that I want to combine. I could do this manually using the Dedupe app but I figured there has to be a way to automate this.

Hello all, Now, I want to count a single select quantity from a different table Table 1 like this Table 2 like this And I want to count Table 1’s status quantity I want the result in table 2 show todo 4 in progress 2 done 2 Does anyone know how to do that? Thank you all. David

Hi All, How do you produce a gantt chart which has the tasks from two different tables (in the same base) and shows the dependencies between them? ie you have two projects generally be tracked separately but want a gantt view of the dependencies between the projects? Thanks

I’ve made a airtable form and received quite some data already (incl email). I realised I forgot to ask the date of birth. Is there a way to send many people individual emails to request them to send it back and it auto fills the DOB field?

Hi everyone, I am new to Airtable and I have been stuck on this for a while now, basically what I need is: A Products table for thousands of products These products can be grouped into 10 main categories There are a few dozen sub-categories under each main categories What I would like to achieve is, each time when I am adding a new product record, I can select the main categories drop down menu, and after that only those sub-categories related to that main categories will show in the sub-category drop down menu I am totally lost here, please help. Thanks in advance. Anson