Jump to content

Search the Community

Showing results for tags 'dropdown'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 33 results

  1. Hi I am stuck with javascript doing multiple calculations in same datapage. 1st javascript is calculation of unit cost, no of units and total (in local currency) 2nd javascript is convert local unit cost to USD based on cascading dropdown field 3rd javascript is using unit cost (in USD), no of units to derive total cost (in USD) the 1st javascript seems to be working. But when I add on 2nd javascript, only one value shows and in the wrong field. There is also no error appearing in the web console. Eg javascript 1 calculation = virtual field 1 = virtual field 1 value javascript 2 calculation = virtual field 2 = virtual field 2 value Instead what i see is this javascript 1 = virtual field 1 = virtual field 2 value javascript 2 = virtual field 2 = blank I followed basically this script and did my own modification http://forums.caspio.com/index.php?/topic/6053-perform-calculations-in-submission-form/ I think the problem is I did not define 2 variable that points to virtual field 1 and virtual field 2 respectively. var totalField = document.getElementsByClassName('cbFormData')[0]; I need 2 of it, and I do not how to define for the 2nd virtual field. Also, how do I pass the the virtual field to a table field? I used the Pass field value as parameter, it does not seem to write into the table. Can anyone please help? <script type="text/javascript"> // Caspio form elements to calculate local total cost var unitcostField = document.getElementById('InsertRecordLocalUnitCost'); var unitsField = document.getElementById('InsertRecordUnit'); // var totalField = document.getElementById("cbParamVirtual1"); ** I tried using this to point to virtual field but it did not work ** var totalField = document.getElementsByClassName('cbFormData')[0]; // Caspio form elements to convert local to USD cost var exchangerateField = document.getElementsByName("InsertRecordExchangeRate")[0]; //var convertField = document.getElementById("cbParamVirtual2"); ** I tried using this to point to virtual field but it did not work ** var convertField = document.getElementsByClassName('cbFormData')[0]; var caspioForm = document.getElementById('caspioform'); // Event handler var calculateTotal = function (event) { // TODO: Do something on value change --> totalField.innerHTML = unitcostField.value * unitsField.value; } var calculateExchangeRate = function (event) { // TODO: Do something on value change --> convertField.innerHTML = (1/exchangerateField.value) * unitcostField.value; } // Run total calculation on input to any of these two fields unitcostField.addEventListener('input', calculateTotal); unitsField.addEventListener('input', calculateTotal); unitsField.addEventListener('input', calculateExchangeRate); unitcostField.addEventListener('input', calculateExchangeRate); </script> Thanks in Advance
  2. I'm needing to create drop down or radio button section that will allow the user to "rank" their choices. I have 4 locations and want them the to rank their preference to that location by selection 1 - 4. But I only want unique answers to each one. So if they rank one as number 1, then I don't want number 1 to be an option for the remaining 3 choices and so on. I've tried several ways but can't get it to work correctly and wasn't able to find any other posts that described this. Any suggestions on if and how it can be down are greatly appreciated.
  3. I have an issue with the case on the report page, where the field should be active for adding or visible (hidden before). Details: I have a dropdown for answer revision with three status variants: Pending, Approved and Not Approved. The changes are provided via inline edit. If the message status is not approved I should be able to write a comment, but for the other cases window should not appear or should not be editable. It would be nice if somebody can help me with this case. Thanks.
  4. 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.
  5. I have found that if I manually click on a dropdown that is a parent to another cascading dropdown, the cascading dropdown works. But when I try to use javascript to change the value of that parent dropdown, I find that it does not kick off the cascading activity of the cascading dropdown that is connect to it. Strangely, the value changes in the parent dropdown (so it works), but it doesn't impact the cascading dropdown. The js code I am using to change the parent dropdown value is: document.getElementsByName("cbParamVirtual1")[0].value="2012"; which successfully updates the value, so I know the JS works. But it doesn't impact the cascading dropdown. Is there an onchange event that is misfiring? Any suggestions?
  6. How to set dropdown field type to receive parameter, upon DataPage onload
  7. Good Morning, I'm using a bulk edit on a tabular search and report. I've noticed that my Cascading drop-downs in the bulk edit show blank entries when there in no data for the filed being edited in it's own table. I have a view set-up to filter out blank entries in the table being used for value purposes; however unless the field has data in its own table it still shows a blank. I found the following code for standard drop downs but haven't found any information for cascading drop downs used in the bulk edit. Hoping someone can assist with code updates. All my attempts have been unsuccessful. Thanks...Bre <SCRIPT LANGUAGE="JavaScript"> <!-- Function removeBlanksInDropdown searches for blank entries and removes all occurrences. It is advisable to use this script with the "Show distinct display options" checkbox checked in the dropdown configuration in the Caspio Bridge DataPage Wizard --> function removeBlanksInDropdown() { /* dropdown stores the value of the dropdown form element reference in the DataPage. */ var dropdown = document.getElementsByName("Value1_1"); for (var q = dropdown[0].length-1; q >= 0; q--) { if (dropdown[0].options[q].value == "") dropdown[0].remove(q); } } document.addEventListener('DataPageReady', removeBlanksInDropdown); </SCRIPT>
  8. Hi, so I have a datapage that has a dropdown for countries, provinces, and cities. each of these dropdowns are collecting data from individual tables. beside the country dropdown I added a plus icon to give the client the option to add a country if it is not on the list. the plus sign is pointing to another datapage. That all works, my problem is when the client adds another country, and closes the pop up window, it doesn't show in the dropdown. So I am looking for a solution to refresh this particular dropdown without having to refresh the whole datapage and loose all data entered already. Any solutions?
  9. This has been asked before but the answer didnt work. I have a Lookup table being called in a Datapage. I want one of the table choices to be the default. It work fine using Custon Lookup table and not using the table. Previous posts said add this to footer: <script type="text/javascript"> function f_default(){ document.getElementById("FieldName").value = "TheDefualtVaule"; } window.onload = f_default; </script> I have done this, referencing the correct field name and value but it doesn't work. Thoughts? Thanks as always.
  10. Hello, Just got the free trial to play with to see if this will do everything I need. I've been looking around and I cant see how to create a data field that's just a basic drop down selection. I have tried looking for options around List -String but I can only get this to allow multiple options from a list. I want to be able to select one and only one option from a dropdown list of options. Can anyone explain how to do this? Thanks,
  11. I need to create an alert on a submission form where, If the drop down box PACKTYPE is = "Simple" then if text field SIMPLEUNIT not equal to 1 Else if PACKTYPE is = "Complex" then a second text field COMPLEXUNITS must be =<2 or greater than 1, which ever is easier. I would like to include alert messages if possible. I am not sure how to write this. I am sure it is simple but I am not familiar enough and not in submission forms. I've only seen items for reports. Any help is appreciated!
  12. When using dropdown in a form, I would like to be able to search in a dropdown with the criteria "Contains". Now, if I type "C", the cursom jumps to the first Item in the list that starts with the letter "C". Is it possible to narrow down a search in a dropdown when typing and where only items that contains the text I typed are displayed?
  13. Hi there, I have tabbed content on my page. One of which looks like this: <li><a data-toggle="tab" href="#menu4" style="background-color: #10368F; color: white;">5. TEST RESULT</a></li> I'd like to change the background color of this element to grey IF my dropdown (named [@Expected_Outcome]) equals Business Insight. I know I can probably figure this out, but my brain is turning to mush from looking at this and I have a deadline looming!! Can anyone help me write the correct script? Many thanks Nikki
  14. I just watched the video How to Create Multiselect Dropdowns in Caspio. The video introduces several new data types: List - String List - Number List - Data I've created a new table to try these new types out but do not see any of them as data type options. Should I be seeing these new data types now, or is this scheduled to be included in an upcoming release perhaps?
  15. I'd like to display the value of a cascading drop down as text. My submission form allows the user to select a lesson from a list. Once the lesson is selected, I would like to display the lesson description below it. I use a cascading drop down to get the description, but it only shows the first part of the description because it's a drop down. I need to display the full text, which varies from 350-600 characters. I think I need to use document.getElementsByName and assign it to a variable, then display that variable. But, I'm not a JS programmer. Attached is a screen shot of what my form looks like. It allows the teacher to select a lesson then request a time and day for the lesson to be taught. Any help would be appreciated!
  16. Our database was created before formulas were allowed in tables. Due to relationships, table restrictions and being live, I would like to fix this without using formulas. I have a submit form that is creating a Work Order Number by concatenating the Equipment_VIN and Time Stamp. In the form the Equipment_VIN is chosen by drop drop down from an equipment table. The form works perfectly. When I change the Equipment_VIN to autocomplete so the VIN numbers are easier to find the element of the VIN is no longer pulled by the script. Anyone have an idea as to why this is happening? Here is the script I am running in the footer. The script points to an HTML block div that is called "won" for work order number. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordEquipment_VIN").value; var position2 = '[@cbTimestamp]'; var allpositions = position1 +" "+ position2; document.getElementById("InsertRecordWork_Order_Number").value = allpositions; document.getElementById("won").innerHTML= "Work Order Number is: " + allpositions; } document.getElementById("Submit").onmouseover=concatenate; </SCRIPT>
  17. I'm sure I'm missing something obvious but...I have a dropdown field that has about 10 values in it and it automatically defaults to the top value. I want the user to have to select something from the list and not just accept the default value. So, I made the field "Required" and inserted a default value of "Please Select". So when the form is displayed, that value shows and there's a red asterisk showing that the field is required, but the user never has to select anything in that field because the app is accepting the default value. How do I make the user have to inspect that field and select a legitimate value?
  18. Hello everyone, I started using Caspio only a couple of days ago. As a first test project I am trying to build an invoicing app. I am now facing a problem and I really hope that someone here can help me. Before generating a new invoice, I need to enter all data for it. Customers I pick from a drop down, invoice date from the date picker etc. That is all fine. Now I select the Service I am sending the invoice for. (Let’s assume it’s only one service in the invoice.) This is another dropdown and refers to a table with, let’s say, the following content ID SERVICE PRICE 1 Accounting 100 2 Consulting 120 3 Training 140 In my data page I pick the service from a dropdown, display and value are both set to the 2nd column shown above. I pick Consulting, Consulting is displayed. The problem is, I need the price to show up somewhere so I can later calculate the invoice overall sum with it. I know I could insert a 2nd dropdown with SERVICE as display and PRICE as value, but I don’t want to drop down twice. So here is my question: How can I, in my data page, display the price (col. 3) of the service (col. 2) that I just picked in the drop down field? (By the way, the same solution will help me to, in the next phase, display the customer’s address in the printable invoice page, after I selected the customer’s name from a drop down. Same thing I guess.) Thank you very much in advance. I am looking forward to receiving your posts. Anatol
  19. Some of the seemingly easiest features of an online form seem problematic so far in my initial exploration of Caspio. Previous post cant figure out how to consistently get first drop down option to be blank, but that's a different matter. But here, now I cant get the nice black down arrow indicating a drop down box to appear in Production. Shows fine in form preview, but not live. Thoughts? IN datapage PREVIEW, Good: DEPLOYED LIVE, Bad:
  20. Hi, it seems that the only way to make a field available as a PARENT FIELD for a cascading dropdown, is to make that field editable; otherwise, that field is not an option. I need to filter a dropdown according to a field that I can't allow to be edited. This is what I need on a Bulk Edit on a report: field type: cascading dropdown filter by: parent field parent field type: display only Has anyone run into this before? Any ideas? Thanks
  21. Is it possible to have validated dropdown options when entering data into a table? I know how to do this in a datapage, but I would like to provide a similar option for internal users who have access to data on the back end.
  22. My Update form has 7 dropdown fields (Q1 – Q7) in which Rate/Yes/No options have corresponding numeric values. (Rate=No - No value, Yes=5, No=0) . We need help in 2 things. 1. Calculate and store the total Value of all the fields.To Calculate and store the total value of the Q1 – Q7 dropdown, we use the following script in the footer of the update form, (but it seems that it's not working) <SCRIPT LANGUAGE="JavaScript"> function calculate() { var Q1 = parseInt(document.getElementById("EditRecordQ1").value); var Q2 = parseInt(document.getElementById("EditRecordQ2").value); var Q3 = parseInt(document.getElementById("EditRecordQ3").value); var Q4 = parseInt(document.getElementById("EditRecordQ4").value); var Q5 = parseInt(document.getElementById("EditRecordQ5").value); var Q6 = parseInt(document.getElementById("EditRecordQ6").value); var Q7 = parseInt(document.getElementById("EditRecordQ7").value); QRating=parseInt( Q1 + Q2 + Q3 + Q4 + Q5 + Q6 + Q7); document.getElementById("EditRecordReferral_Rating").value = QRating; } document.getElementById("caspio").onsubmit=calculate; </SCRIPT> 2. Calculate and store get the Percentage of the answered questions. --> Need help on this. Our URL https://c2arw288.caspio.com/dp.asp?AppKey=DA284000754da7037a634519be3d&bestemailID=cmedrano@orangetheoryfitness.com Thank you in advance.
  23. I have a search form and a results page in the same webpage. The search form only has one field, which is a dynamic dropdown list. When I select a value from the dropdown list and click search the search is performed correctly and the results page changes accordingly. What I'd like to do is get rid of the search button, add a dropdown arrow on the righthand side of the search dropdown field and when I make a selection the seach to be carried out automatically. Any ideas how I might achive this would be greatly appriciated. Cheers Monoux
  24. Hi, My database has a dropdown list that users can pick from. They choose the product they want based off that list, however, many of them choose the same item or more than one. This means that I receive many notifications from the same person. Is it possible to block someone from choosing an item once they have chosen one item from the list?
  25. I am able to get the cascading dropdowns to work in the details page for first selecting state, then county. However, I am having difficulty making it work in the grid edit mode of my tabular report. Since going through some of the Caspio HowTo documentation, I made my County table into more of a cascading table format that includes columns for both state and county. (I also have a separate table with the list of states in case I need to go back to distinct County and State lookup tables.) When a user selects a county, there is an implied state with it from the County table. My goal is to have the user be able to select the state first in my Facilities tabular report, then select the county as a cascading dropdown filtered on the state value. (Sometimes the state is known when a new facility record is added, but the county not until later.) When I try to implement cascading dropdowns in the grid edit page, there is no option to select the county name as the display value. The column "CountyId" in the Facility table is an integer number data type that stores the autonumber Id from the linked County table. I would appreciate anyone's suggestions! Screenshot included.
×
×
  • Create New...