Jump to content
  • 0

Issue with virtual fields in formulas



I spend about 30% of my time testing variants to get formulas to work. I wish Caspio would issue a documentation of rules for virtual fields in formulas. Does anyone else struggle with formula syntax related to virtual fields? For example, what is wrong with this formula? It does not deliver anything.

WHEN '[@cbParamVirtual73]' != ' ' THEN SELECT Org from tbl_360Obj WHERE Objective_PK='[@cbParamVirtual73]'
WHEN '[@cbParamVirtual82]' = 'Define my own' THEN '[@cbParamVirtual80]'

Virtual 73, 82, and 80 are handling text. V73 is a drop down selection outputting a random ID and so is V80.  82 is a radio button selection. Instead of != ' ' I have tried IS NOT NULL many times.

Any hints or written set of rules for virtual fields?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
1 minute ago, IamNatoyThatLovesYou said:

Hello @KG360, Is the formula just not show anything or are you receiving error messages? Can you provide me with an exported copy of the DataPage and the expected result?

Hi and thank you. Actually I think I just solved it by putting the SELECT statements in parentheses. I believe Caspio should do a better job at providing a rule book, for example: 'Always put SELECT statement sin parenthesis when they are part of a formula'. I will validate that this works now...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...