Hello, I'm in need of a script to circumvent the 100 found records limit.Here is my use case:I have a database of 2k records updated on a weekly basis.The user can setup and save complex filters (what I call alerts) to get a weekly email with new rec...
Hello,
I’m looking to remove double line breaks in a rich text field (empty lines in the text).
The substitute formula will make me lose the formatting.
I tried the find and replace script to no avail.
Could someone please help me ?
Thanks a lot
Hello,
@Joris_Grouillet made me this script to search for {tag} and replace by the tag column.
Am in urgent need of some changes but don’t want to be too much of a burden so I ask here.
Could someone please help me modify the script so that:
It repl...
Hello everyone,
I have a base with 12 tables and a few plain text and rich text fields in each.
I’m looking for a way to find and replace the name of my company everywhere (any table, any field).
The marketplace script only lets me choose one field i...
Hello everyone, :wave:
I’m having some odd behaviour I can’t figure out.
I have a formula rolling up invoices linked to a case.
IF(Statut = "Clos et facturé",MAX(values),"Dossier ouvert")
It does not work.
The cell shows up empty when it should sh...
The VALUE(RECORD_ID()) attempts to convert the unique record id (which is alphanumeric) to a numeric value. In theory, since each record has a unique id, the numeric value derived from it would also be unique.This part IF(VALUE(RECORD_ID()) <= 0, 1,....
You can never achieve true randomness natively with a formula but here is what I use:MOD(
(FIND("0", RECORD_ID()) * 11.5 + FIND("1", RECORD_ID()) * 23.21 +
FIND("2", RECORD_ID()) * 37.12 + FIND("3", RECORD_ID()) * 49.49 +
FIND("4", RECORD_I...
This removes subdomains, folders, etc and doesn't output anything if there is no url.IF({url}="","",REGEX_EXTRACT( {url}, '^(?:https?:\\/\\/)?(?:[^@\n]+@)?(?:www\\.)?(?:[^.]+\\.)?([^:\\/\n?]+\\.[^:\\/\n?]+)'))
Hello,Don't know if you solved it yet, but here is what I use to publish an article within the next 30 days at random: DATEADD(CREATED_TIME(),IF(VALUE(RECORD_ID()) <= 0, 1, IF(VALUE(RECORD_ID()) >= 1000000, 30, MOD(VALUE(RECORD_ID()), 30) + 1)),"da...
