Solved

I'm creating an automation in Airtable where the info from each stripe payment comes though. The price comes in without decimals, so I thought it would be easy to add a conditional action that is there isn't a '.' in the dynamic object I could just add it within the automation, but ... its seems to be out of my comfort zone.Is there a Script that someone has to do this?  or another workaround?

I need some help using an IF statement within a CONCATENATE formula. I have tried many permutations but have just not found the right syntax. I have the following fields: AirtableID CompanyName Project Sub-Project Person In the Name field of a table, I want to concatenate these fields as such: If Sub-Project is not NULL, then Name = AirtableID_CompanyName_Sub-Project_Person Else (Sub-Project is NULL), then Name = AirtableID_CompanyName_Project_Person Here is as far as I got, and I know the syntax is not right: CONCATENATE({AirtableID},’’,{CompanyName},’’,IF({Sub-Project} = 0,{Project},{Sub-Project}),’_’,{Person}) Thanks!

Sorry if this is obvious, and I've just been unable to find a solution, but... Is there any way to create a PRIORITY field that changes dynamically? Imagine there are ten projects in a base, with a Priority field numbered 1-10. I now need to add an eleventh project, but this one is more urgent and has a priority of 2 on the list. Currently, I then have to manually change the old Priority 2 to a 3, 3 to a 4 and so on. Is there a way to automate this?

I have a "date paid" date field that I've realized I could automate better by transitioning it to a checkmark (paid?) and a last modified date field. But when I do that I lose all the paid dates paid (which impacts other calculations throughout my table). Is there any way to get around this?

Greetings! There is a formula for getting the ID of the current table record:RECORD_ID()Is there a formula or mechanism for deriving the name or ID of the current table? Such as:TABLE_ID()or…TABLE_NAME()Thank you!

Hey friends, family, and everythign in between,So, I have a table embedded into a landing page, and like, overall, I am pretty happy with it! That being said, there is usually a footer in an embedded table that says "view larger table" in the bottom right hand corner of said table. For whatever reason, mine doesn't show up. As a workaround, I have implemented a button that brings you to the airtable website view of it, but would like that little footer back in case people need it, or to at least have an option for such both above and below the table. Any thoughts or insights as to why it might not be showing up? Let me know!

Hello everyone,I am currently discovering Airtable and trying to familiarize myself with all its features! Today, I am trying to update a date field when a select field is changed (example: Sending status -> sent, I want the date field to be updated with the sending date) but I can't find a solution, neither through scripting nor automation.Can you please point me towards a resource or any relevant information so that I can figure out how to do this?Thanks for your help ! 

Hello everyone! I have a formula (below) that calculates a Monthly Rental Fee Renewal Date that is 45 days out from the Staging Date. For one client, I want her date to be calculated at 90 days out.  How can I do that? I know I need an identifier field and I think Client Name is it (file attached). Thanks everyone!IF({Total Monthly Rental Fee w/Tax}>0,DATEADD({Staging Date},46,'days'))

Hello all, I have two tables.MONTHS : https://airtable.com/shrkKQn1rwn5BcjksDAYS: https://airtable.com/shraNAmopa2LDZQxVIs there any way to make automation that each time I change manually the date of a record in DAYS table, it changes the field MONTHS wich is a link to the MONTHS table?i.e.: When the date is 12/01/2023 (European) it must be linked to the "23/01" record in MONTHS table, and if I change manually this date to 12/02/2023, the automation should change the link to the "23/02"  record.Thanks 

Hi Airtable community,Attached photos show problem and desired solution separated by the empty row. One example in Airtable. Second example in Google Sheets. This is a small sample of a much larger dataset (hence the query).If Column-B contains 2> (2 or more) names/items then I want that row to duplicate with separate unique Column-B names/items.Your formula/script/automation and how to implement would be greatly appreciated and helpful.  Thank you,Krys

I am creating a dashboard interface for a donor management base.  There are fundraising campaigns which have receive donations towards a goal.  If the goal is, for instance, $1,000 and I receive $100, that's 10% of my goal and I'd like the dashboard donut chart to move the colored section up to 10%.Is this possible???  Thanks!

