New to Appian

In my application I have a two record types with a One to many relationship. recordType!Workflow -> recordType!Task. I have process that needs to create a Parent record and child records. Currently I have two Script Process Nodes.  Process 1. Creates workflow record and store in pv!workflow. Process 2. Creates multiple task records and appends to pv!workflowTasks. Then I call Write records to store the records to the db. My question is, do these have to be two seperate Script Process Nodes?  Or can I combine my logic into one Script Process Node where Output 1 creates the workflow record in pv!workflow and then the second output creates the task records and appends them to pv!workflow.tasks?

I have a process where I have two script nodes.  The First creates a parent record type and stores it to a PV!: 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance'( 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{707eb7ae-ea9f-446e-9f88-d818ff7227fb}parentType': typename(typeof(pv!event)), 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{74c50dc1-dd17-43f3-92b6-98bf5753125a}parentId': pv!eventId, 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{c939f3ac-6a45-4ca5-9441-44aa056523ca}targetCompletionDate': pv!event['recordType!{f07fa26e-a28d-44ca-ab58-7ba4db20200b}WPA1 Event.fields.{987c7817-ad5b-4c64-b91e-0ab1087a91ea}endDate'], 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{d18891c0-c267-4d9a-8370-4bb662b7be83}createdBy': loggedInUser(), 'recordType!{f68fc74f-edcf-4bec-b576-6aa21d7ae8df}WPA1 Workflow Instance.fields.{d2b

Hi there, I'm on the last part of the instructions where we have to create a record action: 1. In the left menu, go to the Actions page.2. Click GENERATE RECORD ACTIONS.3. In the Choose Your Action dialog, deselect Update and Delete. For this exercise, you will focus on the Create record action. Click CUSTOMIZE.4. Configure the following properties:● Display Name: Enter Add Vehicle.● Description: Enter Action to add a new vehicle to the fleet.● Click NEXT: REVIEW OBJECTS.5. Review the objects that Appian generates for this action, including a process model and interface for adding a new vehicle.6. Click GENERATE. After clicking GENERATE in step 6, I am put back at the Actions page with the following error displayed (Your record actions and supporting objects could not be created. Try generating them again or configuring manually.): Interestingly, when I look at the object listing for the site, I see that the Process Model was generated, but not the Interface: Any suggestions

Can I assume Stored procedure in DB side and Expression rules in Appian side having same functionality/usage?

Doing Appian Developer course in which under Engage Logged IN Users excercise it is trying to add a second page as Action where we have to select Process Model which doesn't exist when trying to add an empty Process model it keep throwing this error - help me with steps how to getrid of it or point me to excercise which I missed and can follow to get rid of this error

I currently am doing an aggregate query that groups by two fields and sums a third field.  The result is the following: [period:1,week:1,total_hours:2]; [period:5,week:1,total_hours:3]; [period:2,week:2,total_hours:5]; [period:6,week:2,total_hours:8]; [period:12,week:3,total_hours:4]; [period:3,week:4,total_hours:2] I am trying to pass this data into a grid but with one row per "week" value with an array of period / hour values as below: [week:1,periods:[[period:1,total_hours:2],[period:5,total_hours:3]]]; [week:2,periods:[[period:2,total_hours:5],[period:6,total_hours:8]]]; [week:3,periods:[[period:12,total_hours:4]]]; [week:4,periods:[[period:3,total_hours:2]]] - Can this be done in the queryRecordType itself? - Which array methods would be best suited to handle this? - Should I be using foreach to do this?

I'm new to Appian. I have a user main page, and the user is able to click on a icon within the read-only grid, which is a recordactionlink, launching the interface to carry out managing of user information. Now, it would be simple if it was just the user I am handling. Considering that this action is within the "Users" Record Type as a related action, I was planning to also use this same interface to do management of another record type "Access" within the same interface. My issue is with the Access of course. With it being a grid/gridcolumn layout, with 3 columns, Location/Department/Role, the user is only able to populate the Access Record Type, 1 row per Location. Basically, the User Record Type and the Access Record Type has a one-to-many relationship. In an attempt to control the amount of rows the user is allowed to create within this interface, I first used a!for each to loop through the location Record Type, which basically ensures there's only as

In my community edition, I cannot see the DATA type in the New dropdown. Only the Record type is available in the dropdown. 

Hi I have a requirement involving two tables: Tyre Record Tye Columns: TyreID (Primary Key), PartNumber (Foreign Key)Country Restriction Record Type Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries. Requirement: We need to export the data in the following format: Part Number|Country1|country2|.......country150 12345 | 1 | 0 |................|1|

I am using appian-locust to perform e2e load testing. When I form.click_record_link(label="Related Actions", locust_request_label="Any") I encounter following error  msg, Type of record link and label are found but on different component. How to solve this kind of problems? Seems we are bound by whatever appian-locust gives us.

I have created a service backed record type where my source is a sharepoint list. The record type is sync enabled. New record is added or updated frequently in a day so a daily sync is not enough. The client wants to have an option to trigger the sync manually via a click of a button. So far i have configure sync optionThe problem is only the existing record in my record type gets sync for updates made in sharepoint list but the new item i created in sharepoint is not sync in my record type.

I created a service backed record type with sharepoint list as data source. The record type is sync enabled. New list is created or updated frequently from sharepoint list on a day. So daily sync is not enough. The client wants to have an option like a button to trigger sync right away. So far, I already configure sync option for the record type. And created a process model to trigger the sync The issue is only the records available in my record type gets sync on updates.But the record I newly created in sharepoint list dont get sync in my record type. Appreciate the help you could extend to me. Thanks

hello, i am new to appain and complete training program. i want to create online cart and checkout process app in appain. anybody assist me to how can i create it. i have started an app with cart process create database and record type. but i cannot get product listing view with component and pattern. How can i do this.

Hello,  I am looking for some options in Calendar grid adapting Outlook, that shows tasks, when user clicks should redirect to a link. can you please give some references. 

hello I'm new to Appian and i have a task to generate a pdf from word template i used DOCX From Dynamic Template smart service then PDF From DOCX i checked every thing but the document isn't generated i will attach the xml code and the word template [View:/cfs-file/__key/communityserver-discussions-components-files/62/Stationery-Request-templete-test.docx:320:240]   here is the xml generated  <orders><createdBy>sliman.izz</createdBy><createdOn>4/7/2025 3:50 PM GMT+02:00</createdOn><items><orderDetails itemName='test' itemCode='54' requestedQuantity='100' receivedQuantity='50' notes='not done' /><orderDetails itemName='test' itemCode='45' requestedQuantity='20' receivedQuantity='10' notes='not done' /><orderDetails itemName='test' itemCode='85' requestedQuantity='50' receivedQuantity='50' note

Hi Everyone, I am handling the task assignment through database tables. But when two users will click simultaneouly on the link which will start the process model. How to ensure that only one user should be given the task.

Hi Everyone, Is there any smartservice or utility in appian to convert docx files to pdf ?

or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups: cons!SLC_GRP_VERIFICATORE_INFRATEL), contains(cons!SLC_INTS_ID_FASI_PROGETTO_DI_CONNESSIONE[3],rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{12f3ca11-6e56-437c-a111-0188f3e80076}idFase']) ) ), or( and( rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{8435c94d-c75d-4250-b60c-267fa8e9fe8c}locked']=false, a!isNullOrEmpty(rv!record['recordType!{6456804e-1013-4209-bb05-6edb57f49898}SLC Progetto Di Connessione.fields.{6586c1e5-e5c7-4f5b-8a42-04f5c067aab3}utenteLocked']), a!isUserMemberOfGroup(username: loggedInUser(),groups:

a!localVariables( local!choiceValues: cons!VS_VALUES(list of array : "AB","BC","CD",) local!dropDownValue, local!value, a!multipleDropdownField( choiceLabels: local!choiceValues, choiceValues: local!choiceValues, value: local!value, saveInto: { a!save( local!value, if( contains( save!value, index(local!choiceValues, 1, {}) ), 0, save!value ) ), a!save( local!dropDownValue, if( contains( save!value, index(local!choiceValues, 1, {}) ), remove(local!choiceValues, 1), save!value ) ) } ) ) Hi All. Hope you all are doing well.  I am using multiple dropdown and working with records. The above code i am trying to edit already present value in the multiple dropdown. Above is the code .  If i try displaying the selected value i am unable to deselect it and

Hi, I'm new to Appian and apologies if I missed something really obvious.I'm running into an issue attempting to capture selected choices and their respective labels of an a!multipleDropdownField(). I've declared 4 local variables to hold the list of available choice labels, available choices, selected choice labels and selected choices. a!localVariables(  local!arrChoiceLabels: {"Option1", "Option2", "Option3"},  local!arrChoiceValues: {1, 2, 3},  local!arrSelectedLabel: if(    a!isNullOrEmpty(ri!rec.selected),    {},    split(ri!rec.selected,";")   ),  local!arrSelected: if(    a!isNullOrEmpty(local!arrSelectedLabel),    {},    wherecontains(local!arrSelectedLabel,local!arrChoiceLabels)  ), Then I tried to plug them into the multiple dropdown field,  a!multipleDropdownField(    choiceLabels: local!arrChoiceLab

I have added the Wyndhamm Power Outage app from the App Catalog, then I need to add my user to the Technicians group but this group doesn't exist. The Appian Community Edition is on a later version - 24.4 - and the exercise is based on 24.2 version. In Security Summary a warning is detected: "Missing administrator group. No basic users will be able to administer these objects, which includes editing their security or deleting them".

Hi there. Is there any way to take out the "Summary" icon when I see the Summary record? I have exploring the Views section in the Record Type but I don't know how to set this feature to remove the Header: Thanks in advance!

Hi, I am working through the developer course and I am up to the Query Your Data part. In this section it references a record AA_Get Vehicles that was meant to be created earlier, but I can't work out where this was created? I don't have this record and I have been back through everything and can't find where I am meant to have created it. Thanks Haleigh

Hello all, I am currently working on an interface that includes an editable grid. Although the backend processes the percentage field modifications correctly, the site displays incorrect values, particularly in some other rows.

hi, i am using a!forEach to create a list of variants and wanted to return the iteration item as Array/List itself for eg, a!localVariables( local!testVariable: { "A", "B", "C;D" }, local!valuesAsArray: a!forEach( items: local!testVariable, expression: if( length(split(fv!item, ";")) > 1, split(fv!item, ";"), fv!item ), ), local!valuesAsArray) Above expression is returning results as {"A", "B", "C", "D"} Instead i wanted the results as {"A", "B", {"C", "D"}}. Any suggestions on how to achieve this