This article will guide you on the Conversion Functions provided by the Pretty Forms Designer Add-on to perform the Value Conversions in Google Forms. These functions can be used to convert a value from one data type to another data type or value type.
Date To Milliseconds
Description: This function returns the Milliseconds in number for the given Date.
Return: Number.
Example 1: Date: Jan 1, 1970 (In UTC timezone), then this function returns 0.
Example 2: Date: Jan 1, 2000 (In UTC timezone), then this function returns 946684800000.
Milliseconds To Date
Description: This function returns the Date for the given Milliseconds in number.
Return: Date.
Example 1: Number: 0, then this function returns Jan 1, 1970 (In UTC timezone).
Example 2: Number: 946684800000, then this function returns Jan 1, 2000 (In UTC timezone).
Time To Milliseconds
Description: This function returns the Milliseconds in number for the given Time.
Return: Number.
Example 1: Time: 00:00 (In UTC timezone), then this function returns 0.
Example 2: Time: 00:01 (In UTC timezone), then this function returns 60000.
Milliseconds To Time
Description: This function returns the Time for the given Milliseconds in number.
Return: Time.
Example 1: Number: 0, then this function returns 00:00 (In UTC timezone).
Example 2: Number: 60000, then this function returns 00:01 (In UTC timezone).
DateTime To Milliseconds
Description: This function returns the Milliseconds in number for the given DateTime.
Return: Number.
Example 1: Date: Jan 1, 1970 00:00 (In UTC timezone), then this function returns 0.
Example 2: Date: Jan 1, 2000 00:00 (In UTC timezone), then this function returns 946684800000.
Milliseconds To DateTime
Description: This function returns the DateTime for the given Milliseconds in number.
Return: DateTime.
Example 1: Number: 0, then this function returns Jan 1, 1970 00:00 (In UTC timezone).
Example 2: Number: 946684800000, then this function returns Jan 1, 2000 00:00 (In UTC timezone).
Text To Number
Description: This function returns the Number converted from the given Text.
Return: Number.
Example 1: Text: “11”, then this function returns 11.
Example 2: Text: ”aa”, then this function returns NaN.
Number To Text
Description: This function returns the Text converted from the given Number.
Return: Text.
Example 1: Number: 11, then this function returns “11”.
Example 2: Number: 0, then this function returns “0”.
Get Inverse of Boolean
Description: This function returns the Inverse value of the given Boolean value.
Return: Boolean.
Example 1: Boolean: true, then this function returns false.
Example 2: Boolean: false, then this function returns true.