vanderLeest

Caspio should have the ability to trigger email notifications automatically in Caspio Bridge. Can I ask you, Carlson, to elaborate a bit about option 2 using JavaScript on a bulk edit form to auto generate the email upon URL open and use Windows task manager to schedule? More specific, an example for the JS, and how to refer to open/refresh a Caspio page in Windows Task Manager.

Thanks for your answer Douvega, I do hope Caspio will create a way to do this type of automated emails soon, so we don't have go through the hassle API's and third-party email delivery services

I am trying to create a pop-up child form in the form of a Tabular Report datapage, as I want the user to be able to edit information relating to existing contacts or add a new contact for the organization; the organization is unique and represented by Org_ID on the original Submission Form. For additional records, I hope to set the inline insert value for the organization to its Org_ID, which is the parameter I want to filter the report on. If at all possible I would like to hide this Org_ID, and show the organization name either in the tabular report or ever better in the report Header. The link to open a pop-up would be next to the select a contact dropdown on the Submission form.

Can you please share how you did this?

Thanks Brasovan, your comment put me in the right direction. I have created a multi-step trigger on the Awards table which generates the financial milestones for up to 6 years, and any shorter period in between, based on a set of IF statements and a calculated value of the next financial year end (and start of the next one); the budgets are attributed based on the total award divided by the number of months of the project duration.

Create a trigger that fires on insert on the submission table, and insert the records one by one in the destination table based on If statements for all available options.

Thanks MayMusic This worked great

This is surely an advanced version of tried https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/automatically-add-options-to-dropdowns-and-listboxes. Is it possible to do almost the same thing based on a report page for the lookup table? I have a lookup table with contact persons per institution. if the submitter selects an institution and the dropdown for the contacts does not list the perosn they want to associate with the current project. I would like the submitter to be able to add a new contact OR reactivate a contact, hence my attempt to base the lookup addition on a report (listing contacts for the institution) instead of a blank submission form.

I am trying to make a simple "Submit a Request" form, which will have fields like first name, Last name, email address, phone number, request, etc. Field names are like C_FirstName, C_Surname, C_Email, C_Phone, C_Request I want to validate text entries in the following fields as follows: First / Last name: No numerical characters are allowed Email Address : authenticate email according to https://www.w3resource.com/javascript/form/email-validation.php mobile no.: formatting and checking as per So far I have the phone script working, but my adaptation of the email script (or the combination of the two in the footer of the form) doesn't check the entry in the Email Address field. Any help sincerely appreciated Floris W3's ValidateEmail Script below: function ValidateEmail(mail) { if (/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/.test(myForm.emailAddr.value)) { return (true) } alert("You have entered an invalid email address!") return (false) } document.getElementById("caspioform").onsubmit=validateEmail;

I am trying to add via an Insert trigger a second row of data, based on the first row of data which is inserted by a trigger associated with another table. The Awards table has an start date and end date of the project, and on insert creates the first milestone in a Milestone table, based on the entered start and end dates for the Award. On insert of the first milestone, I would like to add (if at all possible) a second milestone if the remaining period for the period is bigger than 12 months (which is calculated in a formula field in the first record). I get a "Triggered Action cannot be enabled because it exceeds maximum nested level of 1" Error message. Any help appreciated

Thanks for your quick answer, MayMusic I sadly could not implement your suggestion as I need to calculate the End Date of Financial Year on a submission form, and a Caspio submission form does not have a calculated field option. I cobbled together (after much trial and error) a bit of javascript and added it to the Footer of the form: <SCRIPT> function setEndDateValue() { var today = new Date(); var entered = document.getElementById("InsertRecordStartDate").value; if (entered.length > 0) { today = new Date(Date.parse(entered)); var mm = today.getMonth()+1; var yyyy = today.getFullYear(); } if (mm > 6) { var yyyy = today.getFullYear()+1; } else { var yyyy = today.getFullYear(); } document.getElementById("InsertRecordMonths").value = mm; document.getElementById("InsertRecordFinDate").value = '06' + '/' + '30' + '/' + yyyy; } document.getElementById("caspioform").onsubmit=setEndDateValue; </SCRIPT>

I want to insert a the next 30th of June as a field value in a online form, based on the entered start date of a contract e.g. is the start date is earlier than 30 June of the current year, the value I need is 30 June this year, if the start date falls in July or later, is should be 30 June next year. (I need this date to do further calculations for milestone periods and budgets) I have tried to modify a few scripts dealing with related issues, but I cannot seem to make it work for this problem, I get either the wrong date format or no calculation/result at all Any help sincerely appreciated.

Hi lmooring What was the solution you came up with?

What I hope to do, is autofill a table based on submitted start and end date of a project. The routine to be developed should create a record in the Milestone table for each 6 months period the projects lasts. i, mx, dur as integer dur = Round((DateDiff("m",[SA_StartDt],[SA_EndDt])+1)/6+0.3,0) = number of records to be created For i = 0 to dur mx = i * 6 Proj_ID // Period_No // Period_StartDate // Period_EndDate // Budget [Proj_Recno] // i + 1 // DateAdd(month, mx, [SA_StartDt]) // DateAdd(month, mx+6, [SA_StartDt]) // [SA-Awarded]/dur) Can I set this up as a trigger action on the table? or do I need to write a bit of Javascript and add this to a button? In both cases, I would appreciate some pointers. Floris

T_EA_Entities stores for each Activity the Entities involved and a Contact Person for each Entity. Some Entities will have more than one Contact Person, and they will be entered as a separate record. The unique composite key for the T_EA_Entities table would be a combination of Activity_ID, Entity_ID and Contact Person. Data is entered in T_EA_Entities via a child form on the Activity Data Page. To run a combined chart and report that shows which Entities are involved with how many Activities (and links to details of the each Activity), I need a table for which the combination of Activity_ID and Entity_ID are unique, hence the name T_EA_Entities_Unique. On any record changes in T_EA_Entities, I want to update T_EA_Entities_Unique via a Trigger Action. To make this possible T_EA_Entities needs an Autonumber RecordNo field and a Formula Concat field combining Activity_ID and Entity_ID in a string, e.g. Right('000'+Str([@field:EAE_ID],Len([@field:EAE_ID])),6)+Right('00000'+Str([@field:Entity_ID],Len([@field:Entity_ID])),6) The table T_EA_Entities_Unique needs the RecordNo as a Number Field and the same Formula Concat field combining Activity_ID and Entity_ID. The following Trigger Action will add, delete and update the Activity Entity records in T_EA_Entities_Unique, when the records in T_EA_Entities are changed.