Jump to content

Calculation on a Repeating Field and Putting Result into Specific Repetition


 Share

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.

Link to comment
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.

Link to comment
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?

Link to comment
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.

Link to comment
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.

  • Like 1
Link to comment
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']?

Link to comment
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 ) ) 

  • Like 1
Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.