Hello,

I’m working on a form with a file upload field. After uploading a file to WorkDrive, I fetch the public file link and update a field in the form with it.

Workflow:

When using the single-line text field ("File_URL"), the link is updated correctly with the following code:

1. updateMap = Map();
2. updateMap.put("File_URL","https://workdrive.zohopublic.eu/file/jnqal0d8d8d0da5204a219592d5443e975da0");
3. optionalParams = Map();
4. response = zoho.creator.updateRecord(zoho.adminuser,zoho.appname,"Content_database",input_id,updateMap,optionalParams,"creator_oauth_connection");
5. info response;

However, when I switch the field to a URL field ("File_URL"), I get this error:

"{\"code\":3001,\"data\":{\"ID\":\"155237000000213067\"},\"error\":[\"Invalid column value for File_URL\"]}"

My Question:

Why does the URL field fail to update while the single-line text field works fine, and how can I resolve this to update the URL field with the WorkDrive public link?

I need the URL field to make the links clickable.
Any help would be greatly appreciated!