General

Hi every one,  I'm having a local variable that store data in a Json format then converted it into a type that Appian accepts: a!fromJson(local!settings)  and I get this as the result:  Dictionary name"Type"(Text) value"["5"]"(Text) valueDisplay""(Text) I want to get all the settings with value equals a particular ID, but it shows this error: Expression evaluation error at function 'wherecontains' [line 41]: Invalid types, can only act on data of the same type (Number (Integer), Any Type).  index(local!settings, wherecontains(local!currentType.Id,local!settings),"value",null) I guess the issue is because value is now containing special characters.  Any one having a solution for this?  Thanks a lot in advance for your helps!

We have .csv files in System logs   hc-application-objects.csv and hc-applications.csv. I know we have an excel plugin Load/Import CSV to database. But with this approach we have to upload the csv files in Documents folder.  What we want is we have to load these csv files from logs to Database without saving them in documents folder.  Can anyone help me how to approach.

Hi, I am going to take a test for Appian Certified Lead Developer, but I didn't find any offical courses for that, is there any advice for the exam? thank you very much! [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Can you check if the task has been rejected by all assignees? And is it possible that the task can somehow be seen again on the system or gone for everyone else. 

Hi everyone,  I'm having a question regarding how to use the writeToDataStoreEntity function to modify values in DB.  To be specific, I'm having a form that allow users to update their phone numbers. It will be saved in a DB with corresponding DSE storing all customer data. When the customer click  the button Save New Change, the existing number need to be replaced by the new number, both on the interface and in the DB. I'm not sure how to do that yet. I'm thinking of using writeToDataStoreEntity, and find the number that needs to change by the unique customer ID, but not really know in specific how.  Any one have a solution for this? Really appreciate your help! Code for the Save New Change button is currently as below, in that local!allUser query list of users from db, and selected user is the one that need to change phone number: This code shows an error:  An error occurred while trying to convert the given data to the type of

In the image bellow the 3fields in the square come from a dropdown  ("SI" or "NO") in a user interface. I can see the user responses in a read-only grid (see the image bellow).  I want IF 3 condition ("Financial", "Documents", "Certificate") in the red square are "SI" then the column "Estado" return a new value "Finalizado"  IF just one condition ("Financial", "Documents", "Certificate") in the red square are "NO" then the column "Estado" return a new value "Pendiente" Next i want to store the value of the column "Estado" in my cloud database

 How can we set a link which is valid for 2 hours only? And I want to send it by email object to someone. If someone tries to open this link after 2 hours it will display a message only e.g. Already submitted!! 

Hi,  I have updated my profile picture in my organization's instance. However, the document was deleted and hence I am seeing an error as shown in image below. Please help me on how to resolve this.  

Hello i'm new to Appian, I want to make sure before completing the traingin, 1- Can i build afull accounting software hrough Appian Low-Code ? 2- Can i sell the program/ Application i will create as Saas on Appian cloud ?

Hello, I'm having some trouble with performance on my site. We have a site made up with a record type, and when opening the cases from the list it takes up to 25-30 seconds to open them. We have around 8000 total cases. On our appian site we have enough disc space and cpu following the graphs (disc space around 20% usage and cpu max use 40% on peak). Do you have any recommendation to increment the performance and the opening time, or any way to find where the problem is? I'm asking this for any recommendation before escalating the issue to a support case. Thank you!

Hi, I want to know that, Do Appian have any examples of migration from Java swing to Appian? Thanks,

a!radioButtonField( label: "Status",choiceLabels:{"APPROVE","REJECT","RETURN"}, choiceValues: :{"APPROVE","REJECT","RETURN"} ), a!paragraphField(  showwhen(...) ) *if user selects Reject or Return, then only show the Paragraph field.

Hi Everyone, I have been stuck in one of my requirement and seeking help. I have a report which gets downloaded in the pdf form. The report should have a page number at the bottom in the form of "1 of 10" like that. Can anyone please guide me how can I achieve this. Please note that pdf is generated from docx template. Many Thanks

I want to add 50+ Appian objects to a package. Actually I need to do this activity on a regular interval to prepare deployment package. so is there a way to do it by writing some script or we will have to add each object to package manually only. I have objects name, type and version with me. 

Does anybody know any issues with the order being accepted by branch chief, but is then rejected

Business users should be able to model and execute workflow processes , Is this possible ?

I have a requirement where in a text field needs to be formatted in a specified format of "X.1234567", where 'X' and '.' will be a constant followed by 7 digits.If we are typing 123 in the text field, it should be formatted to "X.0000123". Any help would be appreciated. Thanks!

Hi All I want to comapre the documents which i have uploaded or created. can i get a solution apart from using the microsoft word compare plugin. Hoping a useful answer. Thank you.

# Exploring database things Creating roles adding users to the roles Giving privileges  Cloud database throwing me an error when the "create user" command is run MySQL said:  #1227 - Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation here, iam the system administrator in my appian site. Do I need to configure anything before I go?

What is the APPIAN's equivalent for  JS String.replaceAll ? 

Hello everyone!! I´m working on the exercise 9 ( learining path) to Add a manintenance request as a related action. I followed the exercise instructions: I made configuration on the expression editor Request Maintenance for the context configuration and also  as well as the visibility Once I test  I got this error. can you pls guide me on how to fix this error.   Thanks a lot for your support

Hi My question is  i need a form to fill the details like below, for this requirement i am thinking to go with the form layout will be fine or any other methods i can go with?  after filling these details if user wants to add one/more contracts he should get the same form below one after the other is that functionality is possible in forml ayout ? let me know if any suggestions  Contract No.   How many times [number validation] Total No of Days previously extended (A) [number validation]     Current Extension Request:   Contract Limit [aed validation] Value of Full Contract - Outstanding  [aed validation] Value of Extension sought [aed validation] Capital Amount  [aed validation] Interest Amount  [aed validation] Current Maturity Date of Payment being extended  date validation Number of days extension sought (B) number validation New Extended Maturity Date  date validation

Hi All, I want list the group members on a interface in my application. anyone can help me out please?. Thanks.

We are trying to understand how to upload a pdf into a folder and save the id in table to be retrieved later. We are not able to get the id to return and then save it.  We have a response json and we can't just hardcode from the uploadfield.  in the component containing the upload field  we can't call from the process model that component.  All the interfaces are nested and dynamic and contained in a dynamic json.  Currently, attempting to create a process model for uploading the pdf has failed because we can't get the id back when the pdf is being stored in a folder. 

Hi All,  I have requirement to fetch/list all knowledge centers for all the application available on server. I have uuid of all the application, need to get knowledge center. Please guide how this can be achieved. Thanks