Solved

Hello community!I have a problem, which I've been unable to resolve myself.I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).Now, in the first table (table 1) with different entrees all entrees have a name connected to it.But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.Hope my explanation is clear.Does anyone know how to do this?

Is there any way to search for emoticons (any of them) in a text field, and replace with something like a dash or space? Is there a code for emoticon that allows a formula to search for this? Emojis and emoticons are often put into titles of blogs, but I am curating titles and creating url’s out of them, but want to remove any trace of these.

Hello guys! I’m new here and I’m still learning about Airtable, but I’m really enjoying it! I have some doubts about formulas, I would be very happy if they work for what I need, here are my doubts: 1 - Is there any way to add numbers in a column automatically every time you turn the month? For example: Column “parcels” on 12/22/2021 = 1 on 01/22/2022 = 2 and so on? This would be very useful because here in Brazil we make purchases in installments, so the number of installments, changing month by month alone, would make it much easier. 2 - Is there any way for the formulas to understand the “unique selection fields”? I would like to create a formula like: If the “unique selection field” has the option “green” the answer is 1, if it has the option “purple” the answer is also 1, but if it has the option "black " the answer is “1/2” Thanks in advance!

The Team plan is $20 per seat/month billed annually. Does the "per seat" mean users? So if we have 10 editors, it'll be $200 per month? But the plan also says it includes unlimited editors. It's very confusing...

posting on Facebook date and time from my table doesnt get me the same format on the post (2020-12-17T06:00:00.00)this is the outputthis is my input 

Google calendars that are imported to Airtable - it looks like only 20 google calendars are allowed to be imported on a base. If we need more calendars on a base, then we need to create a new base? Is there a way to get more than 20 google calendars on a base? Please see screencast and pic attached

Is there any way to change different versions of domains to its root domains? example: If we add Column 1 https://www.domain.com/ https://domain.com/ https://www.domain.com https://domain.com http://www.domain.com/ http://domain.com/ http://www.domain.com http://domain.com Column 2 Result in all rows of above domain.com

Hello!Currently I have a button column linked to a column with a webhook. When I press this button, the webhook is triggered and the row informations are exported to Make.I want to get in a column, the number of times the button has been triggered (+1 each time).Do you have an idea ?Cheers

Hi. This seems like something trivial, but I can't seem to find any way to do this. I had synced two tables from a base to another.  During that time, various fields were renamed in Base A (the source table).  I noticed that the fields in Base B do not seem to get renamed as well, yet the sync remains active.  How can I know which is the fieldB name in Base B, which maps to fieldA in BaseA, without having to resort to guessing? 

I have a Date field (Date Asset Added) whose value is entered manually formatted like this:12/8/2023Another field (Date RM) contains this formula: DATEADD({Date Asset Added}, 0, 'day')  which outputs this: 12/8/2023.  12:00am I want to execute an automtion when these two values match, which they don't. So I tried using thiis: DATETIME_FORMAT(DATEADD({Date Asset Added}, 0, ‘days’), ‘M/D/YYYY’)) which outputs this: 2023-12-08T00:00:00+00:00  I think that DATETIME_FORMAT turns the date value into text. In any case, what formula can I use to get the value of the field Date RM to match the value in Date Asset Added? 

Hello,I want to make an automation to send an email at a specific time. When I choose the trigger "at a scheduled time" and go to write the message of the email, I can write a message, but I cannot input any data from the base. When I click on the blue plus sign in the upper right corner, the only options are "actual trigger time," "expected trigger time," and "next trigger time" (pictured below). How can I pull data from the base, such as "dear [insert name]"?Thank you.  

Hello everyone, Please I need your help I would like to send out an email with two answering options referenced from my table in my base and the user should just be able to pick one option in the email with just one click and automatically the value are being transmitted into the base directly without opening the form. I don't want any form to be seen after pressing the button I just want it to be submitted automatically.What i have done is to create a form and write a prefill url formular that prefills the form with the option and an extra field that will also be prefilled that works only in the base but when i reference it in the email and preview it doesn't appear at all in the email.Would it be also possible for the form to be submitted automatically once the button is pressed ?I would really appreciate any suggestion or insight Thank you.

I want my automation to update the record when it is complete and then remove or delete any/all the attachments in a particular field, how can I do this?

I have searched Airtable Help and Google and haven’t located a solution for the following issue: I have created simple formulas in Currency and Number fields. The results are always rounded up. I’ve tried different options (Integer, decimal places) but they made no difference. How do I get Airtable to show the correct result without rounding up? Thank you!

