How to insert multiple selected records from a report into subform of a form in zoho creator?

Question

I am developing a simple site inventory application in zoho creator. There are 2 forms in this case. Form A: Material request .This form has a subform with fields for product and quantity ,Form B: Purchase Order.Has a subform with fields for product and quantity In the purchase order form, I have to select the approved requests from the form A's report and after clicking 'create purchase order' button in that report , it should lead to the purchase order form and should auto populate the product and quantity fields. How can I take multiple records and insert them into just one form?

I tried scripting a few times. But I don't think my logic itself is right. Is there any way with which I would be able to auto populate the subform based on multiple records?

please share the form screenshot and some sample script for better understanding on the requirement — Prabal Kanti Sarkar
– Prabal Kanti Sarkar, Commented Dec 10, 2024 at 11:48

Darshana Mohanan · Accepted Answer · 2025-01-31 09:37:55Z

0

Explaining the question and answer a bit more clearly here. Question: How to create one purchase order for multiple material request records? Answer: Create a button on material request report and create a function for that button. Give an argument name (eg:records) and choose their type(material request)

po_id = records.ID;
   openUrl("#Form:Purchase_Orders?Request_ID=" + po_id,"same window");

In purchase order form, make sure to have a multiselect lookup field to material request form. Here Request_ID is a multiselect lookup field. Then, create a workflow for the load of the purchase order form to auto populate the details of the records selected.

answered Jan 31 at 9:37

Darshana Mohanan

32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert multiple selected records from a report into subform of a form in zoho creator?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related