Autofilling a text field based on text from multiple other text fields
Hi, I am a simple forester, not a programmer, but I have some basic skills where I can possibly suss out what I need to add to a script to make things work. Every year we have to fill out applications for out clients. These applications are the same every year and consist of 4 pages that have common text fields among them. We have a script for most of these to auto-fill when the information is added to the first page, it will auto-fill on the subsequent pages. These applications are to get a tax break for landowners' property taxes. There is a line on the application for Block(s) and Lot(s), allowing for one to add multiple block and lots for one landowner as long as these lots are contiguous. This Block and Lot line is on the Application, supplemental form, and lastly, on the Woodland Data form. The conundrum comes into play when some Tax Assessors, in their ultimate wisdom, require a landowner to fill out a separate Application and Supplemental form for each individual lot, while only requiring on Woodland Data form for the whole property, thus making the Woodland Data form basically a summary for all the applications of the individual lots of the contiguous property. My question is, is it possible for us to autofill the block and lots on the woodland data form gathering that information from the multiple Block and Lot fields of the individual Applications.
example: John Doe's property consists of Block 1 Lot 1, Block 2, Lot 2, and Block 3, Lot 3. He must fill out a separate Application for each of those lots, but he only needs 1 Woodland Data form that gets turned in with the 3 applications, that lists all three lots onto one line. Is there a script that can be written that links the Block and Lot line from the 3 applications and autofills them as a list on the 1 Block and Lot line on the 1 Woodland Data form?
