Foundation

Hello, I'm new to Appian and I'm facing an issue in Appian Step-by-Step #11 Exercise specifically in the Request maintenance process model,  it gives me this error below :  Unable to write to the source due to system error.Error Details: Column 'VehicleID' cannot be null Even though I have given the vehicle a default value in the Request Maintenance Interface and have assigned it in the store additional values node as an output. Please let me know if you got some ideas to fix it. Thanks in Advance!

Hello, I'm new to Appian and I'm facing an issue with Exercise 10, I have completed all the Add New Vehicle process model successfully, except for the cancel condition because as shown below, I couldn't assign a value to the rule input cancel .. even though I have assigned it successfully in the Add New Vehicle Interface. Please let me know if I can do anything else to fix it. Thanks in advance!

Hi, Is there any way I can get to know which objects are deleted from the application ?. I know that it is not possible to retrieve those objects back but is there any way to know the details like name of the deleted object and who deleted it etc. Thanks

Consider I have created a package and added 5 objects. Someone has removed some objects in the same package. And I didn't notice that and added some objects in the same package. Now the last modified was updated by me right. But I need to see who has removed the objects. Can anyone help me in find this?

Hi,  We have a requirement to create reports using BigQuery data. If we use API to access BigQuery the data is very huge and we are unable to process it or we need to call the integration multiple times to retrieve the data. Instead, we are trying to configure BigQuery as a data source. Do we have any plugins or a way to connect to Google BigQuery? Please let us know. Thanks, Bhargavi.

Hi All, Recently got an inquiry for use case where users would like the ability to click a link provided in an email which will navigate them to either a Start Form or User Input so they can reach the necessary screen faster. Users recently want to streamline their emails and provide a link to the necessary page where users will perform the necessary action that is being notified in the email. Issue with this inquiry I believe is there is not possibility to do this outside of the start page URLs on the sites. Given there are about two dozen different forms they could be wanting to access through the email I can't think of a solution to provide a unique link for each one of these process models. Does anyone have a use case where they made this work or a useful plugin that may make this possible?

Hello All, I have a question, is that possible to provide helptoolTip in textfield that each item has to be shown different helptool,like I have decision for each parameter different HoverOver_desc (placed screenshot) has to be shown, how that can be shown in textfield? a!textField( readOnly:index( rule!CR_RISK_PARAMETER_MAPPING( Param_description: fv!item.parameterId_int ), "isReadOnly_bool", {} ), value: rule!CR_RISK_PARAMETER_MAPPING( Param_description: fv!item.parameterId_int ).parameters, saveInto: rule!CR_RISK_PARAMETER_MAPPING( Param_description: fv!item.parameterId_int ).parameters, helpTooltip: rule!CR_RISK_PARAMETER_MAPPING( Param_description: fv!item.parameterId_int ).HoverOver_Desc, ),

