# Calculation on a Repeating Field and Putting Result into Specific Repetition

This topic is 2910 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I've got a repeating field as a calculation and need to put a value into a specific repetition value/location, but I don't want to have to run a script every time to accomplish this.

For example, I have two fields, NumberField and RepeatingField[10]

When NumberField = 5 I need a 5 to show up in RepeatingField[5]  Can I do this in a calculation? If not, what's the best way to do this? This seems to trivial to me, but I'm looking for a elegant solution.

##### Share on other sites

The best way is not to use repeating fields.

Why are you using them?

##### Share on other sites

Ha! I figured that. I thought I'd try because I thought there would be a simple and quick way with a repeating field and one calculation. Otherwise, I've got to create 10 fields and 10calculations which all would need to be maintained and cluttering up the table.

##### Share on other sites

When NumberField = 5 I need a 5 to show up in RepeatingField[5]  Can I do this in a calculation?

Yes. But one example does not establish a rule.

##### Share on other sites

I've got to create 10 fields and 10calculations which all would need to be maintained and cluttering up the table.

If this is for developer use, there is nothing wrong with repeating fields - as long as it does not hold client data.  Can you explain the purpose here?  10 fields and 10 calculations indicates either 1) they should be records in a related table or 2) they are developer tools, doesn't it?

##### Share on other sites

Why don't you describe more broadly what problem you are trying to solve and what the purpose of the  repeating fields is?

##### Share on other sites

Sure thing...

I have a table of tasks each with a due date. In list view I have each task and adjacent to each task are twelve columns one for each month. I just want to highlight the corresponding repeating value which corresponds to the the month.

if Month = 1 then put a value in the first repeating field..If month  = 2 then put a value in the 2nd repeating field..so on. I can then do conditional formatting to get the highlighting.. I've already worked this solution out with 12 fields and 12 calculations...looking for a simpler solution.

##### Share on other sites

What value do you want it to have?  Well, try this:

Create a calculation with 12 repetitions and a calculation of:

```Let ( [
i = Get ( CalculationRepetitionNumber ) ;
d = Extend ( date )
] ;
Case ( i = Month ( d ) ; i )
)
```

You should be able to replace the final result where I have i - to be whatever you wish.  As is, that repetition fills with the month number. Adjust as needed.

• 1
##### Share on other sites

What value do you want it to have?  Well, try this:

Create a calculation with 12 repetitions and a calculation of:

```Let ( [
i = Get ( CalculationRepetitionNumber ) ;
d = Extend ( date )
] ;
Case ( i = Month ( d ) ; i )
)
```

You should be able to replace the final result where I have i - to be whatever you wish.  As is, that repetition fills with the month number. Adjust as needed.

This works. Thank you! Can you explain how this works? How does it put 'i' into repetition['i']?

##### Share on other sites

I'm pleased it worked for you, GisMo.  I lost my post so I'm try again to explain ...

i - is just the repetition number

d - is your date extended the same to all repetitions

If each repetition number identified as i ( evaluated from itself ) looking across to the matching 'rep number' of the extended  date equals the month number of the date (in its matching rep) then produce the result of i which is assigned as the local variable within the Let() otherwise produce no result.

So for another month example, instead of this:

Case ( i = Month ( d ) ; i )

it could be this:

Case ( i = Month ( d ) ; MonthName ( d ) )

• 1
##### Share on other sites

This topic is 2910 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

• ### Similar Content

• #### fmp17 A simple repeating field question

By Asu,

• 2 replies
• 1,592 views
• #### Join table portal within portal

By ehwalker,

• 16 replies
• 2,821 views
• #### What to do when a child record has multiple parent records of same table

By ehwalker,

• 9 replies
• 2,458 views
• #### Portal SC Get Container in a repeating field display

By cat traveller,

• 1,143 views
• #### Repeating field relationship in a portal.

By gerg nnud,

• 2 replies
• 1,486 views
×
×
• Create New...