All Activity

This stream auto-updates     

  1. Today
  2. I originally asked for help with this problem back in 2016 and I received a reply that worked at the time. But now for some reason it does not work anymore and I could use some help. I have a telephone number formatted as follows: +17035551212 and it is in a field named [mobilenumber] I want to remove the first two characters so the number looks like: 7035551212 and then insert this number in a field called [mobilenumberten]. For some reason I just cannot get it to work anymore on my submission form datapage. Any suggestions would be helpful. Thanks in advance.
  3. Thanks so much for your quick reply with a nice example. I have tried to implement it, first by selecting top 1 based on two fields, Activity_ID and Entity_ID, however that did not work. Next I created a formula field in the tables T_Entities and T_Entities_Unique, which would result in the same concatenated ID in both tables for Activity_ID and Entity_ID combined, concatenated ID, which can have multiple values in T_Entities, but only a unique value in T_Entities_Unique. Sadly, the following Trigger Action does not result in inserting unique values in the T_Entities_Unique table, i.e. no values are added when updating an Entity in T_Entities. Any assistance will be sincerely appreciated as this logic (when working) will be appropriate for many use cases.
  4. Yesterday
  5. Two Step Submission

    On a Submission form I would like a button to validate all fields and records and run my imbedded HTML in my footer, similar to the checking of fields when the submit button is executed. When this checking button is executed and successful a confirmation of all details appears and the final execution button appears with the data and a submit button can be executed and insert the record in the table. The reasoning for this is I have some front of sales people who may at time enter incorrect information and I want them to check their entries prior to a final submission execution to the table. Possible??
  6. Last week
  7. Hi DesiLogi, I am afraid that you are correct.
  8. Try to redirect user to another URL and close the window on submit, You may try using the following code in the footer of the datapage: <script> document.getElementById("caspioform").onsubmit=function() { window.open("URL"); window.close(); } </script> Don't forget to specify your URL instead of URL. Cheers!
  9. ssue: My trigger action is not processing the ssue: My trigger action is not processing the Having statement in the Where clause. I barely know SQL and while the 30 minute Caspio webinar on Trigger Actions was helpful, the action I am attempting was not covered. I have a parent table and a child table, their common field is NTAID. I am trying to use a trigger action on Inserted/Updated/Deleted to quantify the number of records in the child table for the NTAID and assign a category to each parent record. The purpose of the categories is I need to use the field in the parent record to create filter views of the parent table for another data page. Some portions of my Update trigger actions work - I have four Updates. The Update for categorizing "Regional" is not occurring under any circumstances, and "Local" categorization is occurring even if the Count in the Having clause exceeds the limitation. I reversed the order of these two Updates and that did not alter the outcome. The other two updates run flawlessly. I appreciate any assistance in the proper set-up of these trigger actions. Thank you! I barely know SQL and while the 30 minute Caspio webinar on Trigger Actions was helpful, the action I am attempting was not covered. I have a parent table and a child table, their common field is NTAID. I am trying to use a trigger action on Inserted/Updated/Deleted to quantify the number of records in the child table for the NTAID and assign a category to each parent record. The purpose of the categories is I need to use the field in the parent record to create filter views of the parent table for another data page. Some portions of my Update trigger actions work - I have four Updates. The Update for categorizing "Regional" is not occurring under any circumstances, and "Local" categorization is occurring even if the Count in the Having clause exceeds the limitation. I reversed the order of these two Updates and that did not alter the outcome. The other two updates run flawlessly. I appreciate any assistance in the proper set-up of these trigger actions. Thank you!
  10. How to change start of weekday in calendar

    Hi Andre, I would recommend checking that French (Canada) region is selected in your localization. Week starts from Sunday for this region. Hope that helps
  11. Re-Enter Password on Submit

    Hi brandon, You can enable a confirmation field in field settings. regards, vitalikssssss
  12. Limit access based on jobsite

    Hi mdav20, You can use filter the records based on pre-defined criteria via authentication parameter "jobsite" and use " If empty, ignore criteria" filtering option in order to allow managers to view all records. Hope this helps. Regards, vitalikssssss
  13. Hi Moritz, 1. You can hide submit button by placing following CSS code in Datapage header. <style> .cbSubmitButton { display:none; } </style> 2. You can use an HTML block and display the message via innerHTML Property. Hope this helps. Regards, vitalikssssss
  14. Hi vanderLeest, This can be achieved by using Joins with #inserted and table which has multiple records under same Id`s as inserted but "Select distinct" will restrict the output only to one record. Here is an example of the Triggered action which will insert unique records into the separate table: Hope this helps. Regards, vitalikssssss
  15. Adding Business Days to a Date Field

    Hi, this solution requires creating a sql function, which is not possible in formula or calculated field. I usually post my requests which fall out of standard behavior here, you may post your idea there as well
  16. Hi, you may try specifying an URL where both datapages are deployed on the Destination and triggers screen of the submission form (select go to a new webpage option) Also you may insert a record directly on a report using inline insert feature. You may find more details here
  17. Hi all

    Hi, you may check this section. If you'd like to create a login screen, have a look at this and this article.
  18. Since the CB 10.0 upgrade Ive been updating all the deploy codes in my datapages utilizing the new Asynchronous DataPage Deployment Method (a noticeable pageload improvement over the legacy deployment method, plus no more chrome deprecated warnings in the console Thank you for this improvement Caspio). One problem I am faced with now is I have several tabular report pages that conditionally load link buttons dependent on the status field of each row. With the legacy page deployment I was able to perform this with the following script in an html block... <script> var stat = '[@field:Status]' if (stat == 'Assigned') { document.write('<a class="recordActions" href="assignedwopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]&stat=begin">View/Open WO</a>'); } else if (stat == '~Suspended') { document.write('<a class="recordActions" href="resumewopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]">Resume WO</a>'); } else { document.write('<label>WO Pending Review</label>'); } </script> -------------------------------------------------------- The innerHTML solution I came up with to replace the document.write follows... <div id="linkto"></div> <script> var stat = '[@field:Status]' if (stat == 'Assigned') { document.getElementById("linkto").innerHTML = '<a class="recordActions" href="assignedwopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]&stat=begin">View/Open WO</a>'; } else if (stat == '~Suspended') { document.getElementById("linkto").innerHTML = '<a class="recordActions" href="resumewopage.html?on=[@field:WO_Num]&at=[@field:Assigned_Tech]">Resume WO</a>'; } else { document.getElementById("linkto").innerHTML = '<label>WO Pending Review</label>'; } </script> Apparently this does not work because the “linkto” div is an html collection within the html block and improperly assigns the last read value to only the first row in the table. I tried a createElement method along with several other ideas all with the same results. Can anyone please inform me on the proper method to perform for the desired result of displaying a link button conditionally in a report. Thanks in advance for any and all suggestions.
  19. I have a webpage with both a submission form and a report. Upon submission of a form, I would like the report to automatically refresh. Does anyone have script to refresh the entire page upon submission of a form?
  20. Hi all

    I was wondering if I require user login / registration template for my website is there any tutorial on how to achieve this please? Will ever be so great!
  21. I would like to have access limited to records based on jobsite but also allow certain users to see all records (managers). So say user1 is a jobsite worker, he needs to only be able to see his jobsite's records. The area manager who is in charge of multiple jobsites needs to be able to see all records no matter what jobsite the record is tied to. I currently have user_Authentication table with a field named jobsite and user level security linked on the datapage which works good for the jobsite workers but the managers can't see anything since they don't have a value in the field jobsite. I don't want to have two datapages if possible. Thank!
  22. Hi all, I'm a newbie and would like to know if it is possible to create a hyperlink within a calculated field? Any help is greatly appreciated. Thank you
  23. I aim to add unique values in a support table on which I hope to build a graphical report On Insert into the T_EA_Entities table (which is child table linked to the main Activities table, and data is entered via a child form on the Activity Data Page) I want to insert unique Entity IDs associated with the Activity stored in a separate table called T_EA_Entities_Unique. NB: T-EA_Entities stores nect to Entities also sometimes multiple contact persons for an entity (= multiple records) I have attached the Trigger Action. This Action only adds one Entity ID to the T_EA_Entities_Unique table, instead of the multiple who are entered via the DataPage in the T_EA_Entities table. Does anyone have an idea how to modify the Trigger Action so it will add multiple values to the table?
  24. That's what I'd thought. So to be clear, if a record is updated in a table it's impossible to update another field in that record OR other records in the same table?
  25. Hi DesiLogi, I am afraid that you cannot use Update block with the same table as the one on which you have built Trigger Action with event "update" because it will create an infinitive loop of Trigger execution. Regards, vitalikssssss
  26. Hi Vitaliksssss, Thanks for the help with the insert Update issue. That works well- I couldn't figure out how to get it to do that. Now the last thing I need to do is create a trigger for when the table is Updated (meaning the user updates an existing record's 'Use_This' to 'True') to update all records in the same table, with the same CompanyID and InvoiceID but NOT the same RequestID (the unique ID value)- because that would be the record being updated manually. Basically, so if a user marks one record's 'Use_This= True' then all other records in the same table (with same CompanyID and InvoiceID) are marked 'Use_This=False'. So there can be only one record with Use_This=True for any given InvoiceID. I think it would be similar to the first part of the trigger but running on Update. Problem is I keep getting 'Nested' error messages when I try to update the same table I'm running an Update trigger on. I think once I get the fundamentals worked out like in this issue the Triggers will make a lot more sense. Thanks very much for your help on this, I really appreciate it.
  27. Hi DesiLogi, You should use an Update block instead of Insert block if you would like to set the field 'Use_This' to 'True' for the new, inserted record. Here is an example: This Trigger should do the trick. I am afraid I have no idea of such Trigger behavior for another issue which you have discovered. I think it is better to ask Caspio Team about the reason for this odd behavior. Regards, vitalikssssss
  28. Hi vikovs, I tried this and it helps, thanks. I could sort of achieve what I was trying to. However, the Caspio system seems to have some severe problems. After setting up along the lines you suggested, I deployed to my browser and it worked. But then I needed to go back to make an edit. When I went to make the edit, one of my Rules was no longer there. It vanished into thin air. So I deleted all the Rules, logged out, logged in. Did the same thing again. Deployed and tried in my browser. Again it worked. I then went back to make more changes. Once again a Rule had disappeared. It's hard to imagine a system that's been around for a while could be this flakey. I mean, this is fundamental. I went back and repeated the process and took screen shots. Appending them here. The screenshots are timestamped - you can see when I go back at 9.44 to edit, Rule 3 has VANISHED. I didn't change anything at that stage - simply went back to the Rule page so I could edit, only to find my Rule GONE!!!
  1. Load more activity