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.
We have tried CTRL-SHIFT-R and also CTRL-F5 and also the refresh button
on the app. however the app is not pull the latest format rule or
changes data (VC display calculation) anyone has any tips to force
reload the app.
Trying with the bit.ly shorten URL API call using Web Hook. The web hook
has been setup successfully, and it returned with the following
response. how do we retrieve the returned respond “link” so that we can
include in into the next Step/Process "Re...
Have checked out the forum posts and documentation, can’t seem to find
the right way to do the duration calculation for two datetime to exclude
non working hours (weekend, after office or PH) any one has any idea how
we can do it. IF( (AND(DATETIME([...
Trying to a validation to ensure that there is not “-” symbol in the
textbox with valid if NOT(CONTAINS([_THIS],"-")) in the valid_IF,
however this is only happen if the - is the first character, if it is in
between it can’t throw error
Have a challenge here, to calculation the “Respond Time” SLA calculation
based on the working day and working hours, understand that we have a
WORKDAY() but what about working hours? (just say working hours is at
9AM to 6PM) how can we do it? current...
Kirk_Masden: re located within a row, and those values are not dependent
on other rows, virtual columns can be very useful. In fact, I use them
all of the time. That’s about all I can say for now. I hope others will
share their insights with us. @Ste...
Kirk_Masden: Tip 2 = Don’t use virtual formulas if you can avoid them.
Especially where they have to be recalculated on every sync for tables
with a large number of rows (>500) What is the different between using
virtual column and also normal column...
@Steve it is picking the first entry instead of the latest entry, so the
result wasn’t the expected one. however i followed your FAQ guide here
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() -
#3 by Steve To pick up for the lat...
I have use LOOKUP() LOOKUP([_THISROW].[SD Case ID], “Work Orders”, “Case
ID”,“Finished Date & Time”) in the Action 2, it is a correct way of
doing it?
@Steve can we pass a value from the Work Order Details column to the
Case Details column? example we have [Arrival Time] from the Work Order
Details Table, to pass the value to the [Resolution Time] Case Details
table?