Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Hello @walkerc You need to insert the following code into the footer of your result set: <script type="text/javascript"> function inputHandler(event) { if (document.getElementById('clicked')) { let clickedElem = document.getElementById('clicked'); clickedElem.click(); clickedElem.id = ""; } event.target.id = "clicked"; } function assignEvent() { let elems1 = document.querySelectorAll('tr[data-cb-name="group1"]'); let elems2 = document.querySelectorAll('span[data-cb-name="switch-group-state-btn"]'); for(elem of elems1) { elem.addEventListener('click', inputHandler); }; for(elem of elems2) { elem.remove(); }; document.removeEventListener('DataPageReady', assignEvent); } document.addEventListener('DataPageReady', assignEvent); </script> Prior to insert the code, you need to disable the HTML editor of the header. You can do this in the Advanced section of the footer.
  3. Hi @walkerc, You will not be able to build a View with desired output because Joins cannot be configured with OR logic. I can suggested using a filtering criteria on Datapage in order to show the records from Main_Data table to the Contractor. You should use a Main_Data as a data source for your Datapage. Also you should enable authentication which based on "Contractor_Data" table for this Datapage. Finally you can use the following filtering logic: P.S. use TradingName i.o. Record_ID from my sample. Hope this helps. Let me know if you have any questions. Regards, vitalikssssss
  4. @JanineB Hi! Here is the up to date formula considering new Timestamp function: DateDiff(year, [@field:Date], SysUTCDateTime()) - CASE WHEN SysUTCDateTime() > DateAdd( year, DateDiff(year, [@field:Date], SysUTCDateTime()), [@field:Date] ) THEN 1 ELSE 0 END
  5. Hi @GrahamMoore, You may consider using Weebly (my choice), Yola, WordPress (wordpress.org). Hope this helps. Regards, vitalikssssss
  6. We can easily upload our location in google maps, To do that if anyone like your friends etc,.. is in that location they can share the live location from that exact spot. Through this way we can trigger the exact geocode in google maps.
  7. Yesterday
  8. You can also put this in your Footer if you are using calculated fields to manipulate the styles: <script> document.querySelectorAll(`[action*="[@cbAppKey]"] .cbResultSetCalculatedField`).forEach(function(elem) { if(elem.innerHTML == "Not Available") elem.style.color = "red"; }) </script>
  9. Hi, apologies but not sure my title explains exactly what I'm trying to achieve! I've got 2 tables - Main_Data and Contractor_Data, I've then created a details data page where I have included 3 drop down fields. The user can then select a Contractor (TradingName) using the drop downs from the Contractor_Data table which then become Contractor_1 in the Main_Data table, the same then for Contractor_2 and Contractor_3 - this all works fine. So I have created a view so each contractor can log in to see their respective jobs, I have linked the tables using Contractor_Data.TradingName = Main_Data.Contractor_1, this also works fine - Contractor_1 logs in and can see all the jobs under Main_Data.Contractor_1. Now the problem I'm having and hope that you might be able to help with, the jobs where we allocate more than 1 contractor (total of 3 on any one job) those contractors are unable to see their jobs as the view is only linking Contractor_1 so I added to the view - Contractor_Data.TradingName = Main_Data.Contractor_2 and Contractor_Data.TradingName = Main_Data.Contractor_3 and in the criteria tab set them as OR thinking that whatever position the contractors TradingName appears he should be able to view those jobs. The result I get is 'No Results' unless I enter the same TradingName in all three fields. What I want to achieve is that a contractor can log in using TradingName in auth field and then see all jobs allocated to them irrespective of whether they are either Contractor_1, 2 or 3 Hoping I've made sense?
  10. Hello @SteveP, Please refer the code in this post: https://forums.caspio.com/topic/7824-hide-columns-on-tabular-report-when-empty/?tab=comments#comment-23918
  11. I have been using WIX for a website. What is the best website builder to use, when working with Caspio, multiple pages and query strings, many tables.
  12. Last week
  13. Many thanks for your reply @Vitalikssssss What a huge shame this is, and a strange omission by Caspio given that values can be looked up in HTML blocks, JS code, etc. I appreciate your advice with the View and I'll follow it, but it's going to be detrimental on performance as my records run to the low millions. How I wish Caspio would expand its sql capability in calculated fields. Best Farnsbarnes
  14. You could deploy the two DataPages in one web page and check this article for your desired workflow: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/results-and-details-on-two-separate-web-pages/ I hope it helps!
  15. You can refer to Caspio's link menus and pop-up window generator here: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/ I hope it helps!
  16. Thx kpcollier. My brain always goes direction that I screwed up some code somehow. Will start referencing that Known Issues more. I do think internally they would have a hot topic/issue awareness about that
  17. If you go to their HowTo page > Troubleshooting > Known Issues you will find it. Yes, you have to dig pretty far to even see it. I agree they should've sent out a message. I spent an unruly amount of time trying to fix this issue. Not only, but I was talking to Live Chat about this issue, and they had no clue about the issue until I pointed them to the post on their HowTo page...
  18. Hi @Farnsbarnes, I am afraid that it is not possible to reference a look up value with any syntax. I can recommend creating a View to join your tables (parent child) and use this view as a datasource for the Datapage. You will be able to reference the parent field by using a parameter picker. Hope this helps. Regards, vitalikssssss
  19. I need create a webpage with 2 datapages, the second being the results of a search using a field from the first datapage. How could I do this?
  20. Hello @AnisDuncan, You may find related posts on the Forum . Please, follow this links to articles:
  21. Hello @Emilaos Can you provide some more details about your workflow?
  22. Hello everyone, I'm quite new to this forum and I have a question which is needed to answer. How do I code a JavaScript pop up window?
  23. Does anyone know how to access the display value of a field when using a formula inside a calculated field with sql? The critical line for me is below. In my table the field 'Column_values' is referenced to another table, but displays text in place of the underlying reference data. So far I can only manage to access the references, not the text display values. WHEN CHARINDEX('[@myexample]','[@field:Column_values]') > 0 THEN ... Other than the above I've tried '[@lookupfield:Column_values]', '[@lookupvalue:Column_values]', and all kinds of other combinations, but I just can't get the right syntax. Any help much appreciated.
  24. Needs to be emailed out as an important FYI. People can waste hours/days trying to figure it out when there is an easy platform specific solution. Had NailDylan not responded to my post I would have spent days trying to figure it out. I was already a few hours in ;^) Maybe there is an important announcement area I just dont know about? Just my $0.02
  25. If you only have small amount of records, it is easier to remove those unwanted addresses. However, as your record grows vast, it will start become troublesome locating and deleting those unwanted addresses. This workflow will surely be helpful.
  26. I just want to share this. If you ever need to prevent your triggered action/ task on sending emails/sms on certain numbers. You can create a table which contains all those unwanted email addresses/ phone number and create a blocklist. It is just an extra condition on the where statement if you used a 'select from' block. Hope it helps...
  27. Yes, you just have to concatenate with a semicolon in between. Kinda like this one: This one is on task, but I am sure you can easily have it converted to trigger.
  1. Load more activity
  • Create New...