You need to sign in to do that
Don't have an account?
Craig Donnelly
Deployment of working Quick Action fails with "Formula result is data type (Text), incompatible with expected data type (Date)."
Hi.
I have a quick Action in our production Org on the Contact object which creates a Custom Object. I'd like to move it to an existing Sandbox to do some more work on it.
There are 4 predefined field values on the Action, one of which is a Date field and it is calculated using a DATE(year,month,day) formula and another is a Text field that uses some YEAR(TODAY()) etc functions to construct part of a string.
The formulas in the Action save fine with no errors and the action works and creates a record with an appropriately calculated predefined field values.
However, when I put the action in a deployment package, send it to a sandbox and try to deploy it I get the following error message "Formula result is data type (Text), incompatible with expected data type (Date)."
Wondering what the problem is?
I have a quick Action in our production Org on the Contact object which creates a Custom Object. I'd like to move it to an existing Sandbox to do some more work on it.
There are 4 predefined field values on the Action, one of which is a Date field and it is calculated using a DATE(year,month,day) formula and another is a Text field that uses some YEAR(TODAY()) etc functions to construct part of a string.
The formulas in the Action save fine with no errors and the action works and creates a record with an appropriately calculated predefined field values.
However, when I put the action in a deployment package, send it to a sandbox and try to deploy it I get the following error message "Formula result is data type (Text), incompatible with expected data type (Date)."
Wondering what the problem is?
Mark as best answer, If it resloves !!
issue may be here
Formula result is data type (Text), incompatible with expected data type (Date)
you need to put your formula inside Text
Ex: Formula field support text , But from that formula you getting values as date
As per requirement it is correct but data type is not supporting so you need to place you formula inside TEXT() . Issue will fix
Mark as resloved if it helps :) :)
Thanks,
Bhanu Prakash
visit ForceLearn.com