Validate file attachments or image upload on save
There are two variables available to have the attached or image field values in comma separated string.
Axp_AttachedFiles - is a variable that will contain the list of files (header attachments) attached as comma separated string.
Axp_LoadedImages - is a variable that will contain image fields as comma separated string.
Using which, a validate expression can be defined as shown below...
iif((Axp_loadedimages # {}) & (Axp_attachedfiles#{}), {T}, {File/image is not loaded})
Related Articles
How to download or open attachments from Iview
Files or images attached in a transaction can be viewed through iview hyperlink It uses two columns to achieve the functionality. Column1 - display the hyperlink ( it’s the regular iview column. Eg: Attachment as column name) Column2 - have path and ...
Error in Excel Import : Unable to connect to Excel, make sure given file is an valid Excel file
This issue could be due to OLEDB driver missing in the respective system, where the application is running. It can be downloaded from the below link and installed. https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255 [Access database ...
How to concatenate image data in Postgres to use in fast report
Define your own aggregate to do binary concatenation and use it sql. https://stackoverflow.com/questions/10194117/append-binary-content-to-bytea-column-in-postgresql-database eg. CREATE AGGREGATE bytea_add(bytea) ( sfunc = byteacat, stype = bytea, ...
Postgres 14 version has an issue in establishing connection from Axpert
PostgresSQL 14 uses “scram-sha-256” method for authentication by default (as per pg_hba.conf file), which is causing the connectivity issues in Axpert. Solution for the issue : The method “scram-sha-256” needs to be replaced as “trust” in pg_hba.conf ...
How to activate offline license
First, you activate as offline using the below mentioned option. A Reg file will generate in your axpert folder. Share that "Reg" file to License team, They will provide you ".lic file", you paste that .lic file in your axpert folder.