Other Questions

Hi guys, I’ve got a form with a single select option, that’s linking to another table. However when you click to add, it shows all of the fields for all of the records in the linked table. Is there any way to prevent seeing all of the fields during selection? It pulls every field from the linked table. Thanks for your help!

Trying to get cells in my base to display photos from Google Drive or Google Photos. When I select Google Drive as the location of the attachment, I get the page that connects me with my Google Accounts. I choose an account, I grant permissions, then we go back to the Airtable attachment selection, but the only option is the same as before “Connect to Google Drive”. I have no problems importing directly from my computer.

Hello! I’ve got a few questions that I’m having a hard time figuring out the best approach to solve or if it can be solved easily (very much not a JS person)… I want to create a record in a table based on conditions from the original table. The new record should copy information from the original table that are held as different field types. Something like this: Conditions for new record: If xTeam is in thisField, then create new record in otherTable Data to be copied: thisTable.launchDate = otherTable.liveDate thisTable.activityDescription = otherTable.description thisTable.launch = otherTable.launch --> (this is currently a lookup between the two tables where otherTable looks up thisTable) thisTable.activityOwner = otherTable.requestor --> (this is currently a lookup from a 3rd table) write otherTable.status as request Is this feasible in the scripting block? and are there any good examples/resources on the types of functions to write to execute this? I’m also concerned about d

Can you add a color legend to the Gantt view? Especially with multiple Gantts and color schemes, people keep asking what the colors mean and are struggling to remember. This has prevented the full collaborative potential of this block view. Currently Gantt ease of use is lacking between the color scheme and custom record IDs. Thank you for listening to us and improving this product!!

I built a master base to keep track of stories across 4 other bases using the Sync block. It’s working as an MVP, but I don’t seem to have the ability to sync the “Collaborator” field from one base to another. Why is that? Any recommended approaches?

It would be great if I could use a column value other than the unique identifier as the display value for the gantt block. That would be much better as a single line text

We have used smartsheet for our Program management and has been asked to look at airtable as some of the other teams have been using it. will appreciate insight from users who have used both airtable and smartsheet, some questions How good is airtable for work collaboration - so that extended team can collaborate at all project phases ? Gantt chart and dependency - have read negative reviews? how this can be accomplished by airtable? Parent - child relationships - smartsheet does that very nicely for Program - Project - milestone - activity level zooming tracking & reporting, can it be done by airtable? executive level dashboards - can you give read only access to executives? If we do reach a decision to use airtable, can smartsheet information be imported in airtable without loosing ( conditional formatting, formulas etc.) Thanks, P

I’m creating an RFQ form where customers will state what type of product they want, the desired quantity, and any special instructions. Is there a way to create a chart in the form where the first column is the product name, the 2nd column is the quantity, the 3rd column is the unit, the 4th column is the deadline, and the 5th column is special instructions. The chart needs to have multiple rows in case they order several products. How can I do this? Thanks!

Hello, I’ve created two forms in the same workplace, but the submissions are all being combined into one grid. Is there a way to create a separate grid for each form’s entries?

I am checking in to see if I am right with this one: When a person is assigned read only access to a base, they can see everything, but they are unable to apply any filtering or sorting of any given view. However, if a private link is provided via a url, then even without access to airtable a person can apply filtering and sorting. Is this correct? Because if so, It seems slightly odd.

Hi all! I’m creating an airtable, but I have a user that I need to be able to see just one view, but not the whole table, for privacy reasons. I also do NOT want that view to be viewable to the public (by a link). Is this possible?

Hi there! I’m wondering if anyone knows of a way to customize the text a user sees when they’re being redirected on a form? Thanks in advance for your help! James

Hello I have 6 letters going to 6 different addresses with the same address and personal information. Is there a way to automate this process where I can add the address and personal information of the person one time and place it in all 6 letter templates? Thank you

We are currently looking to collect a wide array of data on individual subjects at several data collection stations. Because of this, we have taken a single table, and have built several distinct forms off of it in order to split the data collection between different computers. For instance, on a single football player, one station may record height and weight, while another station records position and running speed. However, when we try to do this, despite having the same primary field, we have multiple records for each sample, looking something like this: Individual…Height…Weight…Position…Speed (sec) John_______6’_____200 Peter______6’2_____210 Andrew____6’4_____220 John_____________________QB________4.75 Peter_____________________WR_______4.69 Andrew___________________RB________4.20 Despite the fact that the sample in the primary field the same individual, using two forms to fill in data is causing a repeat of the individual’s entry. Is there a way for us to have the table fill

