Propegate fields from 2nd form based on information in 1st?
Is there a way (deluge script perhaps), that I can propagate fields in form 2, with information from form 1, based on information in form 2?
Example:
Application to track favorite books and request feedback for similar types of books.
Form 1:
Person would enter their name and their 5 favorite books (that they could later change).
Form 2:
Tracks current books being read.
In form 2, I would like to have the first field be user.name. Then, do a lookup in form 1. If the same user name is found, return the results for the 5 favorite books into form 2. If no record matched, then in form 2, those next 5 fields would be left blank and the person would manually enter them. The final field in form 2 would be current.book.
Is this possible?