Is it possible to make an attachment unclickable

Hi Anthony,

You can decide to use an expression column that takes the value of the File name field and presents it as Text rather than a File upload field. With a Layout procedure, you can make sure you see the Text in Navigation mode, whilst seeing the File upload field in Add/Edit mode.

Hope this helps!

Hi Anthony,

Not quite, the Layout procedure can only affect the Visibility of fields and tell the GUI to make fields Mandatory.

Let's say you have the following in your table:

col_id int (primary key)

file_name varchar(1000) 

file_data varbinary(max)

file_name_text varchar(1000)

The column file_name has a domain with the File upload control, whilst file_name_text does not have the same domain but rather uses a generic domain that is simply a varchar(1000) and has no control).

File name text is an expression column that uses the following query to obtain its value:

t1.file_name

Indeed, nothing more, nothing less😃

In your Layout procedure for the desired table, write the following:

if @layout_mode = 2 -- Navigation
begin
    set @file_name_type = 3 -- Hidden outside form, shows expression column instead
end
else -- Add or Edit mode
begin
    set @file_name_text_type = 3 -- Hidden outside form, shows File upload column instead
end

This will ensure that when you are Adding or Editing a record, the File upload field is shown, whilst in Navigation mode the File name text field is shown instead. Note that this only functions in the Form. The grid cannot interpretate the _type parts of the Layout procedure.

This should do the trick, let me know 😄