How to add an editable Access Desktop Database to Sharepoint Server 2016

I’m a university student summer intern at a government agency, so sorry if this comes off as a dumb question or if I don’t appear very knowledgeable, but our team of maybe 10-ish people uses an excel spreadsheet currently to store records of forms submitted by contractors, and in order to save time and make it easier to enter records, I made a very simple Access desktop database, with 5 identical forms for entering/editing records from years 2015-2019, and five tables to where the records go after being entered in the form.

My boss and I were both very happy with the Access database I made, and it was working perfectly the entire time I was using it. The trouble comes when I try uploading the Access database file to our Sharepoint 2016 Server. When I click our old excel document, or any other word or powerpoint file, I can edit them as I please then click save and they automatically sync to sharepoint. With my access desktop database however, it just downloads the file onto the computer of whoever clicked the link and then you have to not only edit it, but save it onto your computer and reupload to sharepoint in order to have your changes saved.

I’ve been looking all over the web for answers, and it seems that Microsoft has retired Access web apps, which is why clicking the database automatically downloads the file, instead of just opening it in browser as it does with excel and word etc.

Since I’m working in the government, I have no admin privileges or anything on our sharepoint server, and I am unable to even add access apps to sharepoint if they still exist (I have no clue), but I am almost positive that there has to be a way to have a collaborative database on our sharepoint server, so that we can all go in and edit/add to it when we need to.

I was really hoping someone would outline precisely what I need to do, as I have only had this job for about a month and I am still getting used to sharepoint/databases/SQL. All I need is a way to get my Access Desktop Database onto our sharepoint server where all our other collaborative documents are, and have the ability to edit from within sharepoint, without having to download and reupload the desktop database every single time. Thanks so much in advance!

SharePoint 2013 -Compare values in list to see if all column values match- dashboard

I want to create a dashboard indicating when all items in a list are equal to “Yes”. For testing I am innerHtmling Done/Not Done. The logic seems to work , but I am afraid the code is testing the list as a whole and not the individual items. I am using choice columns.

Am I missing a loop?

$  (document).ready(function() {     arrayIn_OutItems();     

});

function arrayIn_OutItems(){ var siteUrl = “https:xxx/_api/web/lists/GetByTitle(‘listName’)/items?$ select=”Title,Office,HR,Accounting; var array = []

$  .ajax({     url: siteUrl,     type: "GET",     async: false,     headers: {         "accept": "application/json;odata=verbose"     },     success: function (data) {         array = data.d.results;         console.log(array);         var isYes =          for(var i = 0;array[i].length < 0;i++{             array.every(function (e) {       return e  == "Yes"       });         }         if(isYes == true){           document.getElementById('yes/no').innerHTML = "Done";         }else{           document.getElementById('yes/no').innerHTML = "Not Done";         }      },     error: function (err) {         console.log(err);     } }); 

}

Daily report on SharePoint

I’ve got a list with ~2000 items. I’m hoping to add a daily status update (i.e. Up/Down) to each that i can then use the results to make monthly/yearly/etc.. trend charts. Is there a clean way to do this without lists getting out of control large?

edit: To keep it simple, I don’t really need to know how to get the data, just wondering on the best way of setting it up. Lets say I have a thermometer and each day I want someone to check that and add the value to that item on the list (therm. 1) but have access to all the previous values for trending. Now i have 2000 thermometers, what would be a good way to track all that data? All I can come up with is versioning, I’m not sure that would be the best way.

Thanks,

Chuck

Adding tags to Sharepoint online Office 365 documents via C# and CSOM

I have a small project that requires migrating from Sharepoint 2010 to Sharepoint Online. According to Microsoft, tags have been discontinued.

I have been able to add Enterprise Keywords and custom metadata columns which works great.

Sharepoint Online still has a column for tags (despite it not being editable). The client is still very much focused on tags for the moment. I cannot seem to figure out how to assign a tag via C#. Is there anyone who could point me in the right direction?

using (var cc = new OfficeDevPnP     .Core     .AuthenticationManager()     .GetSharePointOnlineAuthenticatedContextTenant(         "https://company.sharepoint.com/sites/",          "Test@test.com",          "password"))      {         Web web = cc.Web;          FileCreationInformation newFile = new FileCreationInformation();         newFile.Content = System.IO.File.ReadAllBytes(@"C:\Test\Upload.jpg");         newFile.Url = "Upload.jpg";          Microsoft.SharePoint.Client.List docs              = web.Lists.GetByTitle("Documents");          Folder folder = docs.RootFolder.Folders.GetByUrl("General");         File uploadFile = folder.Files.Add(newFile);          //uploadFile.Tag = ???          cc.Load(docs);         cc.Load(uploadFile);         cc.ExecuteQuery();      } 

What do I set at uploadFile.Tag?

SHAREPOINT FRAMEWORK – REACT JS alert on Page Load

I am new to SharePoint framework and React JS.

I have build a basic Web Part with CRUD operation using React JS.

I wanted to show drop-down(html select) value on Page Load in an alert. I am able to get an alert on page load but not able to figure out how to get html select value in that alert.

Please advice.

Here is my code for getting alert on page load.

componentDidMount() {      alert("Hi"); }    public render(): React.ReactElement<IReactCrudProps> {        return (          <select id="myDDl">          </select>     ); }  

Enabling an attachments field when creating an event in SharePoint Online?

I have my site configured with a basic out of the box events app, where the user can click ‘add event’ and fill in the details of it.

When filling in this info, I want the user to be able to attach documents. This might be for handouts or presentation slides that people attending the event can access.

Within the events content type, I can’t find any column for attachments. I’ve also made sure the attachments option is enabled in the list settings.

Does anyone know how I can enable this? Thanks

400 Bad Request when updating list item in SharePoint Online using HttpClient

I have written a REST API which to update the a document metadata in SharePoint. Document resides in a Folder in a Library. I have tried the following code:

var stringData = ("{'__metadata': { 'type': 'SP.Data.IncidentItem' }, 'NameOfUploader': '" + NameOfUploader + "'}");                  client.BaseAddress = new Uri(newurl);                 client.DefaultRequestHeaders.Clear();                 client.DefaultRequestHeaders.Add("Accept", "application/json;odata=verbose");                               client.DefaultRequestHeaders.Add("IF-MATCH", "*");                 //client.DefaultRequestHeaders.Add("X-HTTP-Method", "PATCH");                 client.DefaultRequestHeaders.Add("ContentLength", stringData.Length.ToString());                 client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", accessToken);                  string FolderUrl = string.Format("_api/web/GetFileByServerRelativeUrl('{0}')/ListItemAllFields", folderServerRelativeUrl + "/" + fileName);                 StringContent strContent = new StringContent(stringData);                 strContent.Headers.ContentType = MediaTypeHeaderValue.Parse("application/json;odata=verbose");                 strContent.Headers.ContentType.Parameters.Add(new NameValueHeaderValue("odata", "verbose"));                 HttpResponseMessage response = client.PatchAsync("_api/web/GetFileByServerRelativeUrl('"+FolderUrl+"')/ListItemAllFields", strContent).Result;                  response.EnsureSuccessStatusCode(); 

I am getting 400 Bad Request at “HttpResponseMessage response“. I have provided all headers, still couldn’t figure it out. I have tried this in POSTMAN with all the headers and this metadata, it’s all working fine. Can Anyone please tell what I am missing?