Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


kristina last won the day on March 30

kristina had the most liked content!

About kristina

  • Rank
    Advanced Member
  • Birthday June 8

Recent Profile Visitors

218 profile views
  1. kristina

    making login form

    Hi, Just to update this post, here is the updated link for making a login form: https://howto.caspio.com/authentications-and-connections/authentication/ -kristina
  2. kristina

    Distance by address

    Hi, Just to update this post, here is the updated link for Distance Search: https://howto.caspio.com/datapages/reports/search-by-distance/ Please note that Distance Search is available to Build Plan and higher. -kristina
  3. Hi all, I found a similar post about calculating dates excluding weekends. You may visit this link for more details. -kristina
  4. Hi @ppbb123, I have a formula that gets the exact age considering the leap year. You may visit this link for more details: You may use this in your Calculated Value. Hope this helps. -kristina
  5. Hi all, Just to give you an update, Calculated Value is now available in Single Record Update and in any Details Page. You may check it out. -kristina
  6. Hi @MichaelB, Just to add from the previous comment, you may check this link for more information about "Referential Integrity" and Managing Relationships: https://howto.caspio.com/tables-and-views/relationships/relationship-settings/ -kristina
  7. Hi @YourSolutions, I understand that you want to save the result of the calculated field into the table. Unfortunately, Calculated Fields are for display only. What I thought as a workaround is to have triggered action that will calculate the value upon inserting of data and will be saved into the table. You may refer to this link for more details regarding triggered action: https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, kristina
  8. Hi @amunnings, I know it's late but just to give you an update, we already have SEO as a standard feature. You may refer to this link for more details: https://howto.caspio.com/deployment/seo-deployment-directions/ Thanks, kristina
  9. kristina

    Display File

    Hi @Role21, You can also try the solution provided in this forum post: Regards, kristina
  10. Hi @MyMelody, This is a known issue with IE Browsers. To overcome this, you can add CSS style on the Header of your DataPage. First, disable HTML editor and paste this code: <style> .cbFormTextArea{ white-space: pre-wrap !important; } </style> This will allow you to wrap the text in a text area. Hope this helps. -kristina
  11. Hi @MyMelody, If you want to get the numbers after the last "/", you can use this formula: REVERSE(SUBSTRING(REVERSE([@field:TestCode]),0, CHARINDEX('/',REVERSE([@field:TestCode])))) You can use it in a Formula Field, Calculated Field or in a Calculated Value. I tried it on my end and it worked! -kristina
  12. Hi Melody, I believe that you are referring to this ↓ You can get rid of that icon by adding CSS style on the header of your DataPage. You can try this one: <style> .cbFormSelect{ -webkit-appearance: none !important; } </style> Hope this helps. -kristina
  13. Hi @MyMelody, I have a code that will convert the date format to dd/mm/yyyy and will determine if the time is AM or PM. You may try this one: CONVERT(VARCHAR(10), [@field:TimeCreated], 103) + ' ' + LTRIM(RIGHT(CONVERT(CHAR(20), [@field:TimeCreated], 22), 11)) The result will be like this: Hope this helps. -kristina
  14. Hi @ivorykeys87, In Details Page, there is an option in the Advanced tab if you want to hide the field if blank. Please see attached screenshot: Hope this helps. -kristina
  15. Hi @jaxnz, For your first inquiry, "Is it possible to have one registration form and insert the data to the correct table based on a drop-down selection? e.g. UserType1 / UserType2" You will need to have a Main Table that will hold all the registrations. Then, create a triggered action for that table that will insert a record to a table for the first user type for example Admin. Then, for another user type. Please see attached screenshot below: The DataType of your Password field must be Text(255) for you to copy the password to other tables. Verify that email hasn't been used in either table on registration  You can set the Email in the Main Table as Unique. Login from one form and redirect based on which table that user is in You can create a Stand Alone Login Screen that will redirect the user based on Roles or User Type. Kindly check this link: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ Hope this helps. -kristina
  • Create New...