Foundation

Hi, I have a process model with an Export DSE to Excel smart service and it exports to an Excel file stored in a  folder dedicated for this functionality in my application. During QA testing, 2 different basic users who are in the same parent group and the group has Viewer access for the folder security. One user can successfully download the exported Excel file, while the other user's process instance gets the folder security error "The specified Save in Folder doesnt exist or you do not have enough privileges to access it ". I resolved it by setting the Export DSE to Excel smart service's assignment to "whoever designed the process model" but still would like to understand why 2 basic users will see different behaviour in the process when that node is set to "whoever started the process" as the assignment. TIA

Hello, I have the following validations on a file upload. When I upload a wrong extension for testing, it is giving me a completely different validation message than what I have in my code and I'm not sure where it's getting it from. Also, it looks like each time I upload a new file, the earlier validation message does not get replaced with the new one and I have no point of reference to see where this is happening, if anyone knows how to fix these two issues I'd really appreciate it. Here is the code. For reference, the constant being used (cons!GF_FILE_EXTENSIONS_UTILITY_PACKAGE_ARTIFACTS) has an array of all valid extensions (pdf, jpg, png, etc.)

Hello Appian enthusiasts, I am trying to improve an internal deployment process, and one thing that pop up is the need to update "Group Attributes" in every environment, because we are using SAML Sync. I know Stefan already published an awesome article proposing a solution (SAML Group Sync – Appian Rocks). However, it is for applications starting from scratch. In my case the pieces are already setup. Then, I couldn't find in the documentation a way to use the Customization File for that (Managing Import Customization Files - Appian 24.2). Is there a way to update the group attribute during the deploy or am I asking too much from the Customization File capabilities? Thanks in advance for all!

Hi Everyone , I am getting an error in write to record node in the process model. we had relationship between two records, the table name of the parent  record was modified and it was throwing an error in Process model. telling: table does not exist  "The table name(old table name) " ,later the parent record was removed from application ,and the relationship is also removed. Even now I am getting the same error. when I am not even referring that record ,I am getting an error saying the older table name does not exist ,the table name is modified and record is removed ,why am I facing the error still? Pls let me know the solution

This is my recordtype: This is the interface's creation rule input. EPT_Order_Status_RT is a Recordtype and it is showing up.

It's common practice to store the Appian username to the database for the createdBy, updatedBy, assigned, and similar fields. It's easy to handle in Appian to support search and filter capabilities when referencing those fields in a record type. But occasionally an associate has a name change, which subsequently causes their Appian username to change, since it's often their email address or something similar. That change disrupts the different features that depend on the username to match in Appian. At my current client, we're trying to mitigate that disruption by storing the UUID for each user instead. It's easy to use the People Functions plug-in to derive all of the user's information from that UUID. But, search, filters, and sorting will use the UUID. I tried remedying that by creating a custom record field, but it doesn't allow the user() function (or any plug-in function) to be called from the expression. How can I do this without resorting to a CDT an

Hey ,  Is it possible to update a constant with a array value using update constant smart service ? If yes ,then how ? Thanks , Bisheswar

Hi Champs, Can I able to change the color of icon for an Appian record action. Regards, Ghanashyam

Hi, I have requirement like below. I have one main Record Type( MFU TestData), in that I will store some columns, And I have Second Record Type(MFU TestFiles), In that I will save files. and It is referencing above table.  Can someone please help me to upload multiple files and save them to folder and save the values to database. Please help me to write expression which stores data to main table and list of files to second table. I am getting the following error if select the column from reference table ri!record['recordType!MFU TestData.relationships.mfuTestfiles.fields.fileName']

Hi there! I'm facing this timeout issue - "The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete" in process model SFTP Smart Service. This issue occurs in the last instance of 20+ iterated instances and it resolves as soon as I retrigger the node. That last instance has only 4.87 KB JPG file to transfer. Anyone faced such kind of issue and how did you resolved?

Can anyone let me know if there is a way to update the group security using the Create Group smart service or any other method? Currently, my functionality requires me to create multiple groups with a single click. While this process successfully creates the groups, it automatically adds me as an admin to each group. I need to remove the creator’s name from the security settings. If you have any solutions or suggestions for this issue, please let me know.

