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.
Can anyone see what I am doing wrong here.Two fields, one date (as text type) one time (as text type) - The formulae field SHOULD make these into a single date/time field - This is the formulae I have, but I get errors on any dates with two character...
If I have these values in a formula field, 0_99_123_456_abc_wantedtext1_ppp_876_333_wantedtext2hhh_kol_ggb_hhh_sss_wantedtext3can someone please tell me how to extract the following text into a new field please?wantedtext1wantedtext2wantedtext3Thanks...
If I have a table as follows :
Date/Time. Numeric value. Gain Since Last. Usage per day
Record 2. 10/1/2022 100 50 10
Record 1. 1/1/2022. 50
Is ther...
Is there a way to search for a record, (and ideally link it) in table B based on an email address field in table A, whilst entering the new record in table A?- I dont mind if it fails if it finds duplication or none, but it would save me much time to...
I have a formula field as follows:
DATETIME_FORMAT(DATETIME_PARSE(RIGHT({Webhook Data},20), ‘^DD/MM/YYYY HH:mm^’), ‘DD-MMM-YYYY HH:mm’)
But it returns a string - Is there an easy way for this same formula to return. date/time field that I can use for...
@Simone PLEASE can you background colour fill fields when creating a new record or editing an existing one, white on white is not a great combination as it is now!
Thanks for the reply. Right$ wont work as variable length, but what will stay the same is that it will be the string after the last underscored every time.
