- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 02:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 03:00 AM
To help you further, Is it possible for you to share the code you have written?
Regards,
Shubham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 04:42 AM
Hi @ShubhamGarg thank you and sorry.
I removed the code because it wasn't working and I'm exploring alternative methods to complete the task.
But I can provide more details about the requirement. We created a SharePoint form for updating records, and I want to update the link to this form in the `u_sharepoint` column which we created in the incident table. I have created a fixed URL property under the `sys_properties` table with the value `"www.sharepoint.com="`. The updated column should contain the current incident number appended to the URL after the `=` sign, forming a link like `www.sharepoint.com=INC12345`.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 07:09 AM
Hello @Kalpesh Kalgutk ,
I see & understand what is implemented. If interested, you can try my solution so provided in your PDI and we can check why it does not work. Normally, it does.
If my response helps you in any way, kindly mark this as Accepted Solution/Helpful and help in closing this thread.
Regards,
Shubham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-20-2024 01:16 AM - edited 08-20-2024 04:39 AM
Thanks @ShubhamGarg ,
I tried the following code, and it worked. The actual issue was that the "Insert" option under "When to run" was unchecked. I realized this today, and now it's functioning properly.
var baseUrl = 'https://sharepoint.com';
var Url = baseUrl + '/' + current.number;
current.[COLUMN NAME] = URL;