Foundation

Hi, I am using 'Save draft' functionality on a User task. The user task interface has an editable grid, containing file upload control in each row. The row can be dynamically added or deleted (using the X icon implemented in the top right column - dynamicLink). As explained in https://community.appian.com/support/w/kb/802/kb-1480-unable-to-save-changes-on-a-sail-form-if-an-file-upload-component-is-present-with-uploaded-files 'Save Draft' functionality doesn't work with files temporary uploaded to the form and I have to live without it [emoticon:c4563cd7d5574777a71c318021cbbcc8] However, I have a problem if users uploads a file in a grid row and deletes the row (clearing the grid row item in a grid data source and clearing the save target of the fileupload component contained in the grid row). I am not able to clear the inactive temporary saved file from the memory and Appian keeps preventing the Save draft as the fileupload is still there, although fileu

Hi, My requirement is to, Enable the particular row( Remarks, start and end date) columns for just the selected grid row item(goal) . I am storing just the index of the selected items in the local variable. On click of the save button only they get saved to a rule input. so while the user chooses a particular goal, the corresponding remarks and start and end date should be enabled else disabled. attaching the snapshot and part of the code for reference. Please help. Thank you a!localVariables( local!tabs: { "Functional goals", "Job Knowledge Goals", "Productivity Goals", "Review" }, local!isselected, local!activeTab: 1, local!FunctionalGoals: a!forEach( items: rule!MOB_fetchFunctionalGoals(), expression: { goal: fv!item.subtype, description: fv!item.description } ), local!selectedFunctionalGoals: tointeger({}), local!JobKnowledgeGoals: a!forEach( items: rule!MOB_fetchJobKnowledgeGoals(), expression: { goal: fv!item.s

Hi Team, We have a requirement to get files from external system along with some input parameters to our process model via a web api. The web api which starts a process would upload the file to the target folder and write/update data in respective appian DB tables. How can we achieve this? Request format :  document - type (document/file) id - type int name - type text etc This request can either be in form or json format. Appian version used is 21.1

Hi Folks, I am new to Appian (Had a quite bit of experience with BPM tools). I wanted to know if Appian has the capability to read and parse data from excel files. I am using Appian community edition and  I did my fair share of research and haven't seen any function or utility to read any excel files. Can anyone please help me.

how to write validation in date field so user cant select any date from past?

Hello!Apologies if this has already been answered but i am attempting to capture the current user name, date and time when they open an interface and then record this for later.So i have:loggedInUser()  - which with no other details gives me the current user(great) now() - which gives me the current time and dateI am unsure of how to tie this all together I am guessing if I use a process model I can call a rule to get this information but then I need to add this to a record type and this process would need to be fired on open of the interface?? I'm just lost right now! Sorry i'm a bit lost any help would be greatly apricated.Thank you! 

So I have a CDT with a bunch of fields in it. One of the fields is a category, while the other is string. That string field will be identical throughout a particular category, but may or may not be different in different categories. So for example: local!data: {{category:"round things", string:"bubbles, <otherdata>}, {category:"round things", string:"bubbles, <otherdata>}, {category:"soapy things", string:"bubbles, <otherdata>}, {category:"hard things", string:"rocks, <otherdata>}} I'd like to get the union of categories for that set, but instead of the output being the categories, it is the strings.  so something like union(local!data.category, local!data.category) and have the output be: {"bubbles, "bubbles", "rocks"} instead of {"round things", "soapy things", "hard things"} I hope the idea is clear?

Hi All, I have a use case where I need to convert Date and time based on user time zone. I have a date and time component, and if user of timezone CDT selects date and time as "4/1/2022 11:46 AM CDT" and submits the case. If another user of time zone IST logs in then they should be able to see the date and time value as "4/1/2022 10:16 PM IST" (whatever the usertime zone is). Based on user time zone date and time value needs to be changed in UI. I have tried with todatetime(), gmt() and usertimezone() functions but none of them works. Please provide your suggestions. Thanks

Hi, the issue is batch size in the paging.. count[no of rows] is miss matching.. when i give the batch size =-1 then count[no of rows] will match to db data  when i give the batch size =10 or 1 or 20 or 50 whatever it will miss match the count[no of rows] from db to UI  why this will happen! what is the exact issue? why batch size is giving issue? can anyone help me with this 

Hi all - I'm having trouble with the User Picker field to populate a rule input with a specific user.  I'm able to search and select a user. it shows for a split second then goes blank again.  When run in Design Mode, it does populate my rI! field, but at runtime, just shows then goes away. What am I missing?

Hi Team I have a requirement where I need to generate different update query statements for different tables depending on some conditions in a  process model.Do we have any feature to implement this? I do not want to use a XOR gate and create different nodes from XOR condition as the query statements may be huge.Or if we can generate the query statement in a Script Task and directly call the query to update the tables in the process model.We use Appian version 21.1 Thank you!!

Hi Appian Team, We have a use case where Appian API integrated with SAP , and  the SAP system will input base 64 encoded strings for pdf, we have to read the same from the input variables and convert the same to PDF. Can anyone help us to implement the  same if we anyone have already implemented or have knowledge about this? thanks Sunu Sam

in a simple process that consists of two steps first : student upload image or pdf of his certification second : secretary review document  My Question : how to connect the image component in the secretary  interface to the uploaded document by student ? p.s in the student form the uploaed document is saved a table of Document Type

i debugged a process but it keep running for infinity and filling the database with the same row

I am trying to add an existing attachment dynamically to the "Send Email" task. These attachments were previously uploaded to the application and the attachment name and document are stored in a table. I have added documents previously that were static and had a constant name. Thank you for the comments.

Hi Champ, I need to have a checkbox where I need to show the hyperlink like below. Can it be possible? Regards, Ghanshyam

Hi, I have below kind of interface (editable grid) to upload multiple documents. By default, I am providing 1 row and when user click on "Add Document" I am adding additional.  I have a rule input which is of CDT like below I was able to insert "Document Type" value to DoCTypeCode and "UPLOAD" to DocumentID. But, I was unable to inert values to "DateAdded" and "AddedBy". I have to store "DateAdded" as loggedinuser() and "AddedBy" as now(). Is there away I can load default values into these columns in the page load or when the user selected "Document Type" dropdown. Thanks.

a!localVariables( local!additionalInfoRequired, local!cancelled, a!formLayout( contents:{ a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!additionalInfoRequired, true, null), saveInto: a!save( local!additionalInfoRequired, if(isnull(save!value), false, true), a!save(local!cancelled,false) ), ), a!checkboxField( labelPosition: "ABOVE", choiceLabels: {"additional Info Required"}, choiceValues: {true}, value: if(local!cancelled, true, null), saveInto: a!save( local!cancelled, if(isnull(save!value), false, true) ), ) }, buttons:a!buttonLayout( primaryButtons:{ a!buttonWidget( label:"Submit", submit: true ) } ) ) ) Hi, My requirement is when I check one checkbox, another checkbox

Hi Appian Devs,I have long length dropdowns in the interface belowPlease let me know what is the probable reason of this error on the interface.Thanks in advance

Hi!, I´m having this error: The save target must be a local variable that does not refresh on every evaluation or on an interval, a process variable, or a node input (or a rule input passed one of those three) I´m trying to start a process with start form interface in a  a!startprocesslink inside a button. Any posible answers? Thanks

Hi, is their any other alternative to between operator? bcz am querying data from db.. giving different o/p in UI same query i have used to query the data from UI so  a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int

Hi all, My question is: What kind of field would you use in an Appian interface to display [but not allow editing] of a field like "created by" and "created date" that you want to display but not allow user editing - such that the data from these fields is actually stored into the database. Details of issue: My colleague and I are fairly new to appian development and are working on a problem. She created an interface that that allows us to add and edit the rows in a particular reference table. The interfae [mostly] works - in that it allows you to add and edit rows in the database table. The problem we have however is that there are some fields, which are not supposed to be directly edited by users. For example: "Created by""Created date" Rather than the users adding values for these fields, we want them to be automatically set by the system by retrieving the currently logged in user and the system date. My colleague has been able to set the fiel

Hi, I am working on a process model which has a Create New User smart service and in that smart service, there is an option to send Account creation email which when turned on sends the user an email with Temporary credentials with predefined content. My current requirement is to change the content of the email. Is there a way to change the content present in Body of the auto generated Temporary Credentials email sent from Appian?

So I am working on filling up my information in an interface that later will be saved and it will turn that interface into a read-only interface so I can see all my user information. The issue is that once I press submit, the interface doesn't update the fields from each section of the interface until I press refresh on my browser, is there a way to update those fields when I change it into read-only or make the site or page refresh?

Im new to Appian, first step i want to create in my app is a login page, can anyone help me on this Help me to create a simple login page with user authorisation, error message if wrong user id and password or if user id is not created in the app.