-
Recently active
a!localVariables( local!data:rule!VG_CRK_RT_get_all_srvc_nm(), local!exportDocId, local!errorMessage, local!flag:false(), a!formLayout( label: "", contents: { a!sectionLayout( label: "", contents: { a!radioButtonField( label: "Select Any Option", labelPosition: "ABOVE", instructions: "", helpTooltip: "Before Uploading, Download a file for service, to view latest data", choiceLabels: {"Download", "Upload"}, choiceValues: {false(),true()}, value: ri!isUpload, saveInto: {ri!isUpload}, required: true, choiceLayout: "STACKED", validations: {} ) } ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Before Uploading, Download a file for service, to view latest data" } ), a!dropdownField( label: "Service Name",
how to validate a text field which can be A,B,C,D, Null, or groups of A,B,C,D (ex. ‘A,B,C’ with commas no space).
HI All, I have SAIL form with summary details and a grid. i have a add card layout button above the grid which will open different process to add data. when Calling Process model using a!StartPRocessLink service under add button(card layout) from Parent Sail form which mostly read-only info. when i click on Add button , i receiving a message saying you would like to leave from this page., looks like its browser message. navigate to chained forms/process model and once added data its expected to come back to same form. Please suggest how can i avoid such message, Thanks in advance.
Hi everyone, I'm quite stuck at this part so I'm needing some helps [emoticon:6d505171faa4497c85c5ca27290c555d] I built an interface to show a report which data is from a view, the view looks like this table below: Case Id Step User doing this step Updated Date Time 1 Created Molly 11/11/2021 5:11 2 Processing John 11/9/2021 7:22 2 Pending John 11/3/2022 8:33 2 Completed Molly 11/2/2022 9:11 3 Created Nick 10/5/2022 13:20 4 Processing Nick 9/9/2022 9:09 4 Pending Molly 12/8/2021 6:12 4 Completed Molly 12/6/2021 6:12 4 Created Molly 22/10/2022 1:20 The interface does not show updatedDateTime + Step (business requirement), and was filtered by loginUser(), which is why I got this result of duplicating rows with same case ID and other columns all have the same values in the report for the same case. Is there anyway I can get the unique row using Appian if there are duplicating row in the interface? Case Id Created date Related
Hello everyone, Trying to add back button on the summary page and then returning back to the same list, but not getting any perfect solution for this. "I need back button on summary page and when a user clicks on it, it will get back to the same list." Thanks for any help.
Hi, I'm trying to dynamically display a!datefield based on multidropdown values. If user has selected 2 values from the multidrpdown component, then I should display 2 datefields for user to select dates. I'm trying to do this with a!foreach , however I'm not able to store values. Can you please help me with this? Sample code: { a!multipleDropdownField( label: "Titles Held", labelPosition: "JUSTIFIED", placeholder: "--- Select a Value ---", choiceLabels: local!titleNames, choiceValues: local!titleIds, value: ri!selectedTitleIds, saveInto: ri!selectedTitleIds ), if( a!isNullOrEmpty(ri!selectedTitleIds), {}, a!forEach( items: ri!selected
Hi All, I have to show a text field below the "Reassign button" like some instruction but I am not getting how to do that,since it is 17.4 version. Please help me sort this out. Thanks in Advance.
Hello all, I'm trying to create 2 dropdowns where the 1st dropdown will show the unique manufacturer brands from this table. I managed to do it, but the 2nd dropdown is to get the motorcycle models based on the selected manufacturer. The catch is I need to only make a single query. What I did is I created a query rule then saved it to a local variable. On the 1st dropdown, I used union function to get the unique manufacturers from the local variable containing the query. However, I'm having a hard time on the 2nd dropdown.
Hi, I want to create an interface when the users select the date, then the form will display a form for the whole week, example I choose 4 Nov 2022, will generate a form table to display the week to allow the user to enter how many hours they work on the day. such as something like this
Hi,Could someone help me understand the concept and solve my below problem? I have a Two tables 1. VehicleTypesFieldId category1 Cars2 Buses3 Trains 2nd table SubVehicleTypes SubID Id SubCategory1 1 Sedan2 1 Suv3 2 Luxury4 2 Semi luxury5 3 Ac Trains6 3 Non Ac Trains Requirements:1. Drop Down 1 will have data from Table 12. Drop Down 2 will have data from Table 2 I want to display the selected field in 2nd dropdown with the list like Actually i want this
Hi, I am tasked to do a timesheet POC, I am asking the user to select the date, and I will using the weeknum function to find out the week number, after that will add into the database and wait for supervisor approval. How to verify the week number is exist in the database record before the user submits the form. Please kindly assist me thank you
Hi Team! Good morning! Need your help/suggestion on the below: I have got a requirement like the check box should appear on the UI with all possible values as selected(ticked) by default, then the user unselects the option that they does not require and submit it. I have tried the below snippet, where in UI its appearing with all the values checked, but upon unchecking the box, it gets selected again. Can you please help me or let me know if there is any possibility to achieve this functionality ? Code snippet: a!localVariables ( local!Checklist:{"A","B","C"}, a!checkboxField( label:"Checkbox testing", choiceLabels: local!Checklist, choiceValues: local!Checklist, value:local!Checklist, saveinto: a!save(local!checked, save!value) ) ) Expected result: 1. At first ,all the options get checked by default 2. The user can able to unselect one or more of the option and submit it Actual result: But after unselection, the values gets chec
Hello! I would like to prevent users from using emojis in comments, however I have absolutely no idea how to accomplish that. Have you got any advice, folks?
How to make a card layout collapsable?
Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult". If it's a group, I will have to tie into the "groupResult" method. The properties are the same, but the methods are different. I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.
Hi There, I’m trying to use card as buttons pattern to call an interface. Interface is having gridfield used inside a!headerContentLayout() to display task lists. However, I’m not sure how can I call call this interface using card as buttons pattern. Is that a right way of calling ? Please do let me know if you need any more details.
Hi everyone, I just created one interface which queries data from a record type, to build a dashboard. I want to call that interface into a bigger interface, in which if I click the card field, the dashboard will show up. This existing interface is using a!cardLayOut for displaying other field, and I couldn't find any solution to call the new interface into it, as the a!cardLayOut link parameter only accepts a!documentDownloadLink(), a!dynamicLink(), a!newsEntryLink(), a!processTaskLink(), a!recordLink(), a!reportLink(), a!safeLink(), a!startProcessLink(), a!submitLink(), a!userRecordLink(), or a!authorizationLink(). Is there any way I can work around with it?
Hi team I'm needing some help to force an answer in a dropdown field where a given answer is selected in another dropdown field. Here is a screenshot of the editable grid. I want to force "not used" in the "how important" column when "never" is selected in the "how often" column The software names are returned from an existing table. This is how the answer table is set up: Answer Table id Name questionID 1 Daily 1 2 Weekly 1 3 Monthly 1 4 Quarterly 1 5 Annually 1 6 Never 1 7 Vital 2 8 Important 2 9 Useful 2 10 Not Useful 2 11 Not Used 2 The questionId corresponds to the two column headings. Here's the expression for teh editable grid: { /* For the Software Title Column*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.softwareID.name, color: "ACCENT", size: "MEDIUM", style: "STRONG" ) ), /* For the Frequency Of Use and Vitality Columns*/ a!forEach( item
Hi all, I'm creating a record hours system app, I made the interface that lets the user insert his start time, and leaving time then, the system should calculate the duration between start time and leaving time. the problem is when I finished the code, I got a problem which is A null parameter has been passed. then I've tried to solve this issue by adding this before the first if sentence: if( a!isnullOrEmpty(ri!ES_Working_Hours_Record), null, hour(ri!ES_Working_Hours_Record)) but I have a casting problem now, I got this: Interface Definition: Expression evaluation error at function 'hour' [line 36]: Could not cast from ES_Working_Hours_Record to Time. Details: CastInvalidCould not cast from ES_Working_Hours_Record to Time. Details: CastInvalid this is the code: a!formLayout( label: "Working Hours Record", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dateTimeField( label: "Start Time", labelPosition: &qu
Hi, As the "Save Draft" is a completely internal Appian function, is there any way to retrieve those data with an Appian function or plugin?
How to suppress rows in record view grid based on some condition, and expand the hidden rows after button is clicked.
I'm attempting to populate a record section from the click of a grid. Not sure how to populate the record...also wanted to ensure I'm building out the grid properly. Thank you. a!localVariables( local!selection, local!selectedRows, { a!sectionLayout( label: "Results", labelSize: "SMALL", contents: { a!gridField( label: "", data:{ a!map(id: 11, Name: "Elizabeth Ward", dept: "Engineering", role: "Senior Engineer", team: "Front-End Components", pto: 15, startDate: today()-500), a!map(id: 22, Name: "Michael Johnson", dept: "Finance", role: "Payroll Manager", team: "Accounts Payable", pto: 2, startDate: today()-100), a!map(id: 33, Name: "John Smith", dept: "Engineering", role: "Quality Engineer", team: "User Acceptance Testing", pto: 5, startDate: today()-1000), }, columns: { a!gridColumn(
I am working on developing a inventory data collection application and would like to have it play an audio sound if the barcode scanned is a valid part no. Any thoughts on this?
this is the code i have written
Hi I want add or complete data in a text fields in an interface (image below) to update many rows of my db at one go, instead of updating one by one or row by row For example, complete the form interface (image above) to update 5 rows at one go... this rows of my db which would be the best practice or help me with examples? please help
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.