Morning Folks!
I'm using a row action on a table to create a new row whilst populating its fields with data from the original row. This is working fine except for using a formula field on the original row to populate a field on the new row.
I've tried re-querying the model before updating but that hasn't fixed it - the field comes up blank.
Any ideas?
Cheers!
Louis
I'm using a row action on a table to create a new row whilst populating its fields with data from the original row. This is working fine except for using a formula field on the original row to populate a field on the new row.
I've tried re-querying the model before updating but that hasn't fixed it - the field comes up blank.
Any ideas?
Cheers!
Louis
-
5,144 Points
- fabaroonie
Posted 4 years ago
mB Pat Vachon, Champion
-
42,926 Points
-
5,144 Points
mB Pat Vachon, Champion
-
42,926 Points
-
5,144 Points
mB Pat Vachon, Champion
-
42,926 Points
-
5,144 Points
-
5,144 Points
Here we go...!
mB Pat Vachon, Champion
-
42,926 Points
-
5,144 Points
mB Pat Vachon, Champion
-
42,926 Points
Same model and row?
I ask because the moment you make a new row in that model the context merge fields change to that row.
So, prior to making rows, save the row and pull that original row into its own model and create the 2 new rows from it. Ie. {{$Model.modelname.data.0.fieldnames}}
I ask because the moment you make a new row in that model the context merge fields change to that row.
So, prior to making rows, save the row and pull that original row into its own model and create the 2 new rows from it. Ie. {{$Model.modelname.data.0.fieldnames}}
-
5,144 Points
For anyone else that tries to do things the wrong way - as I was - this here and Pat's next post is the fix.
-
5,144 Points
mB Pat Vachon, Champion
-
42,926 Points
Model
Set max records to 1.
Create condition of Id = "" Filderable Default Off
Add fields as necessary.
Actions to add before creating two new records.
Set max records to 1.
Create condition of Id = "" Filderable Default Off
Add fields as necessary.
Actions to add before creating two new records.
-
5,144 Points
mB Pat Vachon, Champion
-
42,926 Points
-
5,144 Points
Rob Hatch, Official Rep
-
44,168 Points
mB Pat Vachon, Champion
-
42,926 Points
Peter Bender, Champion
-
6,276 Points
Just to be clear for others that had this same issue, as this can be confusing:
To use a row action to create a new row/record and default/populate a field with data from the original/parent row/record, the original/parent model needs to contain the field that you are referencing. In other words, the new/child model does NOT need to contain parent__r.source_field__c, but the parent model DOES need to contain source_field__c. The new/child model does need to contain the target field into which the default data is being populated, of course.
To use a row action to create a new row/record and default/populate a field with data from the original/parent row/record, the original/parent model needs to contain the field that you are referencing. In other words, the new/child model does NOT need to contain parent__r.source_field__c, but the parent model DOES need to contain source_field__c. The new/child model does need to contain the target field into which the default data is being populated, of course.
Rob Hatch, Official Rep
-
44,168 Points
Thanks for the clarification Peter. You are correct.
(Nice to see you in these parts again. We've missed you)
(Nice to see you in these parts again. We've missed you)
-
1,202 Points
Wow so glad I found this. Been pulling my hair out for a bit wondering why I couldn't populate 2nd field on my action. Not sure I would have ended up here!