Hi Sir, I have created a form where i am generating an ID(Unique) that id will flow to next form that is done if we are creating for first time. But ex: In 1st form i have created 10 records but i din’t entered data in 2nd form i want to do it later ,now by clicking on edit button of the 1st form interactive report then i will move to 2nd form but i want the same id to be reflect in the 2nd form how can we get the same filed id using session or anything else.
When i edit A41 i am able to edit it for 1st form but when i move to 2nd form then it is picking the last record that is in 2nd form ie., A61 but i need A41
In your form-1 interactive report add a new column as a link or make an existing column, for example, ID column (A41) as a link and open the form-2 from that link by passing the ID value to the item in form-2.
Below is the screenshot for the link column settings:
Assume, page 28 is your second form, and the page item P28_FUNCTION is the PK ID column to which you are passing the #ID# value.
Please let me know if my understanding is right for your requirement.
Thnx sir,this is done but i am moving the same id when i am creating in 2 form one by one in form 1 when A41 is created it will automatically go to form 2 (select VOLUNTEER_ID as display_value, VOLUNTEER_ID as return_value from V_REGISTER) but when i am applying your logic also i am getting the A61 as before ,if i am removing this(select VOLUNTEER_ID as display_value, VOLUNTEER_ID as return_value from V_REGISTER) then i am getting correct in interactive report
So what exactly your issue now? Please explain to me in simple words (straightforward).
i have created two form (form 1 and form 2) when i enter data in form the id is auto created and the same id will be reflect in 2nd form (in id field i have written query
(select VOLUNTEER_ID as display_value, VOLUNTEER_ID as return_value from V_REGISTER) to get the id from the form 1 and once i click on create button that id will store in form 2 table.
for ex:if i have created 10 record in 1st form and i skipped 2nd form ,but later i want to enter data in 2nd form by click on id from 1st form where i have left, like record no 2 i want to enter but when i am moving to 2nd form it is fetch last id i.e., 10 from 1st form.
It is assigning the wrong ID because you are using the wrong approach to get the ID from the form-1 table using the SQL query.
If you want to open form-2 later, then give an option to open it from the interactive report using the link I explained already. This is only the right method.
To pass the data from form-1 to form-2 at the same time, follow these steps:
Click on the Process tab, then click on the Branch node and create a branch to go to the form-2. And when you will create the branch don’t forget to pass the ID to the form to as I suggested you above.
Now what will happen is, when the user will submit the form-1, then after submit it will automatically redirect to the form-2, with the parameter value, you specified in the branch.
ok but if want to enter data in form 1 and form 2 at same time then how to get the id from form 1 to form 2
I want to create an I’d(auto generate) in form 1 and that I’d should flow to form 2 Now i am Creating the same in form 1 when I will click in create button after filling all data that I’d is visible in form 2.
Thnx sir its worked plz leave the last question thanx alot