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.
Aloha everyone!I am having issues with getting the correct result from
this formula. It is returning the wrong max "Date Received" therefore
the wrong "Shipment ID" etc. The interesting thing that I've noticed is
that when I place the [_thisrow].[Ori...
I've got the age old problem of "Cannot compare Text with List in ([...]
= [_THISROW].[...])", but I can't for the life of me figure out why.
I've used the formula a million times but I'm not sure what I'm doing
wrong here. Here's the full
formula:if...
Creating a new post for this issue. Refer to this link for context:Copy
Parent Child Grandchild with new ID post I've followed @Aurelien's
helpful sample app to accomplish a "Copy Parent and Child" action. The
only issue is that it functions correctl...
This seems like it should be simple but I'm really struggling with this
one. In the standard Order Capture sample app, is there a way to
duplicate a previous Order and it's Order Details. I have a set up an
action to duplicate the Order, and separate...
I'm trying to do something I'm sure is simple but I can't figure it
out.In an Order Capture app I'd like to show the Related Order Details
inline in the Orders inline view. All I need is the Product Name and
Quantity to show. I've tried concatenate f...
The Lookup formula is actually returning the [Shipping Cost/Unit] from
the Shipment Received table which is what I want. The Maxrow formula is
telling the Lookup formula to return the row key of the latest [Date
Received].In addition there are two fi...
Alright, pretty sure I've got it now. Tested and seems to be performing
correctly. if(isblank([Email]),any(select(Contact[Email],in([Contact
ID],[_thisrow].[Contact]))),[Email]) Just a heads up, the IN() formula
did not work until I used the ID colum...
Ok I realized that I have Customer[Contact] set to an Enumlist with Base
Type Ref because I need to allow the selection of multiple Contacts from
the Contacts table. So I thought that I may need to use the IN()
function inside my ANY(SELECT(...)). He...
