Using One Forms Data to Populate Related Forms

Chris McFarland

June 12, 2015 14:33

Hello!

I'm working on my first Frevvo data connected forms project, and while I'm an experienced operator in databases of many flavors, I'm really new to this mode of operation and so far I haven't found support or documentation that breaks down what would seem to be a common way for a forms system to be built out.

Here's what I'm trying to do:

My project is a suite of forms making up the admissions/registration packet for a school.

The first form will be the Student Registration form, and it will have the most data of any of the forms.  It's pretty comprehensive.

SO, given that, once that first form has been submitted I'd like for all the other forms that will come up in the flow to have any fields on them that match data pulled in from that first form to auto populate.

At this point I don't even see all the data anywhere in the GlobalForms tables, so I'm a little adrift here.

What do you think?

Thanks!

 

Christopher McFarland, MCTS, CDIA+   Manager, Production & Solutions   (713) 329-9909   CMcFarland@dahill.com   www.dahill.com

0

• 

  Prajakta

  June 15, 2015 14:07

  Please see this documentation about linked flows. I think this is what you are looking for.

  I would recommend that you go through the frevvo workflow tutorial which covers a lot of functionality in the flow designer. That should help you get a pretty good understanding of how to design frevvo flows.

  0
• 

  Chris McFarland

  June 15, 2015 17:25

  Perfect!

  I'm going through the DB Connector Tutorial now, and it is helping a lot.

  Things are definitely coming together, as my database operations are passing their tests and writing the various files and URLs/URIs seems to be on track.

  Writing a Rule to pass on my key data to the query is my present step, and if that goes right I'll have a simple data interaction that works, and can branch out from there.

  I can see how I may end up using an UPDATE operation to pass off the cardinal form's data to a table and then having the subsequent forms read from that in order to populate themselves.

  So, I'll check out that tutorial and keep moving along one step at a time.

  Thanks!

  0
• 

  Chris McFarland

  June 15, 2015 21:00

  OK, here's something that you may be able to help me with...

   

  So, in the typical fashion I'm cobbling together my solution from a bunch of tutorials that are semi related.

  Here's my angle:

  I first want to keep it super, super simple  and have a single field (SSN) bring back the Name associated with that SSN.

  All my data elements test perfectly, and in the catalina.log file I can see my data transaction being process perfectly.

  Everything checks.  The SQL bit can be copy/pasted from the log file for a good return, and the URL that I used to generate the schema will pull perfect data when punched in with normal GET syntax.

  I generated my XSD file, loaded in the schema and then pulled it into my form.

  I hit the '+' symbol to create some controls, and they show up.

  I created my Manual URI string, and that looks awesome, too.

  Sounds great, Right???

  So, what's NOT happening is that my controls are NOT populating with data.

  I must be very close!

   

  What do you think?

   

  Thanks!

  0
• 

  Prajakta

  June 16, 2015 14:10

  Please confirm that you have configured the Doc URI for the schema document and not the default document that is present for palette controls:

  

  Please see this documentation for full details.

  0

Please sign in to leave a comment.