Foundation

Hello there, I wanted to convert html to csv file and send CSV file in email. I have used "HTML Doc from Template" node and "Convert HTML to CSV" node. My CSV file has generated at backend folders but HTML file is going in email. How Can i send a CSV file in email? Please suggest. Thanks

Hi All, Is there a way to implement a form for other users that are not in the application to fill out, but at least have some sort of validation of who gets access to this form.  The purpose is to save the form information but the user who fills it out is not an application user, and this form doesn't appear in any menus of our application. Is this possible?

When the screen loads Custom picker show load the Editable Interface. And while search example if searching any data from the grid it should return the respective row from editable grid

As per my Requirement I need to use the Dual Picklist with Editable Grid in Interface instead with Dual Picklist with Checkbox Design Pattern. So the issue here is 1.Currently i am having the 4 items in the available list 2. When i am selecting 1 & 4 the local variables is taking the respective data related to 1 & 4 and after clicking on the ADD SELECTED it moved to the Selected List local variable 3.Remaining items available 2 & 3 when i am selecting them it should consider as 2 &3 but instead it was consider as new iteration as 1 & 2 Now the issue here is when i am selecting 1,4 those needs to be added to selected list and after submitting these when i select 2,3 the items needs to consider as 2,3 instead of 1,2 and all needs to be append and display the data Code: a!localVariables( local!availableDataIndex, local!selectedDataIndex, local!availableList: rule!example().data, (record type) local!selectedList, { a!sectionLayout( contents: { a!col

Hi Team, I have a requirement where I need to convert MNI into batches/looping, since its reaching threshold(MNI has limitation of 1000). Can someone help how to convert . Requirement: I am trying to write data to database via Stored Proc(Data is huge). In advance I don't know how many records am getting to write in database via integration.  I cannot use Record, since its old Application(Business People are not in favor to convert to Record, since it has dependency on 100 objects.)  

I am having the below array configuration as output, but I only want 4 array of List Of Document with each having 50 items.

Hi, everyone Which options is better for system setting

I am trying to move a application from Dev to UAT. When I do inception, I am getting below message No missing precedents or warnings detected null of item(s) will be created/updated. null of item(s) will be skipped because no changes were detected. Skipped objects may have identical definitions but different version histories. All version histories will be synchronized on import. Any help is much appreciated... Packagae size is 2 MB

I am having date and time of submitted form in Date time format.I want to compare the date and time if it exceeds 1 hr from submission I want to show a proceed button. How I can give a condition where it is comparing submitted form have completed 1hr 

Hi Members, Am getting below Issue. Can someone help how to resolve it. Data store write operation(s) had an average response duration over 2000ms (High) and 10 data store write operation(s) had an average response duration over 1000ms (Medium) - CDT has a dependency on over 40 objects.

a!localVariables( local!userDtl: rule!GAI_GetUserDetailByUserDetailId(id: ri!userDtlId), local!userAddr: rule!GAI_getUserAddress(userDtlId: ri!userDtlId), local!address: rule!GAI_getAddress( addressId: tointeger( local!userAddr['recordType!{95223579-776a-485d-b38c-eeaedbe5930a}GAI User Address.fields.{42a88eac-f478-4bf9-a8da-e8c5e666ed11}fkAddressId'] ) ), local!userRoles: a!refreshVariable( value: rule!GAI_getUserRole( userDetailId: ri!userDtlId, isActive: true() ), refreshAfter: "RECORD_ACTION", refreshAlways: true() ), a!formLayout( contents: { rule!SCO_CommonHelpText( helpText: "User has been deactivated in the system", isError: true(), showWhen: not( rule!SCO_isUserActive( local!userDtl['recordType!{1a68a647-eb88-4f12-be8e-e3d5fc6495eb}GAI User Detail.fields.{d07378d8-ee37-479d-a6e4-06adfb5bdd15}username'] ) ) ), a!columnsLayout( col

Hi All, I need session timer on user input task like there is one interface, in that user can do three activities but if in certain time user does not click on any activity then it should show popup as do you want resume this session is it possible to do in appian? thanks in advance.

why does it mean ID NOT FOUND ?

I using a record relationship (1 - Many) (Dept -- Employee (multiple)). I am trying to create a interface, where in top grab the Dept details and in bottom Employee details for that Department , which is Editable grid. When I try to addRowLink - its not creating a new row. Pls see the code below and let me know , what is the issue. a!localVariables( local!emp : 'recordType!{f4411d12-5d9e-43b0-9eb3-430ef2ea01b9}Emp.fields.{a808753b-fbba-4fd9-bd49-058256eae7a2}empno' : "", local!empnme : 'recordType!{f4411d12-5d9e-43b0-9eb3-430ef2ea01b9}Emp.fields.{62b2206f-9897-4495-9957-8fc3c3a6253a}ename': "", local!job : 'recordType!{f4411d12-5d9e-43b0-9eb3-430ef2ea01b9}Emp.fields.{47784a4a-362f-4104-a42d-4762074fddec}job':"", local!sal : 'recordType!{f4411d12-5d9e-43b0-9eb3-430ef2ea01b9}Emp.fields.{2d76dd3c-1e76-4924-af64-24652c4f3b4f}sal':"", a!formLayout( label: "Department & Employee Relationship", contents: {

Hi Experts  I need to migrate data from On premise environment to Cloud environment. For every record there is a folder creation whose id is stored in DB table , Also these folder , later, filled with documents that uploaded by end users. 1) Is there a way that I can migrate the same folders with same IDs in DB, If not then what is the best way to do so? 2) Is there a way that I can migrate the same documents with same IDs in DB , If not then what is the best way to do so ? I'm new to appian , so please provide a step by step solution in easy language. Thank you in advance 

HI Team, i  have active tasks which i am showing in task grid with query process analytics, My client have requirement like Once one task is submitted  the user need to automatically redirect to another task, Any suggestions on how can i do this, How i can handle the completed instance  task to move further and also user need to redirect to another task and also client is not looking out any activity chaining  interface which we have safelink  and use taskurl  Thanks, Udayasai

IS there any way to download document automatically by using Process Model without click .

Hi, while accessing Appian Developer Learning Path (Associate Developer) in Appian Community ,post the new curriculum update in November am not able to access one of the lessons "Query Your Data" and also I had taken the mock test before November , currently the  same set of questions are available , its not updated as per the new blueprint. Could anyone help me on this. Thanks and Regards

Hi, I have created a simple stored Proc with 1 input parameter Can someone let me know why am getting this error

There any way to append a dynamic link to a text field? For example, in a Text field with read only mode that contains a lot of characters. I want to truncate the characters and add a link after it that says "Expand" or "Read More", If they click on it, the user will sees all the text.

Hi Appian PalsPlease have a look on the interface below, this is having different cards, and each card is having independent interface behind it and can be accessed using a button click.But after the successful completion of the process, it is brining back to the main home interface instead of the child interface.Again I am back to the main interface, instead of the child interfaceThe process should end on the interface where it started.Any workaround on this?

How to pass process parameters in WEBAPI which calls process model .a!startProcess( processModel: cons!PCI_PM_CALL_INTEGRATIONS, processParameters: a!fromJson( http!request.body ), onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error starting the process" } ) ))

Is it possible to have a drillable chart if the data from the chart is not from a record? I am getting my data from multiple tables and mapping it to what I need

Hi All, Currently, we are using the 23.2 version. I have deleted the process model's latest version, and I realized the earlier version will not be enabled or activated automatically. I saved the earlier version of that process model and then published it successfully (Version No. 10). Now, I am facing some issues. Whenever the above process model is referred to, Appian doesn't always pick the latest published version, sometimes picking an earlier version (Version No. 9). Can anyone advise on the below? How do I make sure Appian picks the last published version (version #10)? by restarting the application server? Appian is giving provision to delete the version, but is it recommended to delete the older versions?   If yes, then how do I make sure the earlier version is active?   Thanks in advance.

Hi all, I have a query that when we are configuring any file within validation like fv!files.size < 3Mb.Will it check the total uploaded files size or for a single file validation will it checks. Please give me some theortical knowledge on this. Thanks & Regards, Divya.