---
description: How to automate the review cycle number for each submission record
---

# Incrementing Review Cycle Automatically

### Incrementing Cycle Automatically

#### Required Fields in Parent Object (TIA\_request)

* Count - Number of Scope Submissions
* Count - Number of Submissions
* Equation - Increment Scope Cycle
* Equation - Increment Submission Cycle

#### Required Fields in Child Object (TIA\_scope\_submission & TIA\_submission)

* Text Formula - ScopeCycle
* Number - Scope Cycle
* Text Formula - SubmissionCycle
* Number - Submission Cycle

#### Incrementing the Count Field

```
{Number of Scope Submissions} + 1
```

#### Pulling Cycle # into Child Object Text Formula Field

```
{TIA_scope_submission TIA_request.Increment Scope Cycle}
```

#### Set Number Field to Text Formula if Blank

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-Mfn6MAe1e2FchnCHqGD%2F-MfnKdiPFQ2xwQhoNH72%2Fimage.png?alt=media\&token=55763112-fb82-4b60-aa74-249e85a5067d)

{% hint style="warning" %}
Be aware that duplicate cycle numbers can be created if a previous cycle is deleted, therefore reducing the count value.
{% endhint %}
