Solved

What would be the most practical way to incorporate multiple tables worth of calendars into one?  In an interface, to be specific.I have three tables worth of data I'd like to mix together in a single calendar.  I suppose I could have them all in one table, but I'm concerned it might make things a bit busy in that main table.I have Table 1 that is basically like a CRM for any incoming proposal requests for my business and I have a few date fields there.  3 sets of start and end dates to cover dates we'd hold for the client.Then I have Table 2 where we actually schedule specific events.  Just a start date (with a time) and an end date (with a time) for a specific event stemming from an approved project in Table 1.  1 entry in Table 1 could have 20 events in Table 2, mind you.  But every Table 2 event is linked to an entry in Table 1, so there's already a natural link there.Table 3, on the other hand, is less connected to Table 1 and 2.  This is just a

I have successfully gotten airtable to upload a PNG and a PDF from Dropbox. But when airtable processes the file, the type is listed as text/html If I include a type field, I get an error: { "fields": { "Type": "Test", "Comment": "", "Attachments": [ { "url": "https://www.dropbox.com/s/XXXXXXX/robots.png?dl=1", "type": "image/png" } ], "User": "", "Part": [ "recFI6JhdkwTCeB9q" ] } } And I receive this: { "error": { "type": "INVALID_ATTACHMENT_OBJECT", "message": "Invalid attachment object for field Attachments: {\n \\"url\\": \\"https://www.dropbox.com/s/XXXXXXXX/robots.png?dl=1\\",\n \\"type\\": \\"image/png\\"\n}" } } But if i just strio out the “type” there is no error, just the type is wrong.

Hi, I've been struggling with this for an hour and I'm hoping someone might be able to help.I have a Timeline Interface that displays a series of tasks, and I want my users to be able to edit the task fields - changing the assignee or the status for instance. I would either like to be able to add additional fields here to the initial small modal that appears when you click a task:Or, I would like to make the fields in the sidesheet editable. Based on what it says on this documentation page that should be possible, i.e. Click into record details - This setting allows end users to expand a record to see more details. You can choose to show the details as a Sidesheet or a Full-screen. Once enabled, creators can design record detail pages showing specific fields — in any orientation to their end users. Additionally, individual fields can be set to be View-only or Editable.  

Hello everyone! Relatively new to scripts, but I think I am starting to get the hang of it.Basically, I am trying to convert a currently overloaded automation into a script for easier maintenance and better customization. Overly simplified automation process:If record is updated > set [Ticket Status] = [Status] for that recordThe script so far: let table = base.getTable("Quick Adds"); let inputConfig = input.config(); await table.updateRecordAsync(inputConfig.RecordId,{ "Ticket Status" : inputConfig.Status }) console.log(`The value of Status is ${inputConfig.Status}`); If I remove the "await" line, everything runs and it outputs the status value. When I run the script with the addition of updating the second field, I get a "Error: Field "fldjRCz6y0ku2XxIY" cannot accept the provided value." for line 3.inputConfig.RecordID is the @ Airtable record ID fieldinputConfig.Status is the Status field

Hi Everyone, I want to create multiple forms to gather contacts for different reasons - Subscribers who want our newsletter Those who want to download our resource Those who fill out our profile form All of the forms capture Name, Email and then they have different fields. I want to keep all these contacts in the same table. I was hoping to have one table with 3 different form views. The issue is, I want to track how each contact came in, and I can’t figure out how to tag the submitted responses by the form they submitted. Instead, I have these split across different tables and I manually tag each, then copy/paste new responses into a master list. Am I missing something obvious here? I keep all the tables structured the same so the copy/paste to master is easy.

We have a table called Documents and I want to use a formula that pulls the name of the file in the {Attachment} field in order to provide the Name of the record. I've been using the LEFT({Attachments},FIND("(",{Attachments})-1) for this purpose and it works great, but I've now found that if the name of the attached file contains a comma, then the formula name adds a quotation mark at the beginning of the name. So now I'm trying to combine the SUBSTITUTE and FIND formulas to:1. Look at the name of the attached file, and if it contains a comma then replace it with a hyphen (eg. 'Ocala, FL' becomes 'Ocala-FL' )  2. Then use the name of the attached file as the name of the record without the URL at the end (using the FIND formula). Another acceptable option would be to just remove the comma from any file name in the {Attachments} field and then allow the original LEFT formula to do its work, but I think that might require an additional field. It's less elegant, but I'm

Is there any way to be notified when a base has no new records in a period of time.I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.Anyone know of a way to do this?

Hi there,In the last few months we been happy with getting an email on each new lead being created in one of our tables. The email contains all the needed data relevant for our sales team. BUT i'd really want that email to contain an attachment which is a .eml file (email) which is populated specifically with the records data. How can i accomplish this?Goal is to minimize errors when our sales rep copy/paste the data from the email. 

I signed up for beta a long time ago, but seems I'm still on the waitlist. Has anybody one else been let in to beta?Notion's AI tools are cool and I'm using them already.  Wondering if I should be shifting my workflows over, or keep waiting.  It's almost 2024!  

Hello, I'm trying to merge a CSV but the field that I need to map to is not available to select. I can't select the field I need as the merge field. It is not one of the options in the "choose a field" drop down.

Hey all I've created an automation where when a form is submitted - a record is updated. However! Sometimes there isn't a record to update, so it needs to be created first. So I need to create a process like this:WHEN a form is submitted AND record exists UPDATE it. IF record doesn't exist CREATE itBut the automation is getting stuck on the first part and fails to run into the second. I've taken a screen shot to show what I mean. How can I fix this?Thanks!

Structure is as follows:Project tab has all of our project records with around 50 fields of project-specific details.Some project records are categorized as "Original Project" and some are categorized as "Revision""Revisions" are linked to their "Original Project"I want to do the following:1. Create a new "revision record"2. Fill out ONLY the fields that will be changing 3. Link the "original project" in the "Original associated project field"4. When that field is updated, I want an automation to run that will copy and paste fields from the original project record to the revision project record, but ONLY for fields of the revision record that are empty.Example:"Original project record" fields/Project info:Unique Project Number: #557 (Autonumber)Customer name: John DoeSolar module: Mission Solar 400WQuantity: 25Inverter: Solaredge 7600kWProject type: Original ProjectAssociated Original project: None"Revision project record" fields/Project infoUnique Project Number: #558 (Autonumber

We have a list of questions in a base that we want to email out to gather answers, or ratings on a scale of 1-5. Is this possible to automate?

Hi,I'm using a form so users can enter their data into a table. In that table one field always has to have the value "SUM" I want that every new record to be receiving default “SUM” Thank you

Hello! I'm new to Airtable formulas & could use some much needed guidance! I need to calculate the total with an option of a discount if a multi-select answer is chosen. For context, this is in reference to grades of elementary curriculum books purchased. I am trying to create a formula that will show me:If Rural Discount multi-select = 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $250 + additional invoice amount= total invoice costIf Rural Discount multi-select does NOT equal 'Small school (one classroom per grade level)' answer, then total # of grades licensed x $500 + additional invoice amount= total invoice costHere was what my closest effort was: Additional info:I'm not sure if this will make a difference/make things more difficult but the column I need to multiple from (total # of grades licensed) also has a formula. Not sure how Airtable is with multi-formula mingling so just wanted to throw that out there! (side note: If ther

I have a team that wants to send a weekly digest that shows updates only from the previous week. I found a formula that can show if a date is this week or not but can't figure out a way to show just dates from the previous week 

Hi, I am trying to automate an email message with invoice details for the finance department to create an invoice. For each record (invoice) I have one or multiple sales, invoice lines, so each record will have fields with multiple linked data. In the body of my email I would like to split out these fields by the invoice line (sold item), but they lump together by the fields on one line.Message body build up: Below you can see Sale #1 and Sale #2 with their corresponding fields are clustered on the same line. I need them to be on separate lines with their corresponding fields:Thank you.Best regardsChristopher

Hi all, i need help form you 🙂i have 2 tables : - VariantTable -CostTableThe key is the SKU, this field is in the 2 Tables.I would like to add colunn in VarianTable with the CostPrice.How to create field with Automaticaly put the CostPrice when SKU is same.  Thanks for you help

Hello everyone!Im trying to automate a LinkedIn Image Post using Make. But i have some problems:Even tho my scenario runs successfully, the post dosnt get posted to LinkedIn, the problem is the image.I dont know how to get the image from Google Sheet/Airtable to the LinkedIn module, even tho i use a HTTPmodule, which is weird.Here is the scenario:This is in the output from the LinkedIn module:The image URL is public, so Make can find it.Do you guys have any tips?

Using the insert Grid/List of Records into Automation email how can I include more than the Name field of the record,? Similar to what you can do with a Grid in the Page Layout designer? So the result in the email would look like:Name 1 Date StatusName 2 Date StatusName 3 Date Status Again this is a field in the main record that looks up related records that I want a Grid of, but with more details.

Hi Community,I have a team annual plan. I have a base with 8 editors. How do I read this bill?Thanks!

I have an automation attached to a button, and I want to insert the user who is logged in to a field. I can’t seem to figure this out. Is there a current_user() formula?

I have several single select columns with "yes/no" selection answers. I want to make a sort of if/than formula to combine the information from those yes/no columns. For example, in the photo below, there are columns a, b, c ,d, e. We will call those each "foods" for the purpose of the example. If someone says "Yes" to foods a, d, e but they say No to foods b and c, can I make a column that combines the yes data? I would like a formula field to show that the person has chosen foods a, d, e, just like how a multi select field looks. I have thought about using If statements, but I'm not sure if that will allow multiple answers into 1 column. I'm not even 100% sure a formula can give me the information I need. Does anyone have any input on this? 

When I use to copy a base via public share link, automations copied over as well. They were just turned off.Now when I do it, automations aren't copied. They're all gone.Am I doing something wrong? Was this removed?

hi fellow community members, I'm scheduling a series of posts on Instagram.I have created post and assets tables on the same base. However, the image previews formatted as PDFs never show through Lookup. In the attached screenshots you'll see that only one is coming through. That's a PNG screenshot. I understand that this was a major issue in 2020. Does anyone have a solution?Thank you so much!Rafael