Checkboxes - change Values and add to sheet

[doppeld1971]

Hi ya !

for my own "pleasure" @work i'm trying to do a little app , which saves Data to a Google sheet
(Car's getting in / Out)

I use 2 checkboxes - 1 for in , 1 for out .
Results are , as they should , TRUE or FALSE.
Is there a way to convert the TRUE to a Letter like "X" BEFORE sendig to the sheet ?

Tia
Stefan

[TIMAI2]

Of course. If checked then variable = X . Send the variable value to Google sheet

[doppeld1971]

Shall i use these blocks ?

[TIMAI2]

This approach might be easier....

[doppeld1971]

Thank you very much for the suggestion , unfortunately the Result in Sheets now is TRUEX

[TIMAI2]

Show your relevant blocks

[doppeld1971]

Here we are

[doppeld1971]

DONE !!

Dunno why it works know

Cheers Mate

[TIMAI2]

Probably needed to refresh something...pleased to hear you got it working.