Skip to main content

 Hi all, 

 

We have a from which is in paper format and we need to transform on SharePoint. 

 

 

Information about form:

 

  1. Evaluated by the submitter to create the new supplier and approved by respective HODs.
  2. For Warning and Disqualification record section, Fill in by Admin department and approved by MD

 

The form has 2017, 2018, 2019, 2020 for the “Evaluation Record” in the manual paper form and current process by company. 
Going forward company just evaluate the suppliers per year but need able to gerenrate reports for the past years using SharePoint Online. 

Having a year column would be considered as a solution and good for reporting. However, change the year for every year needs to be taken care of. 

Q: How this can be handled by form for a dynamic year?
Q: What shoud be the best approach?  

 

 

Any suggestions would be appreciated   

Thanks in advance, 

I would do it by creating a simple SP text column "Year" and on the form dynamically fill the related field on the form with (0,4)substring from current date.

Other option would be to create a calculated SP column with a calculation to again substring year from current date.

At least if I understood your problem right

In the end the report can br created using PowerBI for example. It allows to create really tasty reports with just couple of clicks, way easier and elegant than SSRS

Regards,

Tomasz

‌ have you solved the problem?

Regards,

Tomasz

‌ ..I guess I got an idea ..I still work on have to this challenge ..

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings