-
Recently active
Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022, how to we retrieve the date range like " 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]
Hi All I am currently working on version 22.3!! I have a use case wherein one of my current process is started when an external system sends email on the process model id i.e.: processmodel<id>@companydev.appiancloud.com( here dev represents the Appian environment). The requirement is that:The system can receive external mails using company's SMTP i.e. @company.com rather than @companydev.appiancloud.com. Would like to know is there a way I can do this? I have read the the topic "Legacy configurations" in the link below but I am not able to understand what does reply-to-address means and will it even help me in my problem: https://docs.appian.com/suite/help/22.3/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email Thanks in advance!!
I have a string "a,b,c" I want to convert that to array of string.
Hi everyone, I'm having above error message after using a!todatasubset(), my code is as below: local!pagingInfo: a!pagingInfo( 1, 1, a!sortInfo( field: local!emailsRelatedToCase.id, ascending: false ) ), local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo ), within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email. Did anyone see this error before? Thanks a lot,
hi, I have built a bar chart with a simple measure of SUM of time but when I put the labels I see a value like 47.9499999999999996 I have checked the issue is not with data.. I do not have that kind of data. I have a solution that I round off the the time taken, store it in another variable and use it for SUM and it works.. but I cannot individually round off the time field.. the overall data deviates a lot. All I need is to round off the above data to 47.95 .. when I see the expression generated by the MEASURE function on the chart I see Is there a way i can modify this expression so that it returns a value upto 1 or 2 decimal places.. I tried using round func in this expression but that's not working thanks much jaideep
Hi Team, During our performance testing, we are getting below error . when manual testing we are unable to reproduce it , Expression evaluation error [evaluation ID = c5310:d3811] in rule 'dsm_getslariskcasescount' (called by rules 'dsm_d_dashboardreport' > 'dsm_recordsyncbasedhomepagemain') at function a!queryRecordType: APNX-3-0000-002: The real-time store is not up to date to the requested tx 102138493; latest tx is 102138487 (APNX-1-4198-000)
hi, I want to Complete the empty space to save space, what are the best practices?
I have a read-only grid which should show all the rows with filter (isResigned) when I open the report. Along with that I have pie-chart in the same report based on last working date. So, now when I click on pie chart the read-only grid should be updated based on my selection. I am able to get the full report with filter isResigned but when I select the column the read only grid is not getting updated.
On the process minning install documentation (https://docs.appian.com/suite/help/22.3/pm-5.6/admin/install.html) in the Production installation section step 6 says: Modify the following mandatory parameters in the .env file Shouldn't it be .env-prod? and if so step 6 should be merged with step 5. Because when you run ./pm.sh use-prod-config the file .env will be overwriten with the contents of .env-prod Thank you.
Hi, I have setup a timer to run "Daily" and "Every weekday" at 4 PM. This should trigger a email notification. But, I am receiving an email notification on every day at 5:30 AM EST.
After updating the plugin getting the following errors (Note: It was working fine in the earlier version) : Import CSV to Database v6 - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.Snippet of Datetime format - "2021-12-10 14:20:42.740" Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.
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).
Hello, I'm looking for a best practice how-to enable a user management within an application. Basically there are two main roles within the target application: administrator role - I assume that one can be based on the appian built-in user management standard user role - thats a role where an "anonymous" user can apply for with a self choosen username and password based on an application built login interface such user will have some additional things to do What would be a good way to achieve this if any? Thank you in advanceThomas
How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection
Hi Team, I am looking for a plug-in or Public Appian API or function to list all Folders in an Application including rule, process model, KC, document folders. I tried with below function which returned only the folders inside KC of an application when given searchCriteria with APP_PREFIX&*. Please do the needful findcontentbyattribute( searchAllContent: false(), contentType: "folder", attributeName: "name", searchCriteria: "<APP_PREFIX>*") Thanks, Bharathwaj RK
Hi Everyone , i want to extract pdf file data into database. if any smart service or plug-in is available in appian ? like: ( we have importfromXL to XL files ) please suggest the best way to achieve this. Thank you
I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,locationhere language Id is : id for languages ex: english =1 , french=2, hindi=3 etc unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.Please do help, am struggling to implement it. &
Hi I am trying to find inactive users using getuserlastlogin function. It returns date for some user and for some user it returns null. Am I missing anything?
In a gridField() fed by record data, when you try to use the disableRowSelectionWhen param, record references fail to be evaluated. As an example, we were trying to disable row selection based on a date time in the record data. Originally we had it wrapped in a todate() so we could compare it to a date, but the logic was failing to disable the desired rows. Just for fun we removed the todate() around the record field reference, only to be smacked with an error about not being able to compare Null to a date. That's right, the record reference evaluated to Null. For more fun, we tried using fields that were not dates, and the same thing happened on integer fields, i.e. the record reference evaluated to Null. Has anyone else run into this?
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.
how to redirect to site record page by using record link. a!linkField( links: a!recordLink( label: fv!row['recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type.fields.{986b4d5b-200e-4665-a365-33808cab1533}name'], recordType: 'recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type', identifier: fv!identifier, dashboard: "summary", openLinkIn: "NEW_TAB" ) )
Hi, I have a requirement where I have to schedule a task i.e to activate RPA agent from the server on each day when server comes online, I have used task scheduler to trigger the agent but its not being stable as it is activating and deactivating the next minute, which is leading all the RPA processes to be in queued. Please update with any solution.
only document id shown is there any changes in Interface ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.