-
Recently active
I have a requirement where I have to find the distinct value in the grid column and display it Any suggestion
Hello, In order to display a specific content on a mobile, I have an interface with the following elements: A data subset loaded as a local variable when the interface is loaded (in my business case it's a list of tasks to execute for the user) A list of cards that will display the elements of the datasubset (forEach) A showWhen parameter for each card, if the user click on the card it will open another card to display detailed informations based on the same data subset As long as the mobile network is fine the interface works fine BUT if the network quality is getting worse while using the interface, it is no longer possible for the user to click on a card, as if the data subset was trying to refresh (or reload) with each click. There no message to indicate that the mobile device is offline. I could replicate the scenario by doing so: Loading the page and clicking on card to display detail > OK Tunrn device to offline > no offline message and it's not possible anymore
Hi, I have a requirement where, I have to be able to show the goals for a employee to resubmit as a step after he selects and submits the goals for the first time incase, he/she needs to add/remove any. The local variable 'FunctionalGoals' contains the list of master data as a type from which they can choose goals(1st cdt). It has only goaltype, subtype as columns in this case. The 2nd local variable 'SubmittedFunctionalGoals' contains the goals that have been submitted for the 1st time by the employee(2nd cdt - Transaction table), This has the remarks and startdate and enddate columns. There is a 3rd local variable 'SelectedFunctionalGoals' Which has the new goals which the employee selects (storing this as I need to make the respective remarks and startdate, enddate editable and required for that row). so fetching the remarks and startdate and endate for the submitted goals(1st time selected goals) is what I am stuck with. Hope I am able to convey the issue pr
Hey all, I have 2 user input tasks. For both tasks, I need to implement/adjust alerts as follows. Number of days are calculated since the sending of the 'First task' task to the users (i.e. the deadline for both, the Primary Traveler and the Line Manager's tasks together must be 12 days). After x days 1st TASK 2nd TASK 3 Primary Traveller 0 6 Primary Traveller & Line Manager Line Manager 9 Primary Traveller & Line Manager & Compliance employee who approved the travel request Line Manager & Compliance employee who approved the travel request 12 Mail to Compliance with info that this Post Travel Form has still not been been completed/amended by the Primary Traveller and approved by the Line Manager Mail to Compliance with info that this Post Travel Form has still not been approved by the Line Manager THE POINT IS THE DEADLINE FOR BOTH TOGETHER MUST BE 12 DAYS. I first installed escalations for the primary travelers
Hi, Can we initiate a process model from barchart? Different process model should be triggered for different category data source: recordtype
QUESTION 1> Suppose we have 1 array : local!arr : {a,b,b,c,c,c,d,d,d,d}. Then how we will print in the pattern like a, b,b c,c,c d,d,d,d. QUESTION 2>Suppose we have 2 - arr1: {"apple","banana","mango"}, arr2:{"a","b","c"}. How we will print if we choose "a" then it should print "apple" , if we choose "b" then it should print "banana" , if we choose "c" , it should print "mango".
Hi, I have a multipleDropdownField and it is working perfect in ADD functionality mode of user interface. I have trouble in EDIT functional flow. If users have selected a value in ADD mode, I need to show the same along with other dropdown options. This also, I am able to finish successfully. The issue is happening if user(s) added any new items along with existing item(s). I am not sure how can I handle this situation. Do I need to delete from db the previous records and re-insert new ones or any other process I need to follow.
Hi, Is there any equivalent to Switch or Case statements in Appian. If I have to implement code similar to the below code line, how can I achieve in Appian. Any suggessions. CASE WHEN ( action="A") THEN WorkflowStatus="WAC", RequestStatus="RAC" WHEN ( action="B") THEN WorkflowStatus="WBC", RequestStatus="RBC" WHEN ( action="C") THEN WorkflowStatus="WCC", RequestStatus="RCC" END CASE
Hi Team, I am using Appian with backend SQL Server database. I have observed that the IDENTITY column value of a table where I am storing data is skipping number sequence all of sudden. If you observe in my below attached screen, it started showing 1009 after 24. I was unable to trace the root cause of the issue. Can someone advice on this please. Thanks.
Hi, We have a three records . Record A has one to many relationship with Record B and Record B has one to many relationship with Record C We are displaying the all three record data in a grid. We are having issue when display Record C data if one of the row has no value for Record C. Here is the snapshot of the grid column. We would like to show each lineItem as numbered list. In this example P2P is top level record. a!gridColumn( label: "Tracker Entry Date", value: if( a!isNullOrEmpty(fv!row[P2P.invoice.lineItem.name]), "", a!richTextDisplayField( value: a!richTextNumberedList( items: fv!row[P2P.invoice.lineItem.name] ) ) ) ), This works fine in the design mode in the Appian designer. When we access this from the site it throws an error. "Text?list must be used within a SAIL component" We don't want to use for each to iterate over each item to check null as it is causing performance problem. This issue occurs when an invoice does
Basically the title. Is there any way to play a video that was uploaded to the Appian Knowledge Center in an interface for a user?
Web Video will not work since it only plays videos that have already been uploaded to the website by a different way
Hi Team, We are using a paragraph component in our form-layout interface. We are saving its value in a rule input. Though the paragraph would be visible, it would be allowed for editing only when a specific condition is met. The rule input gets updated in an interface but in site page the value is neither getting updated nor reflected in the component. It just disappears. The form is called via a related action from a record type. Below is the code : a!paragraphField( label: "Closure Notes", labelPosition: "ABOVE", helpTooltip: "Maximum 1000 character allowed without extra space", value: ri!closenotes, saveInto: ri!closenotes, disabled : ri!status<>"Closed", refreshAfter: "UNFOCUS", characterLimit: 1000, height: "MEDIUM", required: if(status="Closed",true,false) ) Please let me know how to resolve this
Hi, I have a Multipledropdownfield where users can select multiple items. Based on the user's selection I have to update the value in another field. When the users un-select all the items and when I check the value which I am storing in the local variable, is not showing as null if I check using isnull(selectedIds)
Hi Folks, How can I have expand-all and collapse-all feature as a button/link in my interface which is having multiple section layout. I know we have is collapsible and isinitiallycollpased parameters which are present. But that works only on page load. How can I make it dynamic which is work on clicking of a button or link? Regards, Ghanashyam
Hi, I am using a barcode scanner to read an asset and display its details. This part is working fine but I want to clear the existing entry in the barcode field for subsequent barcode scans. How can I make it work? Thanks a!barcodeField( label: "", labelPosition: "ABOVE", instructions: "Scan the QR Code of the Asset", acceptedTypes: "QRCODE", value: local!asset.partId, saveInto: local!asset.partId, refreshAfter: "KEYPRESS", validations: {} ),
Hi, I am getting "Missing Keyword Syntax" icon besides my expression rule. There is nothing wrong in calling my expression rule. It is expecting 2 inputs and I am passing. Not sure how to resolve this. Any recommendations please.
Hi All, I have user interface with a read only grid and a button called "ASSIGN" to each row. When the user clicks on any of the button "ASSIGN" then for the respective record I have to update few columns again the selected database record. When I try to use a process model with a "Write to Data Store Entity" then it is making NULL to all of other column value except which I have try to pass. How can I update the specific column value when the user clicks on the "ASSIGN" button without touching all other column/field values in the database.
Hi all i have button layout and i am adding an additional button, with this one, when clicked, the button should go to external website, per say google.com. but a!buttonwidget doesn't have a link field. I found a workaround but that creates a linkfield that opens up once the button is click, the user than has to click the linkfield. but this is outside my acceptance criteria. once the button is clicked, it should go directly to the external website. Any ideas? Thanks.
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
how to write validation in date field so user cant select any date from past?
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?
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
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.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.