Other Questions

My team is using a base to hold client info for meeting attendees. We are all collaborators on this base. We each have our own sheets for our own projects (meetings) in the base (the first sheet is the database). We have a form in the database that we all send to potential attendees to fill out as a “registration form.” We have been using it for a couple of weeks and all has been going well, but just a few days ago, the form submission email (that we check at the bottom of the form) now goes to random team members and not the team member who sent the form. We have done several tests and have verified that we are logged in as ourselves and that the email at the bottom of the form is correct. As an example…my team member Katie sent the form to potential meeting attendees and she checked the box at the bottom of the form to receive an email when someone submits a form. Mr. Smith submitted the form and my team member Nicole got the notification, not Katie. I sent the form to potential atte

Hi everyone, I am trying to import an airtable calendar into Outlook using an ics file. However, it appears that the owner of the calendar has everything coded as UTC when it should be in EST. Thus, when I import into Outlook, it tries to adjust into my local time and everything ends up in the middle of the night. I don’t have any ability to change the calendar itself, only viewing and downloading an ICS or CSV file. Is there any way I can edit the ics file itself so that outlook thinks the times are in EST? Though it may not be the place, this leads me to two other quick questions: If I import the calendar, will it automatically update if changes are made on airtable, or is it static from the moment I import it? Also, is there any way I could import only certain events after applying a filter? I can apply the filter I want on the airtable interface, but I’m wondering if I can basically apply that filter to an exported ics. Thanks so much!

I use Airtable to hold content parsed from HTML emails. The html content is in a long text field. I want a Block that I can use to render the message content from those emails. Does this exist?

I’ve generated a page using the page designer block. Is there a way to create a new field in the original table and add a print of this page? I’m thinking along the lines of an attachment. Thanks!

Hey hi! Ok. So I have a Table with multiple Views, each with a specific criteria of hidden tables and Page Designer set up to pull from various Views. All seems totally normal. BUT… when I attempt to edit a record from within the Page Designer Block using the “Expand Record” button, Page Designer will only ever show me the same specific View. Doesn’t matter what View I select in the Block’s dropdown; whenever I am trying to edit from “Expand Record” from within the Page Designer Block it seems “stuck” on showing me the same (read: wrong) View; a View that has all the wrong hidden fields. I have reloaded the Block. I have disabled/enabled the Block. Any ideas out there? Anyone noticed similar/same ? Thanks C

Good Morning Brilliant Friends! Is anyone aware of web based database tools that are ideal for data analysis and ongoing process capability analysis? Airtable is great for project management, but is extremely limited in it’s ability to crunch data. We could use Microsoft Access, but it’s not exactly intuitive and I am hoping to find a beautiful interface like Airtable, but focused on data analysis. Thank you! Paul Warren

As our business has grown over the last several months, we are finding a need to automate some redundant tasks. Is there a way that I could create a ROW in TABLE 2 when I add a ROW to TABLE 1 (When a certain field is VALID)? Furthermore, if this is possible - could I have the new linked row auto populate with fixed fields or information? Ex: Table 1 (Manual Input) ABC Liquors / 123 Boulevard / John Doe 123-456-7890 / … / Conditional Field that yields NEW ROW Ready to Launch? (Y/N) Table 2 (How do I add fixed fields in place, if possible) ABC Liquors / Ready To Launch / …general info… / (Y/N) / Fixed Fields / Anyone’s expertise is greatly appreciated!

I accidentally deleted my table when I was trying to delete a view. How can I recover this?

Hello, We use Airtable for confidential information. Is there a way to lock a view so that not only can our team not change the filter settings, but also not be able to duplicate the view? Also, is there a way to create a personal view, but for a group of people? Is there a way to keep people out of certain locked views? Something else that would be helpful is being able to customize the permissions of each user for each view. For example, I would like users to have editor permissions for Views A, B, and C but Read only permissions for Views D, E, and F. I know this can be solved by creating different bases, but because we can not link bases, copying and pasting records from one base to the other would allow the possibility of clients falling through the cracks.

For simplicity, let’s say I have an “Orders” table and a “Contacts” table. There’s a linked field on the Orders table with the customer’s email address. This is linked to the Contacts table, which creates a parallel linked field on the Contacts table that links back to orders. How can I create a secondary field on the Contacts table that only shows orders that meet a certain condition, but also links to these records? I can’t do it with a lookup field, because it seems that once I add a condition to that, the items that populate in that field aren’t “live,” that is, you can’t get back to the target record, it’s just text separated via commas. I’ve tried changing the linked field on the Contacts table to limit selection to a view with the proper filters, but it ignores this entirely and still shows all orders.

If my base have two table that is Table1 & Table2,i want to do that when i upload a data in table1 through my app that data will automatic add in table2 …is it possible???if possible kindly help me @Bill.French add a solution image if possible

How can I create question with image on form?

