update a record in table

[Keerthi Lakshmi]

Hi,

My requirement is I have to build a catalog item where i need to fetch details about the vendor. Later with the details, I need to update records in Vendor table. I was planning to map fields using script in workflow. I just want to know this will work and I am new to workflow. Can anyone help me to understand how I can achieve this?

[Danish Bhairag2]

Hi @Keerthi Lakshmi ,

You can do this via workflow/ flow designer.

If doing via workflow the way to access the catalog item forms variable :

current.variables.field_name

if flow designer then what Atul has suggested u can go with that it will be a simple drag drop u need to do.

Thanks,

Danish

[swathisarang98]

Hi @Keerthi Lakshmi ,

If it is a straight forward requirement then you can create a Record Producer and if it has fields which are not available in the table you can directly map the RP variable value with Table field Value as shown below,

For mapping simplest you can do keep the variable backend names same as table name.

short_description=>backend table name of the variable

u_short_description=>RP variable backend name.

it will be automatically mapped.

script:

current.short_description=producer.u_short_description;

Please check and Mark Helpful and Correct if it really helps you.

Regards,

Swathi Sarang

[Keerthi Lakshmi]

HI,

For creating a new record, I can create using create record option in flow designer. But for updating the record which is mapped to the fields which we fetched from the portal, how we can do that?

[Keerthi Lakshmi]

Hi, I need to update the record in a table by mapping the fields which i fetched from the user. How it can be done? Can anyone help me on this? How we can achieve this using flow designer?