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.
When we embed forms on our site, we write the title and description on the page for brand consistency across pages. I do not need the form title to be repeated in the embed portion. AT adds the form title by default in any shared view and there seems...
Using the solution i found in a similar thread but this formula keeps returning an error. I can’t figure out where it has gone awry. The Total Time field is field type: duration. The others are multiple select. Without the DATETIME FORMAT i dont get ...
This closed topic answered my question about accurate time stamps for imported records but i can’t figure out the formula… what is the operator for “not blank”. This is all very new to me and i am learning as i go…
IF({Original Time Stamp}=BLANK(),"{...
So just so i’m clear. There is no way to include the duration type field in a string formula and format it to ‘hh:mm’ without 1st converting it to a date.
What if the duration is longer than 24 hours? is there a way to add the duration to the string? There is no formatting function for time without adding the date stuff?
THANK YOU so much!! this is immensely helpful. Now i have the problem of formatting. I am getting a combination of results that look like this: 2020-06-10T23:43:05.000Z AND this 4/6/2020 5:32pm. I would prefer the latter…