I have a field of dates that are in text form (for purposes of a Zapier automation - Zapier is unable to put entries into Airtable “Date/Time” fields. If I am wrong, please let me know). It is in MM/DD/YYYY format. When we sort the field by A-Z, the MM/DD section sorts properly, but when it gets to YYYY, it is sorting “2020” before “2019”. Why is that, and is there any way to fix this? Thanks.

Hello! New Airtable user here, and I apologize if I’m being one of those people who are asking something very elementary. In reality, I’m just looking to see if what I’m trying to do is even possible. I have a base that has been set up with different tabs/tables. To keep things simple, one of them is marked AGENTS (with columns marked Agent, City, Phone Number, etc), the next is marked EVENTS (with columns marked Agent, Event Type, Length, etc) and another marked MEDIA (with columns marked as Site, Agent, Type of Media). I know how to make each table into a form which can be filled out by an “Agent”, so it feeds directly into that table. But is there a way to create a master form which fills into areas of each of these different tables? I hope that makes sense. Basically, we want to provide a form for our agents to fill in, and have it feed into a variety of tables under certain headings. Thanks for any help or suggestions.

Hello, I am looking for a way to create a link of the page designer report to a website and only show the report. Is this possible?

Is it possible to send SMS messages from a Twilio shortcode? I’ve tried entering into the configuration page just the numbers, +{numbers}, and +1{numbers} and they all return the same error, mentioning “from number NULL”.

Hi! Is there a keyboard shortcut to expand a linked record? Or has anyone found a different way of solving this? When interacting with mouse, clicking to expand the linked record is dangerously close to the X to remove the linked record… Thank you! Freddie

I have a form that populates a current base. Part of the form functionality asks the customer which of our locations they are contacting us about. Currently it all feeds to one base, which I group into separate segments by location. But I would prefer if each location had its own individual grid within the base. Is this possible?

I’ve got a table of monthly subscription transactions, and I’m trying to find a way to report on new and lapsed subscriptions. New subscriptions would be a list of new subscriptions from the previous month Lapsed subsciptions would be a list of subscriptions that had transactions two months ago, but did not have a transaction last month. Currently I have to download the table to Excel, run a pivot table in excel of subscriptions along with min and max month for that subscription and then do a second pivot table of months and a count of subscriptions with min month equal to that month (for new subscriptions) and a pivot table of months with a count of subscriptions with max month equal to that month. Is there some way to do this via a pivot table or chart in Airtable?

Hello, hope anyone can help me with this question, I have 4-5 checkbox fields. I will name them for easy understanding of what I am trying to achieve. Checkbox 1 Checkbox 2 Checkbox 3 Is it possible by any means to “lock” Checkbox 2 and Checkbox 3 until the previous one(Checkbox 1) is ticked? And it continues, lock checkbox 3 until the previous(Checkbox 1 and 2) are ticked. Hope I can get some help :winking_face: Thank you

I managed to move my gallery to WordPress but I want to config it. Is it possible to make the window bigger? I tried to up to with but that didn’t work. Besides that there is an option to download the CVS and see the large version, I want to disable these features Is this possible?

How can I restrict the email field to one (1) particular domain - for example on my form: I only want to accept emails from @example.com how can I restrict any other email domains from being entered?

Hi - new here - this is probably an easy question. I did search the forums but perhaps not using the correct terminology. I am trying to create an aggregate view summarizing data from a form people are filling out on a website. They are selecting from a dropdown indicating their geographical location - there are 40 or so selections to choose from. I then want to count all the people that choose a particular region and display that data People who chose A = 23 People who chose B= 16 and so on… I am close…I have created a linked table based on the selection - problem is that the drop down field can only be a dropdown field (field A) - I cannot also link that field to the new table displaying the aggregate data. So my solution was to make a new field (field B) in the initial table and link that - it works, but only if I manually copy the value from field A to field B. So my question is - when someone fills out the form online, how to I make the Table automatically copy the entry from fie