Other Questions

Hi there,I have been asked to look into if Airtable and Smartsheet can integrate with another. I am looking to create a report from Smartsheet and for it to be integrated into Airtable's calendar view so people know when milestones are due on projects. Is this possible?Thanks

Hello! I have the below table that list Rooms with the associated Furniture and Accessories that belong in them. I would like to be able to filter on a field in a separate table for Client ID. The thing is because I’m keeping track of Rooms over time for each client, multiple Client ID names display when I link the below table to the other table for Client ID. I tried to filter on 1 particular client’s name for Client ID, I could also see the other clients that have used the same type of furniture pieces. I only want to see information for 1 person. I hope this makes sense. Is there a way to make this happen?

HI, I want to be able to select multiple records in a base and update a field in all selected records. I’m thinking this will probably need a script where I can enter a value and then push a button to update all selected records with that value. Has anyone done this or have an idea to get me started please? Thanks

Hello, I have been invited as an editor of another user's database. I pay for the team plan, and the other user does as well. However, the creator of the database is being charged for having me as an editor. Is this correct? If I already pay for the team plan, why does he have to pay for giving me permission to be an editor in his database?

I have a table (source table) synced via a one-way sync to a table in another base (target table). I recently changed the name of a field in the source table, and I noticed that the name of the field in the target table did not update to match the updated field name of the source table. Is there a way to automatically sync the field names, or do I have to manually update the field name in the target table? Thank you for your help. 

I recently switched from google drive to dropbox for my content uploads and when I try to add a photo into the attachment from my dropbox integration it only shows me the content in my dropbox in a list view rather than a grid view. I'd like to see it in a grid view so I can see all the photos as is and not as the file name. Is there a way to change this? TIA! 

Hola AirtableforceoneFirstly, if anyone wants to know how to extract helpscout images from threads and then send them to dropbox and then over to Airtable .  will share that here. Thats 8 hours of my life gone but it's easy now Iknow.BUT - one last question. Right at the very end. How do I fix this?I have Make/Integromat adding an image to an airtable row by providing a URL (Ps, I made a public one of course, used drop box yadayada).But when I upload the image, it deletes all the images in that row rather than just adding another. Cant find any switches of settings for it. Any ideas? Seriously, Make is so far more detailed than Zapier but this last piece is a killer.

Hey Everyone, I am working on a project that brings together data from a number of tables, text and images that are trigger by a web hook in a web app using softer. The web hook is used to tell zapier what data to search for airtable. Then in Zapier the data is parsed into the Google slides document, which is then converted to a PDF, then printed. It is an amazing no code rube Goldberg situation! The method that I am pulling data from Airtable is using the Search, the search provides URLS for the images, but when they are linked to in a. browser, it says that the URL is expired.Airtable support suggested that when  you use the "New/Updated Record "method to pull records, that there is a "Include File Contents" option that will pull the PNG information into the zap making it useable in Google Slides.In an effort to not overcomplicate things, I was wondering?is there another way to get the PNG data from airtable using the "Search" method?   

 I have a database with 3 tables - clients, line items, Invoices.I would like to have a form where a client can add line items and then at the end of each month an invoice for each client would be created (if possible automatically add a record to the invoice table) including a rollup of only the items that were added that month and for that client.I haven't found a way of doing this so any suggestions would be much appreciated! 

Hello, I am trying to take one column with a day/hour field (Start Date) and use a Single-Select (Time zone) to create an updated day/hour column. Currently, I use New York time on all the other dates but I need to be able to see a different version of the time in cases when I am collaborating with people internationally. Time zones would be ‘Africa/Laos’,‘Africa/Maputo’,‘Africa/Nairobi’ etc. Any help would be much appreciated! Edit: I have looked at this sample base and get what it’s trying to do, but I don’t know how to alter it for my purpose.

Hello again! I am trying to create an email report where I use the automation flow below: At a certain time > Find Records > Outlook: Send Email I’m using the “Find Records” action to search for where a checkbox is flagged, then using those records to input a grid or a list into the email. The issue is that I can’t reorder the fields or sort the list/grid it creates. Is there either, another way to do this WITHOUT A THIRD PARTY APP, or is there something I’m missing that allows you to sort records/reorder fields?

I’ve created a base for managing a complex calendar at my institution. I’ve created simple table and calendar views for collaborators, but I also have a table view that is strictly for exporting csv files so I can upload the events to our website since there are strict rules for formatting, etc. All of the events have to have categories, some of which have up to three. I’ve created a multiple select field (“Category”) so people can select the appropriate categories. But when I export to csv, there can only be one category per column. I would rather keep a single “Category” multiple select so I don’t have three separate fields that people have to figure out. Is there a way to write a formula for this? So the logic would be this: I would create three fields (Category 1, Category 2, and Category 3). Category 1 would find the first option in the Multiple Select field “Category.” Category 2 would find the second option in “Category” Category 3 would find the third option in “Category”

