Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by techguy

  1. I am thinking that as well. if I pop a modal and put a caspio datapage on it, then have detail screen come up, it is below modal. I will see what i can mess with to make it work.
  2. Good day! I have a datapage that is embed on a pop-up modal on a page. When I click the button, the modal pops up and everything works great. The tab report is able to inline edit, however the dropdown will not work for editing a field with dropdown. The field looks correct, with the correct current choice, and the drop-dwon icon is there.. just does not drop down to allow a new choice. The inline edit works when I preview.. but not how I have it inside a modal pop-up on the page. My guess the modal and inline edit with a dropdown causes this... Any suggestions?
  3. so maybe I can make a report page work for me.. I assume I would need to change the script for datapage type , but my report pages when updated do not refresh.. do you think that might help?
  4. The dropdown is the one called StatusLocation - all on same script and datapage on the refresh.. so if I update, then it will not refresh the whole page? If I submit form it does?
  5. Bravo!!! You are amazing! a little more maybe.... 1. Is there a way now in this script on the dropdown, when the selected option is 'Off' it also turns the checkbox off (unchecks it?) 2. does the page refresh on submit on refresh because it is a single record update page? Should I try to make this work with another page type. The refreshing of the entire page sucks, lol Thank you soooooo much. a few little tweaks hopefully and one less task!!!
  6. As a note, I have responsive turned off since it buggers up the styling if it is on. I have it in a menu space and very specific css requirments. Not sure if the code changes with responsive is OFF
  7. Actually, I think I had copied and pasted and left some brackets.. the code does work with the dropdown... sorry for the confusion.. however still does not submit when I check or uncheck the box with the else if
  8. Just tested and when I added that, the dropdown no longer triggers the submit either
  9. This did not submit the form. <script type="text/javascript"> document.getElementById("EditRecordStatus").addEventListener('change', function(event) { if (document.getElementById("EditRecordStatus").checked==true){ document.getElementById("EditRecordStatusLocation").value='Online'; } else if (document.getElementById("EditRecordStatus").checked==false){ document.getElementById("EditRecordStatusLocation").value='Off'; } }); <script type="text/javascript"> document.getElementById("EditRecordStatusLocation").addEventListener('change', function myFunction(event) { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); }); </script>
  10. As a note, I changed the page a little where the check box hides the dropdown if not checked.. I then tried to put these scripts together to make the functionality work. If I change the dropdown, this triggers the submit.. however if I uncheck the checkbox I want the dropdown to change to 'off' and submit, if I check the box, it unhides the dropdown and I want the dropdown to show 'Online' and submit . the actions works with the scripts (I can see that the new value of the dropdown is 'online' for instance, but checking or unchecking does not trigger the submit. I am trying to trigger the submit when the field changes value... <script type="text/javascript"> document.getElementById("EditRecordStatus").addEventListener('change', function(event) { if (document.getElementById("EditRecordStatus").checked==true){ document.getElementById("EditRecordStatusLocation").value='Online'; } else if (document.getElementById("EditRecordStatus").checked==false){ document.getElementById("EditRecordStatusLocation").value='Off'; } }); </script> <script type="text/javascript"> document.getElementsByName('EditRecordStatusLocation')[0].onchange = function() {myFunction()}; function myFunction() { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); } </script> If you have any suggestions I would appreciate it! THANKS
  11. Hello. This solutions works well.. but the entire page refreshes when the submit occurs. I do have ajax enabled. On the same datapage there is also a check box (styled as toggle) and I set the same thing for this.. As a note this is a single record update form. 1. I need the screen to NOT refresh entire webpage, either the checkbox or dropdown refreshes 2. I need a script that sets the dropdown to a specific value when the checkbox is unchecked 3. I need a script that set sets the checkbox off/unchecked when the person selects the 'off' from the dropdown Thank you for any help or suggestions!
  12. May, I copied the code from the inspector, created an html block and copied it after my search fields. the new button shows up but i am not able to get the original one to go away, it is right still there as well.. any suggestions?
  13. I have a tabbed report page that uses authentication of logged in user to compare a field in the table (UserID field) that matches. Problem is I have a list of 5 or 6 items that are added for all users and I have set the userID listed as "system" for those items. I cannot figure a way to use the OR function with the authentication check to pull the records that are "system" as well as the auth userID check. There has got to be an easy way to say authenticated userID OR "system" Any ideas.. Probably basic.. thanks for helping!!!
  14. I have a task that runs, but I am having issues with the date. I want the date to return the current today date.. this task works, but I do not want to manually set the date.. any suggestion how to make it use "today's" date? This works exactly how I want if I manually change the date to the today date.. but I want this automated and run at 11:45pm at night for the current day. It is easy to schedule the task daily, just ca not get it to use the "today's" date.
  15. Hmmm, I tried that and actually it does not work. This form is embedded in a modal and when the pop-up screen comes up the first field is still not focused and you have to click in the field to scan a barcode or enter the data.. any other suggestions?
  16. I know I have seen it someplace.. but can someone help me with the script to auto-focus on the first field of a submission form so users do not need to click in the first form field to start typing.. needing to use a form that auto focuses to the first field... THANKS
  17. I tried this with a datapage but could not get it working properly since I am using a html login page the redirects users based on role. But I will try this method and see how it works. I appreciate your help. It is crazy to me that the system is capturing login info (as I see it in the admin side of caspio) but I can not build any pages based on that or create any way for the system to know if someone is logged in. Thank you so much for responding. I thought about moving to another platform since so many things need to be "worked" around to make work that other systems just have built in and very easy to make work... we will see!! Thanks again!
  18. Hi Andrii, A few questions, 1. what is the best way to hide the submit buttons of the two datapages? 2. If I have two datapages on on webpage. Are you saying add the two scripts above to the last datapage? Thank you so much for your help!!! Happy Holidays!
  19. Hello. I am trying to determine a way for users to see other users that are currently logged into an app. Caspio does not make this easy (or I am not finding a way to do this without programming). I thought a check box in the user table would be an easy way to see if the user is logged in or out. When they log in, the system checks the box and when they log out the system unchecks the box. All other low code platforms I have used was able to do this without custom code.. Any suggestions to make it so you can add this to app users to see if they are logged in or not?
  20. I am using a login script that re-directs a person to a specific page based on a role in. Is there a way to modify this script to check a yes/no box to yes when logging in.. then somehow run a script that checks the biox to "no" when logging out of the system or being timed out of the system? Here is the script I am using to log in... <script> if("[@authfield:Role]" == "Admin"){ window.location = "admin.html?UserID=[@authfield:User_ID]"; } else if("[@authfield:Role]" == "Agent"){ window.location = "actionlog.html?UserID=[@authfield:User_ID]&FN=[@authfield:First_Name]&LN=[@authfield:Last_Name]"; } else{ window.location = "oops.html"; } </script> Thanks -Mike
  21. Hi MayMusic, I am trying to create a presence (user logged in) and timestamp of login for users. I am curious if this would be the same thing for me, but I cannot make this work. I created a submission page, created a table for the login and timestamp, user ID etc, but I must be doing something wrong. Any help would be appreciated...
  22. Hi, Anyone have an easy way to make it so that you can track if a user is online or not. Maybe with a field in the user table that is yes/no when they log in, it checks the box for online and when they log out it un-checks the box. So many platforms have this function in their platform but I find this hard to make this work with caspio. Any suggestions? THANKS Mike
  23. I have two datapages on one web page. I want BOTH datapages to submit with ONE button.. can this be done??
  24. I have a table and I want a simple code to display in html the count of a column with conditions using the UserID and data in column. As an example. I want to create an html datapage or report page that only shows the count I want. Since I can not use Select count () statements within html datapage ( I need something that only shows the total of the calculation without a row etc in html.) the statement below works properly, however even in a basic report page it returns the rows that meet the conditions with the count, when I only want the count.. Select count(Contact_Type) from Ninja_Contacts where User_ID='[@authfield:User_ID]' AND Contact_Type = "Other" Any way to create some javascript code to display the count of a table (with conditions) within an html datapage or a regular report page and ONLY show the count, literally one number... thanks
  25. any way I can do a Select count statement within an html datapage?
  • Create New...