-
Tooltip functionality (or lack of)
What can be used as value in a Tooltip? Obviously simple text, but is it possible to use other column data, perhaps modified with some string functions? I tried entering another field,…
-
Refer to a field inside a tooltip @Jacques TUR
@Jacques TUR Is it possible/doable to refer to a field in a tooltip? Cannot be done currently but if it were one could have a kind of trigger. Not sure how well this will work but I am thinking of…
-
Failed to _syncInit message and what to do about it?
Hello, Not sure why but one of my databases on cloud subscription will not open anymore with the error message: Unable to open database syncInit: Failed to _syncInit What has gone wrong and what can…
-
Open a Table using the TableID
Is there a way to open a table using the TableID? Such a simple function, there must be a way to do this.
-
Need Transfer only the last Date.
I'm trying to modify this script so that it only transfer the last of the three Rev Date. In this example it transfers doc with Rev B, not transfer Rev A, or is I have Rev 0 no transfer neither Rev A,…
- Answered
-
RoleGrabber – Tool DB for Cloud Developers
The following text was translated using a translation program. Please excuse this. Here I present a small tool database that is intended to support the documentation and development of cloud…
-
AI and spreadsheets
The AI Spreadsheet We've All Been Waiting For
-
max
To return the highest or latest value of an array Use this function to find the highest value or the latest value in an array.
The function works only with an array of numbers or time-related… -
lpad
To fill up a given length with given padding at the beginning With this function, you fill a text at the beginning, i.e. to the left of the text, with one or more given characters up to the desired…
-
lower
To output a string in lowercase This function converts uppercase characters in a text to lowercase. Other characters stay untouched. This can be useful for comparing strings or for correcting…
-
longitude
To return the longitude of a given location value This function will extract the longitude of an address in a location field as a decimal number. Syntax longitude(location) Return number Examples…
-
log
To calculate the logarithm The function returns the logarithm of a number to a base. If no parameter is specified for the base, it is 10. In the case of 0, the result is -∞ (minus infinity).…
-
location
To return a location value with a given title, latitude, and longitude This function returns a location value based on a given latitude and longitude, which can have a random title.…
-
loadFileAsBase64URL
To convert a file to URL-compliant base64 format This function converts a file into a URL-compliant base64 string. You can then use this in a REST API call, for example.…
-
loadFileAsBase64
To converts a file to base64 format This function converts a file into a base64 string. You can then use this in a REST API call, for example. Syntax loadFileAsBase64(file) loadFileAsBase64(nid,…
-
ln
To calculate the natural logarithm The function returns the logarithm to base e (the Euler’s number) and is therefore called the natural logarithm. It returns a positive number.…
-
length
To return the count of all characters in a string or all items in an array This function returns the number of characters (with spaces) of a given text or the number of items in a given array.…
-
latitude
To return the latitude value of a given location value This function will extract the latitude of an address in a location field as a decimal number. Syntax latitude(location) Return number Example…
-
last
To return the last item of an array You can access the last entry of an array with this function. This function comes in handy if you try to access a record in an array of records.…
-
join
To return a string consisting of all items of the given string array separated by a given separator. Merge multiple elements from an array or table into one string.…
-
item
To extract a value of an array or an object With this function, you can access a specific element in an array or JSON object based on a given index or key.…
-
isDatabaseProtected
To return Yes (true) if a password is needed to enable edit mode Check if enabling edit mode in a database requires a password. Syntax isDatabaseProtected() Return boolean Examples…
-
isDatabaseLocked
To return Yes (true) if the database is locked This function helps you find if the edit mode needs a password to be enabled and if it is already entered... or not.…
-
isAdminMode
To return Yes (true) if the edit mode is active With this function, you'll find out if the current user is in edit mode, i.e. the wrench icon is activated (red).…
-
invalidate
To clear the cache of the database and the values stored by cached() If you execute this function in any table of your database, all values in the database cache (e.g. via cached()) will be deleted.…