Replies posted by StejonatL

47 Replies

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Question on RMA, Return Reason: Repair & Return

Is there a way to control the automatic completion of the original RMA as per return process? Eg. R&R completes the RMA after Posting of Shipping, Receive Only completes after Completion of Repair Task ID etc. I need to either create a new return process or control the trigger of automatically updating the ‘Complete’ Status for RMAs.

4 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

ExecuteScript function in FSM Mobile button as Control Event

For AddToTransaction, is it possible to add where conditions?

7 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

ExecuteScript function in FSM Mobile button as Control Event

Hi @Shneor Cheshin, Thanks for your response. When set Variables for setDBValue function as below setDBValue(stringFormat("UPDATE task set user_def4 ='{0}' where user_def24 ='{1}'",custNRIC,bookingRequestId)); I need to click save twice in mobile app for all values to be updated, why is that? i am updating multiple values. When I Click save once, the main value is updated. When i click save again, the rest of the values are updated.

7 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

PrimaryAdd is already in Namescope error

I get this error when accessing the ‘Request’ screen from Menu. This error is shown before i am shown the Request List

8 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

LaunchBrowser in Client Script for Mobile

Hi Sam, Managed to resolve the issue by changing the front URL by including a .asp at the back before the appended text, this avoids the automatic input of a forward slash when parsing into the browser. Failure Eg.www.google.com will automate the forward slash but Successful Eg. www.google.com/Service.asp will let ? go through next resulting in www.google.com/service.asp?text Thanks for your attention.

8 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

LaunchBrowser in Client Script for Mobile

Hi Sam,Thanks for your reply. Am I able to parse a string as the browser URL so that it doesnt trigger the forward slash? I hyperlink a URL that opens another web portal through the Mobile with some parsed information at the back. Eg. Request id etc. But the URL does not contain the forward slash. Or is there a way to forcibly remove the forward slash when opening the URL.

8 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

How to add workflow condition to screen in Mobile Designer

Hi @Shneor Cheshin, Am I able to hide/show this screen via another method?Currently, I have set the work flow condition for this screen to be hidden/shown for specific task types var taskID = getCurrentKeys("task", "task_id");var taskType = getDBValue(stringFormat("SELECT task_type FROM task WHERE task_id = {0}",taskID));if(taskType == 'PM') { return true; } else if(taskType == 'CM') { return true; }else { return false; } If I cannot include this into DebriefProductRemove, workflow condition. Could I include the code in another field? or Include an amended code to other workflow conditions in other screens.

10 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

How to add workflow condition to screen in Mobile Designer

H @Shneor Cheshin Do you know the configurations for DebriefProductRemove screen? Is the workflow condition only enabled for custom screens? Am I able to enable it?

10 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

How to add workflow condition to screen in Mobile Designer

Hi @Shneor Cheshin, How do I copy an existing screen to a custom screen?

10 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

How to add workflow condition to screen in Mobile Designer

Hi Schneor, I am looking to configure DebriefProductRemoveIt is configurable in one design, when I created a new design, the screen is not configurable anymore.Below is the design where it is configurable In a new design i created it is not, as below. Any idea as to why and how I may change/enable this?

