Other Questions

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. 

Hi. I want to create an agreement form to sign. The form will be made in fillout. There will be fields for name, email address etc to fill in in the form, however I'd like the legal agreement text to be automatically in one field in AirTable that will also show up in the Fillout form. Is there some way to do it or am I going about it a wrong way?

I have been looking for a solution to the issue of creating multiple-page quotations in Airtable. I have a quotation that is 6 pages long. I tried hacking the page designer by using custom-sized pages and dropping page size images as backround to create the various pages. It just doesn’t look right and never will. Also, you can’t email the quote directly from airtable which is an extra pain. I have been trying to evaluate Formstack as a solution. I have followed all the instructions in the videos but when I open the output document or save it in an attachment field in airtable the documents are black. I have tried to get help from formstack but they are taking an age to get back to me and I can’t go through what I am doing so that they can help me identify why it is not working. Has anybody else had this problem or offer any possible solutions? Thanks in advance Sean

Apologies - it's hard to write a subject line in what I need help with. I am trying to make a shotlist for a photoshoot, pulling product information from a non-editable base. Some products will be in multiple shots. Meaning product A could be in shot 1 (solo), shot 2 with Product B, and Product C. I am trying to figure out how to have Product A filter to be shown in Shot 1 and Shot 2. is this at all possible? 

I am using LIST records API to retrieve data from the table.I am needing to get all the records every time. This is acceptable, but no ideal.My client's table has no field that mark when a row is created or edited/updated. Does this of function already exist? If so, How would I grab only the records that were added or changed since the last update? BTW: using this API call:https://api.airtable.com/v0/xxxxxxxxxxxxxxxxxx/$$tablename$$Thanks,Scott

Hey guys, I have a need but I don’t know if it’s possible, I need save data from an airtable in Excel or CSV and send attachment via email It is possible? I appreciate any help or idea.

Hi,I am wondering if there is an audit trail for users outside of the records itself? We've had an important record deleted and we would like to find out who did it.Thanks,Ellie

 How can I make it 2024-08-31 6:30 PM PDT like how the record is in my airtable base? I don't want that T or Z at the end and the seconds and the decimal to be shown either.