Rainer Grabowski

1. Community
2. Calculations
3. Real Estate Sales- variable commissions

Depending on your setup there's perhaps a way to do this with IF-Conditions in the calculation field.  Rainer

• View comment
• Rainer Grabowski
• December 15, 2015 18:40
• 0 votes

1. Community
2. Calculations
3. End date not calculating properly

Hi Brock, perhaps one of the other fields (you get with @All of ...) is empty in one item. If you have a null-value in one item you'll get problems with the mapping of the arrays. There are perhap...

• View comment
• Rainer Grabowski
• December 13, 2015 20:03
• 0 votes

1. Community
2. Calculations
3. Calculating dates using the Calculation.

Hi Maria, example you have a date field named "Start" with the date 1/16/2016. In the calculation field you have to enter: moment(@Start).subtract(80,"days").toDate() The result is 10/28/2015,...

• View comment
• Rainer Grabowski
• December 13, 2015 19:15
• 0 votes

1. Community
2. Calculations
3. Update a Ref Field

Hello Stuart, open an item in the app and copy the url except the number (= unique item ID) at the end. Then paste the url into the additional calculation field (e.g. named "itemURL") and add `@...

• View comment
• Rainer Grabowski
• December 10, 2015 16:41
• 2 votes

1. Community
2. Calculations
3. Calculation of date/time with range parameters??

Answer for the deleted question of John: Yes, that's possible.

• View comment
• Rainer Grabowski
• December 10, 2015 11:00
• 0 votes

1. Community
2. Calculations
3. New email and phone fields

Hi Nicolas, you've to "tell" the calcultion what should happen if the phone field is empty by defining an IF-Condition: var phone = @Phone var phone1 = phone != null ? phone.map(function(obj){...

• View comment
• Rainer Grabowski
• December 06, 2015 11:48
• 1 vote

1. Community
2. Calculations
3. Substring and concatenate a phone number

Sorry, but for me it works (s. image). Are there other lines in the calculation field?

• View comment
• Rainer Grabowski
• November 30, 2015 09:10
• 1 vote

1. Community
2. Calculations
3. New email and phone fields

Hi James, This will show you the first available number. var a = @Phone Number.map(function (obj) { return obj.value}).join(); a[0]; If you want more control in which order the number types sh...

• View comment
• Rainer Grabowski
• November 30, 2015 07:20
• 2 votes

1. Community
2. Calculations
3. 'If' statement help

Hi Hannah, as Nate wrote, the field `@Inherent_Rating_Score ' must be highlighted blue (enter @inherent and select the field from the dropdown list). Besides that: I think your code wouldn't work ...

• View comment
• Rainer Grabowski
• November 25, 2015 07:59
• 0 votes

1. Community
2. Calculations
3. Return string in upper case : string.toUpperCase()

Hi David, you're trying to set an array (@all of ..) to upper case. But it's only possible wiith a string. @all of section.join(). toUpperCase() or @all of section.toString().toUpperCase() shou...

• View comment
• Rainer Grabowski
• November 23, 2015 04:48
• 0 votes