Hi all,I am wondering if there is a way to either create a new table or export a .csv file that would list out all of a record's linked records in columns. I have an inventory base that tracks outgoing and incoming equipment to and from specific sites. Essentially, I want to be able to export all of the linked record data so that each linked record has its own cell in a respective column. I've included screenshots below to better illustrate my specific case. Is there an automation or script that can perform these actions? I've tried to export just a single record by filtering the view, but all the linked records remain grouped in their respective cells rather than each receiving their own cell/row like I would prefer.

After looking at all the questions re: logos in the emails, I find that I am still having problems.  I am not seeing the logo.  I've attached the output and the code.  Please help!!!

HiSo i just invited a user with a view license so they could complete a form (locked to our domain). This user was able to create their own workspace, and in the process upgraded themselves to editor.How do i stop this from happening? I'm about to invite 300 people to be able to submit a form for a project, and really don't want them to be able to upgrade themselves to editor and blow my license count.Cheers

I created a base for a client and now need to transfer that base to them and remove myself as the owner.  What is the best way to accomplish this?

My Interface goals are stalled because I can not figure out how to create my desired bar graph. I created a bar graph example in R to show that I would like to have the number of hours on the Y and the dates on the X. They do not necessarily have to be color coded but they should be separated by the location. In my own attempts to create this bar graph I have only been able to create a count of the number of hours logged. For example, 2 hours has been logged twice for two different dates. This does not provide any substantial information on time and the number of hours spent traveling per location. If anyone is willing to help me figure out how to create this bar graph, please reach out! I would really appreciate it.

Hi, I am trying to create a base and keep getting the "could not send request error" Attached is my Json body and the screen shot of the API call and the error.       { "name": "CMM 2017", "tables": [ { "description": "A to-do list of places to visit", "fields": [ { "description": "Name of the apartment", "name": "Name", "type": "singleLineText" }, { "name": "Address", "type": "singleLineText" }, { "name": "Visited", "options": { "color": "greenBright", "icon": "check" }, "type": "checkbox" } ], "name": " Editorial 2017" } ], "workspaceId": "wsprSxuHCKzjhwYUM" }       

Is there a way to use the Multi-Select Field WITHOUT the field options being in Bubbles (i.e., as just plain text). I currently push several multi-select fields into Page Designer to generate record reports; however, have to maintain an interim field for each that uses a formula to strip out the bubble. It is a cumbersome workaround. Seems like there should be a "Bubble" toggle just as there is a "Color-code option" toggle.

On one table I have item name/type/start date, and I’d like airtable to auto-fill some cells next to it in that row depending on the type/start date selected (type is a dropdown single select). So for instance on this table: When the type (green arrow) is monthly email (or whatever the type is), then fill in the cells next to it (purple box) which is called from this table: I’d also like it to fill in dates according to the start date of that item, so for instance if it’s type “monthly email” starting on June 17th, then according to the second table calculate the date of 2 weeks before the start date. Going to sync this with our CRM for activities, so these cells next to it are the item activities name/date. Here’s a loom video if it’s easier, thanks a lot Loom Charged Production [Copy for Development - June 10, 2022]: Pipedrive...

Hi everyoneTrying to see if an idea is viable from a cost perspective but can't work out licensing implicationsI want to build a FREE, NO COST application for a community scenario where kids are collecting and trading stickers.  The plan is to use Softr and Airtable and the app is basically built but now I'm wondering if it's viable using free licenses.Not sure of the number of users, don't anticipate it will be that many, maybe 100 even if successfulAny thoughts?ThanksMike

Hello!I have a table (table A) that has two fields I want to display in another table (table B). One of the columns in table A is a check box value, the other is free text. I have linked table A inside table B and created two look up columns in table B to display the check box column and the free text ones but they turn up blank. Any ideas on why this is happening? 

I'm an author, and I use Scrivener to write my manuscripts. As you can imagine, keeping up with characters and all their details is a necessity but until I started using Airtable and up until late last night when I had an "ah ha" moment, it's been a nightmare. Last night, I configured a base to keep tract of characters and locations. I then created a character development form to fill out when plotting and designing the story. Another "ah ha" moment later and I remembered that I can add webpages to Scrivener as documents and they will open up in the editor pane as if the webpage is a part of Scrivener. So, I grabbed the share view link for the form as well as the Gallery view for the characters of the book series I'm working on and attached them to the Scrivener file. Everything is working beautifully, but it will not allow me to edit the character records in this view within Scrivener. It says I need to login or create an account even though I've got the base open in another

hellotrying to add end meeting time, which is a formula of one hour later of the meeting timeso I did a formula one hour later, but it wont work 

Is there any way to archive a chart in airtable?I created some graphs using the airtable interfaces, the point is that one of these graphs represents how much I spent on each category in the current year until the current moment, so when the year turns, this graph is reset.I would like to be able to archive it or "freeze" it within the airtable itself, so I would have a year-by-year history to analyze in which categories I spent the most in that particular year.If it were possible, I would like an automation to copy this graph and archive this copy on December 31st, since on the first day the information will be reset. If this function doesn't exist yet, please think about implementing it, it would really be very useful.