Forum Replies Created
-
Posts
-
Hi Alexander
Thanks for getting back to me.
I was more looking for the row in the list view.
I found lots more articles on the JSON List Formatting, so this has helped.
I have have it working – just applying the JSON to the the column for each row is a such a timesaver over doing it the old CEWP route.
I am assuming that sine I can still get to the classic view, I can still apply a web part to the view if I need to.
Iain
Hi Alexander
Thanks for getting back to me.
Yes, when you upload a document, typically, it just uploads, but any of the columns will not be completed as you have not entered anything.
What I want to do is collect that data during the upload process – like name and title for example. When the document is saved, it is uploaded and the column data filled in.
Regards
Iain
Just a quick check – do you have the code the wrong way around ?
The performance list show welders hours and the welders hours list shows performance list.
Iain
Thanks
That is what I thought.
Just a clarification, does all the code go into one CEWP or Script Editor ?
and assuming that I start and end with and
Iain
Many Thanks Alaexander
I will give it a whirl over the weekend.
Just a question
On the lines “viewFields”:[“ID”,”Title”,”January_1″]
Do I just add additional items like
“viewFields”:[“ID”,”Title”,”January_2″]
for each of the additional days of the month ?
Iain
Hi Alexander
The calculation should be performed when either the value in list 1 or list 2 is changed.
Typically, the values are entered once, so not much editing after the fact.
Iain
Hi Alexander
Appreciate your help.
These are just custom lists created with regular columns. I will break it out by months, so yes, there is an entry for each day of the month through the year – perhaps there is a better way to do it, but for me this works. I am open to changes if it suits the code better.
Basically, there 2 main fields, the welder’s name and the day of the month (each has its own field).
Each day, we would record the number of inches welded that day. On the day in the other list, I can capture the welder’s name plus how many hours he / she worked.
The 3rd list is just a combination of the two – the name and the calculation for the particular day
I do have a weekly total which is a calculated field
You have understood – yes, 250 / 8 = 31.25, that would go in Mark in Jan1 or the field that it came from.
If there is anything you need, please let me know.
Iain
Thanks
Having a little direction definitely helped.
One issue, not all the fields are lined up – the date field is lower than the other two.
Any ideas?
Iain
Attachments:
That would be great if that can be done as I tried using a workflow – while I managed it get it to work for one item, it would mean creating a lot – so not really feasible approach.
Here is a screenshot
What I need is another View showing the Performance divided by the hours.
Iain
Attachments:
