I need to use a proper function to change the case of any field to proper (first letter capital rest small, but acs is not taking this function what can be done?

I have a use-case to add a button over a banner image over an email and make the button clickable but not the image but in outlook the button comes after the image , it seems outlook doesn't support this , like it does not support background image , is their a way to sort this. e.g. the banner below...

I Need to randomly select coupon codes and paste it over email for profiles where the coupons does not have any relations with the profile but can be used only once. And these coupons are coming from other database and generated randomly.Please suggest what can be the best way to implement this in A...

Thanks Amit, have followed the same and was able to acheive it.......

Yes you can do this by configuring transactional events and transactional messages in ACS, refer below link: https://docs.adobe.com/content/help/en/campaign-standard/using/communication-channels/transactional-messaging/about-transactional-messaging.html

I have a use case to count all the recipient in database in ACS and print it over the email . But i am not able to do it using count aggregate function in addtional data as it is giving the error , to group by . But there is no group by option in ACS ,is there a way we can complete this usecase.

yes i have checked the column definition it generates the two fields i have added in the json sample given by my api

Thanks for your response Raman, moreover i am using the same link to configure the activity and when i run the worklfow the activity gives error saying malformed json but when i parse the json in the activity it is done correctly as per the doc

i am trying to get response from a public api using the external api activity but it is giving error saying json format not acceptable.Also in the url it is saying this is not a valid integer. Please suggest what can be the issue? 

Hi AllI am working on transactional messages in ACS, and trying to add a mirror page url to the message but as the marketing email mirror page link has data from profile table and transactional messages gets data from rtevent it shows error.Let me know how can we make a mirror page url and link for ...