Recent Discussions
distance between two addresses
I am trying to calculate the distance between two addresses. I put the below formula in but came up with a distance of 5000 and it should be 3. var number OriginLat = [LatitudeVendor]; var number OriginLong = [LongitudeVendor]; var number DestLat = [LatitudePlant]; var number DestLong = [LongitudePlant]; var number Distance = Round(((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5); If($OriginLat =0 or $DestLat=0,0,$Distance) ------------------------------ Sarah Burres ------------------------------0likes18CommentsUsing AND with Null values
I have a formula with multiple Null and Not Null values, one of the nested statements needs to look at two fields so I used AND, but this generates an error "AND" cannot be applied. If( IsNull([Pallet Grp "C"]),0, ((Nz([Low, Carton "C"] and (IsNull([high, carton "C"])),1) [high, carton "C"]-[low, carton "C"]+1) Can someone recommend a solution--if possible.Solved0likes4CommentsAdding an email hyperlink to body of formula-url
I have created an email button using the formula-url field. Within the body of my email, I would like to have a hyperlink to email for help. ex: &"If you see missing tests or errors in the upload process, please provide the error report to abc@abc.com for review and repair." I want abc@abc.com to be a hyperlink to open an email . How can I make this happen?0likes3CommentsGetting the DBID from an Alias
I want to be able to put a text field into a cell and it be the table alias, then another formula field that converts it to the DBID. Reason being when we copy an app, the tables stay the same, but the DBIDs all update and we have to go manually change all the juiced URLs.0likes12CommentsLimit Relationship Choices based on another field..
So I have a table, Purchase Orders. That table is a one to many child of Jobs. It's also a one to many relationship of Daily Reports. Daily Reports is also a child of Jobs. What I want is for user A to login, and enter 5 POs, and link them to Jobs. Then, user B logs in and clicks the "Related Daily Report" field and it's limited to ONLY the jobs selected by user A. Is this possible?0likes2Comments