Skip to content

Uriah

← Caspio Bridge Ideabox

My feedback

2 results found

  1. bulk insert

    24 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…)
    1 comment  ·  Caspio Bridge » DataPages  ·  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
    Uriah supported this idea  · 

  2. Ability to have calculated fields on a view.

    139 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…)
    17 comments  ·  Caspio Bridge » Tables and Views  ·  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
    An error occurred while saving the comment
    Uriah commented  · 

    I have a question about calculated fields. In one of our reports, when the search is done and the results are displayed... On the results page we want to run a specific calculation, but we are not sure how to do it.

    ID Name Address Match
    1 Susy ....... 3
    2 John ........ 11
    3 Joe ........ 1

    This is similar to how our information is returned on the results page of our report. However, we would like to run a calculated field that would take the value of the "Match" field, search for the same value in the table under ID and return the name in the place of the number. Such that the results would look like this:

    ID Name Address Match
    1 Susy ....... Joe
    2 John ........ Sally
    3 Joe ........ Susy

    I tried using the following code in Caspio but it failed.

    SELECT ([Full_Name]) FROM [Contacts] WHERE [@field:Contact_ID]=[@field:Match]

Feedback and Knowledge Base

(thinking…)