General

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

i have few doubts can someone clear me the doubts? i want to write the exam for L1 so which exam i have to take? here i found these, but not sure which is exam is for which level if i want to write L1 and L2 exams at a time then, which exams i have to register for and take?

First Create Function To Calculate Sum called : Calculate_Sum a!localVariables( if( ri!monthName null, sum( todecimal(index(ri!months, { ri!monthName }, 0)) ), sum( todecimal(ri!months.jan, 0), todecimal(ri!months.feb, 0), todecimal(ri!months.mar, 0), todecimal(ri!months.apr, 0), todecimal(ri!months.may, 0), todecimal(ri!months.june, 0), todecimal(ri!months.july, 0), todecimal(ri!months.aug, 0), todecimal(ri!months.sep, 0), todecimal(ri!months.oct, 0), todecimal(ri!months.nov, 0), todecimal(ri!months.dec, 0) ) ) ) Now Create Form in Grid to calculate and call the sum function: a!localVariables( local!invalidIncome: ("Please insert valid income value."), local!DuplicateIncome: ( "Duplicate value. Please check and delete if duplicated" ), local!CurrentRow: 0, local!TotalRow: 0, local!monthDetail: a!map( jan: null, feb: null, ma

Hi All, Multiplying the below values by product function and expecting to return output as 16956.0843 but it is returning the output as 16956.08.  product(16746.75 * 1.0125) Regards,Sandeep

I was making a query today in which I wanted to find entries based on a particular field and if that field happens to be null, I want all the entries that have that field null. I ended up with 2 filters, one that looks for entries when the value is not null, and one that looks for entries when the value is null. It works and all, but the thing is there's a parameter called ignoreFiltersWithEmptyValues that is usually true by default. But you can make it false and now instead of ignoring those filters with empty values, it gives an error for each filter with empty values. My question is why does this parameter even exist if all turning it off does is cause an error on null values? Wouldn't it make more sense to search for null values instead? 

Hi All, Input code: a!toJson( value: {test: { assuranceText: "Jag försäkrar att uppgifterna jag har lämnat är riktiga och bekräftar att jag har tagit del av informationen och villkoren ovan.\n\nDin ansökan grundas på automatiserad behandling av dina personuppgifter. På vår hemsida och under inställningar kan du läsa mera om hur vi behandlar dina personuppgifter och om dina rättigheter.\n\nNär du skickar in din ansökan kommer en kreditupplysning om dig att hämtas in ifrån UC" } }, removenulloremptyfields: true()) I am geeting the out put as below: in the output you can observer that one extra backword is added for the newline character

Hi, I am handling documents in Appian using "a!fileUploadField". When we upload the files/documents using this component it is allowing to upload the files/documents to a specific Folder which we have created inside Appian. I would like to check if there is a way I can upload the documents to the network folder which is mounted. Any advises please.

Hi, I am using a smart service called "Export Data Store Entity to Excel" and generating a document and storing in a pv! variable. Now, when I try to attach the same document in the "Send E-Mail" service, I am getting an error. I passed the variable to the "Attachments" like pv!reportName and tointeger(pv!reportName), but still no luck. By looking into an error message I was unable to find the root cause. Can someone advise please. ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Failed to process attachments Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

What all cases are covered while using validateemailaddress() ?

I have a use case to check if a group already exists. And if not, we should create the group. Is there any way to check a group exists in an environment already.

Do you have any idea on how to check if all values in array matched in appian? example arrayValue = {true,true,true} returns "All Elements are Same" else returns "Not the same"

Hello Everyone, In recent days, We are seeing this error in the tomcat-stdOut.log. In the front end, we are getting, An error encountered while processing the request. ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation. com.appian.komodo.api.exceptions.SignalException: At least one referenced Activity Class Schema is invalid: ,304 Can you help us on solving this issue? Thanks in Advance

How to configure a key in CDT?

Hi  I Am having value as "USA|UK|Canada" like this but i want to remove the "|" from the text and create a array as {USA,UK,Canada}  so that i can write data into DB as each entry. Can someone help here

I have to generate invoice using internationalized characters. Any one have any idea how to do this. Thanks in advance.

Hi all ,encounter below error when using Send Email smart service. `Failed to send email`, Then  i go to check error log see above yellow part  error message: `452 Too many recipients received this hour`wait for a while,it can work fine.looks like it can be configured in somewhere for recipient limitation.anyone has suggestions?

Hi All, One task is assigned to a group and it contains multiple user. If any one the user accept the task, whether the same task is visible to other members task inbox or not. kindly confirm. Thanks in advance.

Hi!I successfully sent a email via Send E-Mail node, the "To" (email main recipient) received the mail, but the "CC" (mail group from outlook) didn't receive a mail. There is no error in my monitoring   . 

In Python, how can I practise polymorphism? Assume we have a very basic version of the option pricing algorithm that requires just three inputs (option type, spot price, and strike price) to compute the intrinsic value of our option. Please see the example code below. from abc import ABC, abstractmethod import attr @attr.s(auto_attribs=True, frozen=True) class Option(ABC): strike_price:float @abstractmethod def price(self, spot_price: float): raise NotImplementedError("This method must be implemented in the subclasses.") class Call(Option): def price(self,spot_price: float) -> float: return spot_price - self.strike_price class Put(Option): def price(self,spot_price: float) -> float: return self.strike_price - spot_price def calculate_option_price(option_type:str, spot_price:float, strike_price:float) -> float: if option_type == "CALL": return Call(strike_price=strike_price).price(spot_price=spot_price) elif option_ty

Hi, I am planning to attend the appian world event, and would like to know the experiences of some people who have attended it in the past.

Hi, On a entity backed record a related action has been defined to set a status flag on the record to canceled. When user choses the related action from a (summary) view, the related action is performed and returns to the same (summary) view. i.e. writes to db a status of canceledThe changes made by the related action are not reflected on the view. i.e. status is not set to canceled although the status flag in the database has been set correctly.Refreshing the browser page then correctly displays the view with the record at canceled status. Any help much appreciated Thanks

Hi All, i have 2 tables. 1.project(id,requesttype,automationname,etc), 2.Task(id,projectid,workflowtype,etc) Project:{ { "",test,test}, {"",test,test},{"",test,test}}  task:{{ "","",task}, {"","",task},{"","",task}} } for example  After write to data store entity of my project data is{ { 1,test,test}, {2,test,test},{3,test,test}}  once project data is created i want to create the task respectively before that i want to assign the PROJECT DATA (ID) which is 1,2,3 to Task Data(PROJECTID) finally after i write the task data into db i want my task data as: {{1,1,task},{2,2,task},{3,3,task}} can you please help how i can set the id of project to particular cloumn in the task data