instead of number you can save the Month Name too..
MONTH_TEXT(MONTH(CustomDate))
Search found 722 matches
- Thu Sep 09, 2021 3:59 pm
- Forum: General discussion and questions about Aware IM
- Topic: How Create a query Group by Month DOB and Sort by Date from DOB
- Replies: 8
- Views: 5275
- Thu Sep 09, 2021 11:13 am
- Forum: General discussion and questions about Aware IM
- Topic: How Create a query Group by Month DOB and Sort by Date from DOB
- Replies: 8
- Views: 5275
Re: How Create a query Group by Month DOB and Sort by Date from DOB
Hi Suwandy,
create a new attribute Month and calculate month from the DOB and assign value in it.
create query and group by month order by DOB
create a new attribute Month and calculate month from the DOB and assign value in it.
create query and group by month order by DOB
- Wed Sep 08, 2021 11:23 am
- Forum: General discussion and questions about Aware IM
- Topic: Webhook Endpoints
- Replies: 5
- Views: 4059
Re: Webhook Endpoints
Hi Rocket, You have create whole BO structure as mention over here https://stripe.com/docs/api/charges/object ... you can select attribute which ever you needed but it should respect the structure. create web hook endpoint for charge.success create AwareIM API expose to consume web hook and update t...
- Fri Sep 03, 2021 8:26 am
- Forum: Problem reports
- Topic: Display Question requires simple string, not concatination
- Replies: 1
- Views: 4385
Re: Display Question requires simple string, not concatination
Bruce, try to concat using AS_STRING(' ' + ' ')
- Sun Aug 29, 2021 5:33 am
- Forum: General discussion and questions about Aware IM
- Topic: Specify form section when using ENTER NEW, VIEW, EDIT
- Replies: 4
- Views: 3706
Re: Specify form section when using ENTER NEW, VIEW, EDIT
I had and have tried too... still not working and getting same error dialogue message.
- Tue Aug 24, 2021 7:51 pm
- Forum: General discussion and questions about Aware IM
- Topic: Translation to other languages
- Replies: 7
- Views: 5255
Re: Translation to other languages
send me your awareim (.lcl) local file.... will translate for you in French... if that works for you then do the other also.
- Tue Jul 06, 2021 5:17 pm
- Forum: Problem reports
- Topic: REST Service not reponse
- Replies: 6
- Views: 9245
Re: REST Service not reponse
Hi,
Try this below
Create a new process and put your line into
Applicaiton.Status='Approved'
make sure you have input object selected as Application, final flow looks like this
RESTProcess
FIND Application
-- UpdateApplicationStatusProcess
--- Applicaiton.Status='Approved'
Try this below
Create a new process and put your line into
Applicaiton.Status='Approved'
make sure you have input object selected as Application, final flow looks like this
RESTProcess
FIND Application
-- UpdateApplicationStatusProcess
--- Applicaiton.Status='Approved'
- Thu Jul 01, 2021 6:09 am
- Forum: Problem reports
- Topic: Build 2927 has problem in JS
- Replies: 2
- Views: 4737
Re: Build 2927 has problem in JS [CLOSED]
I install the latest build and after try to login the existing app (safari), it went into some issue checking the console found some JS bug on some line, then try to comment that piece of line and it works fine after. Now, as Jaymer said it does not appear at his end I tried again by uncommenting th...
- Wed Jun 30, 2021 11:54 am
- Forum: Problem reports
- Topic: Build 2927 has problem in JS
- Replies: 2
- Views: 4737
Build 2927 has problem in JS
Hi Support,
There is bug in the aware.js on latest build 2927. Nothing will run until you remove the bug.
There is bug in the aware.js on latest build 2927. Nothing will run until you remove the bug.
- Tue Jun 29, 2021 6:19 am
- Forum: General discussion and questions about Aware IM
- Topic: Any Plan for Bootstrap upgrade?
- Replies: 6
- Views: 5493
Re: Any Plan for Bootstrap upgrade?
Thanks Support,
I didn't dare to do that before, but will give a try now sure.
I didn't dare to do that before, but will give a try now sure.
- Mon Jun 28, 2021 3:43 pm
- Forum: General discussion and questions about Aware IM
- Topic: Using an IF Statement in FORM
- Replies: 4
- Views: 2089
Re: Using an IF Statement in FORM
Hi,
<<IF BO.IncludeTest = 'Yes' THEN SHOW SECTION_START>>
// Show this
<<SECTION_END>>
<<IF BO.IncludeTest = 'Yes' THEN SHOW SECTION_START>>
// Show this
<<SECTION_END>>
- Mon Jun 28, 2021 5:04 am
- Forum: General discussion and questions about Aware IM
- Topic: Any Plan for Bootstrap upgrade?
- Replies: 6
- Views: 5493
Any Plan for Bootstrap upgrade?
Hi Support,
Do we have any plan to upgrade bootstrap framework in near future?
Current latest version 8.6 still is running on the bootstrap 3.3.x version, latest version really give more UI improvements to existing apps.
Do we have any plan to upgrade bootstrap framework in near future?
Current latest version 8.6 still is running on the bootstrap 3.3.x version, latest version really give more UI improvements to existing apps.
- Thu Jun 24, 2021 5:05 am
- Forum: General discussion and questions about Aware IM
- Topic: What level of access does Guest User have?
- Replies: 0
- Views: 3674
What level of access does Guest User have?
Hi, I am having a business object (Example Employee) which have many references to other business objects. There is another business object called EmployeeActivity which have a reference to Employee too. I have given Guest Access as read only to both objects, now if try to show any record from Emplo...
- Wed Jun 23, 2021 6:54 am
- Forum: General discussion and questions about Aware IM
- Topic: I dont see how Aware can process this JSON data from Quickbooks
- Replies: 3
- Views: 2029
Re: I dont see how Aware can process this JSON data from Quickbooks
We have worked with QuickBooks recently and done integration also, you can PM me if there is specific goal you want to achieve.
- Thu Jun 10, 2021 6:56 am
- Forum: General discussion and questions about Aware IM
- Topic: how to handle a Inactive user logging in?
- Replies: 4
- Views: 15556
Re: how to handle a Inactive user logging in?
Hi Jaymer,
Here is my suggestion..
- create a blank VP
- create a process which will check the LoggedInUser Active status, if yes then move to main VP else logout with DISPLAY MESSAGE if you care.
- place the process on the blank VP initialising setting area
Let me know if it help.
Here is my suggestion..
- create a blank VP
- create a process which will check the LoggedInUser Active status, if yes then move to main VP else logout with DISPLAY MESSAGE if you care.
- place the process on the blank VP initialising setting area
Let me know if it help.