Skip to content

I suggest you ...

← Caspio Bridge

Filter a View by comparing two fields like a calculation.

For example. I would like to be able to create a view by comparing two separate fields.

  1. Field1 Equal to Field2...
  2. Field1, Greater Than or Equal to Field2..
  3. [Sale_Price] - [Cost] < "500"
  4. [LastImportDate] = Max of [LastImportDate]

Examples, COST vs SALE PRICE. Create a filter that allows me to show

9 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Mike commented  ·   ·  Report

    I couldn't agree more with FJackson. Give us the same triggered actions functionality when building views. Let's take this to the next level folks!

  • FJackson commented  ·   ·  Report

    This would be immensely useful for me. It is very frustrating having to generate overly-complex filters to achieve the same results as saying Where [Field1]!=[Field2].

    Now that we have Triggered Actions, replacing the logic generation on Views with the far more powerful version that Triggered Actions has would be ideal, and hopefully require less effort to implement than a new solution.

Caspio Bridge: Tables and Views

Categories

Feedback and Knowledge Base

(thinking…)