Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what...
Hello everyone! I have this formula: IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Dato for udløb}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Dato for udløb}, "YYYY-MM-10"),"YYYY-MM-DD"))=3, DATEADD(DATETIME_PARSE...
I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.
I am trying to create a button to make calls and mail using URL "mailto:xyz@abc.com" but I am not able to use that. Can you suggest me something? The email address and phone number are stored in different columns.
Looking for some help. I have a table were I utilize "last modified time" to be inputed based on the Specific field ("Checkbox").This sequence works well for what I am doing, which is; creating time logs for when we "Start" and "Stop" work on a speci...
Hello,I'm completely new to Air Table and very unfamiliar with the available formulas.I want to have rows display dates for the whole of 2023. Yes, a long list of every day of the year. I'm including a picture as an example.I'm sure I can achieve thi...
I'm currently working on a project in AirTable where I need to include .PNG images in a mapping application. However, I realized that .CSV files can't store .PNGs, so I decided to pull the URLs of the .PNGs in my base and create a new field to store ...
I am using a Formula field as my Primary Field for a schedule table (each record is a time slot).Among my formula for naming each time slot, I would like to add a number (ie. 001, 002) which is generated based on the Date field.ie. Record X: March 5,...
Hi there! I've been trying to replace "," by "&" in a lookup field using Substitute and IF statements but I still receive an error or the result is not giving me what I want. So the result I want is IF First name contains "," then replace by &..
I am trying to create formulas that skips weekends, showing 5 days after a date field called Sendt (and then two other formula fields for 14 days later and 30 days later)I tried using the workday function, however it is displaying a Sunday, as you ca...
Hello everyone,We have a team of 10 persons that have a non-linear schedule (i.e., We are working between 1 and 5 days a week and those days varies from one week to the other).We have defined a set a todos (4tasks) for each day. Every week (Sunday) w...
I am trying to create a payment due date based on adding days (either 15 or 30) depending on what kind of vendor type is selected. Both 'if' parts of the formula work if I place them in separate formula fields but I would like this to all come throug...
Why is array unique formula considering a single data twice? I have typed multiple topics and when I use the formula I can see topics repeated. Is there anyways to avoid repetitions?
Hi Airtable Wizards, I have the following formula which is formatted in currency and occasionally returns a -$0.00 result, where to my untrained eye, I cannot see why. {PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}"PM: TOTAL BANK ALL EFTPOS" a...
Hi, I have many rows with multiple attachments. Some attachment urls are having https://v5.airtableusercontent.com/v1/ format. Some of them have https://dl.airtable format.How do i tweak the script if possible to get https://dl.airtable format? I nee...
Hi all,For about a month, I have noted that when I create a new table and the Primary field , which I have as a formula set to pull it from from the "Name" field, doesn't automatically self populate. So if i create 1-2-3-4-5 new tables, with individu...
Hello! I'm creating an Airtable form, and I want to enable a default text to fill in a field if the field is left empty by whoever is filling the form. Example if name is not filled in, then it will default to anonymous instead of being blank. How do...
Hello All,I am trying to figure out how to perform a calculation if possible.I have jobs that are sorted by date. Currently, data is grouped by date. I want to take the flat rate for example $500 and divide that by the number of jobs. So that I can h...
If you look at my attached images below, I'm struggling with the CONCATENATE function. I want to add the COMPANY as a prefix to each of the multiple items listed in the PRODUCTS column, but concatenate only adds it as prefix to the first item.I am d...
How can i create a field that reads, for example, "Friday March 17, 2023" ?
| User | Count |
|---|---|
| 770 | |
| 721 | |
| 578 | |
| 461 | |
| 269 |
