I have a simple workflow in which the email subject needs to contain the count of records,
When I try to click Use field in the email it says No valid fields, see screenshot below
attached a simple workflow, which has two text inputs, then it gets a count, wanted the count to displayed in the subject
Solved! Go to Solution.
i think you need a String type field for the subject. is your count a numeric field ? If so, a Select tool should do the trick !
Does the count of records exist in the table? In order to use it as the subject you have to have it in its own column. You may want to use a count records from wherever you need to count them from and then use an Append tool right after the table tool where you append the count. That way you will have the table in one column and the count of records in the second. Then you should be able to use the count of records as the subject.
Hi @ealunkal
You would need to bring the count at the end by adding it through append tool and send the field to subject.
Workflow:
You can also use formula tool to create a proper text subject.
Hope this helps : )