Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 08/05/2020 in all areas

  1. Hello @DDLiving, You may refer to this screenshot to achieve that.
    3 points
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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>
    2 points
  7. 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
  8. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
    2 points
  9. 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
  10. 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
  11. 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
  12. 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
  13. Hi @MaraMara, To move your "Record Action buttons column" to the first column you may follow the next steps: 1. Go to Styles and open the styles that you are using for the DataPage 2. Select Table Layout under Results Page 3. Under Element Type, look for Record Action Column 4. On the Position dropdown, change the position to Left. 5. Click Save then go to your DataPage then apply this Style Hope this helps!
    2 points
  14. Thanks to both of you. Learned a lot here. Great to be a new member with such helpful fellow members!
    2 points
  15. 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
  16. 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
  17. TellMeWhy

    Calculated Field Date

    Here's the conversion codes You can also try changing the formatting, should definitely be doable there, however, it's just for display, value would still be the same.,
    1 point
  18. Hi! Just to add on this, I have found a documentation containing the list of URL encoded characters that you can use as a reference: URL Encoded Characters (degraeve.com)
    1 point
  19. Tubby

    Formula Field on Table

    Hi @Joemac, You may also want to check this HowTo Article about Function Reference for other helpful formulas: https://howto.caspio.com/function-reference/ I hope it helps. ~Tubsss
    1 point
  20. that helps a lot. let me see how that works
    1 point
  21. Hi @HexGone! If you can use triggered actions on your account, you can achieve that using a similar triggered action as this: This triggered action will run on an update event(when you update the status), and then check the updated value of the field "type" (in your case, "Status"). Based on the updated value of "type", the trigger will change the email body to the corresponding CASE WHEN statement that it matches and then send it to the email address included in the updated record. I hope this helps. - Tubsss
    1 point
  22. I guess it is because of the related field set as unique. They should not be unique so you can enable the referential integrity.
    1 point
  23. autonumber

    Download All Files

    Hi! On you Caspio bridge you can go to Tools > Export > Custom Export > then Select all the files that you would like to download. You can refer to these links: https://howto.caspio.com/faq/import-and-export/can-i-exportdownload-all-my-files-in-one-batch/ https://howto.caspio.com/files-and-images/bulk-file-import-and-export/
    1 point
  24. 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
  25. GoodBoy

    parameter scope

    You may add cbResetParam=1 at the end of your URL.
    1 point
  26. I have given up on the popup. However what we have noticed is when the record is updated (submit/update button clicked) it is initiating the Delete script Cooper gave me above. Any ideas?
    1 point
  27. Hi, I'm trying to use the code below in the footer of a tabular report results section for the 'Inline Add New Record' can use it. The js is code to get the user's computer date/time (not the localization or CB system) and put it in a date/time field. I use this code in submission forms with no issues but don't know how to reference it correctly for a tabular inline add new record. If someone knows how to mod this I'd really appreciate it. <SCRIPT LANGUAGE="JavaScript"> /* Declaration and initialization */ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); Secs = Stamp.getSeconds(); /* Attach a prefix with digit '0' if the minutes is less than 10. */ if (Mins < 10) { Mins = "0" + Mins; } /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins + ":" + Secs); document.getElementById("InsertRecordComments_Actual_Submission_Date").value=v_TimeStamp; </SCRIPT> EDIT: just found the solution right after posting this. In case anyone needs it, tabular inline add uses 'InlineAdd' instead of 'InsertRecord'. Wish everything was so easy!
    1 point
  28. One more thing, I also checked the 'Read Data' for the data source (table or view) I am using for my DataPage.
    1 point
  29. Looking for one or multiple programmers to work on existing CRM built on the online cloud database caspio (https://www.caspio.com/) . Private company currently has custom CRM program on the caspio platform and we are looking to automate more processes and integrate with multiple API’s from Twilio, Google Docs, Slack, and MapQuest. Pay is negotiable, please contact us with your resume and qualifications.
    1 point
  30. Most probably your WordPress Theme, it applies CSS to the elements that Caspio did not.
    1 point
  31. Just wanted to add that if anyone wants to hire programmers/developers to help with your Caspio Application projects, it is also a good idea to look for Caspio Certified App Developers. I recently heard they have a certification program and figured it's best if those who you will hire are certified to make sure every penny you spend is worth it. - LOEY
    1 point
  32. Hello @Kuroshi I am thinking of a workaround for this and came up with this -> Create a Task instead that has the same functionality as your Triggered action. Task is somehow similar to trigger. However, the task will not fire automatically once you inserted a record. you will need to click the 'Run' task or schedule when will the Task run. I hope this helps and works. - Barbie
    1 point
  33. If you want to apply this to any data type, you may do the following in the Styles Page
    1 point
  34. Hi there @myName after checking Caspio's list of error messages, it seems that error code 62504 is caused by this: 62504 Failed security check. DataPage cannot be rendered from this account type. This error occurs when you store users’ passwords in a Text (255) field in a user table. Due to data security restriction, passwords must be stored in a Password data type field. https://howto.caspio.com/troubleshooting/errors-and-messages/ You may want to check your table.. I hope this helps!
    1 point
  35. 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
  36. GoodBoy

    HTML tags in Tabular Report

    Hi! This can be easily resolved by configuring your results page. Select your text area field and change the "Render value as" into HTML. You can also enable all HTML tags, however, there will be a warning about certain HTML tags that can be used maliciously to harm your data and application. I hope this helps!
    1 point
  37. @SinJunYoung This is exactly what I am going for. Thank you for all of the help!
    1 point
  38. Hello @Paolo, If I understood you correctly, you try to use Autocomplete for the ApplianceTypeID field (like shown on the screenshot below). Since you are going to submit data to the appliances table, it is not possible to submit Text (ApplianceType) to the ApplianceTypeID field due to the data type compatibility. Please try the following workaround. 1) Add the Virtual field to the Submission form. This will be the AutoComplete field. 2) Set the ApplianceTypeID field as a Calculated Value SELECT ApplianceTypeID FROM appliance_types WHERE ApplianceType = '[@cbParamVirtual1]' Double-check your fields and table names. 3) Hide the Calculated Value field. Go to the Advanced tab and check the "Hide Field" checkbox. Maybe someone else will suggest another workaround Hope, this solution works for you.
    1 point
  39. newscafe

    Technology Related Question

    What is part of a database that holds only one type of information?
    1 point
  40. You can use this one if you want to add a subject and body: <a href="mailto:[@field:RecordTextEmail]?subject=Mail from Caspio DataPage&body=Here is an email coming from my Caspio DataPage">Send an email now</a> I used that code here: https://c2abn197.caspio.com/dp/adf580006874c633dd9546e2acf3 Also, what I experienced is, since I don't have a default mailing app, upon clicking, it shows all mailing app I have that is available. However, when I set one app as my default mailing app, it opens on that.
    1 point
  41. Hi @JanineB, It looks like the "$" currency sign added by formatting is the reason for element value not been recognized as a number. You may add a replace function with regex to remove unwanted characters from value formatted as currency. So, your JavaScript would look like this: <script> var elems = document.getElementsByTagName("td"); for (var i=0, m=elems.length; i<m; i++) { if (elems[i].innerHTML.replace(/[^0-9\.-]+/g,"") > 0) { elems[i].style.textDecoration = "line-through"; } } </script> Regards, vitalikssssss
    1 point
  42. 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
  43. Barbie

    Date Range on my search form

    Hi, Here's a screenshot on how to achieve your workflow: Hope this helps.
    1 point
  44. @DefinitelyNot3133, thank you for comments. Regarding your comment #1, I do have the correct settings for that. And I do see the parameter being passed, because I display it in a HEADER section of the form just to verify that it passed. Regarding comment #2, I know that is my issue, but I don't know how to fix it. That is the reason I am using a left outer join, because I know I have a header record, but may not have a child record. I want to go to the new form to add the child record. If I filtered the view on the hdrid on a regular join, I would not get the header or the child because there would be no match in the child table.
    1 point
  45. If you want to retrieve the old value and the new value at the same time, like what I mentioned on the previous response, all you need to do is to join the inserted table with the own table. Here's a screenshot on how to do that. (This is just and idea how to do this, though I don't know your exact workflow) On the table where you're inserting, this will be the value: I hope this helps.
    1 point
  46. Hello, if you are using Styles, you may want to edit it here: Go to Styles > Edit Style > From the DataPage Elements go to Results Page and Select on Table Layout > Data Cells > and the Layout Options > Wrap Text: No Wrap
    1 point
  47. Hello @IamGroot, Just wanted to inform you, I found a way to export/import a table/database with List-DataType value inside it. 1. Change the DataType to "Text(255) field" and Export it. 2. And in your Excel file, make sure that the value for the List-String field is comma separated like this: (Item1,Item2,Item3,Item4, etc.) 3. Proceed with the import as usual. After successfully importing your file. Go to your Table and to the Table Design. 4. Change the "Text(255) Field" (The one we changed in step 1) back to List-String DataType. 5. Then it will just return the way it was. If you want to export it (reapeat step(1)). I hope this helps ~WatashiwaJin~
    1 point
  48. 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
  49. It is better if you hide the section using JS Around that section add HTML Block one on top and have : <div id="section1"> Below it add another HTML Block : </div> Use a code in following format to hide the div in last HTML Block after closing div <script> if (CONDITION){ document.getElementById('section1').style.display:none; } else { document.getElementById('section1').style.display:block; } </script>
    1 point
  50. You need to place the java script in the HTML DataPage not web page source code. Edit HTML DataPage, click on source and paste the code there
    1 point
×
×
  • Create New...