Get data from Edit Input Box

jeremycheong1993

Forums

Hi, I am very new to programming and would like to know how i can use data being entered into edit input boxes in my code.

jeremycheong1993 Mon, 03/12/2018 - 22:28

Actually yes Brian i do,
 
I was wondering if it is possible to extract fields that i upload which are not part of the idea interface or user input.
 
Cheers! :D

Brian Element Tue, 03/13/2018 - 06:33

Hi Jeremy,

I am not sure I understand what you are looking for.  Can you give an example and I will try and help you out.  When you talk about extract fields do you mean extracting fields from one database and placing them in another database?

Brian

jeremycheong1993 Mon, 03/26/2018 - 21:32

Hi Brian,
I guess the right term is that I am trying to do a v lookup between 2 databases. I do not know how to code such a thing.
Example:Database A has field 1,2,3
Database B has field 1
 
Desired result: Database B has field 1,2 and 3
Thanks for the help!
Jeremy.

Brian Element Tue, 03/27/2018 - 07:10

Hi Jeremy,

Sounds like you want to perform a join.  CaseWare Analytics has a video on this (https://www.youtube.com/watch?v=xv_PaGW9_9Y&index=12&list=PLEE1l8LoXUCL…)

Select the join function, since you want to add the fields from Database A to Database B, Database B would be your primary file and Database A would be your secondary file.  Your match would be field1 as they are the commen field between the two databases.  For the type of join I would probably recommend All Primary Recrords as this will return all records even if they don't have a corresponding transaction in Database A. 

Let me know if you have any problems.

Brian

pjbrown Tue, 03/27/2018 - 10:52

Once you've done as Brian has recommended, go to the History tab and you can copy the IDEAScript Code from that join to add to your code.
Also if you're joining more than one database try the visual connector - just discovered this myself. So much easier.