It is a FormLayout with submit button, that works as a standalone: validation before the startprocess is fired. However, if I make it an interface called from a record view, it stops working: the process starts without the validation being done (basic "required" info).Here is the simplified code for the form: a!formLayout( contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Numéro article", labelPosition: "ADJACENT", value: ri!record['recordType!{b3cc31cc-1595-401f-b13c-16b953dd1f5b}ED Projet.fields.{b0296e3d-29b7-42e8-acd8-a99e9fd26649}budgetPrevisionnel'], saveInto: ri!record['recordType!{b3cc31cc-1595-401f-b13c-16b953dd1f5b}ED Projet.fields.{b0296e3d-29b7-42e8-acd8-a99e9fd26649}budgetPrevisionnel'], required: true ), },

Hi Champs, I have a map value having multiple key and value pair. Now I want to check for a value which exists in one or more key. So I guess the only way to do that is to iterate over the keys in the map.  How can I achieve the same. As of my knowledge, for each works for no of map not for no of key/value pair in a map. Regards, Ghanashyam

Hi all, I'm a beginner of Appian, and I am required to show data in a record type by using editable grid in an interface. May I know how to do it? If I use "read-only" grid, it is easy to show the data from record type, but I cannot do it by using an editable grid.. I've tried to look for a document in https://docs.appian.com/suite/help/24.2/Editable_Grid_Component.html#related-patterns, but I could not find it. I need your help! Thank you in advance, Yuki

Hello,I hope you can help me.I have a gried Field with a record Type as the data source (record A), which at the same time is based on a SQL table. Every row has a unique value of its primary key (request_id). Some of the columns of the grid are displaying values which are not from the main source record, but from another record with a one-to-many relationship.This second record (record B) is also based on a SQL table.  The relationship between them is through request_id. Because of this, I have included record B within the "relatedRecordData" parameter of the "a!gridField". I have stablished as well a limit of 1, and a descending sort field based on the date. This way, for every a_id, I only display the value of the latest row in record B (even if there are more rows with different values).This is working completely find. My problem comes when I try to add filters within "a!recordData" > "filters" . The moment I add a fil

I want to learn the most efficient way to create groups for markets,so that I don’t have to spend a lot of time recreating the same groups for 8 markets, want to implement group permissions for multiple markets at once.I know we have smart service to create groups and also we have plugin called Peoples functions plug-in. Do we have any other way ?

Hello, I have the following validations on a file upload. When I upload a wrong extension for testing, it is giving me a completely different validation message than what I have in my code and I'm not sure where it's getting it from. Also, it looks like each time I upload a new file, the earlier validation message does not get replaced with the new one and I have no point of reference to see where this is happening, if anyone knows how to fix these two issues I'd really appreciate it. Here is the code. For reference, the constant being used (cons!GF_FILE_EXTENSIONS_UTILITY_PACKAGE_ARTIFACTS) has an array of all valid extensions (pdf, jpg, png, etc.)

We recently pushed deployed an interface from our development environment into our preproduction environment. A part of this interface is a document upload that then uses an imageField component to render the an uploaded heat map image. The component and interface worked as expected in development but in preproduction the image fails to render. We have checked things like security even though we noticed while logged in as admins. We tested using a small-scale interface and experienced the same behavior. I'm not sure what could be the discrepancy at this point. I'll upload some screenshots for clarity.

I am having issue running FitNesse with Edge browser. Google Chrome and Firefox does not have any issue. I would appreciate if someone could shed some light on this. Thanks.

Hello,  When a process is started from a timer and no user is assigned to it, what user will have started that process?For example, when viewing process instances, who will be the user in the Started By column? Thank you,  Nick

Hi Alla!localVariables( local!crFeesComments_cdt: rule!CR_FN_getModuleComments( crModuleComments: ri!crModuleComments_cdt, commentId_int: cons!CR_AS_COMMENT_IDS[1] ), local!crPricingApprovalComments_cdt: rule!CR_FN_getModuleComments( crModuleComments: ri!crModuleComments_cdt, commentId_int: cons!CR_AS_COMMENT_IDS[2] ), local!crFxRatesBuy_cdt: index( ri!crFxRatesFromDb_cdt, wherecontains( { 1, 2, 3 }, index( ri!crFxRatesFromDb_cdt, "seqNumber_int", {} ) ), {} ), local!crFxRatesSell_cdt: index( ri!crFxRatesFromDb_cdt, wherecontains( { 4, 5, 6 }, index( ri!crFxRatesFromDb_cdt, "seqNumber_int", {} ) ), {} ), { rule!CR_RT_displayInformativeNote( pageName_txt: cons!CR_TXT_SECTION_NAMES_TODISPLAY_AMOUNT[3] ), rule!CR_SC_AS_displayROCOverview( cif_int: ri!cif_int, systemRequestId_int: ri!systemRequestId_int, cr

Hi All, I want to understand matrix for role segregation and activities that one can do as basic user vs sys admin . Generally  I want to create a matrix for business presentation defining global user vs sys admin access matrix. Can anyone please help. Thanks Bihitak

Hello, is there any way to round the corners of a progress bar or a bar chart in Appian?

When you click the add button, the CardLayout component is duplicated along with its fields. Consequently, the dropdowns in each card layout are showing the same selected value as the dropdown in the first card layout. How should I handle saving the data to ensure that each dropdown maintains its own selected value?  a!localVariables( local!count: 1, local!destChildFields: a!map( status: { description: "Status", type: "integer", questionSet: "global", required: false, enum: { 12, 13, 14, 15, 16 }, enumLabels: { "To Do", "In Progress", "Escalated", "Withdrawn", "Resolved" }, typedesc: "Single-Select" }, subStatus: { description: "SubStatus", type: "integer", questionSet: "global", required: false, enum: { 17, 54, 21, 18, 19, 10019, 10021, 10018, 95, 10016, 10026,

Is there a good way to convert a list of items with no more than 1 item in it to a single item? There are 2 ways I know of, both have minor issues depending on the context.  1) use an index such as array[1] to get the first value of the array - This works, but requires some null checking in case the array is empty as it will bug out if that is the case. 2) use cast, but this requires knowing the type ahead of time, and if that's not possible, neither is this casting method.  Is there any other way I'm missing? Some hidden fromList() function I haven't found yet?