This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
In case anyone needs it, for example this is how to get a random number between 1 and 30:IF(VALUE(RECORD_ID()) <= 0, 1, IF(VALUE(RECORD_ID()) >= 1000000, 30, MOD(VALUE(RECORD_ID()), 30) + 1))
No no The alert is like a watchlist.User goes to their profile and can open his watchlists.He receives an email every week with the latest additions as a bulleted list (usually 1 to 10).I would like the watchlist to be complete even if his criteria ...
