Search the Community
Showing results for tags 'checkbox'.
-
Hello, I am trying to make a fairly simple database app. It actually started as a simple Google sheet. There is just one trick to it - there is one field for which I need to allow multiple values, but I want each of those values to be validated from a pre-approved list of values. It seems this is not possible in a Google sheet, so I figured I would try Caspio to do it. I'm happy to have the list of values be it's own table and even to have the selection of those values be on a separate form from the creation/editing of the primary record. But I can't really figure out how to do this. Does anyone know of a tutorial that explains this? Thanks
-
The checkbox for my yes/no field is showing blue background color in MacBook. How do I change this color? Cannot see how to change it in Styles.
-
I have a submission form with a couple of checkboxes. Ideally, it would be mandatory for one of the two checkboxes to be selected. However, my primary concern is that both checkboxes cannot be selected so I want to toggle off one when the other is checked. I have been playing around with other javascript code I have found on the Caspio forum but have not had any success getting it modified and working. Following is my attempted code on two checkboxes, one named "pure" and the other "mix". Any help for a javascript newcomer would be appreciated... <script type="text/javascript"> /* Get value of the Yes/No fields */ var cb_pure = '[@field:pure]'; var cb_mix = '[@field:mix]'; if (cb_pure == 'Yes') { /* make sure cb_mix is deselected */ document.getElementById("InsertRecordmix").checked=false; } if (cb_mix == 'Yes') { /* make sure cb_pure is deselected */ document.getElementById("InsertRecordpure").checked=false; } </script>
-
I have a checkbox field "AppLocked" that when checked I would like the submit/update button to be disabled (or hidden) and for their to be an alert that says "Your application is locked from edits. To submit any changes please contact your federation manager." Is there a simple code I can use for this purpose? -
When using checkboxes, one can assign the value when checked. When the checkbox is not checked, the value should be "0". But in the database the value is " ". I need a "0" to perform calculations. How to solve this ? Thanks
-
I would like to ask for help in my JS code. I'm trying to change the value of a checkbox in a search form when a specific option in a dropdown is selected. I want the checkbox to be set to true if "Math" is selected in the dropdown. Below is my code that's not currently working: <script> function checkdropdown(){ var drpselected = document.getElementsByName("Value1_1").value; if (drpselected == "Math") { document.getElementsByName("Value2_1").checked = true; } else { document.getElementsByName("Value2_1").checked = false; } } document.getElementsByName("Value1_1").onchange = function() {checkdropdown()}; </script> Also, here is a screenshot in the "Configure Search Fields" step of the DataPage: I'm hoping someone can help me with this. Thank you.
-
Is there a way to modify the color and font size of Display Text of a Checkbox in a Submission Form?
-
I have a search and report for current projects. Some of these projects are on hold and so I want to create a field in the search to display all projects when checked but when not checked just show projects that are not on hold (field should say "Include jobs on hold?" and be unchecked by default). I'm at a loss for how to do this. In my table, the value for "On Hold" is just a checkbox, where checked is true and unchecked is false. I'm open to any ideas for how to do this, even if it requires shuffling things around. Thanks!
-
Hi Caspio Community! I am new member here, please help. In my submission form, I want to align checkboxes on the left. Means that label will be displayed on the right. Right now I can see options for Label position: Top or Left or No label? But no Label position: Right. Do I need to change it in Styles somewhere or is there a simple CSS for this? What is the trick? Thanks
-
I know that there are jquery tools used to completely customize standard form elements such as checkboxes, radio buttons, and dropdown menus. Are there any scripts and ways of styling them in Caspio? If so, what's the easiest way to go about doing it?
-
It is possible to set checkmark condition using Calculated Value. The field should be set as Calculated Value The basic formula to set the condition is: CASE WHEN [@field:IntegerValue]=100 THEN 'X' ELSE 'Y' END For Yes/No field, the boolean value us 1/0. However, to make it work properly, the field should receive BIT value. So, CAST function should be applied: CASE WHEN [@field:IntegerValue]=100 THEN CAST(1 as bit) ELSE CAST(0 as bit) END
-
In my search form in Reports DataPage, I want to select all the items in a multi-select listbox when my checkbox is checked. Also, when it is unchecked, all the items should be deselected. Any ideas? -
Hi I've tried using this on my footer but it does not work. My datapage is a results page with inline edit set to yes. Below is my script: <SCRIPT LANGUAGE="JavaScript"> function setTime(){ var v_chk=document.getElementById('EditRecordConfirmed').checked; if(v_chk==true) { document.getElementById("EditRecordDateConfirmed").value="[@cbTimestamp]"; } } document.getElementById("caspioform").onsubmit=setTime; </SCRIPT> Thanks. Ivy
-
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!
-
Hello friends, I have a report data page which is basically a to do list. At the moment I use inline edit to tick the checkbox but it requires 3 clicks for each record. To speed things up I'd like a button as hyperlink which will set the appropriate Yes / No field of the record. Can this be done? I already know how to insert HTML blocks and links, but not what goes in the source code. Thanks and kind regards. Tobias
-
I want to created a multi record audit function, ie the client clicks on a check box to approve a record in a list. There could be many hundreds of lines in the list. The approval is for a parent table from the criterior specified in the child table. I created a view for this and make the parent table the editable table in the view and I have a field for the checkbox in the view. However if I have multiple records in the child then in grid edit in a tab report I would need to click on all rows of the child table. I want to only click on one check box from the parent table. Is there another way around this? Create a tab report for the parent and then an iframe with the report of the child records?
-
Ok so I have a search function that runs as a multi-select. The search options look like this: Project Status: Awarded In Planning In Design Under Construction Project Completed Project Canceled There's a lot more than that but that's the general idea. What I want is to have a checkbox that says "Search Completed/Canceled projects?" and only when that checkbox is marked yes should Completed & Canceled projects be included in the search. If they run the search without that box checked I want all Completed & Canceled project to be omitted from the Search Results. What is the best way to go about this? Virtual Fields? Triggers? Thanks in advance for your help!
-
How can I have a checkbox automatically selected (checked) based on a logged in user's group? For example, after a user logs in, I want a checkbox checked automatically if he/she belongs to a particular group.
-
I have a tabular report that uses a search form. "Field 1" consists of 10 multiple criteria that are all checkboxes. Following that is another single checkbox field, and three text fields. So let's call that 5 fields total (Field 1 includes all 10 multiple criteria checkboxes). What I want to do is this: When Field 2, 3, 4, or 5 is not blank (or is checked), uncheck all the criteria checkboxes in Field 1. Or just "ignore" Field 1. (I found a couple previous posts describing checkbox unchecking, but not with multiple criteria, and they're different situations). Any help would be greatly appreciated! Thanks. -
I am new to using Caspio but am trying to figure out how to make the emails more conditional. It doesn't seem that there are options for different emails to be sent, based on criteria, per data page. We have a web form, and then we have a tracker for our team. The team can check off boxes as items on the setup checklist are completed. Ideally, I want a certain email to go to certain people when a certain checkbox is sent, and for that email to only go out when that checkbox is first checked. Not again just when other changes are made. I know how to do the one checkbox and autosubmit thing, where an email is only sent if a checkbox is selected, but then if I make other updates it will resend that email, and that doesn't work. And it doesn't seem to be able to do multiples in a row like: Submit Goes to Datapage, sends email if match Goes to next Datapage, sends email if match etc. It just goes to one and then that ends the chain So 1- any ideas? Other than creating separate data pages for the team to just update those checkboxes? Also- is there a way to disable checking a checkbox once it's been checked? This doesn't seem to be a rule option. Thank you! -
Hi @abelphathost, Thanks for the message, but let's not ask questions privately.... the point of a forum is for people to find that somebody else has already asked the same question. A couple things to note 1 - I've had trouble using JS and Caspio's checkboxes. Dropdowns are easier to work with. 2 - I never use 'onsubmit'. Rather i create a fake submit button that runs that code I need before the submit happens then wrap the function with: document.getElementById("Submit").click() ** If you must have something easier than a dropdown... This takes some work, but will allow you to do it. HTML block <style> #YOUR_FIELD_ID {display: none} .fake-radio { width: 120px; height: 50px; padding: 16px; margin: 16px 0 0 32px; font-size: 18px; float: left; } </style> <div class="fake-radio" onclick="document.getElementsByName('YOUR_FIELD_ID')[0].value = 'Yes';>Yes</div> <div class="fake-radio" onclick="document.getElementsByName('InsertRecordFieldName')[0].value = 'No';>No</div> YOUR_FIELD_ID 1. right click the field you want to populate > inspect 2. Look for <xx class="sample" id="XYZ_98sd7d" name="InsertRecordYOURFIELDNAME">Hi World</xx> 3. your answer is InsertRecordYOURFIELDNAME Try these suggestions and I'm sure you'll find your solution
-
checkbox Checkbox (and Radio Buttons) - Box Not Displaying
gregbovenkerk posted a question in Styles and Localizations
I have a virtual checkbox setup on a data page, but the actual checkbox is not displaying. The text is there, and it's functioning (set to checked by default), but I can't get the box to appear. Please help! I've also tested it with radio buttons, and those don't show up either. -
I am having trouble with this simple if statement. I would like to update a checkbox field if a separate field is "Final Staff Review". The script I have is: <script> function = applocked(){ if (document.getElementById("EditRecordReviews_ReviewStage").value == "Final Staff Review") { document.getElementById('EditRecordApplication_Detail_AppLocked').checked = true;} else { document.getElementById('EditRecordApplication_Detail_AppLocked').checked= false; } } document.getElementById("caspioform").onload = applocked; </script> Am I missing something? The field is a Yes/No field and it is on the datapage as a checkbox field. I also have several formulas deployed on this page, could that be impacting this? This is currently not working.
-
Hello, In a result list of Action Items (todo) I want the user to just check a box and the items on the line of the checkbox changes its status to "In Approval". I used this code in an HTML block (repeated every line), but doesn't seem to work. <input id="doneCheck" type="checkbox" onclick="done();"> <script> function done() { if (document.getElementById('doneCheck').checked) { document.getElementById("InsertRecordStatus").value="In Approval"; } } </script> Any advise? Thanks Sergio -
Is there a way to have a check box in a search form that is unchecked by default? I'm able to use the radio button option but I'd prefer to use a check box.
