It supposed to update the gallery when triggering the button of the form where only Submit function is executed. Not sure which information you mean but I reffer to the OnVisible codes that I have, I don't know If that would work. Also, as I mentioned, This was working well but it suddenly stopped working, I don't know why, even If I refresh the data base manually from the data sets menu, it is not updating the gallery, unless I click on any gallery button, same for deleting values (I have a button of a trashcan with the Remove function)
///***vis pop ups***///
Set(visPOP_1,false);
Set(visPOP_2,false);
///****nueva cita fields sets***///
Set(visDropTime1,false);
Set(butText,"ᐯ");
Set(startTextCopy,"");
Set(trigger_Add, 0);
//****edit cita fields sets***///
Set(visDropTime2,false);
Set(butText2,"ᐯ");
Set(startTextCopy2,"");
Set(copyNoEmp,"");
Set(copyName,"");
Set(copyPlant,"");
Set(copyDate,"");
Set(copyID,Value(""));
//---REFRES DATA BASES---//
Refresh(DaysOff);
Refresh(Hc_DataBase);
Select(icoToday);
// Build colCalendarDraft - structure for times by 30 minutes and row numbers
With(
{
tvBlankSchedule: AddColumns(
// Initial 15 minute Time output
(Filter((ForAll(Sequence(48),Time(0, 30 * (Value - 1), 0))),Value < Time(16,30,0) Or Value > Time(22,0,0) Or Value < Time(0,0,0)))
,
// Add column with Minute value for current Time less Midnight
ValueInt,
DateDiff(
TimeValue("12:00 AM"),
Value,
TimeUnit.Minutes
)
)
},
// Build collection based off output from With statement, add Row No logic
ClearCollect(colCalendarDraft,
ForAll(
Sequence(CountRows(tvBlankSchedule)),
Patch(
Index(tvBlankSchedule, Value),
{RowNo: Value}
)
))
);
Concurrent(
// Capture today's date
Set(gvDateToday, Today()),
// Use Today's date capture to set additional var
Set(gvDateSelect, Today())
);
With(
{
// Build a temp tbl; appointments for selected date
tvAppointments: Filter(
Incoming_PSY,
DateValue(DateApp) = gvDateSelect
)
},
ClearCollect(
// Create finalised collection
colCalendarFinal,
AddColumns(
colCalendarDraft,
// Add appointment column, using output of With()
Appointment,
tvAppointments
)
)
);
/// color botones radio ///
Set(colorDay, RGBA(189,219,219,1));
Set(colorNight,RGBA(189,219,219,1));
Set(shiftValue,"");
