by admin_mdo | Jul 22, 2018 | LEARN App Building
We are adding field Opportunity of type text with size=4500
to Opportunities_MYCRM table.
GetData link from Table Documentation is clicked which will result
in Menu for Opportunities_MYCRM table.
AddField link is clicked from menu of table=Opportunities_MYCRM.
Fieldname should not have blank spaces.
Form for adding field is filled out and submitted.
Fieldname should not have blank spaces.
Result of submission of form will add field and then menu for Opportunities_MYCRM table will be displayed.
Click Structure link from Menu to find out structure of table and it should show new field in its structure.
New field Opportunity is shown in structure of table.
For Any Question please Contact MyDataOrganizer
by admin_mdo | Jul 22, 2018 | LEARN App Building
Each table documentation record has AddField link which can be used to add calculated field.
Result of clicking link AddField
Form Filled with Data :
Added Calculated Field
Formula used : concat(FirstName, ‘ ‘, LastName)
FullName now shows FirstName followed by LastName
and blank space between FirstName and LastName
Adding CalculatedFieldsExtn involves first adding record into CalculatedFields as above
Formula for CalculatedFields is dummy data e.g. ‘FullName2’
Then record is added into CalculatedFieldsExtn
Check structure of table to find ColumnName to use in CalculatedFieldsExtn
Our ColumnName = FullName2_51963
Add record into CalculatedFieldsExtn
InString = ColumnName = FullName2_51963
OutString = Formula = concat(Contacts_MYCRM.FirstName, ‘ ‘, Contacts_MYCRM.LastName)
From TableDocumentation record Menu click CalculatedFieldsExtn link
result of CalculatedFieldsExtn for Contacts_MYCRM table is as following :
Full_Name is result of CalculatedFields
FullName2 is result of CalculatedFieldsExtn
For Any Question please Contact MyDataOrganizer
by admin_mdo | Jul 22, 2018 | LEARN App Building
Demo2Menu has easy access to some of the common actions needed by App Builder.
Demo2Menu : part1
Demo2Menu : part2
Add Table : Provide tablename without blank spaces.
Provided tablename : Customers_MYCRM
All the tablenames appended with _MYCRM will help group tables used for MYCRM application. It will help in app building.
Once table is added it will provide button to add record about newly created table into Tables Documentation.
Tables Documentation will provide central repository for all the tables used for the applications.
Click the green button to add table into Tables Documentation.
It will create following type of record as Table Documentation.
Each table into Table Documentation will have menu for individual actions which can be performed on the table.
Each record in display grid as well as main title of grid will have Menu customized for each user.
It has easy access to action-links .
For Any Question please Contact MyDataOrganizer
by admin_mdo | Jun 23, 2018 | LEARN App Building
End Result Contacts :
End Result Customers :
Steps :
- Create table Customers_LEARN
- Add fields / Columns to table Customers_LEARN
- Create table Contacts_LEARN
- Add fields / Columns to table Contacts_LEARN
- Add Link Table Customers_LEARN to Contacts_LEARN. It will create relationship between Customers(parent) and Contacts(Children) with one customer having zero or more contacts.
- CalculatedFields and CalculatedFieldsExtension creates Formula fields / columns and uses functions which will create colorful description of Customers and Contacts.
- Each customer-record and contact-record is identified with colorful-description
- while adding customer and contact record , color also needs to be selected which will be used to highlight customer/contact record.
- Color is parent for Customer(Child)
- Color is also parent for Contact(Child)
- Each customer record contains record-menu which can be used for record level operations on Customer
- Each contact record contains record-menu which can be used for record level operations on Contact
- Populate Customers table first. Customer data will be required while adding contacts
- Populate Contacts table. For each record of contact(child) parent=customer needs to be selected.
- Details of each customer will show list of contacts for that customer.
Add Table Add Field Menu :
Contacts Structure :
Customers Structure :
Customers Contacts Tables :
Customers Calculated Fields :
Customers Calculated Fields Extension :
Contacts Calculated Fields :
Contacts Calculated Fields Extension :
Record Menu:
Table Menu:
Contacts for Customer1 :
Contacts for Customer2 :
For Any Question please Contact MyDataOrganizer
