Foundation

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?

Dear experts, I have a PM with user input task, in task form, I define one submit button, which submit is true, validation is true, in this task form, it have a child interface, which have a paragraph field which required is true. However when I keep this paragraph field as empty and press the submit button, user input task completed, PM completed, no validation here. What maybe the possible reason here?

I am working on build an application: step 9 of the Acme Auto App. Currently working on the Process Model.  When I save and publish I get 2 errors: The first one says that "there was an error in an expression in at:" but gives me no further information. When I click on it it takes me to properties but I don't know where to look. I checked the troubleshooting suggested on the lesson but did not find anything. What can I do to fix it? The second it says the process model contains a variable that it does not reference. I'm assuming this is because I will reference this variable later but I am no 100% sure. Is that correct? Thanks in advance, Gabriel

Hi, Please suggest how can i fetch first 100 rows using export data store entity to excel. In filters input we can use only a!queryFilter and a!queryLogicalExpression. Thanks

hi,  I have an editable grid and save the selected rows in the a variable local!selectedrows, has fields {id:1, name:"test1, age:"60"                  {id:2,name:test1,age:"70"} have another variable  local!displayitems has a nested list .    {id:2,name:test1,age:"70"} is present inside the second index and 5 th item    please suggest how to write code for this.  my intent is i have to update the selected Row into the display items by indexing it upon button click.

Hi team, I have a use case where I need to delete old data. Imagine I have three tables: employee, address, and documents. To delete an employee, I need to store documents and address in history tables then i need to break the dependency (foreign key mappings) from documents and address . Then, I need to move the employee details to a history table before deleting the employees. So, I have a process model which executes these steps in individual query database nodes, like moving details to the history table using inserts, then breaking dependency using update, then moving employee details to history using inserts, and finally deleting employees using delete. These tables are just examples; I'm doing a similar process which I cannot fully explain here. The thing is, my production table has 110GB of data, so performing this operation for 3k employees took more than 3.5 hours. So, I planned to process in parallel using startprocess MNI. It is wo