Hi @qquac, This issue primarily occurs due to incorrect mapping in Input Parameter Conditions. If you are validating based on changes in field values, consider using comparisons between the old value and the new value. Additionally, when validating parameters for non-null conditions, include other parameters to ensure that the condition is not satisfied again. There are various scenarios leading to looping issues, so a thorough review of your input parameter conditions is likely to resolve the issue.Thanks,Hariharan P
Hi @Jacksonc , SQLite is the database used in mobile applications, and FSM Mobile incorporates an SQLite database within the application for mobile data storage. SQLite queries within this context do not interact with a server database; instead, they operate within the mobile application's database, returning values directly.Client scripts configured in the Client application for mobile application are imported during installation and function within the mobile application itself. Therefore, these scripts execute queries inside the mobile database, functioning similarly to JavaScript and returning values within the mobile application.Hope this helps.Thanks,Hari
Hi @Jacksonc ,As I mentioned, we can use SQLite along with a custom field to achieve this. If you are implementing this solution solely for display purposes, you can create a custom field and populate it on screen refresh by following the steps below. This approach allows you to split and display your values on the screen.Var serialID= getControlValue("table_name", “serial_id”);var serialIDCust = getDBValue(stringFormat("SELECT SUBSTR('{0}', 1, INSTR('{0}', '/') - 1) AS Result", serialID));setControlValue("custom", "cust_serial", serialIDCust ); Thanks,Hari
Hi @Jacksonc , You are correct; this function is only available for Web Client scripts and not for mobile. You can view the reference scripts by right-clicking on the script selections. Since I noticed that you requested implementation for mobile, I recommended the above approach. The following scripts are applicable for mobile where you cannot find the 'stringsplit'.The following scripts are applicable for Web client where you can see the 'stringsplit' here. Hope this helps. Regards,Hari
Hello @qquac ,FSM Client scripts are only supported for certain functions, and unfortunately, 'stringsplit' is not one of them. However, you can address this issue using an SQLite query by getDBValue, as shown below.SELECT SUBSTR('12345/01', 1, INSTR('12345/01', '/') - 1) AS Result; I hope this helps you. Thanks you,Hari
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.