Greetings, I am having an issue with a!exportDataStoreEntityToExcel() but I do not have an issue with a!exportDataStoreEntityToCsv(). They use the same inputs. I have uploaded a screenshot of the error message on the interface. I checked the tomcat-stdout log file and it says java.nullpointerexception. We are using a View on a PostgreSQL database. I am not too positive but it might have stopped working after manually erasing some rows in the tables for the View. We optimally want the Excel one working. Does somebody know what is wrong or have a similar issue? a!buttonWidget( label: "Generate Export of SFNS Orders", tooltip: "Export Available for Product Creators", /* tooltip: if(local!productCreatorUserStatus = true, null, "Export Available for Product Creators"),*/ saveInto: { a!exportDataStoreEntityToExcel( entity: cons!PMT_DSE_VIEW_SFNS_VIEW_ORDER_GRID, selection: { a!querySelection(

Hi everyone, Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the data store [CR Data Store]. No values have been written. Details: could not insert: [CRModuleCommentsDT2354] (APNX-1-4208-004) This error will not be displayed to the user viewing this form.  I am getting this error in interface,as per the requirement made changes  and in the existing implementation  a!writeToMultipleDataStoreEntities used in UI. Can anyone suggest me a solution for it? Thanks in advance.

Hi everyone, here is my interface a!startprocess in this interface always return the same result even if I update cusNum parameter still same value and here is my process model: when i run the process model: here is the call integration data outputs :

Hi Team, I have a requirement to send email outside our organization with an embedded link to either accept or reject the mail. Once the recipient receives the mail, he/she should click on the link which would open up a page for the user to either accept or reject the mail. This information then has to be passed back to Appian and the work-flow to be continued then. This email response from user is time-bound. If within specified time the user does not respond then the default work-flow is to be followed. We don't want to use a delay timer. We would like these processes to be asynchronous. Can someone suggest me how to achieve this? Any help is appreciated. Thank you!!

Process Model ran successfully but Values were not written in DB in Write to multiple data store entity. We have the values available in variable, what can be the cause?

Hi techie,Is it possible in Appian to give a value inside the donut chart like I below?

just wanted to know the step how to trigger an record action from submit button

If I want to develop look alike application as IDP in a simple way. What are things need to be considered in designing, development?

Is Appian supported with multi-factor authentication for the created applications? i.e. end-users will be required to login with 2FA whether SMS OTP, Email, or Google Authenticator. I found a link here in the community, however, it's broken.

Hi Experts, We got a specific scenario from our client where we have to keep our process waiting until a time provided by user matches with the server time. So from the UI user is providing date in one field as &quot; MM/DD/YYYY&quot; and time in a different field as &quot;HH:MM:SS&quot; and timezone in another field.The process node must only gets triggered or move to next node only when time provided by user matches with the server time.I&#39;m using below code but its not working as expected a!localVariables( local!split: split(ri!endSearchTime, ":"), local!day: day(ri!endSearchDate), local!month: month(ri!endSearchDate), local!year: year(ri!endSearchDate), local!endSearchDateTime:datetime( local!year, local!month, local!day, local!split[1], local!split[2], local!split[3] ), todatetime( if( local!endSearchDateTime - ((gmt(local!endSearchDateTime) - local!endSearchDateTime) - rule!TEST_ER_TimeZoneOffset(ri!endTimeZone)) < now(), now

I have a Process Model that creates a record. That record has a field &quot;record types&quot;, which can be A, B, or C. Based on which record type is selected, I would like to create a record from a related table with additional inputs. I have tried following this documentation:&nbsp;https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html#create-records-and-related-records,&nbsp;but there is a lot that it leaves out.&nbsp;Here is an example. If the Record Type is A, the process forks down to &quot;Create A record&quot;.My problem is creating the A record. The A table has a 1-1 relationship with the Record table.Some specific questions I have are:What should&nbsp;the process variables be set up like for this?&nbsp;How should the &quot;Create A record&quot; Data section be set up for this process?Both tables have Auto Incrementing IDs, is any additional setup needed for this on the actual Appian platform? If so, what?Are there any additional services or processes needed

I am training the document in the reconciliation task. i am able to read all the text fields. but unable to read the check boxes. What could be the reason? Thanks in advance

Hi everyone, how can I obtain the list of the extension of files that are shown in an interface by the document viewer?I checked the documentation and there are no indications or lists about the formats allowed.

Hi, I have a constant which contains array of text, I want to check if a given value is in the array subset of that constant. For that I&#39;m using- contains( { cons!TA_CITY_LABEL[1], cons!TA_CITY_LABEL[3], cons!TA_CITY_LABEL[4], cons!TA_CITY_LABEL[7] . . . and many more }, local!label ) I wonder if there is any solution to it as I have to write the name of constant again and again and I&#39;m checking this multiple times on different datasets.

I have an expression rule which is containing a data with multiple values, I am trying to insert that data to dropdown choice labels and choice values but I am not able to do that.Can anyone help me to configure that?

I have file(docx,pdf) and i have to retrieve or extract comments from the that.

Hi Expert, I have made a expression rule which is returning datasubset . For eg: This is my query entity returning data. Col A &nbsp; Col B&nbsp; &nbsp;Countcolumn a &nbsp; &nbsp; &nbsp; &nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 d &nbsp; &nbsp; &nbsp; &nbsp; e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 g &nbsp; &nbsp; &nbsp; &nbsp; h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Now i want to repeat row based on count column.How can i achieve following output: Col A &nbsp;Col B a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;e g&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; h Please help.

Has anyone been able to run FitNesse for Appian with a Password File? http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordFile Here&#39;s what I&#39;m seeing.&nbsp; All runs use the following command java -jar fitnesse.jar -a "passwords.txt" where the passwords in each file are cleartext or encrypted passwords.txt users.properties Result cleartext cleartext good encrypt cleartext good encrypt encrypt Invalid argument encrypt no user=password line error encrypt no file error cleartext no file error When it&#39;s run, the authenticator&nbsp;says MultiUserAthenticator (password.txt) versus PromiscuousAthenticator (users.properties).&nbsp; But, the above tests seem to indicate that passwords.txt is being ignored completely and FitNesse is only using users.properties. I hope someone can shed some light on this for me.&nbsp; Thanks