Hi,
Let me start with I am very new to Creator.
I have a view that list all requests for an agreement with custom actions, one of these links to the function below. Once the "Complete" custom action is clicked, I want to add a record to the
NDA_Details_Form so that the new record is linked to the same customer. Then it opens that new
NDA_Details_Form record that was just added for editing.
I do not want to use a subform on the
Request_NDA_Form because after the request is complete, I will delete that request record.
The problem is that the recordID seems to be acting like a string and the URL created is as follows:
- void ndaStatus.completeNDA(Request_NDA_Form record)
- {
- record.Status="Complete";
- insert into NDA_Details_Form
- [
- Added_User=zoho.loginuser
- Customer=record.Customer // In the Request_NDA_Form this is a lookup to a Customer Form
- NDA_Type="Standard MNDA"
- ]
- recordID = NDA_Details_Form[ID != 0] sort by Added_Time desc;
- // openUrl("#Form:NDA_Details_Form?recLinkID=" + recordID + "&viewLinkName=NDA_Details_Report","same window");
-
- openurl("https://app.zohocreator.com/" + zoho.adminuser + "/" + zoho.appname + "/NDA_Details_Form/record-edit/NDA_Details_Report/" + recordID + "/","same window");
- }
The following help page states that this is how fetch the ID of the last added record but it is not working. The forum posts on this say the same thing.