This is a messy question i agree... let me rephrase it:I got 2 sheets: Sheet A , Sheet BIn Sheet A there is one field called MONEY(all kinds of money record) and one field called USER (somebody's nickname like P or M or E)What I'd like to archive is in Sheet B's field named NOTE, it can automatically look up in SheetA's MONEY and sum every data if it's field USER is P.Basically it can be done by one link field, one lookup field and a roll up field, but need to update manually if anyone add anything in the data source sheet (SheetA)I guess my question is that is there any way to do that automatically like in excel? Which can be done easily by using the count if() and sum() functions.

I have a Lookup field called 'Call Result' in my Contact table for my Touchpoints table's 'Call Result' column - which is a drop down. I have a view called 'Hit Lister' and I would like to filter records where I have encountered - for example - 8 voicemails in a row. Here is an example of the contents of one such 'Call Result' lookup row record:Call Me Back, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, Voicemail, VoicemailThe challenge I have is when I add the condition:Call Result does not containVoicemail, Voicemail, Voicemail, VoicemailThe record is not filtered as it should be.Please provide ideas or troubleshooting steps on how I can fix my problem. For reference I have supplied a link to a video below of my cahllenge which should clarify any lasting confusion:https://share.getcloudapp.com/z8ulmjwd

Hey,Im currently working on a resource planning tool and im struggeling to make it work like intended.The way it works is, im creating some jobs with a resource linked and a start and end date.What i want is a script to check every new record and if the dateinterval is overlapping several workweeks(Monday-friday) it's splitting the record into several other records with same resource and name but date is a maximum of 5 days inside the same workweek.E.g. record "job1" with start date 15 december 2022 and end date 22 december 2022 with resource George is split into:Record "job2" start= 15 december 2022, end = 16 decemberRecord "job3" start=19 december 2022, end = 22 december"job1" is supposed to be deleted then.If someone could send me in the right direction, i would be grateful!

I have a list of donations made to an organization.  I have created a Dashboard Interface to report monthly donations received.  I would like to add a number widget that sums the number of all donations received in the current month.  I've already worked out how to filter to the current month, but I cannot find any option within the number widget to allow me to SUM.  I can only display the Record Count or a Field Summary.  Yet I have seen the post linked below that has the ability to do what I want:https://community.airtable.com/t5/interface-designer/interface-cannot-use-formula-result-in-number-element/td-p/76935What am I missing???  TIA!

I would like to be able to have a different formula in each record, rather than one formula applied to every record.My table is a task list. The Due Date of each task (record) is relative to the Due Date (date field) of the Final Task. Task A is due 1 day before the Final Task is due, Task B is due 5 days before the Final Task is due, etc. Is there a way to input a formula into each record's field that would calculate from a field in another record within the same table? Like if I put "-1 day" into the field (I don't know what type of field could do this) of Task A, it would display October 30, 2023 if Final Task's Due Date was October 31, 2023.The best I've come up with so far is a short text field where I write "1 day before" "5 days before" etc and then plug in the dates in the date field once I've decided Final Task's Due Date. However, this means if I change Final Task's Due Date, I have to manually change all records' Due Dates.I can't find anything like this anywhere. It's

HiI'm looking to create a new field or to modify an existent one.As of 2022, this formula was okay but in 2023, the value for H sould now be 45.94 instead of 39.27 .Because we don't want it to have an impact on our reports and on our Page Designer, we need to add a condition that if the event took place in 2022, H = 39.27 and if the event took place after december 31th 2022, H= 45.94. Could someone help me? I've been trying different things but it seems that I always forget something. Thanks a lot ! 

Hey guys, so I have figured out how to auto create tasks when I duplicate a project. However when I duplicate a project (because I need to be duplicating theres a lot of other info that needs to carry over) the tasks linked to the original project are linked to the OG project and the new one. The new project tasks are only linked to the new project. Does anyone know how to set an automation to have the tasks from the original project not link to the new/duplicated project? I've tired "Update Record" but I honestly can't get it to work, probably because I'm new to airtable.

I have a base with various different tables containing lists of things, people and places for a large-scale festival production. The various tables are linked in numerous ways, which works beautifully. However, I would also like to use the base for project and timeline management and I cannot seem to find a way of doing this directly. I have created a "timeline" table with a list of events with a date range. At the moment I am syncing all relevant tables I want to link to several tables in a dedicated "sync base", from which I'm syncing back to a new "sync table" in the main base, essentially summarising the various tables into one. In my timeline/events table I then link to this sync table.This works but means I lose the main advantage of linking between records in that the events allocated to each thing/person/place do not show up within that record.Is there a better way of doing this? What am I missing? The ability to sync from multiple tables within the same base would really help

the roll-up value consists of the image filename[image. jpg] and lmagelink[domain. com/image.jpg] now I want to create copy value that has an attachment-type column.@ScottWorld and @kuovonne I'm a fan of you guys! or maybe someone knows the answer. Thanks!

Hello everyone! Right now we have a shared Excel document with an external person. When he has completed a task he will fill a row in the Excel sheet. We want this to be made in Airtable instead. Is that possible? I thought about creating a Form, but would it be possible to only use 1 Form for every new Record that needs to be made? Or is there a better alternative?Thanks in advance!

I changed a text field to a single select field.This field has many options (maybe 100+), but I wanted to ensure that similar entries are same spelling and that when creating filters in views we can select multiple options (using "is any of") instead of making several different filter conditions (using "contains").After making the update, the primary table that holds this field allows for the filter to work properly, as attached. However on the secondary tables that hold the lookup field, I'm not seeing the filter options change. Creating a new view/filter presents as if it were still a text field, with no options for "is any" or "is none of".  

I've run across a script in our base that uses this code:let view = await input.viewAsync("Pick a view", "Projects");Our "Project" Table has 100+ views organized by sections, is there any way to modify the code to limit the input choices to a specific view section? (screenshot: Section=Templates) if not, are there other ways to limit the input options using a view naming convention or similar? Thanks for any input, I've reviewed this documentation, but didn't find any guideance.https://airtable.com/developers/scripting/api/input  

Hello,We are using Airtable to do a content audit. We are using a form to capture the assessment data. The auditors must complete the form for each page of content. We have many pages, so they have to complete the form many times. On the form, we ask them to fill in their email address manually each time they complete the form. It currently is a drop-down field. We have had several requests to have this email field populated automatically with their email address. Does anyone know if this is possible? I have read online about pre-filling fields on a form, but it seems to be possible for specific values only. For example, I can pre-populate the name field with the value "John".What I would like is the following:Auditor 1Email address: johndoe@email.comEmail field on form automatically filled in with his email: johndoe@email.comAuditor 2: Email address: janesmith@email.comEmail field on form automatically filled in with his email: janesmith@email.comAuditor 3:Etc.

I created an automation that, when a new Outlook email is received, creates a new record in Airtable. If there are attachments in the email, how can I automatically import them to an Attachment field in Airtable? Thanks!