Jump to content
  • 0

Rules to Calculate


Glitch

Question

Hello everyone!

I'm trying to create a HIDE AND SHOW function.

I know this can be doable using Conditional Forms.

However, according to my workflow, I'm going to need pretty much more than that.

 

So I have this Condition like

if (field1+field2) = "50"
then hide field3.

Can we do this on a Calculated Value. Like:

CASE
WHEN (field1+field2) = "50"
THEN hide field3.
END

 

However, I don't know what is the exact code to hide that field. Can we use CSS or Javascript. Like visibility:hidden or .hide()? 

 

It is related to this post 

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi Vanellope!

I think this would still be doable within the use of Conditional Forms.

You can create a Virtual Calculated Field for the formula, and then use it later on to the Rules.

1st step: Virtual field - Calculated Value.

(field1+field2)

2nd Step: Use the Virtual field to compare Values

RULE: VirtualField = 50
ACTION: Hide field3.

Not quite sure as well if you can use CSS or Javascript inside the CASE WHEN Statement as, I have not tried it yet.

Although, this would be a good workaround.

If you want to hide the Virtual Fields, you can do so, just visit this link.

Regards,

Scarlet  

Link to comment
Share on other sites

  • 0

Hi @Vanellope,

I agree with with the previous comment, I've created a demo DataPage with the same workflow. I've created two virtual fields to receive user inputs and one calculated field to compute its sum.
If the sum is equal to 50, the field'Field to be hidden if sum is equal 50' will be hidden.

This is the deployed URL of my sample DataPage
 

I've also attached an exported copy of this DataPage is you want to see how it works.

I hope this helps

Regards,

TsiBiRu

CaspioData_2019-Feb-21_2239.zip

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.

Guest
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.

Loading...
×
×
  • Create New...