Looking for an advice to start an app form scratch

[sajarac]

Hi there,

Probably I had to ask this question a long time ago, but here is my scenario:

I would like to have all the app lists in Share Point.

I would like to keep consistence with MS Access, I mean, in one list have the products and in the main list have the product ID.

For instance:

SPL List Employees:

ID | Employee_Name

1 Employee A

2 Employee B

3 Employee C

4 Employee D

SPL Contract_Types

ID | Contracts

1 Full time

2 Part Time

3 Hourly

4 Salary

SPL Departments

ID | Department

1 HR

2 Maintenance

3 Production

Now I want to have my app connected to all those lists, and when the user select "ADD" new record, I want to see the comboboxes display the info for the "employees", "Contracts", "Department".

After that in the "Save" event I would like to save those choices in other SPL "Personal" but I would like to save the "ID's".

for instance if I choose:

Employee C | Full Time | Maintenance

In my SPL "Personal" should appear as:

Emp_ID   | Contract_ID  |  Department_ID

     3                  1                        2

That is the first part, now the second part is the "Personal Form". In this form I would like to perform "New", "Edit" "Save"

So this mean that the form "Personal" should read the share point list, when the user click in edit, it should bring the saved data in that record and also show the Comboboxes for a new selection or change. then Patch the record with the new values.

I am confused, I say videos where others users has SPL for the choices and then use the VLookup. other user has a SP column "Choices" with all the items required. But I think that this option is not good specially if you want to implement galleries to have the user creates new entries.

And in the other side, I don't know about performance, what about if my app have tons of records and all the time the app is doing lookups to present the data? 

Sorry probably too many questions but I wan to be sure to start good from the beginning.

Thanks in advance for any advice.

Best Regards

[v-yutliu-msft · Accepted solution]

Hi @sajarac ,

Do you want to update Personal list with Id value, but display as text value?

Could you tell me the fields data type in four lists?
I assume that:
1)SPL List Employees: ID(number type), Employee_Name(text type)

2)SPL Contract_Types:  ID(number type), Contracts(text type)

3)SPL Departments:   ID(number type), Department(text type)

4)SPL Personal: Emp_ID(number type),Contract_ID(number type),Department_ID(number type)

If so, try this:

1)connect your app with these four lists

2)insert three drop downs

set drop down1's Items:

Distinct(Employees,Employee_Name)

set drop down2's Items:

Distinct(Contract_Types,Contracts)

set drop down3's Items:

Distinct(Departments,Department)

 3)the update formula:

Patch(Personal,Defaults(Personal),
               {Emp_ID:LookUp(Employees,Employee_Name=dropdown1.Selected.Result,ID),
                Contract_ID:LookUp(Contract_Types,Contracts=dropdown2.Selected.Result,ID),
                Department_ID:LookUp((Departments,Department=dropdown3.Selected.Result,ID)
               }
)

Do not need to worry about your app's performance when your data source is large.

The functions that I mention are all delegate for sharepoint.

Best regards,