I just suspended and reactivated the license key.. Can you check if the same works. If not I will start discussion on your email to share another key if this does not work.
In count relationship, only one parameter is passed and it returns the number of entries of the relationship subpanel of that data. For example - If we pass count_relation(leads) in the formula then it'll show the number of entries of the lead subpanel of that data.
In
Sum of relate fields ,firstly we select a subpanel field that can be contacts, opportunities.The options in related field are integer type fields of the selected module. If you want to sum the data present in integer field of subpanel and show that data in the field of module then it can be used.
For example- I want to create a field in account module which shows the sum of amount of opportunities present in subpanel field then I will use the formula-
sum_relate(opportunities,amount).
Yes , there is an option "Diff Month Now" in which only one parameter of date type is passed.
Like diff_month_now(date) and it shows the difference in terms of month from the today month and the month of the date field.
Hi
yes, it is possible.
For this there's an option in dropdown "Diff Month" in which two date parameters are passed and it returns the difference of the months.
Like diff_month(datetoday, datenew) diff_month(01/01/2022, 03/02/2022) then it will return 2 months.
If you want to add n number of months in any date then the correct format is -
add_month(datetoday,6 months) where datetoday is a date field. If you will pass just numeric value as second parameter like add_month(datetoday,06) then it will show "Wrong format,Format: 00 months".