Jump to content

AtayBalunbalunan

Caspio Guru
  • Content Count

    187
  • Joined

  • Last visited

  • Days Won

    20

Reputation Activity

  1. Like
    AtayBalunbalunan got a reaction from Carioca in Where to put the value for X in Next X Days comparison type   
    The value for X should be in the Default Value field under Field Options.
  2. Like
    AtayBalunbalunan got a reaction from Watusi in Designated entry page in Authentication’s settings   
    No, it is not. “Designated entry page” is a destination to redirect all non-authenticated users. 
  3. Thanks
    AtayBalunbalunan got a reaction from Carioca in Long text in rollover hints   
    You can use <br> tag for line breaks.
    Example: Lorem ipsum dolor sit amet, consectetur adipiscing elit, <br> sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. <br> Ut enim ad minim veniam, quis nostrud exercitation ullamco <br> laboris nisi ut aliquip ex ea commodo consequat.
  4. Thanks
    AtayBalunbalunan got a reaction from Watusi in Summary Lookup   
    Hi Watusi, I have a few summary lookup tables in one of my application that was generated upon my confirmation.  When creating a lookup dropdown based on a large table, Caspio recommends generating a Summary Lookup Table to improve performance. You can find this information in this blog post. 
    Summary Lookups are optimized tables containing a static list of the field values automatically filtered for duplicates. 
  5. Like
    AtayBalunbalunan got a reaction from Watusi in How to search on lookup table value in a tabular report   
    Just to add, you may also use the AutoComplete form element and configure it with the below settings.

  6. Like
    AtayBalunbalunan got a reaction from Watusi in Checkbox that will select all items in a multi-select listbox   
    You can use the code below as a reference.
    <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var c_checkbox = document.getElementById("selectAll") ; var elementID = event.detail.uniqueSuffix; function c_event () { if (c_checkbox.checked) { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.length; i++) listBox.options[i].selected = true; } else { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.length; i++) listBox.options[i].selected = false; } } c_checkbox.onclick = c_event; }); </script>  
    Add this in your search's footer with the HTML editor being disabled. Just make the necessary changes for your form elements' ID attribute. You may use this guide for that.
  7. Thanks
    AtayBalunbalunan got a reaction from Carioca in Checkbox that will select all items in a multi-select listbox   
    You can use the code below as a reference.
    <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var c_checkbox = document.getElementById("selectAll") ; var elementID = event.detail.uniqueSuffix; function c_event () { if (c_checkbox.checked) { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.length; i++) listBox.options[i].selected = true; } else { var listBox = document.getElementById('Value1_1' + elementID); for (i = 0; i < listBox.options.length; i++) listBox.options[i].selected = false; } } c_checkbox.onclick = c_event; }); </script>  
    Add this in your search's footer with the HTML editor being disabled. Just make the necessary changes for your form elements' ID attribute. You may use this guide for that.
  8. Thanks
    AtayBalunbalunan got a reaction from Watusi in Automatically copy value from text field to password field   
    You may try the code below in your DataPage's footer. Please disable first the HTML editor.
    <script> var username = document.getElementById("InsertRecordUsername"); username.addEventListener("keyup", myFunction, true); function myFunction() { document.getElementById("InsertRecordPassword").value = document.getElementById("InsertRecordUsername").value; document.getElementById("InsertRecordPassword@Confirm").value = document.getElementById("InsertRecordUsername").value; } </script>  
    Just change the ID attribute value based on your field names. Please refer to this guide for referencing Caspio Form Elements: https://forums.caspio.com/topic/4377-js-guide-caspio-form-elements/
  9. Haha
    AtayBalunbalunan got a reaction from kpcollier in Another Restaurant Hours Check Question ...   
    UPDATE 
    Here's the link where you can submit a form to consult to their Professional Services team: https://www.caspio.com/services/professional-services/
  10. Thanks
    AtayBalunbalunan reacted to JolliBeng in Change color header   
    Hi @Role21,
    You can try to add the following code on the header of your DataPage
    <style> [class*=cbResultSetHeaderCell]:nth-child(2) { background: white !important; } </style> Just change the number inside nth-child(2) to the number of your column and background : white to your preferred color/color code.
     
    -JolliBeng
  11. Thanks
    AtayBalunbalunan got a reaction from Watusi in Time out on a password reset link   
    It is not yet possible to set a specific time out on a password reset link. I asked Caspio Support regarding this and they said that the 2-hour default window is a system generated feature which means we are not able to adjust the time allocation. They said we can suggest this in their Ideabox .
  12. Thanks
    AtayBalunbalunan got a reaction from Watusi in Create a New Submit button and hide the original one from my Submission Form   
    Hi Watusi, if you have just one DataPage deployed in your website page, you can add this script in your DataPage's Footer:
    <script type="text/javascript"> function submitCBForm() { document.getElementById("caspioform").submit(); } </script>
     
    Then, add onclick="submitCBForm()" in your new Submit button to execute the script for submitting the form.
    Your new button's code can look like this: 
    <input type="submit" name="Submit" value="Submit" class="newSBstyle" onclick="submitCBForm()">  
  13. Thanks
    AtayBalunbalunan got a reaction from Watusi in Check the checkbox if a specific option in Dropdown is selected in a Search form   
    Hi Watusi, can you try this instead:
    <script type="text/javascript"> var dropdown = "Value1_1"; var checkbox = document.getElementsByName("Value2_1")[0]; var drp = document.getElementsByName(dropdown); function checkdropdown() { var drpselected = drp[0].options[drp[0].selectedIndex].text; if (drpselected == "Math") checkbox.checked = true; else checkbox.checked = false; } drp[0].onchange=checkdropdown; </script>  
    Let me know if this works.
  14. Thanks
    AtayBalunbalunan got a reaction from Watusi in Login Process   
    Hi Watusi, yes it did. The change is included in the release of Caspio Bridge 16.0 last February 10, 2018.  All users must now log in using their email address instead of Account ID or Username. Immediately after the release, existing account users will be prompted to verify their email address. You can find the release notes here. 
  15. Thanks
    AtayBalunbalunan got a reaction from Perzival in Export unavailable   
    Hi @Perzival,    You can now export your App with Tasks in it. It is included in the recent release of Caspio Bridge 16.0 last December 6, 2018. You can find the information here.   Cheers!
  16. Like
    AtayBalunbalunan got a reaction from JckDY in API   
    Hi JckDY, API calls are counted on either using Caspio Bridge Plugin for Microsoft Office or your custom program using APIs to access, edit, insert into Caspio's database tables.Insert other media
  17. Thanks
    AtayBalunbalunan got a reaction from Watusi in Sending SMS via Twilio   
    Hi @Watusi,
    Yes, it is possible using Zapier, an online automation tool for creating automated workflows (zaps) between applications.
    Here is a video tutorial on how to integrate your Caspio applications with Twilio using Zapier:
     
    You may also read through this article for more information about integration with Zapier: https://howto.caspio.com/integration/zapier/
    Cheers!
  18. Thanks
    AtayBalunbalunan got a reaction from Watusi in Keyboard Hotkeys   
    Hi @Watusi,
    The following keyboard hotkeys are available in table and view datasheets:
    Enter and Down/Up Arrows – Saves the record and moves focus to the next row. Shift+Enter – Saves the record and moves the focus to the previous row. Alt+Enter (Option+Enter on Mac) – Adds a line break inside a field. Ctrl+S (Control+S/Command+S on Mac) – Saves the record without requiring the cursor to move to another record. You can find the information here.
    Cheers!
  19. Thanks
    AtayBalunbalunan reacted to AnchovyXL in Change data type from Autonumber/GUID/Random to other data type.   
    Hello HampasLOUpa,
    If you want to interchange those special DataTypes (Autonumber, GUID, Random ID) to each other or change them to other DataTypes (Number, Integer, Calendar, etc), change them to Text(255) first and then to your desired DataType.
    Interchanging special DataTypes (Autonumber, GUID, Random ID) to other DataTypes directly won't work. I'm not really sure why but think this by design.
    I hope this helps.
    Thanks!
×
×
  • Create New...