有没有一种方法可以检查过去14天内的重复项目 [英] Is there a way to check for a duplicate item with in the last 14 days

问题描述

我有一个订单输入"系统，只有少数几个人可以订购商品，但是我想做的是防止他们在过去14天内订购相同的商品.

I have a Order entry system, where only a select few people can order items, but what I want to be able to do is prevent them from ordering the same thing with in the last 14 days.

我有列

当前用户

ItemName

商品说明

时间戳列

已创建

由列创建并在SharePoint列表中使用.

and created by columns are used in the SharePoint list.

我可以在InfoPath中执行此操作吗?还是必须使用工作流来执行此操作，以检查当前用户在过去14天内是否未订购相同的商品和说明商品.

Can I do this with in InfoPath or do I have to do this with a workflow to check that the currentuser hasn't ordered the same item and description item with in the last 14 days.

检查当前用户在过去14天内是否提交了相同订单的最佳方法是什么.我试图搜索是否有人在此发布过博客，但我认为我的搜索条件不好，因为我找不到任何东西

What is the best way to go about checking if the current user has submitted the same order with in the last 14 days.  I tried to search to see if anyone has blogged about this, but I think my search terms are not good, as I can not find anything

推荐答案

FAASpDeveloper，  

Hi FAASpDeveloper,  

根据您的描述，您要防止SharePoint列表中最近14天内基于两个或更多列的重复条目.

以下是一个演示示例，该演示基于SharePoint列表中的两个或多个列来防止重复条目，供您参考:

https://salnikan.wordpress.com/2011/07/26/prevention-of-duplicate-entries-based-on-two-or-more-columns-in-a-sharepoint-list/

Here is a demo about prevention of duplicate entries based on two or more columns in a SharePoint list for your reference:

https://salnikan.wordpress.com/2011/07/26/prevention-of-duplicate-entries-based-on-two-or-more-columns-in-a-sharepoint-list/

最好的问候，

丽莎·陈(Lisa Chen)

Best Regards, 

Lisa Chen 

这篇关于有没有一种方法可以检查过去14天内的重复项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！