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.

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?

Hi, kindly try this:

On spreadsheet design properties screen:

• Field ID: conflictingR
• Label: Conflicting Record
• Format Type: URL
• Format: http://10.1.12.224/jw/web/userview/jmrb/v/_/form?_mode=edit&id={conflictingR}

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.