Jump to content
  • 0

Bulk Edit Hidden Checkbox update to No or False


DesiLogi

Question

Does anyone know how to configure Bulk Edit to update a hidden check box to No or False? You can update a hidden checkbox to Yes but if you set the Default value to 'blank' it won't update the value to No/False- it just leaves it as is. 

I need to do this with a hidden checkbox so the user doesn't have to 'select' the checkbox field box in order to update to No/False. Any help would be great- thanks!

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi,

I think this is a default behavior of Caspio. Because once the field is Hidden, there will be no actions to that field.  But, once you set it to on load, receive: 'Yes' even it is hidden, the "No" default values that was already set in your table will be changed to "Yes".

A possible workaround would be using Triggered Actions. For example, if the  value in your table is "No" and once you update it, it will be automatically changed to "Yes" and same as the other way around, if the  value in your table is "Yes" and once you update it, it will also be automatically changed to "No"

You may check the sample Trigger Below:

image.png.af2c90374e983db1a3d1e2a3e8ea8218.png

 

Just change the fields that were being used to that Triggered action depends on your fields in your table.

Link to comment
Share on other sites

  • 0

Thanks for the tip re triggers. The issue for me is the table involved has been locked by Caspio because they created backend triggers a few years ago. So I'm not able to use triggers built in the new feature, hence having to use datapages to do things like this.

I've ended up changing the field to text and using "Yes" or "No" as text to do the update, that way it's not a null value that's put in but "No" written out. 

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