Skip to main content

Hi,

 

I have a scenario where there is a list of data in in table format. see below :

 

   |    A     |      B     |      C

| 152.4  | 22.32  | 0.01556

| 152.4  | 26.79  | 0.01491

| 152.4  | 29.76  | 0.01451

| 152.4  | 34.23  | 0.01391

| 152.4  | 38.69  | 0.01335

| 168.3  | 29.76  | 0.01854

| 168.3  | 35.72  | 0.01776

| 168.3  | 41.67  | 0.01699

| 168.3  | 47.62  | 0.01632

| 177.8  | 25.3  | 0.02166

| 177.8  | 29.76  | 0.02112

| 177.8  | 34.23  | 0.02053

| 177.8  | 38.69  | 0.01996

| 177.8  | 43.16  | 0.01938

| 177.8  | 47.62  | 0.01882

| 177.8  | 52.09  | 0.01827

| 177.8  | 56.55  | 0.01776

| 177.8  | 61.01  | 0.01716

| 177.8  | 63.54  | 0.01675

| 177.8  | 69.05  | 0.01604

| 177.8  | 74.56  | 0.01533

| 177.8  | 79.77  | 0.01464

| 177.8  | 84.97  | 0.01397

 

Now there will be 3 fields on Salesforce quote object named Field A, Field B and Field C.

 

data of Field C depends on the data of Field A and Field B.

 

For eg. If value of Field A is 152.4 and Field B is 22.32 (entered manually) then value of Field C should get auto populate with value 0.01556

 

I have created these fields data as a object and imported them.

 

My question is, Can I use flow for these type of scenario? I mean I can use the Get record element here to find the single record but I am not sure with how I can populate the value in Field C.

 

Can someone help me on this please?

 

@Tom Bassett

4 answers
  1. Eric Burté (DEVOTEAM) Forum Ambassador
    Apr 12, 2024, 9:12 PM
    Hello @Dhaval Shah just do a getRecord in your flow, to this custom referential object, with criteria on field A and field B. Test after that your result collection is not null, and get the field C form your first record of the collection to assign it to your triggering object (after insert and update). Éric
0/9000