Creating Replica IDs using the @Text Function
madicon.de/Tipps & Tricks/Creating Replica IDs using the @Text Function

Creating Replica IDs using the @Text Function

An undocumented parameter of the @Text function can be used to calculate a replica ID (like the one assigned to every newly created database).
Use the @Text function in the following form:
@Text( DateTimeValue; „*“ )
 
The „DateTimeValue“ can of course itself be a function that returns a date/time value. The following formula:
@Prompt([Ok]; „Replica ID via @Text“; @Text( @Now; „*“ ) )
for example produces the following dialog:
notion image
When running the statement multiple times, the example nicely shows its dependency on time – the right-hand part after the colon should change continuously.
 

Amazon Affiliate Link
notion image