维护机器服务清单 [英] Maintenance Machine Service List
问题描述
我希望建立一个资产服务列表，这样我就可以向相关人员发送提醒，说明您的车辆或机器应该到期，这是列表制作
I wish to build a Asset Service list so i can send out reminders to relevant people saying your vehicle or machinery is due for service this is the list ive made
SMU（机器营业时间）每天更新，在下一列ID中，表示下一个服务即将到来，每250个SMU
The SMU (Machine hours) is updated daily, in the next column id like it to say the next service coming up which is every 250 SMU
For例如，AE19 目前正坐在8030 SMU，我们在8250 SMU提供服务，所以我喜欢说8250（或者说它是7800比8000）？
For Eg, AE19 is currently sitting at 8030 SMU and we do services at 8250 SMU so id like it to say 8250 (or if it was 7800 to say 8000)?
1）代码是什么看起来像？我该如何解决这个问题？
1) what would the code look like? how do i go about this?
在LV服务到期栏目中，我们每隔20,000公里或6个月的时间为我们的车辆提供服务，比如说接下来的20,000公里和6个月的km / s标记？
In the LV service due column, we service our vehicles every 20,000kms or 6months id like it to say the km/s the next 20,000kms and or 6month mark?
对于机器我们也每隔500,1000和2000个SMU小时ID执行主要服务，如在PM1中显示PM2 500SMU中的下一个250SMU等等，
for the machinery we also do major services every 500, 1000 and 2000 SMU hours id like in the PM1 to display the next 250SMU in PM2 500SMU and so on,
如果有人能帮助我，我很高兴地欣赏这个用谷歌搜索到我心中的内容并且没有提出什么，我不是最伟大的代码？作家编码器？
If anyone could help me id gladly appreciate this ive googled to my hearts content and come up with nothing and im not the greatest code? writer coder?
谢谢你
推荐答案
<嗨ShaneOz，
Hi ShaneOz,
我不太清楚你的要求，请提供更多相关信息：
I’m not very clear about your requirement, please provide more information about it:
你想什么时候发送提醒？当前的SMU达到某个值，或服务到期/ LV服务到期列到达一定时间？
When would you want to send out reminders? When the current SMU reaches to the certain value, or service due/ LV service due column reaches to certain time?
您的描述中的"id"是什么？
What is "id" in your description?
此外，为了在没有代码的情况下定期发送电子邮件，我建议您使用工作流程在SharePoint Designer中发送if条件的电子邮件。
Besides, to send the emails in the regular time without code, I recommend you using workflow to send emails with if condition in SharePoint Designer.
祝你好运，
Grace Wang
Grace Wang
这篇关于维护机器服务清单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
