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?
Eric Burté (DEVOTEAM) Forum Ambassador
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