New to Appian

HII ALL, I need to upload a excel file for bulk upload and after uploading it i need to preview the whole excel data to the user before he  is going to clicking the submit button for further process . please help me to achieve this , i am new to appian please explain this .

i have to send the email once the task is approved  can someone suggest me example which i can refer for email configuration for From,To, Subject, CC 

Hi All,I wanted to write a query which takes input as form of array for each user ("email","firstname","lastname"), and want to map those values to parameters of createUser method, Any suggestions?I tried to write a code but it seems not working, As I have little knowldege in Appian.Below is the code I have written, I know it is wrong can anyone help me to get the correct logic/Code? 

Hi All, I have a scenario where i need to filter the data from db based on the date. Filter values will be something like below. Today Yesterday Last 7 days FYI, In Db,  date column is stored in date time format. Can an someone suggest me how to achieve the filtering thing from db based on the date when db value is date time? Thanks 

Hello community,  In our current project we are using "Move To Collab", lately we are facing a problem with moving Login Audit Files. Error details states:  com.appiancorp.suiteapi.content.exceptions.InsufficientNameUniquenessException: Name is insufficiently unique  Also, please find the error log attached at the end and suggest a method to over come this problem. Thanks and Regards, Vishnu Devalla [View:/cfs-file/__key/communityserver-discussions-components-files/62/ErrorLog.txt:150:120]

I have one interface with few questions on it, i want to set the timer as if user not completing this form in particular time period  it will get auto submitted or else he can attempt all the questions and submit the form in time on clicking submit button. or without clicking on submit button how can we submit the form after particular time. Thanks in Advance.

Hi All, what are the possible ways to get our appian certification extended . 

Hi, Can we change the background of a record action with style "SIDEBAR" in a Read-only grid. something like this, each record item should be different color.  

Is there any method to getting out of the forEach() like any break loop method?

Hi Team, I am having some queries as mentioned below: 1.  Can we create tables in Appian db dynamically ? 2. Can we fire SQL queries to Appian db ? 3. How to maintain the session of a user in a portal? I want to delete some table rows if user session is logged of. Please help in this regard. Thanks in Advance,

Hi Team, I have a use case where I need to sync the whole data of db table to records (on a link click event) but the catch is that I don't need to provide the identifiers. How can I do this ? Please help. See the below screenshot.

Hi Team, I am new to appian.I am trying to call a processModelLink inside a!save but I can see that processParameters are not getting passsed. Please see the screenshot below. Now When I am hitting the link, I am getting process Paramters passed as null, see below screenshot and please help in this regard.

Hi all, 1. Is there a way to customize a placeholder in user Filters in Appian record types (For example if I want to give a text that is not part of a filter value) ? 2. Can we customize search box location in record type? 3. Can we customize export button location in record type? Looking forward for your replies, thank you!

Hi all, Is Appian record type supports cell wrapping up on exporting the grid into Excel? What is the max length/no of characters allowed per cell in Appian on exporting the grid into Excel? Thanks!

Hi All,  I want to know how our pdf template should be if I'm using   "PDF Doc from Template" smartservice

Hi all, I am trying to take a date value from a DB(which I am writing in the Expression value below) and once I am inputting it in rule input it is changing my date value(Refer Value field):   Can anyone guide me what I am doing wrong, I need 03/10/22 as an output. Thank you.

Hi @all, Is there an easy way to separate out users and groups from a Main Group in an expression rule.  Below are the users and groups coming from a group itself. I want to separate out users from this list and wants to store it. Looking forward for your support, Thank you in advance!

Hii All, Can anybody help me how  to Implement pagination in Editable Grid?

Hi team I'm needing some help with getting an interface together to populate a simple table for collecting survey data. I have a list of software titles divided into categories. Each category will be surveyed individually, until we have gone through the entire list of titles - this is to avoid providing our users with a massive task! Likewise I do not want to send through a task for each individual title in a category. Here is the concept model for what I want to do: The survey result CDT looks like this: I have been thrashing around for the past few days with Editable Grids and Read Only Grids, and am experiencing the following issues: With an editable grid I can put a dropdown into the column but I do not know how to generate an individual row for each title. With a read-only grid I can get the individual row for each title but I do not know how o set up the dropdown or equivalent for my users to be able to choose their response I have tried various approaches and

Hi! I created an interface with cardChoiceField, which allows me to choose one of multiple subinterfaces (via rule!), which I created before. These subinterfaces have a dropdown which value is assigned to a local (to subinterface) variable.  The problem is that when I choose a value in the dropdown it doesn't change the local variable simultaneously - to see the "refreshed" interface, I have to switch to other subinterface, and then turn back to the original. In that case I obtain the subinterface I want, with refreshed variables. Is there any way to do this without switching to other subinterfaces?  I understand that it could be solved using rule inputs, but I would like to know how the interaction with local variables in reusable interfaces work

HI all,  am new to this, please tell me how to give paging size of 2 in a grid and has to show "<<" like this so that another records has to show pagingInfo: a!pagingInfo( startIndex: 1, batchSize:2 i gave like this but showing 2 in agrid, but no arrow marks <<    like this i should show 1-2 of somenum > >> kindly edit?/modify the code  Thanks in advance

Hello Everyone, Can anyone please tell me how can I read the excel file and ignore the is blank rows i.e if any column is blank then that particular row should be ignored. Many Thanks

Hey Community ,is there any option that we can translate the runtime value ( fetch from database) in send email smart service translate into french?

I need to write below code in a loop : "<table border=""1"" style=""width:100%""><style> </style>"& "<tr><td>" & ri!headerList[1] & "</td><td>"& ri!cdtType[2].commentDate&"</td></tr>"&"<tr><td>" & ri!headerList[2] & "</td><td>"& ri!cdtType[1].comment_txt &"</td></tr>" &"</table>",  I want a looping only for  "<tr><td>" & ri!headerList[1] & "</td><td>"& ri!cdtType[2].commentDate &"</td></tr>" Can anyone let me know please

Hello, I have data like the picture bellow. The type of the data is Any Type(List of Dictionary), It shows that List of Dictionary has 2 items, but, when I use the count() function it returns "1". How can I count the "Any Type(List of Dictionary)"