Why are urls in spreadsheet not clickable, even though I formatted the field to "URL" type?

 
1
0
-1

Hello,

This is how urls appear in spreadsheet, and they can't be clicked. I have to copy and paste them.

This is the settings for the spreadsheet:

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      Hi, kindly try this:

      On spreadsheet design properties screen:

      When you run the Spreadsheet form, key in:

      • Cell Value = 715_jmrb_meetingRoomBooking

      Save the spreadsheet, reopen same record, Joget Workflow will display in the URL cell "715_jmrb_meetingRoomBooking" which will be an automatic hyperlink.

      Clicking on the link will bring you to the page "http://10.1.12.224/jw/web/userview/jmrb/v/_/form?_mode=edit&id=715_jmrb_meetingRoomBooking" where Joget has plugged in the id value of "715_jmrb_meetingRoomBooking" into the address stored in the spreadsheet FORMAT column.

      Thank you.

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi,

        Refer to Spreadsheet, the URL format type is used to convert a value to URL following the URL pattern in "Format".

         

        For example, to convert an id field to URL

        Field ID : id

        Label : ID

        Format Type : URL

        Format: http://10.1.12.224/jw/web/userview/jmrb/v/_/form?_mode=edit&id={id}

        Best regards.

        1. Sarah

          Hi Owen, That's exactly what I did, but it doesn't work. Could it be that the formatting doesn't work unless the field is bound to another form field?

        CommentAdd your comment...