Hi all! How do you set a native sublist column to ...
# suitescriptk
Kris Wood
06/14/2023, 9:14 PMHi all! How do you set a native sublist column to be mandatory? Or do you need to check for null values in beforeSubmit and throw an error?
k
Kris Wood
06/14/2023, 9:28 PMNot quite what I was looking for, but thanks!
Kris Wood
06/14/2023, 9:29 PMCurrently the customer has a workflow that sets class, department, and location to mandatory at the line level but it only works for the Items sublist. When they go into the workflow action and try to add these fields for the expense and apply sublists, those lists aren't available.
Kris Wood
06/14/2023, 9:30 PMSo I'm trying to accomplish the same with a script
r
raghav
06/14/2023, 11:22 PMIf you want a scripted solution then you can put a client script with validate line entry point and check if the mandatory columns are filled or empty when the user tries to add a row..
✅ 1
k
Kris Wood
06/15/2023, 12:09 AMyeah, I wanted a user event scripted solution so that any other automations/integrations/csv imports could also trigger it, but I can do the same for beforeSubmit really.
Kris Wood
06/15/2023, 12:09 AMThe answer is quite simply that it's not possible.
https://suiteanswers.custhelp.com/app/answers/detail/a_id/85631/kw/85631
Kris Wood
06/15/2023, 12:09 AMsublist isMandatory is read only
r
reptar
06/16/2023, 1:46 PMCan't this be done via workflow now?
k
Kris Wood
06/20/2023, 5:17 PMIt's read only in workflows, too
Kris Wood
06/20/2023, 5:18 PMBest I was able to come up with is validation in beforeSubmit
d
Dan P
08/31/2023, 4:20 PM@Kris Wood Follow up question. How do you stop the process from executing in beforeSubmit? Seems to be throwing in error doesn't stop it and return won't do anything either?
k
Kris Wood
09/01/2023, 6:45 AMThrowing an error should stop it. Just make sure you're not in a try/catch or the catch will eat it
d
Dan P
09/20/2023, 11:24 PM@Kris Wood Thanks for the heads up on the try/catch. That's why it didn't stop it. Removing the try/catch solved the issue. 😉
👍 1
k
Kris Wood
09/20/2023, 11:44 PMHappy to help!
2 Views