
deemuss
Members-
Content Count
13 -
Joined
-
Last visited
-
Days Won
1
deemuss last won the day on July 29 2020
deemuss had the most liked content!
About deemuss
-
Rank
Member
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
deemuss reacted to a post in a topic: Inline edit only in certain circumstances
-
Johnny reacted to a question: Set condition to Yes/No field
-
CoopperBackpack reacted to a question: Set condition to Yes/No field
-
deemuss started following Set condition to Yes/No field, Accent mark, Multiple Relationships and 3 others
-
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.co
-
deemuss reacted to an answer to a question: This page doesn't seem to exist. It looks like the link pointing here was faulty. Maybe try searching?
-
List of things, which in turn have properties
deemuss replied to lutl88's question in Tables, Views and Relationships
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. -
deemuss reacted to an answer to a question: DataPage based on View and the data showing
-
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 yo
-
Spencer reacted to an answer to a question: DataPage based on View and the data showing
-
I had such an issue and 'Use display value on DataPages' worked for me. For some reason it is unchecked by default
-
deemuss reacted to an answer to a question: Can I Add Space Between Title and Axis
-
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?
-
deemuss reacted to an answer to a question: Set Check box with a formula?
-
deemuss reacted to an answer to a question: Values cannot be submitted due to a data restriction.
-
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?
-
deemuss reacted to an answer to a question: Make Y Axis title horizontal
-
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 modificat
-
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/