Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RESUELTAS

Getting no valid fields while using use fields for email subject

ealunkal
Átomo

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 subjectdynamic_email_sub_field.jpg

3 RESPUESTAS 3
Jean-Balteryx
16 - Nebula
16 - Nebula

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 !

BrandonB
Alteryx
Alteryx

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. 

atcodedog05
22 - Nova
22 - Nova

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:

atcodedog05_1-1626884915342.png

 

You can also use formula tool to create a proper text subject.

 

Hope this helps : )

 

Etiquetas
Autores con mayor cantidad de soluciones