deemuss

Hello Israel! The solution really depends on how technical you are. If you can manage SQL queries, you can try using COLLATE with latin1 (ASCII) to perform this: SELECT * FROM Table WHERE Name COLLATE Latin1_General_CI_AI Like '%cafe%' COLLATE Latin1_General_CI_AI If you are not too technical, you can use a simple SOUNDEX query The application is extremely simple: if you type soundex(value), the query returns 'V400'. It is designed to group 'similar' words, but it also ignores diacritics SELECT SOUNDEX(VALUE) Here is the source document: https://docs.microsoft.com/en-us/sql/t-sql/functions/soundex-transact-sql?view=sql-server-ver15

Hello! In my opinion it is a good idea to have a lookup table for such cases: it is simple to set up and it is really scalable: you can add or remove some entries without need to review all the data. Try using Relationships for that: https://howto.caspio.com/tables-and-views/relationships/creating-and-managing-relationships/ Once you set up the database relationships, it will be possible to use readable values, but store numbers in the table.

Hello. Well, it is not very clear what is actually wrong with the tables. You have described the design for the first table, but not for the second. Also, it is not very clear what for should the resulting view be used. Also, did you check the guide on creating views? https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/ Generally speaking, if tables have compatible fields as primary (unique) and secondary (non-unique) keys, you can create a relationship between them. Then, it is pretty easy to create a view. Also it is a good idea to design your database in a proper way to avoid tables having same set of data or one big table having non-relevant data. Here is a small article with tips on table design: https://howto.caspio.com/tables-and-views/table-and-database-design/

I had such an issue and 'Use display value on DataPages' worked for me. For some reason it is unchecked by default

I have a chart and I need some more space between its axis title and the drawing itself. However, I cannot see any option to customise that.

I have a form that contains the list of options. Multiple options can be selected, and I want the user to see the option right away within the same page (not in report after form submission). I tried parameters, but that did not work. Do you know whether there are any other options?

Hi! Is it possible to set the minimum length reuirement for Text (255) field? For example, I have a search forms with lot numbers from different sources, however all of them are 5 or more characters. Is it possible to return an error message if the user tries to enter less than 5 characters into the Lot number field?

The default exis title is vertical: The Label direction settings only change the marking direction, but not the title direction: Is there any way to tilt the title too?

Is it possible to add "Remember me" checkbox so users would not need to enter their data every time they go to the deployed page?

I have found a good solution to format a phone number in JS Format Phone Number article, however this worked only for one field. Is there any way to apply this formatting for multiple fields? Another question: in the search field I have an e-mail field and I need it to be verified before the Search button is pressed. Is it posible?

It is possible to set checkmark condition using Calculated Value. The field should be set as Calculated Value The basic formula to set the condition is: CASE WHEN [@field:IntegerValue]=100 THEN 'X' ELSE 'Y' END For Yes/No field, the boolean value us 1/0. However, to make it work properly, the field should receive BIT value. So, CAST function should be applied: CASE WHEN [@field:IntegerValue]=100 THEN CAST(1 as bit) ELSE CAST(0 as bit) END

Sometimes deploying to Wordpress may result in Caspio DataPages looking not as expected with broken alignment, glitching buttons and weird borders. This happens due to Wordpress having its own set of styles which interfere with styles provided by Caspio. To avoid such issues, it is possible to find style conflicts and edit styles manually. For example, to make tables look normal, it is possible to add such user-defined style: table td, table th { border: none !important; } Alternatively, it is possible to import and apply the style attached here which contains small modifications eliminating most of the glitches caused by Caspio vs. Wordpress styles. Any better ideas? Wordpress_Styles.zip

Caspio apps can be deployed virtually to any web hosting. HTM, iFrame and .Net deployment is working on most hostings: iFrames are commonly used with Wix: https://support.wix.com/en/article/guidelines-and-limitations-of-the-html-code-and-embed-a-site-elements GoDaddy is just a web hosting, so without Site Builder it is up to you to chose how to deploy the app. Site Builder supports HTML with JS: https://www.godaddy.com/help/add-scripts-and-html-7684 So, you can use the default Embed code as described in Deployment instruction: https://howto.caspio.com/deployment/