Dear Creator community, Hello :)
My situation is as follow:
I have one application which contains a form with customer data:
Application A, Form A:
Row: Customer ID, First Name, Last Name
Application B, Form B
Row: Customer ID (look up field to Application A, Form A ,Customer ID)
First Name, Last Name
Application A is my master database, while application B is a secondary database created per user
The desired process is as follows:
I register a new user in application A database
then, when i create application B i look up his customer ID, and when this ID is chosen i want to add a work flow that will take this Customer ID, go to application A form A and return the first name and the last name of the Customer with the Customer ID searched.
In other word, every table has a unique key which can be used to associate it with data in other tables and applications, and i want to be able to fetch data from one application to another using a common key.
So far i found only the fetch data deluge task which can only fetch data within forms of the same application
Any one has a better idea?
Thank you
Tal