在SharePoint列表中自动填充日期和时间 [英] Auto-Populate Date and Time in SharePoint List
问题描述
我需要创建2个单独的字段,只要用户创建新表单,就会自动填充这些字段。这些字段还需要能够被用户手动覆盖(因此计算的列将不起作用)。我需要自动填充的字段
如下:
I need to create 2 separate fields that are auto-populated whenever a user creates a new form. These fields also need to have the ability to be manually overwritten by the user (therefore calculated columns won't work). The fields I need to be auto-populated are below:
1)订单日期 - 这需要填入今天的日期(我可以通过创建日期字段来完成此操作)并将默认设置为'今天的日期'。
1) Order Date - This needs to be populated with Today's date (I can do this by creating a date field and setting default to 'Today's Date'.
2)订单时间 - 需要填写用户点击"新表格"的确切时间,格式为hh:mm: ss。
2) Order Time - This needs to be populated with the exact time the user clicks on 'New Form' in the format of hh:mm:ss.
如果以上情况可以,请您告诉我,如果可以的话,如何实现?
Please could you let me know if the above is possible and if so, how this can be achieved?
谢谢
推荐答案
您好,
对于"订单日期"列,正如您所说,创建日期并将默认设置为 '今天的日期'。
For Order Date column, as you said create a date filed and set default to 'Today's Date'.
对于"订购时间"列,创建单个文本字段。然后将默认值设置为计算值并输入以下公式:
For Order Time column, create a single text filed. Then set default vale to calculated value and enter this formula:
=TEXT(NOW(),"hh:mm:ss")
测试:
Best此致,
Michael Han
Michael Han
这篇关于在SharePoint列表中自动填充日期和时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!