Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 09/16/2020 in Posts

  1. Hello @DDLiving, You may refer to this screenshot to achieve that.
    3 points
  2. Not sure if what I understood is correct, but, you can try this, create a Calculated Value, this is to check if the date today is less than 5 or not. If it's 1, user can input any date, if it's 0, only on the current month and later. CASE WHEN DATEPART(day, GetUTCDate()) <5 OR (DATEPART(day, GetUTCDate()) >= 5 AND DATEPART(month,GetUTCDate()) <= DATEPART(month, [@field:Date])) THEN 1 ELSE 0 END Script on the footer: (change the number on cbParamVirtual1 depending in your Virtual Field) <script> document.addEventListener("BeforeFormSubmit", function(e){ var a= document.querySelector("input[name='cbParamVirtual1']").value; if (a == 0){ e.preventDefault(); alert("Please input Date within or after the current month"); } }); </script> If you want this to trigger on change of the field that is being used in the Calculated Field. Change the InsertRecordFIELDNAME to your actual field's id cbParamVirtual1 to your Virtual Field's name if it's 1 2 3 or whatevers <script> document.getElementById("InsertRecordFIELDNAME").addEventListener("change", function(e){ document.querySelector("input[name='cbParamVirtual1']").addEventListener("change", function checker(){ var a= document.querySelector("input[name='cbParamVirtual1']").value; if (a == 0){ //if Calculated Value is 0 then alert alert("Please input Date within or after the current month"); //add another code } this.removeEventListener("change",checker); }); }); </script>
    3 points
  3. What does yours look like? Mine adjusts accordinly...
    2 points
  4. try this, basically, it's excluding the elements with the said classes using 'not' <SCRIPT LANGUAGE="JavaScript"> var elems = document.querySelectorAll("td:not([class^='cbResultSetGroup1Label']):not([class^='cbResultSetTotalsData'])"); for (var i=0, m=elems.length; i<m; i++) { if (elems[i].innerHTML=="1") { elems[i].style.color="BACK";} if (elems[i].innerHTML=="1") { elems[i].style.backgroundColor="LIGHTGREEN";} } </SCRIPT>
    2 points
  5. autonumber

    Trigger and Task?

    Hi @Gigigigi, Task are operations that you can create in your application and run them manually or automatically based on a predefined schedule while Triggered Actions allow data manipulation, calculations, and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables. You can also use Triggered Actions to transfer data from another table but if you have existing records it is recommended to use Task.
    2 points
  6. Additionally, you may refer to this article about SQL Convert: https://www.sqlshack.com/sql-convert-function/
    2 points
  7. Yes. Convert first your formula into VARCHAR. For example: CONVERT(VARCHAR(255), [@field:Field1] + ' ' + [@field:Field2])
    2 points
  8. Hi @FredFarfadoe, To achieve that you will need to add a CSS code on the header of the DataPage: You can use this: <style> g.highcharts-series-group { pointer-events: none!important; } .highcharts-a11y-proxy-button { pointer-events: none!important; } tspan { pointer-events: none!important; } </style>
    2 points
  9. LittleMsGinger

    Combined Views

    Hi @Joemac, just to verify, you would like to use two views as the Data Source of one DataPage? If that is correct, unfortunately, it s not possible. You can only select one Table or View as a Data Source. You can just combine the Tables to create one View and use it in the DataPage. Hope this helps!
    2 points
  10. You can also use F12 > click on the cursor thingy > click on the element that you want to change the style and you should be able to see what class it belongs to Go to Styles > Source > All, press ctrl + f and input the class there
    2 points
  11. GoodBoy

    AWS

    Hello! These articles might help you as well. - https://www.caspio.com/caspio-recognized-amazon-web-services-partner-network-advanced-technology-partner/ - https://www.caspio.com/caspio-expands-its-platform-as-a-service-to-meet-global-market-demands-utilizing-amazon-web-services/
    2 points
  12. I also experienced this issue a last month. What I did is that I also allow or checked the 'Read App' for the application where my DataPage belongs and it is now permitting my external users to access the DataPage.
    2 points
  13. Just include the dates in the criteria. On Search Filters, enable the On Exit, and then you can then use these parameters on the WHERE (i.e. WHERE Call_Outcome = 'Sale/Offered' AND DateColumn >= '[@DateParameter1]' AND DateColumn <= '[@DateParameter2]'
    2 points
  14. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
    2 points
  15. Hello @Gabrielle, Please note that this dropdown shows the tables that have a unique field. The Authentication can be created using the table with the unique field since it`s required to define the specific user. For example, in this table the email field is set to unique: Feel free to update this thread in case of additional questions.
    2 points
  16. Hi @Tyler, I can suggest using a different approach for this case that does not require JS snippet. You may create a lookup table that would be prefilled with date range Monday-Sunday (current week) with a help of Application Task. The Task might look like the following: You may use this lookup table as a source for a dropdown with predefined options. Hope this helps. Regards, Vitalikssssss
    2 points
  17. Hello @SaraK, Thank you for the detailed explanation. You have made a big research on this as well and were so close. Please try to use the following formula in the Calculated field to get the number of IDs that were Submitted Today: SELECT COUNT([@field:Request_ID]) FROM curbsideEntries WHERE DateDiff(day, [@field:Timestamp], SysDateTime())=0 Hope this helps! Please let me know if it works for your case. Regards
    2 points
  18. Hello @roeithemeiriman, If you created a Trial account, as I remember it will be deleted automatically in 14 days. No action is required from your part. In case you created a Free account, you can easily delete it. Please go to the top menu Account -> Usage and Billing -> Cancel Account. Here are screenshots for better visualization. Screenshot_1 Screenshot_2
    2 points
  19. The real answer is Caspio should just create a distinct field button of some sort like they do in dropdowns when you can check Distinct Options and Im sure it would take them 20 minutes to do and everyone could use this!
    2 points
  20. Barbie

    Hide Search button

    Hi Watusi, You can try to paste this code in your header instead: <style> input[class*="cbSearchButton"]{ display:none !important; } </style> I hope this works for you.
    2 points
  21. Hi! I agree with TellMeWhy this can be achieved using Triggered Actions. I just wanted to add these links that you can refer to in creating Triggered Actions. https://howto.caspio.com/tables-and-views/triggered-actions/
    1 point
  22. Does this need to be a dropdown? You can use Calculated value form element maybe? (Select MAX(IDFIELD) FROM TABLENAME) + 1
    1 point
  23. Alternatively, you can use the following: <style> .cbSearchButtonContainer{ grid-row: 1 !important; grid-column: 5 / span 4 !important; padding-top:30px !important; } </style> row depends on what row you want to put it to. Column depends on the position on the specific row, just play with it, keep the span to 4 padding is just to adjust the specific position in the column and row Sample:
    1 point
  24. waltmayo

    Hired help...

    I am in need of some help with integrating Javascript into some of my apps. I know that the Caspio team will take on custom programming jobs, but these tasks are sometimes very small. Does anyone else out there do freelance Caspio work? I'm not opposed to hiring Caspio's programmers, just was interested in learning all my options. Walt
    1 point
  25. Hi @DDLiving, You can search for elements with “_mobile” attached to them in Styles to customize the HTML elements when in mobile mode. For most of the elements there are CSS classes with the “_mobile” or “_tablet” suffix, which contain the current settings for tablet and mobile screens: “_mobile” refers to screen width 320px – 567px “_tablet” refers to screen width 568px – 1024px I hope this helps.
    1 point
  26. It's pretty easy, just add ELSE on the code and use auto submit <script type="text/javascript"> document.addEventListener("DataPageReady", function tester(){ if(document.getElementById("errormessage")){ window.location.href = "https://www.google.com"; } else{ setTimeout('document.forms["caspioform"].submit()',1000); } }); </script> In my code I removed the display none, but, you can include that since you wouldn't want your users to be seeing that anyway, you can also reduce the 1000 delay to a faster one, but I think that's fast enough and if you have display none, it will be alright.
    1 point
  27. Joemac

    Triggered Actions

    @Tubby So appreciate you doing this for me! I think I can follow this and set it up.
    1 point
  28. autonumber

    AWS

    Caspio is already running on AWS so you don't have to manually connect it. You may check this: https://www.caspio.com/platform-overview/
    1 point
  29. GoodBoy

    parameter scope

    You may add cbResetParam=1 at the end of your URL.
    1 point
  30. You absolutely nailed it!!! It seems so simple now that I actually see it. I will hang on to this code and example since I'm sure I can find other uses for it going forward. And also adapt it to some other scenarios too. Again, thanks so much for the fast solution.
    1 point
  31. Hello, I am trying to make a cascading dropdown field that receives the value from the parent field selection and still have the rest of the values from the dropdown source show along with it. Sort of like the option 'Match all when blank' but I want to match all - all the time, and populate the dropdown with the cascading value. I am building a scheduling calendar. We take information from our Work Order Table to use for creating records for the Scheduling Table. Each Work Order record has a technician assigned. When a work order is selected in the Scheduling Submission Form, the Technician field is populated. However, I need to be able to change this value for the Scheduling Table if needed. I need our scheduler to be able to select a work order, have the technician field populate, and have the ability to change the value. Is it possible to have the Technician field be a regular dropdown with all of the values from the datasource, and then use javascript to prefill the value? Maybe, use a virtual field to get the cascading value, and then use JS to select the value in the tech dropdown? I have the virtual field set up, but if someone could help me out with the javascript, that would be appreciated!
    1 point
  32. Hi @RunForrestRun, If you want to change the font color of the current record page on all Detail's DataPages then it is possible in Styles: Go to Styles -> Form/Details -> Navigation -> Current Record For more in depth customization, go to Styles -> Source -> All -> Find .cbFormJumpToTextField class -> change color or other attributes to the required value Hope this helps!
    1 point
  33. Hi @Cherry, Based on what I understand, in your Reports Page, you will have a column for Sales Person. Then, you would like to sort the report based on the most outstanding sales person. First, you need to have a calculated field in your reports. You can have an SQL statement to count how many instances that this sales person is being selected by the customer. For example: SELECT COUNT(Sales_Person_ID) FROM TABLE WHERE Sales_Person_ID=target.[@field:Sales_Person_ID] Change the field name and the Table Name. Lastly, sort the report using this calculated field. See screenshot below for the sample. Hope this helps.
    1 point
  34. @AccessNerd, you'll want to use an Update Trigger on the table with the Status field. Use the Email Block, click the options, and turn the SELECT option on. You'll want to make sure your trigger is set to run on update. Go to the Select Block's options and enable JOIN and WHERE. Set the Select Block to #inserted and the INNER JOIN set as the table with the Status field. Use '#inserted.IDField equal tablewithstatus.IDField' for the join. Then, in the WHERE section, set '#inserted.Status not equal to tablewithstatus.Status' This should only send an email when the updated record's status does not equal what was in the table before the update.
    1 point
  35. Oh, alright, sorry about that, thank you for the solution, as well!
    1 point
  36. Hello @wimtracking2, As I understood from your inquiry, you store the cities in the field with the Text(255) data type and set this field on the Search page as Listbox -> Allow multiselection And the Search is set like this: If this is the case, it is possible to add the "selected" attribute to the options you want by JavaScript. I added this code to the Footer section on the "Search and Report Wizard - Configure Search Fields" page (the HTML editor is disabled on the Advanced tab before pasting). <script> document.addEventListener('DataPageReady', selectedOptionHandler) function selectedOptionHandler() { let firstCity = document.querySelector('#Value1_1 > option[value="Bozeman"]'); let secondCity = document.querySelector('#Value1_1 > option[value="Belgrade"]'); let thirdCity= document.querySelector('#Value1_1 > option[value="Livingston"]'); firstCity.selected = secondCity.selected = thirdCity.selected = true; document.removeEventListener('DataPageReady', selectedOptionHandler); }; </script> And here is the output. So, I can see the list of records where City is Bozeman, Belgrade, or Livingston on initial load. In the example, the City field on the Search page is the only field and has the id Value1_1 that is used in the code above. Basically, the second field on the Search has the id Value2_1, the third field - Value3_1, etc. Please replace the id in the code if needed. Hope this is the expected result and this solution helps.
    1 point
  37. sandy159

    Filtration Criteria

    Hi @myName, If I understood you correctly, you want to filter the records where Work_Date is blank or Work_Date is not today's date. Here is a workaround that I found. You may add a Difference field in the Table and populate it with the Application Task. Then use this field to Filter the needed records in View. Table (Difference - Number data type): The Task can be set up to run every day and update the Difference field. Basically, it checks the difference in days. If it is today- then difference will be equal to 0. In the View you may filter all the records where Difference field is not equal to 0. Hope this helps!
    1 point
  38. @kpcollier I see, that's quite the workflow. Basically, what you want is the onchange function in the virtual field that receives C, and then select that option in the dropdown. It should easily be able to select the same value with the script, like : document.addEventListener('change', function (event) { document.getElementById("InsertRecordTitle").value = document.getElementById("cbParamVirtual1").value; }); I'm only changing Virtual 1.
    1 point
  39. Hi, You may try pasting this on the Header DataPage element of your wizard: <style> @media only screen and (min-width: 577px) and (max-width: 1024px) { section[class^="cbFormSection"], section.cbCalendarReport, nav.cbCalendarNavBarPanel, .cbAuthSimpleOuterTable, .cbAuthSidebarOuterTable { margin-left: 0% !important; } </style>
    1 point
  40. Hi @kpcollier, Caspio does not have any standard feature for a time picker, but you may check this How-to article for customization. You can also check this URL as a sample. You can also use this code: <input id="time" type="time">, by inserting it to a HTML block and disabling the HTML editor. Below will be the final output.
    1 point
  41. Hey there @RossChevalier List data types are designed to accept multiple values. A user Can select just one option, but they Can also choose more than one. Not sure if any script will work for enforcing the field to just accept one choice. You can learn more about that data type here. Depending on your workflow and why you needed to use a list data type, an alternative I can suggest is to use a text 255 data type for these fields instead. It's kinda ideal since if you use it in a submission form, set the form element to a dropdown, it will only accept one value. Plus, since you mentioned you have a table where the choices are coming from, you can use this as a lookup table or table where you will be getting the choices from for your dropdown. Good thing is, when you use a text data type, you can now use it as a parent field for cascading form elements whereas list data types cannot be used as parent fields for this. This will be useful for your second question where the DeptName will be automatically pulled up based on the Department Number. You can check this sample DataPage I created for you -> https://c2abn197.caspio.com/dp/adf58000bdb28da708494616b1c6 Now for your first question where you can see both the Department number and name, I do not think that's possible as of now. Maybe some type of script too. But if you want a more standard approach, you can choose to show the department name as the display values, but still save the department number of that record. I hope this somehow gives you an idea
    1 point
  42. I have a tabular report datapage with a map on the detail page. I also have a "Return to Menu" button on the results page (and the search page) to close the tab using "window.top.close();". With AJAX disabled, the map shows, but the button doesn't work. If AJAX is enabled, the button works, but the map doesn't show up. I found this link which seems to address the problem: https://forums.caspio.com/topic/7714-generate-geolocation-from-input-fields/ ...I followed the instructions but the map still doesn't work. Any suggestions?
    1 point
  43. I see some older posts concerning no support for outbound webhook activity on triggers. Still the case? Best solution is to utilize Zapier for that functionality at a cost? Other solutions/possibilites. Thanks.
    1 point
  44. Hi @Vvillie, You can still use the code here. You just need to change "#InsertRecordPhone1" to "#Value1_1" Hope this helps!
    1 point
  45. I have a report data page that utilizes a details page and on this details page, all fields are display only. I am wanting to format the details page so that the information is displayed more consistently. I see how text fields, for example, can be manipulated with the pixels and other options, but those options are not available when using display only. All of my fields are display only as we do not want any editing of values on this data page. Was hoping someone could tell me how to control the width of displayed information for fields that are form element:display only? I found the other thread on this topic, but it appeared to be referring to the label of the field, not the field itself. Thank you in advance
    1 point
  46. <style> .cbFormData { display: flex !important; } </style> Perhaps you can use this CSS code to override the CSS styles for radio buttons.
    1 point
  47. Hello @nanglin, I see. Since there is the code to submit the form in the "else if" condition, once the Submit button is clicked, 2 records are submitted. As I understand, the email field is unique in the table, so you see the message regarding the duplicates. Please remove the else if condition and test the DataPage. <script> document.addEventListener('BeforeFormSubmit', function(event) { let checkValue = document.querySelector("[id*='cbParamVirtual2']").value; if (checkValue == '0') { event.preventDefault(); alert("Your domain is incorrect, contact your system administrator"); } }) </script>
    1 point
  48. I tried to move the title of a chart from middle to left using Styles and CSS but no luck. Is there a workaround to do this?
    1 point
  49. I am trying to show a pie chart of the sex of the entries by the logged in user. As they enter data, one of the datafields is the individuals sex, I want the user to see how many of their entries are male or female, but I also want them to be able to select the length of time, past week, past month, past year or all records. As soon as I make the search criteria 'X previous days' it makes it hidden and won't let me create radio buttons or a dropdown with the various options. Is there a way to have pre defined criteria for displaying graphed data?
    1 point
  50. Hi Marc, Yes you can. When your trial account expires, select Caspio Personal plan which is free. You can see a comparison of our plans here. Regards, Jonathan
    1 point
×
×
  • Create New...