Is there a character limit in the Formula field type beyond which the formula no longer processes? It allows me to type in arbitrarily long formulas, but I notice that sometimes after a certain point the editor no long suggests auto-fill options when typing in the formula, and when I finish writing a long one, it seems like the end parts of the formula don’t process. Then when I go back to look at the formula, the end part of it is not present in the Formula box, even though I know I typed it in there. (A separate, but related issue - the thing I am trying to accomplish with this is converting a month number from a date field to the month name. So my hyper-long formula starts IF(MonthNum=1,"January",IF(MonthNum=2,"February",IF(... etc. If you know another way I can accomplish this that wouldn’t run into character limits, that’d be great too - thanks!

I need to find a way of creating multiple views of all data from a table. Ideally I would like to create a table and duplicate the table in a way that if I edit the data on either of the tables it will auto update on the other table and I can set up different views and filters for each of the linked tables. I may want to show all tasks for one team member on one table and all tasks for part of the project on another table but be referencing the same data on each of the table veiws. The columns would be the same on each table, better still if you edit the column properties on one column it will update on the other. Any help with this would be much appreciated.

The code below successfully display records. Please how do I add pagination to it. Thanks const base = useBase(); const table = base.getTableByNameIfExists('myfirst_table'); // grab all the records from that table const records = useRecords(table); // render a list of records: return ( <ul> {records.map(record => { return <li key={record.id}>{record.id} -- {record.getCellValueAsString('lastname')}</li> })} </ul> );

Greetings to the Airtable Community! In my SVCS/Tasks table I have two special views. One filters where items are coded as “Task”, the other where items are coded as “SVC” and a status of “SVC YES.” I link to the SVCS/Tasks table in my Events table, using the views above to “Limit record selection to a view.” One column to display the SVC items, the other the Tasks. This was working well, but now I’m seeing SVC items in the Task view and vice versa. I’ve attached some screen grabs to demonstrate the issue. Any assistance/guidance would be most appreciated.

Is there any way for a “Link” field to share the filter properties of a “multiple select” field? For example, when filtering a multiple select field, I have many options (e.g., has any of, has all of…) and I can toggle the selected options on/off. Seen in these 2 screenshots: However, when filtering a linked field, I have limited options and I have to type in the exact thing I’m looking for. Seen here: Is there anyway to get the link field to act like a multiple select field? I don’t suspect there is. But wondering what the roadblock is to making this happen. Can that be programmed? My current solution is suboptimal. Every so often I copy the multiple select field column and paste it into a column designated as a linked field. It works but require a lot of ongoing maintenance and if I change the name in one place, I have to remember to change it in the other field. It’s a hassle. I would love a way to allow Link fields filterable similar to multiple select fields. Any advice

I’m sharing a view of a table to a client, however, when I update the table, their view isn’t updated unless they refresh the tab. This makes it completely useless for me. I would add them as a collaborator but that would give them access to hidden data that I need to keep protected. Is there a setting or work-around for this? Thank you in advance

Hey! I’m trying to count the number of Mondays and Thursdays between two dates - does anyone have a formula or tip on how to achieve this?

I’m setting up a large base to track an entire industry. I will have several people adding info to the base. The “Employer” field in the “Worker” table will link to the “Employer” table and will track the employers of each worker. There are thousands of workers and dozens of employers, and many of the employers have different possible ways to write their name (e.g. MEC Consultants, M.E.C. Consultants, Inc., MEC, etc.). Is there any feature in Airtable that will protect against us creating multiple unique entries for the same company over and over, other than clear rules, thorough training and pro-active clean-up?

Here’s what I’m trying to do: In Table-1 I have records with a “Created At” field and “Status” field. I’d like to create a new Table where I could see total numbers of records from Table-1 where “Created At” is let’s say May and “Status Field” equals to Done. I’ve tried linking records from Table-1 to Table-2 and use Rollup filed but it only counts number of linked records, to look like this: Month - May Total Sales - 12 Amount - 120$ Any ideas?

Hi I have a project / task management base that works well, If i can find a solution to the following point I’d be a very happy man. I have tables for projects and tasks and link the two, in the task view i have a grid view where task are grouped by project. The top task under each project is the next action on it, i have a process (GTD ish) where I have a list of those next actions across all projects, I currently create the next actions with a tick box I manually set but its cumbersome. Any suggestions on how this could be automated would be appreciated, Regards Rob

chart is very useful but i cannot see numbers or % in the pie or bar that i generate. Any suggestion or help ? Thank you

At the bottom of a form editor it states ‘send email of submitted form to…’, and then my admin email address. Is there a way to have these get sent to my assistant on a different email address? Thanks!

How would you approach representing a sitemap in Airtable? I can see how using a select field would help me denote different types of pages. But how can I overcome the fact that a sitemap is essentially a hierarchical construct? Thanks, all.