On Success form open another form and populats fields
Hi, I am a newbie and I am trying to develop an app for my business. One of the many problems I am facing ... :
1/ Form "New_Request" is the form where a fill up some basic info of a new client.
Among various fields I have "client_name".
2/ Form "Tour_Program" is the form where a build the tour program for clients.
In this form I have a field "Nome_cliente" (where I can select the name of the clients) lookup field of "client_name" in "New_Request" form.
In "New_Request" I created a checkbox field "Create Program". When I select this box and I Submit the form I would like to open "Tour_Program" form and populate "Nome_cliente" field (lookup field) with the value (string) of "client_name" field from "New_Request".
I tried different solutions but I always end up having data type error between "client_name" (string) and "Nome_cliente" (bigint). So, I understand the type of issue.. but I cannot figure it out the solution.
if(Create_program = True)
{
request_record = New_Request[ID != null];
name = request_record.client_name;
openUrl("https://creatorapp.zoho.com/xxxxxx/yyyyyy/#Form:Tour_Program?Nome_Cliente=" + name, "same window");
}
Any help ?