Skip to main content
Solved

Create a task to insert a schedule

  • September 29, 2022
  • 4 replies
  • 58 views

Blommetje
Forum|alt.badge.img+13

Hi,

My goal is to have the end user create a planning schedule.

Currently we have this in legacy; 

Here we see some values like year and start date etc, which is not the problem. 

The middle is the info entered; here stat 2 of may, with a Day shift (first green cel) and so forth. 

The lower part, where number of weeks (3 in this case) is displayed, and the 7 days for each week. 

 

I'm thinking of creating a process flow that will take the user through these steps. 
→ Create a Rotation (year, description)

→ Select number of weeks (lookup from table - can range between 1 and 52)

→ Select a shift PER day PER week (lookup from shift table (morning/day/night)

→ Save 

 

Point 3 is my problem, display number of weeks on runtime in the task, and a lookup per day/week.

Can I display a 'table’ where a user can select these shifts per day, AND insert that in the Db/ 

 

It does not need to look like this, but some advice on how to achieve something similair like this would be very welcome. 

The colorful result will be created later in a View, where i'll show the info for the selected Rotation and some conditional layout; it's for a later concern). 

Much appreciated! 

 

Alex

Best answer by Blommetje

Hi Mark, 

I think have done it slightly different, but very happy with the outcome. 

I have made a table with a form - insert amount of weeks (eg.6). With a handler I insert 6 rows for this Rotation. 

In this edit-in-grid the user can select Shift from the Shift-table. 
 


When all weeks/days have the shift that is needed, there is a task that will calculate all Shifts per weeks for the running period of the Rotation. (insert in different/final table). And a PF to jump to that table, to display; Something like this; 

Works ok. 

Only downside is that in Universal this all looks way too big. In Web gui I can fit everything on my screen (whole month) in Universal the last 10 days or so are in a horizontal scroll. 
There is no way to make universal ‘smaller’? Font size? Whatever. It’s hard to fit a lot of rows in that gui… 

But this is a pretty good outcome!

Thanks 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Alex,

Can I display a 'table’ where a user can select these shifts per day, AND insert that in the Db?

That is not really possible. Inside a Task parameter, normally only a single value is inserted. To have multiple values you either need to combine them using something like Multirow task execution.

I think a Process flow can certainly help with this, by guiding the user in inserting/selecting data step by step. Step 3 could be a new screen that can only be opened via the Process flow. This screen holds the desired dates which the user may choose from. 

Could that be a good alternative?


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hey Alex, did my reply help out? Looking forward hearing from you.


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 209 replies
  • Answer
  • October 28, 2022

Hi Mark, 

I think have done it slightly different, but very happy with the outcome. 

I have made a table with a form - insert amount of weeks (eg.6). With a handler I insert 6 rows for this Rotation. 

In this edit-in-grid the user can select Shift from the Shift-table. 
 


When all weeks/days have the shift that is needed, there is a task that will calculate all Shifts per weeks for the running period of the Rotation. (insert in different/final table). And a PF to jump to that table, to display; Something like this; 

Works ok. 

Only downside is that in Universal this all looks way too big. In Web gui I can fit everything on my screen (whole month) in Universal the last 10 days or so are in a horizontal scroll. 
There is no way to make universal ‘smaller’? Font size? Whatever. It’s hard to fit a lot of rows in that gui… 

But this is a pretty good outcome!

Thanks 


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Looks awesome Alex! Great you got it working.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings