none
Apps for Office in Access RRS feed

  • Question

  • Hi All,

    I am creating an app for Office which is using Access database, there is a button which shows the UI for Binding and I am getting the binding data and everything in the callback.

    But there are few requirements:

    1) On opening the UI for binding selection, the previous binding is not shown in the UI. So how can I show the previously selected binding in dropdown in the UI.

    2) Suppose there are total 6 columns for binding in UI but I want only 3 columns to be shown first time. And after clicking ADD(+) button next column is added until the count is 6 and after that ADD(+) button is disabled, just like "-" button is disabled when column Count is 1.

    Please suggest, Thanks in advance.


    Himanshu Nigam

    Thursday, December 11, 2014 12:41 PM

All replies

  • 1. cache the previous binding data

    2. use some js tree library to bind the data

    Friday, December 12, 2014 9:18 AM
  • Hi Shawnzkz,

    Thanks for your reply.

    I have saved the previous binding, but how do I set it so that on Binding UI form opening it is populated with the previous binding.

    And I am not getting "use some js tree library to bind the data" can you please elaborate.

    Awaiting for reply.


    Himanshu Nigam

    Friday, December 12, 2014 9:25 AM
  • Hi Himanshu,

    I'll involve some other engineers who have Apps for Office experience in you case, I hope they'll give you some more valueable suggestions or solutions. But this will take some time, so please be patient.

    Thanks for your understanding.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 12, 2014 9:31 AM
    Moderator
  • Hi Caillen,

    Thanks for the reply and helping me out.

    Looking forward to your help.


    Himanshu Nigam

    Friday, December 12, 2014 9:43 AM
  • Hi Himanshu Nigam,

    >> On opening the UI for binding selection, the previous binding is not shown in the UI. So how can I show the previously selected binding in dropdown in the UI.

    I assume you mean using the Bindings.addFromPromptAsync method to create a data binding in App for Access.

    Based on my understanding, the previous binding will not show is because the Bindings.addFromPromptAsync method will create a new binding rather than updating the previous one. To update the previous updating, you need to release the previous binding first (using Bindings.releaseByIdAsync method) and create a new one.

    >> Suppose there are total 6 columns for binding in UI but I want only 3 columns to be shown first time

    According to the document TableData.headers property, I did not see a property to set “hidden/show” column header, but if this a feature you want to include future versions of Apps for Office, please feel free to submit your ideas to Office Development Platform User Voice.

    By the way, please let me know if I have any misunderstanding on your questions.

    Regards,

    Jeffrey


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, December 15, 2014 4:55 AM
    Moderator
  • Hi Jeffrey,

    Thanks for the reply.

    I will try implementing the solution that you had suggested for showing the previous selected binding and would let you know if I face any issue.

    For limiting the column count, is there any way if I could limit the column mapping because as of now if all the columns are mapped then also I can add a new column for mapping which should be disabled.

    Is there any way that I could get the data for selected record apart from the columns that are mapped in the UI Form. I am using the getDataAsync method to get the callback and getting all the values and columns which are mapped, but can I get the value for a column which is not mapped.

    Also for connecting to Sharepoint online currently I have saved the credentials and web url in web.config of my application, so what should be the best way for defining these Credentials and using them as currently its hard-coded for a single application.

    Thanks in advance.


    Himanshu Nigam

    Monday, December 15, 2014 7:53 AM