Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 1 - Visitor
  • 20 Views
  • 1 replies
  • 0 kudos

Utilize Date conditions after creating date token in formula

I have used a formula to create a new date value based on another date cell: The Next Due Date uses the following formula: SWITCH(Frequency,'Weekly', DATETIME_FORMAT(DATEADD({Task Due}, 1, 'week'), 'DD/MM/YYYY'),'Monthly', DATETIME_FORMAT(DATEADD({Ta...

Screen Shot 2023-02-01 at 12.05.39 PM.png Screen Shot 2023-02-01 at 12.05.56 PM.png

Calculating Funding Year

Hi everyone, I am trying to create a formula that will output what funding year a record falls within. I have a field with the dateStart of the funding and another with the dateEnd of the funding. I also have a program start date which is a static fi...

NeptuneDev_0-1675182138206.png

Enter new deadline in recurring task?

Hi all,I recently switched my team over to Airtable for project management. There were a few things holding me back, including that we'd have to build the automation for recurring tasks manually. Now that I have that built, I'm curious if I can get a...

OpsDir_Cassie_0-1674582794730.png OpsDir_Cassie_1-1674582869695.png

How to summarize revenue based on shift hours?

Hi everyone,I suppose someone else must have dealt with this before so here my question, hope someone can point me in the right direction!We run a few bars in our property and we connected our POS to Airtable, so every day I get all sales data import...

How to show most recent entry in group of numbers

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...

Rich_Nuzzi_0-1674682858384.png
Rich_Nuzzi by 5 - Automation Enthusiast
  • 56 Views
  • 3 replies
  • 1 kudos

Problem with this formula

Hi there, I have a single select field name "Département" and I want to concatene the 2 first letters (later for automation).I have a problem with this formula :IF(  OR(    {Département} = "75",     {Département} = "78",     {Département} = "77",    ...

Date & Time formula incorrect

Hello!I have created an estimates / intakes base for a client. One of the goals of creating this was to have an automation that sent a confirmation email to the customer once their estimate was scheduled. When I tried to insert the Estimate Date/Time...

OpsDir_Cassie_0-1674581845622.png OpsDir_Cassie_1-1674581874105.png

Resolved! "Can you attend?" form

Evening! I am trying to create a table with multiple purposes: 1. Share and store meeting notes2. View date for next meeting 3. See who attends each meeting - this is the one I need help with. _______ So I have created this table:Each Record has its ...

Skærmbillede 2023-01-08 kl. 19.55.19.png
plyske by 6 - Interface Innovator
Solved
  • 101 Views
  • 1 replies
  • 0 kudos

Resolved! Automatically update date on a new Record

Helle everyone! I am trying to make a table where I'll have an overview of different kind of meetings. Let's take meeting A as an example. This meeting happens every 14 days. When the meeting has happened (the date is yesterday) I would like a new Re...

plyske by 6 - Interface Innovator
Solved
  • 85 Views
  • 1 replies
  • 1 kudos

Recurring Records, how to have field data saved for the "new" Record?

Hello! I have a table with Recurring Records, representing daily or weekly tasks. Some of these tasks have sub tasks to them. When I complete a task (Record) it is sent to a 'Done' view and then Recreated automatically in the Todo view. However only ...

plyske by 6 - Interface Innovator
  • 166 Views
  • 5 replies
  • 0 kudos

Help improving table

Hello everyone! I've made this Table: The idea with the table is to show different kind of tasks, sorted by Week and Day. Right now when a task is completed, I will click on the 'Næste gang?' field and choose whether the task should be listed in the ...

Skærmbillede 2022-12-13 kl. 15.37.10.png Skærmbillede 2022-12-13 kl. 15.39.33.png
plyske by 6 - Interface Innovator
  • 652 Views
  • 13 replies
  • 2 kudos