Jump to content
  • 0

Calculated cost field in form



Have a field that will be a value of 1,2,3,or 4.

based on what the user picks.. the value of the cost field should be 

1 - $75

2 - $125

3- $175

4 - $225

i tried it but it needed a currency value.  Any help you can give would be great.  Thanksm!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi Oakley

I'm guessing at the scenario and use case here so apologies if I'm way off.

If you're trying to use this in a calculated field does this work?

WHEN [@cbParamVirtual1]=1 THEN 75
WHEN [@cbParamVirtual1]=2 THEN 125
WHEN [@cbParamVirtual1]=3 THEN 175
WHEN [@cbParamVirtual1]=4 THEN 225

(replace [@cbParamVirtual1] with your table field)

And then select in the calculated field to format to currency.

If you're trying to get the value on a dropdown field, does the attached option work by setting the value different to the display in the dropdown options?


Link to comment
Share on other sites

  • 0

Hi! Just to add, if you want to just format the value as currency for display purposes only, you may refer to this link - https://howto.caspio.com/datapages/datapage-components/field-formatting-options/ But if you want the value to be saved in a currency format, I highly suggest setting the datatype of your field to currency. You may check this link - https://howto.caspio.com/tables-and-views/data-types/data-types/#:~:text=Currency-,Currency,-Used for money

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