Onchang multiple input_updates

[Joelkohym]

Hi, I would like to know if I am able to make updates on multiple inputs based on one onchange selection as seen below. Currently, my first selection changes one input. But the last input doesn't change. Can anyone help me out please?

readDF = pd.read_excel(FilePath, sheet_name='Queue')

lotNumlist = readDFA['Lot'].tolist()

availableLotList = sorted(list(set(lotNum)-set(lotNumlist)))

assignTruck = input_group("Assign Lot",[
radio('Lot Number', name='lotNumber', options=availableLotList, inline=True, validate=checkLot), 
select('Project Number',name='pjNum', options=readDF.loc[:,'Project Number'], onchange=lambda c: input_update('truckPlate', value=readDF.loc[:,'Truck Plate'][readDF[readDF['Project Number'] == c].index[0]])),
input('Truck Number',name='truckPlate', value=readDF.loc[:,'Truck Plate'][0],readonly=True, onchange=lambda c: input_update('bookTime', value=readDF.loc[:,'Booking Time Slot'][readDF[readDF['Truck Plate'] == c].index[0]])),
input('Booking Time',name='bookTime', value=readDF.loc[:,'Booking Time Slot'][0],readonly=True),
])

[wang0618]

The onchange only can be triggered by user's actions.

In your case, you can also update the bookTime input item in your pjNum onchange function.

[Joelkohym]

Dear @wang0618, thank you for your reply. By any chance will you be able to show me an example of how it should be written instead please? Many thanks!!

[wang0618]

Like this:

def on_roj_num_change(val):
    truckPlate = readDF.loc[:, 'Truck Plate'][
        readDF[readDF['Project Number'] == val].index[0]]
    input_update('truckPlate', value=truckPlate)
    
    input_update('bookTime', value=readDF.loc[:, 'Booking Time Slot'][
        readDF[readDF['Truck Plate'] == truckPlate].index[0]])
    
assignTruck = input_group("Assign Lot", [
    radio('Lot Number', name='lotNumber', options=availableLotList, inline=True, validate=checkLot),
    select('Project Number', name='pjNum', options=readDF.loc[:, 'Project Number'],
           onchange=on_roj_num_change),
    input('Truck Number', name='truckPlate', value=readDF.loc[:, 'Truck Plate'][0], readonly=True,
          onchange=lambda c: input_update('bookTime', value=readDF.loc[:, 'Booking Time Slot'][
              readDF[readDF['Truck Plate'] == c].index[0]])),
    input('Booking Time', name='bookTime', value=readDF.loc[:, 'Booking Time Slot'][0], readonly=True),
])

[Joelkohym]

Dear @wang0618 ,

You are a genius! It worked!! Thank you so much!!