10 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin I have implemented this for both Web and Mobile client. Thank you very much for your assistance.

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin The statement is able to be run. I think it was because person_skill wasn’t added to sync rules.Also, person Id variable works. Thanks. I am using a tap event in JobList screen to run this script. Currently I am getting an error on my if conditions. Any idea why I am getting this error? var taskId = getCurrentListRowControlValue("task", "task_id");var personId = getUserInfo("PersonID");var personSkill = getDBValue(stringFormat("select count (*) from person_skill where person_id = '{0}' and skill = 'PERSONALSC'",personId)); if (personSkill=="0") { alert(You do not have the necessary Skills); } if (personSkill=="1") { setCurrentKeys("task", "task_id", taskId); goToScreen("DebriefOverview"); }

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Is there a way to trigger the client script on button press of the task status button? instead of on value change of task_status

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin, No, I am not seeing the alert message as well. When I accept the task, the status changes to assigned as per normal. Do not see alert message and am not stopped.I tried just using return; Same result. I am using value change field for task_status. Maybe the trigger point is wrong? I tried adding person_id field to the page and adding the script to value changed for person_id, still don’t trigger.Is using GetCurrentKeys for task id and getControlValue for Person Id correct?

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin I have simplified the code just to test, var taskId=getCurrentKeys('task','task_id');var personId=getDBValue("select person_id from task where task_id = '{0}'",taskId);var personSkill = getDBValue("select count(*) from person_skill where person_skill.person_id = '{0}' && person_skill.skill = 'PERSONALSC'",personId);if (personSkill=="0") { alert(getMessage("C_SEC_PER_FAIL", "ERROR")); return false; } if (personSkill=="1") { return true; } When I try in mobile client, i am still not getting stopped. Is there a function that is missing to trigger the error message? and stop user from being assigned? Again, this script is in the value changed field of the task.status field. which may be wrong as well?Appreciate your help.

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin, I am calling the SQL client script. am I not able to do that for mobile client?

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin Thanks for your help, I am able to implement the script successfully on manager portal. Currently I am trying to do the same logic for Mobile App. I am using the same script and tying it to value changed for the task.status field. So when user updates status from mobile app, the client script will be run. Currently, When I update task status on the mobile app, nothing seems to be happening. What could be going wrong?My client script code as below, i made some adjustments VS the web client scriptvar taskId=getCurrentKeys('task','task_id');var personId=getControlValue('task','person_id');var taskStatus = getControlValue('task','task_status');var projectSkill = getDBValue('C_SKILL_PRESENT_SQL',personId,taskId);var personSkill = getDBValue('C_PER_SKILL_PRESENT_SQL',personId,taskId);if (taskStatus == "ACCEPTED" && personSkill=="0") { alert(getMessage("C_SEC_PER_FAIL", "ERROR")); return false; } if (taskStatus == "ACCEPTED" && personSk

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin I am now able to view the output result. I did it by specifically calling the row from the result. Test function in client script, the output is correct, and the code is able to run. When testing in web client, I get this error: Its probably because (hopefully) the syntax for this line is wrong. How do I properly write these 2 lines below?var projectSkill = projectSkillList[0] ['count'];var personSkill = personSkillList[0] ['count'];I tried, var projectSkill = projectSkillList[0].count;var personSkill = personSkillList[0].count; but got this error: I tried thevar projectSkill = projectSkillList[0].count;var personSkill = personSkillList[0].count; in web client as well, but i get the same error. Any idea how to resolve this count issue.Basically I can use getDBValues, just need to indicate which row I want to select and the code can run. I also had received this error when trying to run a count statement. Could the 2 issues be related?

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin Sorry got a basic question on getDataTaleSelectedRows.I get this error: var selectedRow = getDataTableSelectedRows('task');var personId = getRowControlValue(selectedRow,'task','person_id'); var personSkill = getDBValue("C_PER_SKILL_PRESENT_SQL",personId,taskId);if (personSkill == 0) { alert(getMessage("C_SEC_PER_FAIL", "ERROR")); return false; } if (personSkill == 1) { return true; } How do I use getdataselectedrows and get row control value together? I will still be using the getDBValues for client sql scripts right?

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

@Shneor Cheshin Currnetly I am just testing in client script with the testing function. Result usage will be to add this as a savetablerow event in UI Designer, when user try to assign person id to task via Request page.SQL scripts are triggered upon save and if conditions are not met, they will be thrown an error message. Using getDBValue without the ‘s’ already works. I am able to get all values output as expected. But because this script is to be run on Manager Portal, web client. and I get getDBValues not implemented error. So when changing it to getDBValues, i get the errors as below. When I try your solution and adding count function, I get When i try the simple count statement, i get this error:

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin I am able to get the person Id. Alert function works and outputs as indicated.

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

Hi @Shneor Cheshin Is this error normal?

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

11 months ago

StejonatLDo Gooder (Customer)

asked in Field Service Management (FSM) & Planning and Scheduling Optimization (PSO)

Skills Validation Business Rule for Assigning of Technician

@Shneor Cheshin I tired, but does not seem to recognize square bracket, does the get control value line need square bracket as well?

11 months ago

Page 1 / 2

Replies posted by StejonatL

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded