roattw

Greetings Document templates and PDF generation is kind of cool. But it doesn't quite do what we need. We need it to Generate PDF for the client AND Create/save a copy for use as well AND Send generated PDF by email to client (in acknowledgment email or via a trigger) Are wishes #2 and 3 possible? Thx!

Curious about custom CSS styles people have created. Anyone feel like sharing/showing off some of their custom CSS styles for Caspio?

I have some data that I was hoping to graph with 2 X axes. In a solution offered by Barbie in 2019 it mentions adding a second X-axis: https://forums.caspio.com/topic/9496-bar-chart-x-axis-value/?do=findComment&comment=29013 - select X axis, add new value for it. In mine, when I select X axis (#1) then add new value (#2) mine shows up only under the Y axis (#3) Im trying to achieve this that I get in Excel in Caspio. My data is "Calls" which are a count of nonblank entry IDs. My "Treats" are derived from a formula in a table that renders a value of "Treated" or "Not Treated". Is the fact that its a value derived from a formula that presents the issue? I copy the same data over to Excel I don't have an issue. In Caspio, I can only get single bar, cases or calls, not both. Thanks for any insight.

This is great, thanks! If you wanted to do this for 2 fields, would you just put a comma between the fieldname references?: <script type="text/javascript"> //This will hide the field for the "plain" text var non_formatted_txt = document.querySelector("#InsertRecordFIELDNAME1_html, InsertRecordFIELDNAME2_html"); non_formatted_txt.style.display = "none"; document.addEventListener('BeforeFormSubmit', function(event) { //This will replace all the HTML tags with blank var input = document.querySelector("#InsertRecordFIELDNAME1_text,InsertRecordFIELDNAME2_text").value.replace(/<\/?[^>]+(>|$)/g, ""); non_formatted_txt.value = input; }); </script>

Followup. The code in my original post did not work. However, this version did: <script> document.addEventListener('DataPageReady', upperCaseHandler); const ids = '#InsertRecordFieldOneName, #InsertRecordFieldTwoName, #InsertRecordFieldThreeName'; //replace with your local field names function upperCaseHandler() { document.querySelectorAll(ids).forEach(element => element.addEventListener('change', (event) => { element.value = element.value.toUpperCase(); })) }; </script>

Greetings I followed the instructions on this older post. The CSS style inclusion converts text in field to caps. But the capital letters don't appear in table as caps on when submitted with submission form. If I type lowercase letters in field, the CSS displays it as caps, but the data submitted to the table remains its typed in lowercase. https://forums.caspio.com/topic/5600-capitalizing-all-letters/ Not sure whats different about my form. Field is Trial_acronym Code in footer: <script type="text/javascript"> function capitalize() { var fieldname = "Trial_acronym"; fieldname = "InsertRecord"+fieldname; confirmname = fieldname+"@Confirm"; document.getElementById(fieldname).value = document.getElementById(fieldname).value.toUpperCase(); document.getElementById(confirmname).value = document.getElementById(confirmname).value.toUpperCase(); } document.getElementById('caspioform').onsubmit=capitalize; </script>

Thanks for the reply! They are part of Everyone. And I set that users permission for that App to just Read, but that lets them edit/add/change data. So I edited that users overall permissions for All Tables, nothing checked, but it still lets them edit table data. Interestingly, if I go to All Data Pages for that user and app, and remove Full Control and hit Apply > Ok if I go back to that same setting they are all checked again.

I am giving access to my Caspio account to someone to look under the hood a little. Under their account in Caspio I set their account level for an app to Read only. But when they login they can edit data in tables. I take it Read does not mean Read Only? Is there a way to have them look at tables and datapages but not be able to change the data? Thanks

Append "will only add the new records" Does that mean an entire new entry/record/row? What If I am only adding data for empty fields in a record? Will append only add entire new records or fill in blanks in all records?

Thanks for that input. Thats a good idea. Will make atest app using that concept.

Looking to build a basic self-help Start Here type trouble shooting steps app for a small range of common topics. Like a knowledgebase I guesss but more interactive in scope, funneling people thur some help steps. Basic flow: Dropdown: Please choose what you are having issues with - - Topic 1 - Topic 2 - Topic 3 With a new menu popping up for each Topic: - Topic 1 ---> Is the wifi button on --> Yes/No ---> heres how to try and fix it --> did it work --> yes/NO --> send a report to us -Topic 2 ---> Is the probe there --> yes/No ---> try this secondary location ---> yes/no --Out of stock? Send a report to us -Topic 3 ---> Here is how to restart the machine --> Did it work? yes/No ---> Link to some web material This seems like a conditional logic multi-step form, with rules hiding sections based answers chosen at each step, and HTML sections with any content/images/instructions. lnterestringly, there would be no atual data collecton. Anyone build something like this,or have some good ideas, leassons learned, etc? Thansk all!

Thanks for that answer! Cant believe I missed that. Never knew the small case vs large case "T" icon.

Thanks for the reply IIyrian, and sorry for the late response. It is interesting why mine is a mismatch. Verified both are TextArea (64000). But get 2088: Mismatch data type error. Obviously, Im missing something ;^) Doe the #insterted change things somehow? This is on an update trigger.

Thanks. And data that is already in the table from the old dropbox values is not affected. For example, if I delete a dropbox entry from the dropdown list table, then import the new table back in with new order and new entries, it doesntr remove data from the table where the records are stored. Like if I used to have a drop down ITEM A, and remove that dropdown choice, it doesnt remove all instancs of the old ITEM A from tables that used it?

Have a "Clear Search" button under some search fields on a DP. If you enter text in a field, and hit enter to search, it activates the Clear Search button instead of the Search button. Presumably just advances to next available field/button/option Is there a way to make the Clear Search button only activated by a mouse click? <button class="reset" onclick="window.location.reload()">Clear Search</button>