I have a co-worker who can't "star" any bases on his homepage to favorite them. He can star the one workspace he has, but not the bases. When you hover over the base, the greyed-out star isn't there. When you click the three dots, there is no option there to "star." He has creator permissions for the workspace. What am I missing?

Hi, I am trying to count the number of months from the Start Date till today.  The actual day of the 'Start Date' doesn't matter.  For example, if 'Start Date' is 9/20/23 and today is 12/11/23, I want to count the number of months that have passed: Sept, Oct, Nov, Dec = 4.  I have tried this formula: DATETIME_DIFF(TODAY(),{Start Date},'months') but, I know that doesn't work. I have been searching the community and haven't found the right solution.  Any help would be appreciated.

Hey guys, I have multiple users who work for me on the free version of Airtable and one of them signed up for the free trial.On March 11th at the end of the 12 days him and all collaborators (as he set up the base) incurred a charge of £1200 for the year which we did not want or intend, how can I go about getting a refund?I have tried multiple times to contact Airtable but there are no listed phone numbers or fast ways to get a solution, any help would be amazing.

I have added the collaburators by mistake and I got charged from Airtable about $1,200 so Can I get a refund? please help me… :disappointed_relieved:

If you pay for a Team Plan for your Workspace and another person adds you as a Collaborator to a Base they own (and they also pay for a Team Plan), are they charged for you as a Billable Collaborator too?

I am trying to format decimals in a formula to no avail: To the left is the number the 3rd column is what happens when this number is used in a formula (the end is cut off for numbers ending in 0) (e.g. 12.50 > £12.5 middle column is where I have formatted the number with this formula: so this was a solution found on another thread: IF({Refill / lowest price}, “£” & {Refill / lowest price} & IF(FIND(".", {Refill / lowest price} & “”) = LEN({Refill / lowest price} & “”) - 1, “0”)) However, if you now look at the middle column it works for the £12.50, but for any round numbers under 10 it misses the decimal place. (i.e. 5.00 > £50. Any help with tweaking this formula would be greatly appreciated! THANKS! :grinning_face_with_big_eyes:

Hey All, I built an Airtable base for a consulting client and their flow relies heavily on being able to print information from Airtable. I set them up with 6 separate Page Designer extensions for them to do so. They're having a consistent problem when trying to print a custom size paper.- it jams in the printer every single time. They've tried it on multiple printers and had their printer tech review as well. They're not having any issues printing when the page is a typical 8x11in size. The size dimensions for the custom page is 545x545 px and I've set the printing size also to 545x545px. When they try to print this page as an 8x11 it does print and there's no issue except that the content is only at the top of the page and they already have custom size printer paper they want to print on (not print and cut each page). Can anyone see why this may be happening? I've run out of all printing thoughts and they're a remote team, so I can't review the printer in person.&

Hey all 👋The subject may be confusing.Basically, I have a column {Day}, {Day} is a single select field.The options in {Day} includes the following strings:mondaytuesdaywednesdaythursdayfridaysaturdaysundayI want a formula field that returns the date, based on {Day}.For example, this post is written on 13 Dec 2023, Wednesday.If {Day} is "monday" then the cell should return 11 Dec 2023. (last monday)If {Day} is "wednesday" then the cell should return 13 Dec 2023 (today)If {Day} is "thursday" then cell should return 7 Dec 2023 (last thursday)how should I write this formula?

Hi,I've been trying to learn and build a script with the help of ChatGPT. The script creates a report in Clockify and all works fine until I replace the value input variable from a fixed value to a feiled in the base from a previous step. The value is just a string but is actually a lookup from another table. I've tried to use a formula in another field and use that but both result in the error seen in the screen shot.I feel like I'm so close, any advise ?  

I’m really enjoying the new collaborator views on interfaces. But I wish buttons could pass the collaborator information of who pressed them, especially for automations and scripts.It solves the problem of multiple collaborators checking the same checkbox, getting the collaborator information from a last modified by field, and waiting for an automation to uncheck the same checkbox so someone else can do it. I don’t know if it’s a tall ask, but it’d really help me refine user-specific controls and automations. thanks!

I need to be able to write a formula that checks if the last modified date is after a specific date and time. Basically, I imported a large batch of data and I want to track whenever a change is made after the specific date and time of import. I'm having trouble referencing the specific date and time of import within my IF(IS_AFTER) formula. Here is what I have so far - but I know AT isn't reading the date and time I referenced. IF(IS_AFTER({Updated Post Initial Import}), '2023-07-14 120000', "Updated Post Initial Import")