AA01: Advanced Use of Formulas

AA01: Advanced Use of Formulas

Automating your workflow with formulas is a very effective way to add efficiency to your processes.

About this course

 

Advanced Use of Formulas

Explore complex use cases and how formulas create efficiencies and an enhanced user experience. This course uses a series of hands on build challenges and exercises to boost your formula skills and ability to troubleshoot problems.

This course is recommended as a pre-requisite to all advanced training courses. 

Advanced Use of Formulas is presented by Eric Mohlman.  Eric is the resident expert on the use of formulas to enhance and automate Quick Base applications.

Eric Mohlman

Eric Mohlman

Solutions Engineer, Customer Success

 

 

Curriculum111 min

  • Course Introduction
  • Introduction to Advanced Use of Formulas 1 min
  • Formula Resources 6 min
  • Review: Intermediate Formula Training 2 min
  • Advanced Formula Use Cases
  • Use Cases Overview 2 min
  • Use Case: Concatenating Text Fields 2 min
  • Use Case: Form Rules vs Formula 5 min
  • Use Case: Calculating a Date 5 min
  • Use Case: Extracting Append Field Information 8 min
  • Use Case: Duration Calculation 4 min
  • Use Case: Icons and HTML 9 min
  • Use Case: File Attachment as a Lookup 8 min
  • Use Case: Formula Simplification 12 min
  • Use Case: API Button to Complete a Project 8 min
  • Use Case: API Button to Create a Series of Records 9 min
  • Troubleshooting Challenges
  • Troubleshooting Challenges Overview 1 min
  • Troubleshooting Challenge 1: Display Due Date 1 min
  • Troubleshooting Challenge 2: Change a Sales Rep’s Displayed Name 1 min
  • Troubleshooting Challenge 3: Show Date One Year After Sales Call 1 min
  • Troubleshooting Challenge 4: Row Colorization 1 min
  • Building Challenges
  • Build Challenges Overview 1 min
  • Build Challenge 1: Create Mailing Labels 1 min
  • Build Challenge 2: Add a Written Date to a Project Letter 2 min
  • Build Challenge 3: Convert Numeric Time to Hours/Minutes 1 min
  • Build Challenge 4: Display a Picture as a Thumbnail 1 min
  • Build Challenge 5: Display the Most Recent Entry in a Field 1 min
  • Course Summary
  • Summary: Advanced Use of Formulas 1 min
  • Assessment: Advanced Use of Formulas
  • Assessment: Advanced Use of Formulas 10 min
  • What Do You Think?
  • Please Rate This Course - AA01: Advanced Use of Formulas

About this course

 

Advanced Use of Formulas

Explore complex use cases and how formulas create efficiencies and an enhanced user experience. This course uses a series of hands on build challenges and exercises to boost your formula skills and ability to troubleshoot problems.

This course is recommended as a pre-requisite to all advanced training courses. 

Advanced Use of Formulas is presented by Eric Mohlman.  Eric is the resident expert on the use of formulas to enhance and automate Quick Base applications.

Eric Mohlman

Eric Mohlman

Solutions Engineer, Customer Success

 

 

Curriculum111 min

  • Course Introduction
  • Introduction to Advanced Use of Formulas 1 min
  • Formula Resources 6 min
  • Review: Intermediate Formula Training 2 min
  • Advanced Formula Use Cases
  • Use Cases Overview 2 min
  • Use Case: Concatenating Text Fields 2 min
  • Use Case: Form Rules vs Formula 5 min
  • Use Case: Calculating a Date 5 min
  • Use Case: Extracting Append Field Information 8 min
  • Use Case: Duration Calculation 4 min
  • Use Case: Icons and HTML 9 min
  • Use Case: File Attachment as a Lookup 8 min
  • Use Case: Formula Simplification 12 min
  • Use Case: API Button to Complete a Project 8 min
  • Use Case: API Button to Create a Series of Records 9 min
  • Troubleshooting Challenges
  • Troubleshooting Challenges Overview 1 min
  • Troubleshooting Challenge 1: Display Due Date 1 min
  • Troubleshooting Challenge 2: Change a Sales Rep’s Displayed Name 1 min
  • Troubleshooting Challenge 3: Show Date One Year After Sales Call 1 min
  • Troubleshooting Challenge 4: Row Colorization 1 min
  • Building Challenges
  • Build Challenges Overview 1 min
  • Build Challenge 1: Create Mailing Labels 1 min
  • Build Challenge 2: Add a Written Date to a Project Letter 2 min
  • Build Challenge 3: Convert Numeric Time to Hours/Minutes 1 min
  • Build Challenge 4: Display a Picture as a Thumbnail 1 min
  • Build Challenge 5: Display the Most Recent Entry in a Field 1 min
  • Course Summary
  • Summary: Advanced Use of Formulas 1 min
  • Assessment: Advanced Use of Formulas
  • Assessment: Advanced Use of Formulas 10 min
  • What Do You Think?
  • Please Rate This Course - AA01: Advanced Use of Formulas