-
Content Count
384 -
Joined
-
Last visited
-
Days Won
37
Everything posted by Vitalikssssss
-
Pivot Table... well maybe?
Vitalikssssss replied to Roosta's question in Tables, Views and Relationships
Hi @Roosta, I assume that you see "Error in Formula" because one of the divisor results in zero. You need to add CASE check in order to avoid division by zero. It can look like this: ([@calcfield:1]/ (CASE THEN [@calcfield:9] = 0 THEN 1 ELSE [@calcfield:9] END) )*100 Hope this helps. Regards, vitalikssssss -
Expand Autocomplete Dropdown To More Than 10
Vitalikssssss replied to davidhshugar's question in General Questions
Hi @davidhshugar, I do not think it is related to XML of the Datapage. Do you see this issue on Datapage direct URL? Can you try applying a different theme for the Datapage and verify the result? Regards, vitalikssssss -
Date Range on Submission Form
Vitalikssssss replied to Elderberg's topic in User JavaScript and CSS Discussions
What is the purpose of this script? Sorry, it does not make any sense to me. Regards, vitalikssssss -
Date Range on Submission Form
Vitalikssssss replied to Elderberg's topic in User JavaScript and CSS Discussions
Hi @Elderberg, I am not sure why you need Date to be saved as String, but anyway you can simple change the datatype for the field "Date". Regards, vitalikssssss -
Date Range on Submission Form
Vitalikssssss replied to Elderberg's topic in User JavaScript and CSS Discussions
Hi @geoffdude, It is available in 20.0 Caspio Bridge version. Probably your site has not been updated yet to 20.0 Caspio Bridge version. You can check your Caspio Bridge version within your account: from the top menu bar HELP --> About Caspio Bridge. Also, you can check Caspio Twitter for latest information about system updates. Regards, vitalikssssss -
How do you port applications to multiple platforms?
Vitalikssssss replied to EmilGrier's question in General Questions
Hi @lypoextract, You can use import/export of application if you would like to transfer it to different account. Here is a documentation: https://howto.caspio.com/apps/exporting-an-app/ Hope this helps. Regards, vitalikssssss -
Hi @Ed727, I assume that you have both Datapages deployed on a web-page with an embed method. You can use a JS which clicks on Submit button if my assumption is correct. Here a a code which you can use on web-page: <script> function submit () { document.querySelector("input[id*='Submit']").click(); } setTimeout(submit, 5000); </script> Hope this helps. Regards, vitalikssssss
-
Change Textfield Color
Vitalikssssss replied to Johnn's topic in User JavaScript and CSS Discussions
Hi @Johnn, Yes, it is possible with CSS. Here is an example of CSS code. It should go into Datapage Header and also make sure that you disable HTML editor. <style> input#InsertRecordYOUR_FIELD_NAME { background: #008000; } input#InsertRecordYOUR_FIELD_NAME { background: #00bfff; } </style> Replace "YOUR_FIELD_NAME" with your actual fields name and change the color according to your preferences. You can use this color picker. Hope this helps. Regards, vitalikssssss -
Date Range on Submission Form
Vitalikssssss replied to Elderberg's topic in User JavaScript and CSS Discussions
Hi @Elderberg, I can suggest using a simple Dropdown or Listbox for date selection and a lookup table which will be updated via Tasks on daily basis. Here is an example of Task which adds yesterdays, current date, and tomorrows date on daily basis. You may also import this Task from attached archive. Hope this helps. Regards, vitalikssssss CaspioData_2019-Dec-02_1638.zip -
Hi @BFuchs Did you place the code into Datapage Header? HTML editor was disabled? This code is designed for Tabular report Datapage. Send me a URL of the web-page via private message, so I could take a look. Regards, vitalikssssss
-
Hi @BFuchs, Try using complex css selectors as per below: <style> td.cbResultSetData.cbResultSetTableCellNumberDate.cbResultSetCalculatedField { color: blue; font-size: 20px; font-weight: 1000; } </style> Hope this helps. Regards, vitalikssssss
-
Expand Autocomplete Dropdown To More Than 10
Vitalikssssss replied to davidhshugar's question in General Questions
Hi @davidhshugar, I think I will be able to help you with this. Please send me an exported XML of the Datapage. Regards, vitalikssssss -
Inner or outer Many to Many Relationship
Vitalikssssss replied to GWBjr's question in Tables, Views and Relationships
Hi @GWBjr, I assume that you would like to populate the table "MSA_Lender_Offering" with all possible combination of ID`s from "Lenders" and MSAs_ tables. If my assumption is correct than you can use Tasks to achieve this. Here is an example of Tasks which populates all possible combination of ID`s from Table_A and Table_B. Hope this helps. Regards, vitalikssssss -
Mouse Hover Popup that shows field parameters
Vitalikssssss replied to Ras2019's question in Styles and Localizations
Hi @Ras2019, Recently, I have came across the web-site of Caspio Technical Evangelist Ned: https://someapp.com/np/apps/workflow/index.html He has an article which explains how to create a Tool Tip in Caspio: https://someapp.com/np/apps/workflow/tooltip_popup.html Hope it helps. Regards, vitalikssssss -
Add text field entry to a text area
Vitalikssssss replied to RickManolo's topic in User JavaScript and CSS Discussions
Hi @RickManolo, Well, for me the easiest way to do this is to use a Virtual field to display "Notes" and make an actual field "Notes" as hidden. I assume that you use Single Record Update or Details Datapage. If the answer for above is yes, you can use the following JS code to concat existing Note with AddNote input after Update of the record. <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function (event) { let target = document.querySelector('[id*="EditRecordNotes"]'); let n_notes = document.querySelector('input[id*="EditRecordAdd_Note"]').value; let o_notes = document.querySelector('input[name*="cbParamVirtual1"]').value; target.value = o_notes + n_notes; }); </script> Change the name of the fields if necessary, and also make sure you disable HTML editor prior to pasting the code. Hope this helps. Regards, vitalikssssss -
Hi @Yolanda, You can find answer in this blog post: https://blog.caspio.com/update-on-caspios-data-transfer-policy/ Regards, vitalikssssss
-
Hi @mgredmond, Well, it is better to bring your concerns through Caspio Support. Here is a Style attribute which controls width of the Tabular Report.
-
Automatically focus cursor on first field... inline edit report datapage
Vitalikssssss replied to blarney's question in DataPages
Hi @valentid, Try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('input[id*="InlineAddWristbandID"]').focus(); }); </script> Regards, vitalikssssss- 6 replies
-
- focus curson
- javascript
-
(and 1 more)
Tagged with:
-
End user bulk import via data page
Vitalikssssss replied to Mikey's question in Import/Export and DataHub
Hi @Mikey, I am afraid that this feature is not available in Caspio and I doubt that you will be able to find and easy workaround. I have found a feature request in Caspio Ideabox where you can give your vote for this feature. Alternatively, you may consider using shareable Google Sheet where users can copy/past the data and Zapier to sync this spreadsheet with Caspio. Please note that only Premium account in Zapier allows to have near real time sync with Caspio. Free account has 5 minutes interval to perform a Zap. Hope this helps. Regards, vitalikssssss -
Hi @eventshd, You are doing correct steps in the email setup, however you trying to render field name as Email link i.o. field email. Hope this helps. Regards, vitalikssssss
-
Hi @mgredmond, Caspio Style has a default settings for the width of the Datapage set to 100% which overrides the field width settings. You need to check the width of the container where you placed in your CMS and adjust width of the Datapage accordingly. Hope this helps. Regards, vitalikssssss
-
Hi @mgredmond, If you don`t have any sensative data, can you share with us a link to this Datapage or web-page? You can restrict the width of the Datapage as explained in this article: https://howto.caspio.com/styles/fix-the-width-of-the-datapage/ Regards, vitalikssssss
-
Auto Assigning to Files
Vitalikssssss replied to LoriM's question in Security, Authentications, Roles, SAML
Hi @LoriM, I think this is possible. Authentication with a User groups explained in this tutorial: https://www.youtube.com/watch?v=X8HZC3mBSPg You may consider using Triggered action for assign the roles to the client. Basic Triggers explained in this tutorial: https://www.youtube.com/watch?v=wA7KR9dygh4 Hope this helps. Regards, vitalikssssss -
Passing sensitive data from Result Page to Web Form
Vitalikssssss replied to Ras2019's question in Parameters
Hi @Ras2019, That is true, you cannot pass parameters via Bridge session from Result page. I think this is the best option for your case. Regards, vitalikssssss