Archives
In syteline 7 it was SessionManager.BaseUserName. In Syteline 8 Create form component ‘UserEdit’ and bind it to variable ‘User’ with initial value ‘USERNAME()’ Get the value on form script by ‘ThisForm.Variables(“User”).Value’ This will return the UserID who login to Syteline. Use System.Environment.UserName to get the UserID login to Windows. Here is a sample screen shot
Let say you want to show item material status in Item Availability Form, you may just create a new edit field in form, then bind the form component to COLLECTION(SL.SLItems(PROPERTY(Stat) FILTER(Item = FP(Item)))) . Please note that if you want to do this in grid column, since the value is not in collection, so the […]
In Syteline form grid, if you have line# and you want it to be auto populated, you may use the AUTONUMBER function, just set the component default value property to AUTONUMBER. Syntax AUTONUMBER( [ STEP( ) ] [ FILTER( ) ] ) Remarks During processing of the New standard operation, AUTONUMBER sets the value of […]
Sometime, in an In Collection Validator, you would get a “Cache Property not in Cache” error. Make sure to check the “No List Cache” check box. This will force to refresh IDO collection in Cache.
I found this article is pretty useful on understanding various Syteline service too. There are two types of logins used for Syteline 8.00, 8.01 and 8.02. This article discussed the areas that use Windows Accounts and SQL ‘sa’ accounts would need to be updated. Windows Login – This Login should be part of the Windows […]
In general, the variables you create will be specific to your application’s forms and fields. However, WinStudio supports one variable that will be of general use to form developers. The variable InitialCommand can be used to determine the initial behavior of a form. The syntax is as follows: InitialCommand(arg), where arg can be one […]
Below is a pretty useful Form Script Function that can be used to send out email. You can trigger this by any event. PublicSub SendEmail() Dim EmailBody AsString Dim toAddress AsNew Net.Mail.MailAddress(ThisForm.PrimaryIDOCollection .GetCurrentObjectProperty("your_email_field")) Dim FromAddress AsNew Net.Mail.MailAddress("me@company.com", "Display Name") EmailBody = "Some text:" & ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty("some_property") & vbNewLine _ & "Some more stuff: " & vbNewLine […]
When a Syteline form open in “filter in place” mode, you may want some of the fields already have frequently use value there. For example, you may want the warehouse field has default filter value of “Main”. To do that, it is pretty simple. In the form you want to set this up, add a […]
How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box. Example: If Fat, Use range from C6:C7 If Skinny, Use range from D6:D7 You can direct put the IF statement in 2nd drop down validation, like =IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)
Excel provides conditional formatting which allows you to change the color and other attributes of a cell based on the content of the cell. There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row. You can, however, achieve the same effect by using a macro […]