Possible to update runtime input variable dropdown list from wdata table?
Udzielono odpowiedzi|
Hi, I'm looking for a way to dynamically update a runtime variable dropdown list from a wdata table. I have the wdata table refreshing, so I just need a way to link that to the runtime variable dropdown. Is that possible? Wdata table: Runtime input:
|
-
Hi Michelle Haynes,
If the question is to be able to update Dropdown Input options for a Runtime Input, the answer is that the options cannot be changed programmatically. This is because a change to a Chain, include updating the Runtime Inputs, requires publishing prior to being able to run the Chain.
As a workaround, you could design your Chain to have a Text Input and then build a Chain that reads in the value and passes it to the sub-chain via a Run Chain event.
0
Hi Jeff Hickey,
I've called another chain from a chain before, but are you recommending using a file for users to enter each run or how would I provide the parameter values dynamically from the main chain to the sub-chain? Thanks!
0
Hi Michelle Haynes,
If you need to send a value to a Chain as a Runtime Input and the value is not available within the Dropdown Input selection, a workaround is to use a Control Sheet. This allows you to control the values dynamically.
You can achieve this by creating a new parent Chain (Chain A) that reads the appropriate input from the Control Sheet and then passes that value to your existing Chain (Chain B) via a Chain event to a Text Input, rather than a Dropdown Input. This method allows you to control the input value which is updated through the Control Sheet that Chain A reads from.
Alternatively, you can modify your existing Chain (Chain B) to read directly from the Control Sheet, bypassing the need for a new parent Chain. The choice between these two methods depends on your specific setup and requirements. This solution provides flexibility and control over the input values and allows you to dynamically update them as needed.
0
Hi Jeff Hickey,
Thanks so much for this information! A few addition questions on this approach, which I think might be a great option:
1. Can the data validation list be populated dynamically? For example, can I update this daily from an Oracle OTBI report that I save as a csv doc? My goal would be to update the list daily (or potentially more often).
2. Is it possible to have cascading data validations, for example in my spreadsheet below, could I have the task list dependent on what project is entered? Say it's dynamically populated from an Oracle OTBI report/spreadsheet (assuming question 1 is possible) and my spreadsheet has the following values can I have it so if project entered is 123 only tasks 01-01 and 02-01 are available on task number?
3. What if multiple users are trying to update the same control sheet at the same time? Is there a unique version for each user? Is there a way to allow multiple users to use the same control sheet at the same time or would I need to create multiple control sheets/chains (one for each user), so we don't overwrite each other's updates?
Spreadsheet:
0
Hi Jeff Hickey
I actually figured out questions 1 and 2, using formulas to link to other spreadsheets with the Overwrite Sheet data. The only thing I'm still curious about is question 3.
3. What if multiple users are trying to update the same control sheet at the same time? Is there a unique version for each user? Is there a way to allow multiple users to use the same control sheet at the same time or would I need to create multiple control sheets/chains (one for each user), so we don't overwrite each other's updates?
0
Hi Michelle Haynes,
Multiple people can use the same Control Sheet. If more than one user is in any Spreadsheet (including a Control Sheet) at a given time, those users will see each other as active in the lower right corner, the highlighted cell each user is active in, and be able to see each others edits in real time.
0Zaloguj się, aby dodać komentarz.
Komentarze
Komentarze: 6