Jump to content


Caspio Ninja
  • Content count

  • Joined

  • Last visited

  • Days Won


douvega last won the day on December 6 2017

douvega had the most liked content!

About douvega

  • Rank
    Advanced Member
  • Birthday 01/12/1989

Recent Profile Visitors

326 profile views
  1. Payment Integration

    Caspio can integrate any other third party service that provides API access,
  2. Payment Gateway

    Hi Sheik, I have succesfully integrated 2Checkout Payment Gateway with my Caspio apps through the API. You should consider it as an option. In any case, you should get Caspio Professional Services or an independant developer to do integration. Regards.
  3. Hi, This seem to be a many to many relationship since many movements could belong to many wrestlers. To do this, you need to use an intermediate or third table. So you have, Wrestlers and Movements tables. Each of these should have their own key (GUID for wrestlers and Autonumber for Movements would be fine). The third table should be called something like "Wrestler_Movements" with basically 3 fields, ID, Wrestler_Rel_ID and Movement_Rel_ID. Please Note, in this third table, you will only store keys not values, this way you will have access to all fields from both tables in the same view if needed. Then, you need to create the relationship, from Wrestlers to Wrestlers_Movements and from Movements to Wrestlers_Movements, at this point you have a many to many relationship created. You can use this article as a reference. When creating the relationships, I would advise you to check the "Display Value" box and select a meaningful field for you, you will see the importance later. After doing that, open the Wrestler_Movements table and start linking Wrestlers to Movements. Then, you can use the Wrestler_Movements as a dropdown source using Security filters in your datapage. I hope it helps.
  4. Any Programmers for Hire

    I would disagree. Upwork takes 20% and when you reach certain amount, it gets down to 10% which is the case when you are interested on building long lasting relationships through your excellent work. I think it is worthy the protection level you recieve in both sides, as a company and as a developer, resolving disputes and some other benefits. I have also posted jobs and I have not received any spam. Plus, there are good developers, cheap ones are not recommended though, usually not good english and poor logic sense. My answer was oriented to provide an option, the final customer can decide what is the more convenient depending on their needs but as developers, we should not judge but provide options.
  5. Hi, Maybe you are trying to make a cross table calculation by using the calculated field, in such case, you can write the calc field formula and then by ussing some CSS, you could hide the calc field column and use a HTML Block to create your link using the calc field data as it will be available from the parameters dropdown list. I hope it gives you some light towards the most appropiate solution.
  6. 1 email after submitting several records

    Hi there, The way I would do it is by adding a sort of Status to your process. For example, when the work is done, user should mark a check box on or select the process status from a dropdown. Then, using JavaScript, track when status is changed to the one that should fire the email. When the file meets the conditions, then insert the email value(s) in a virtual field and assing this virtual field to the "To" option in the email wizard in the Caspio datapage. The JS solution would be something like this: var dropdownField = document.getElementById("YOUR_FIELD_ID"), emailField = document.getElementById("YOUR_VIRTUAL_FIELD_ID"); dropdownField.onchange = function(){ var ddValue = dropdownField.options[dropdownField.selectedIndex].value; if(ddValue == "YOUR_DESIRED_VALUE"){ emailField.value = "EMAIL_YOU_ARE_TRYING_TO_SEND_THE_NOTIFICATION_TO"; }else{ emailField.value = ""; } } You can place this in the DP footer. Do not forget to include the code between the script tags. <script>THE CODE DESCRIPTED ABOVE</script> I hope it helps.
  7. Any Programmers for Hire

    You can also post your projects at https://www.upwork.com You will find very good developers
  8. Why dont changing the format in a way both regions can understand? Instead of 01/08/2017 make it 08/Jan/2017? Hope it helps.
  9. Validate Date and Time

    Hi there, I just tested this code and it works on form submit. Just remember that this Caspio Form should be the only one deployed in your webpage. <script> document.getElementById("caspioform").onsubmit = function(){ var dateOutString = document.getElementById('InsertRecordDefined_Time_Out'); var dateInString = document.getElementById('InsertRecordDefined_Time_In'); var dateOut = new Date(dateOutString.value).getTime(); var dateIn = new Date(dateInString.value).getTime(); if (dateOut <= dateIn){ alert("Please enter a date and time OUT after date and time IN "); dateOutString.value = ''; document.getElementById("cbParamVirtual6").value = ""; document.getElementById("cbParamVirtual7").selectedIndex = ""; document.getElementById("cbParamVirtual8").selectedIndex = ""; document.getElementById("cbParamVirtual10").selectedIndex = ""; return false; } }; </script>
  10. It does now, so you are trying to count how many values you have in the table. I dont think you are going the correct way. What would happen if this table is 3 pages long? How would you track the amounts in the div. The way I see it you have these three options: Getting a custom JS function to add 1 to a JSON object for every single line and then do the counting to place the results in the div (now sure how it will work in large reports) API calls from a view to count records (You have a limitation of 1000 rows max per call so if your report is greater than 1000, multiple calls are needed) Use two datapages. One for the table and the other one should be tabular too with grouping to show results in the way you want to see it. This datapage should be deployed as an iFrame in the main Table footer. In all ways, you may need to get external help in case you feel stuck, again it can be done but I dont want you to get fustrated. Please also take into consideration that this is how I see it, I am sure there may be other people that can suggest something different and it would be ok as soon as it works. Sorry for not being able to help you with a final coding but a further review is needed.
  11. Sorry, I got lost. Where is the field you want to count from? I see only a table with no edittable fields. By the way, have you tried to use the Grouping function and Aggregate field on this table to display counting results?
  12. Could you please share the datapage? Also, did you include the jQuery Library in your datapage/webpage already?
  13. How to set dropdown field type to receive parameter

    Hi, I think this article will help you accomplish that. Regards.
  14. Can you hide an HTML block with a rule?

    I just came with another idea that should work, this is by using your current HTML block content. Create a section for these two elements, Specific LSN time: and your HTML block Message. Go to Rules in your Datapage and create a new Rule. If the radio is not equal to Specific, then hide the section that contains the field and the HTML Block That would be pretty straight forward. You can learn more about this way in this article Hope it helps.
  15. Can you hide an HTML block with a rule?

    Dear roattw, Please replace your current HTML block for the following code: <div id="msg24"></div> <script> var radioField = document.getElementsByName('InsertRecordLSN_time'); var messageCnt = document.getElementById('msg24'); function getRadioValue(){ for (var i = 0, length = radioField.length; i < length; i++) { if (radioField[i].checked) { return radioField[i].value; break; } } } for (var i = 0, length = radioField.length; i < length; i++) { radioField[i].onchange = function(){ if(getRadioValue() == 'Specific'){ messageCnt.innerHTML = '<span class="cbInfoText">*24-hour clock</span>'; } else { messageCnt.innerHTML = ''; } } } </script> Let us know whether or not it works.