Working on costuming for a film - have 4 main tables of Actors, Costumes, Scenes, and Characters.There's a lot of table to table referencing going on w/ lookups...But one thing I would LOVE to be able to do:When looking at the COSTUMES table (charact...
Hi!Is there any easy way to add a unit to the number field?I have a lot of tables with dimensions. Some of them are metric, some imperial.I want to show them as:0,234 => 0,234 mmor0,234 => 0,234"Of course without changing numbers to texts - because I...
I have a field with a formula that calculates total days using this formula: IF({Status }="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'), "N/A")The formula works, but returns results of 1, 2, 3 etc., which when i try to use this colum...
I have a form that a member uses to search for their name using a lookup from another base. Because of PII Standards, I can't have their full name listed for others to also see. This basically works as a task tracker so (external) users have to enter...
I am trying to create a field that tells me is a date field, called Purchase Date, is before a specific date, 04/09/2023 (did/mm/yyyy, same format as the date field). This is my formula so far, but it returns a “0” (ie false) on all records so many w...
Hi, I'm feeling a little stupid in this moment, because I know that I'm doing a little mistake but I can't find it!I need to print the actual hour, so if now it is 10:31 am, I need that the result is 10. I'm trying to use DATETIME_FORMAT and SET_TIME...
Good day to allI am looking for some help for my problem after spending all morning on it. My table is an 'audit table' for blood tests. I have a colum that is a linked field to another table that allows me to select the blood test requested (Samples...
I'm working with a long-text column in Airtable and need to insert line breaks into my text to help improve readability. Could anyone guide me on how to add a break (\n) in my text within a long-text field in Airtable? Any help or guidance would be m...
Concept: I have 3 columns i have a multi-select field of Job Types as followsAerial Display - Water / BargeAerial Display - LandClose ProximityI have a total invoice column in $ (approved spend)I have a formula column with the current formula "IF(...
I want to be able to extract capital letters from a string (name of a type of event) to create its ID CODE.This way I can keep my ID CODE as a formula, not manually, and still control how it comes out through the capitalizing of letters in the name.F...
List A: the, cat on, was not, sat onList B: cat on, sat onoutput: the, was notEDIT: List A & B are linked fields. Linked to the same original field.I want to implement this functionality. It is achievable using a SUBSTITUTE on list B to add the relev...
Hello guys, I'm in urge for help realizing this and I can't find anyone that has done something similar. I have a table called Wod_list where workout challenges are stored. In this table each workout has an ID and 2 result_type single select (there a...
Hello community,My script do not work if the field is blanc there is a line break. however, i need the linebreak when there is a record.How can I do ? Thanks in advance {MARQUES} & IF({DESIGNER}, " X " & {DESIGNER}) & IF({DATATION}, " - " & {DATATION...
As I've searched the Community, big shout out to folks who have shared formulas which convert dates to quarters and fiscal years. I'm currently using the formula below, and I'm trying to find a way to blank out cells which have no date. Any suggestio...
I am using a formula field and selected decimal format, but it doesn't return with a thousand comma separator. Does anyone have a workaround?
I have a field with the number of days, and the total fee. I wanted to create a formula field where I could add this logic below. Is this possible to compute? One month or less (≤ 30 days)10% of the Fee2-3 Months (31-90 days)20% of the Fee4-6 Months ...
I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time...
Hi, does anyone have any ideas on how to write a formula to mark a previous date for each person?
Hi, I have multiple Image attachments in airtable I want to show only 1st image in the pic#1 column is that possible i try few solution/formula it showing image URL ? any quick solution?
Our Attachments field ("Images") contains sometimes five or six images. Is there a formula I can use to copy just, for example, the first or first & second images only?THANKS!
| User | Count |
|---|---|
| 794 | |
| 786 | |
| 589 | |
| 487 | |
| 277 |
