Jump to content

AnchovyXL

Caspio Ninja
  • Content Count

    46
  • Joined

  • Last visited

  • Days Won

    2

AnchovyXL last won the day on November 29 2018

AnchovyXL had the most liked content!

2 Followers

About AnchovyXL

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello, The applications that can be built with Caspio is one thing. THE SUPPORT IS ONE OTHER GREAT THING. I am absolutely telling you that Caspio after sales support is so awesome. Worth every penny. You must try their services to prove it yourself. You can have a free account here: https://pages.caspio.com/free-trial . After having an account someone from them will help you set things up. Thanks.
  2. AnchovyXL

    Adding Emoji

    In addition, There are many ways in which you can make use of the emojis. You can make them clickable by adding hyperlink tag like this: <a href="link">&#x1f601 </a>. You can also add them to dropdowns, checkboxes and also radio buttons.
  3. AnchovyXL

    Adding Emoji

    That is actually possible in Caspio. You can add emojis to Caspio DataPages by adding an HTML Block and pasting the emoji code. You can get a list of emojis here: https://apps.timwhitlock.info/emoji/tables/unicode Get the Unicode of the emoji that you want to use. Replace the first 2 characters of the code to "&#x" instead of "U+". Here's an example:
  4. This can only be applied to the Caspio Bridge User. If you want two-factor authentication for the end users, I think it is something that is not yet possible. What they have now is two type of authentication for end users. You can have them login using Google, Twitter and OpenID OR your Caspio-built authentication. https://howto.caspio.com/authentications-and-connections/authentication/
  5. You can actually use a Formula Field to do that. Create a column and set the Data Type to formula. Then choose the field that you want to copy from the picker when editing the Formula. After that click on Save. This will allow you to copy the records from the other field. Change the data type of the Formula Field to Text(255) then to the desired data type.
  6. So I was told by the awesome Caspio Support people some useful information about your inquiry. While it is true that you can add up to 10 million records per table, you will start having lots of performance issues the moment it reaches to let say one million. For example, you have a table with 1m+ records and then combined it to another table through a view and used it as the data source of a Report DataPage. You will experience very noticeable and increasing delays. It's always best to stay a little lower than a million. You can always do some archiving for old records so it won't add to the pain. Also, it'll free up some space so you won't have to purchase extra storage. It's always a good practice to trim everything down you know! CASPIO Rocks!!!
  7. Hi, This is for everyone's appreciation. If you want, you can actually request to have like a custom URL for your DataPages. The usual URL: DataPage is something like this: https://accountid.caspio.com/dp/8d196000f43161bfds2cd41eb8775. You can request for a custom url like this: https://myapplication.caspio.com/dp/ 8d196000f43161bfds2cd41eb8775. Though I think you have to pay for it and also will depend on the availability of the URL. Still, it's kinda cool though.
  8. I encountered this once. I think this happens when Caspio's servers are encountering problems or some sort of issues. They normally go back to normal after about 5 mins or so. This also helps. Not sure about the exact cause though.
  9. 1.) Inside Caspio Bridge:Click on Tools 2.) Click on Export 3.) Select Custom Export 4.) In the DataPages section, click on Add 5.) Select the affected DataPage(s) then set it to export DataPage & Dependencies 6.) Click on Add 7.) In Tables Section set your table(s) to export Without Data 8.) Click on Export
  10. I found out that as of 2017, there is no way to close a web browser tab or window using JavaScript. Modern security standards do not permit this behavior. The Window.close() method closes the current window, or the window on which it was called. This method is only allowed to be called for windows that were opened by a script using the window.open() method. If the window was not opened by a script, an error similar to this one appears in the console: Scripts may not close windows that were not opened by script. You can check this website for reference: https://www.computerhope.com/issues/ch000178.htm https://developer.mozilla.org/en-US/docs/Web/API/Window/close I hope this helps.
  11. These links are useful, you might want to check them. Adding Formula Fields: https://howto.caspio.com/tables-and-views/data-types/formula-fields/ Function Reference: https://howto.caspio.com/function-reference/
  12. Hi, You have to convert them first. CONVERT(VARCHAR(10), [@field:Company_Rel_ID])+" " +CONVERT(VARCHAR(10), [@field:Category_Rel_ID]) If you want to concatenate the fields in your DataPage, then you can use the Calculated Value. This can also be done at the table level using a formula field so you don't have to do it in your DataPage. Just like this: http://prntscr.com/mamp5s Hope this helps!
  13. AnchovyXL

    Rule Help

    When you make a field required, you are technically unhiding it already so there's not much need to have individual options for both of them.
  14. Hi, There is a very simple solution for that. First, change the form element of the field you want to have the random name to calculated value. Then, put this SQL Code: SELECT TOP 1 <Field_Name> FROM <Table_Name> ORDER BY NEWID() Change the Field_Name to the name of the field that you want to get the value from. Same as the Table_Name. This should do the trick.
  15. Hi, Technically speaking, the storage count does not include the number of DataPages you have. Meaning, even if you've already built one thousand DataPages the storage count for them will still be zero. What constitutes to your storage count are the following: 2. The size of files and data you are submitting (e.g. Images, Texts, Files, etc) 3. Scheduled Tasks & Tasks(Import). 4. API Data (Import to tables) 5. The size of your tables in general. Having activities pertaining to any of those items will significantly increase your storage use. The data, files and indexes inside your account determine your total database storage. Hope this helps.
×
×
  • Create New...