別のフィールドが更新された正確な瞬間の日時で、日付フィールドを入力しようとしています。これにはArcadeを使用しています。マシンのローカル時間を取得し、他のフィールドが更新されたときに日付フィールドに入力することはできましたが、毎秒更新され続けてしまいます。時間フィールドは、他のフィールドが最初に更新された時刻のままで、自動的に更新され続けないようにしたいです。以下はArcadeコードです: var ResDate = ToLocal(TimeStamp()) var Status = $feature.Status IIf(Status == 'Resolved', ResDate, null) このArcade式をレイヤーのポップアップに入れています。つまり、フィーチャのStatusフィールドが「Unresolved」から「Resolved」に変更されたら、その時刻を取得して新しい解決日時フィールドに入れたいのですが、その時刻が何度も取得されて更新されてしまいます。Arcadeの'break'演算子を試しましたがうまくいきませんでした。基本的には一度だけ時刻を取得して、それを保持したいのです。どんな助けでもありがたいです！Arcadeはまだ新しく、詳細なドキュメントを見つけるのが難しいです。ありがとうございます！ Scott

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcadeで日付フィールドを入力する

ScottEvans6

<\/HEAD>

別のフィールドが更新された正確な瞬間の日時で、日付フィールドを入力しようとしています。これにはArcadeを使用しています。マシンのローカル時間を取得し、他のフィールドが更新されたときに日付フィールドに入力することはできましたが、毎秒更新され続けてしまいます。時間フィールドは、他のフィールドが最初に更新された時刻のままで、自動的に更新され続けないようにしたいです。以下はArcadeコードです:<\/P>

<\/P>

var ResDate = ToLocal(TimeStamp())
var Status = $feature.Status<\/P>

<\/P>

IIf(Status == 'Resolved', ResDate, null)<\/P>

<\/P>

このArcade式をレイヤーのポップアップに入れています。つまり、フィーチャのStatusフィールドが「Unresolved」から「Resolved」に変更されたら、その時刻を取得して新しい解決日時フィールドに入れたいのですが、その時刻が何度も取得されて更新されてしまいます。Arcadeの'break'演算子を試しましたがうまくいきませんでした。基本的には一度だけ時刻を取得して、それを保持したいのです。どんな助けでもありがたいです！Arcadeはまだ新しく、詳細なドキュメントを見つけるのが難しいです。ありがとうございます！<\/P>

<\/P>

Scott<\/P><\/BODY><\/HTML>

タグ付けされた投稿をもっと見る

Accepted answers

All comments

BillSimper

I forgot to mention the issue for me is with Arcade used in calculating a value in the Field Maps app. Obviously in Survey123 the "once" function is not an Arcade function.

BillSimper

Hi,

I have the same problem. In my case I'm trying to create a unique ID value utilizing Hours/Minutes/Seconds when the record is created. Both the Now() and Timestamp() functions work for this EXCEPT that the value keeps changing over the course of the user filling out the form, i.e. every time some attribute value is updated, the timestamp value will also update. This is problematic because this ID value is intended to be used for specimens being collected, i.e. it's being written on sample baggies and these two values need to match. Even more problematic is the fact that if the record is opened for editing later (possibly days later) this value will continue to update, hopelessly confusing things. This seems like kind of a niche problem but it'd be great to have a solution (besides just having users write this value into a free text field). The equivalent solution in Survey123 is to use the "Once" function to limit the re-calculation of a calculated value. Thanks!

Jean-FrancoisBrisson

Hello,

I have the exact same question (I want to do the same thing as Scott) !

Do we have a final answer ?

Thank you,

KellyGerrow

Hi Marques,

Thanks for the feedback. Am i correct, in that you only want the date recorded when a specific attribute is changed? For example: Only record the last precipitation date, if the users specifies Yes for the precipitation field.

Would you want to have more than one of these types of calculations per feature?

-Kelly

MarquesMunson1

Hi Kelly,

I would be highly interested in this if it is possible. To take editor tracking and somehow an arcade expression to populate a field when another field is updated. Can you assist with this?

The workflow is: a feature class of countries and a user can update a particular attribute of that country. Would like it so that the date field is populated when that one attribute is updated/changed.

ScottEvans6

Xander,

This makes sense to be a part of ArcGIS Online. Is this functionality planned for a future AGOL update soon?

Scott

XanderBakker

I think this might become possible in the future when support for attribute rules is implemented in ArcGIS Online and the Field Apps (at this moment there is only support for attribute rules when you have Enterprise): https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/an-overview-of-attribute-rules.htm

This would require the a Calculation Attribute Rule: https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/calculation-attribute-rules.htm#GUID-4E18C976-36C0-433C-884D-034A6353910B

ScottEvans6

Hey Kelly,

The issue is that the editor tracking [EditDate] field gets updated every time a feature is touched. Let's say that the user marks the point feature as resolved, and the [EditDate] field get updated with the date and time they marked the feature resolved. Then they go back in a week later to add attachments, or extra notes and follow up information. That [EditDate] now gets updated as well. In reality, I want the exact date and time that the user marked the issue resolved initially. Does that help?

Thanks,

Scott

KellyGerrow

Hi Scott,

Are you trying to display the field using Arcade in calculate function or are you calculating the expression in a pop up? When a field is calculated using Arcade a one time calculation is made. If you are running this calculation and include the time stamp, it will take the timestamp at the time that you run the tool.

When calculating an expression in a pop-up using arcade (which I think is what you are doing), the arcade expression runs and calculates when the map is loaded and the pop-up is called. The timestamp will then be displayed based on when the map was opened.

I don't think either of these functions will address your need.

I think using editor tracking (keep track of who created and updated features) and an arcade expression to calculate resolved based on the date created or updated field. Can you provide some more details about the workflow? How does the time get updated?

-Kelly

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.