Create filter for Fuel
Filter name
Icon
Add to menu
Add to quick create
Share filter
Columns
Order by
Conditions
{"condition":"AND","valid":"true"}
[{"id":"Fuel:name","field":"name","label":"Name","type":"string","input":"text","variable":"fuel_name"},{"id":"Fuel:description","field":"description","label":"Notes","type":"string","input":"text","variable":"fuel_description"},{"id":"Fuel:fuel_level","field":"fuel_level","label":"Fuel Level (%)","type":"string","input":"text","variable":"fuel_fuel_level"},{"id":"Fuel:range_km","field":"range_km","label":"Range (km)","type":"string","input":"text","variable":"fuel_range_km"},{"id":"Fuel:date","field":"date","label":"Date","type":"string","input":"text","variable":"fuel_date"},{"id":"Fuel:liters_filled","field":"liters_filled","label":"Liters Filled","type":"string","input":"text","variable":"fuel_liters_filled"},{"id":"Fuel:price_per_liter","field":"price_per_liter","label":"Price per Liter","type":"string","input":"text","variable":"fuel_price_per_liter"},{"id":"Fuel:total_cost","field":"total_cost","label":"Total Cost","type":"string","input":"text","variable":"fuel_total_cost"},{"id":"Fuel:month_cost","field":"month_cost","label":"Month Cost","type":"string","input":"text","variable":"fuel_month_cost"},{"id":"Fuel:user","field":"user","label":"User","type":"string","input":"text","variable":"fuel_user"},{"id":"Fuel:group","field":"group","label":"Group","type":"string","input":"text","variable":"fuel_group"},{"id":"Fuel:created_by","field":"created_by","label":"Created by","type":"string","input":"text","variable":"fuel_created_by"},{"id":"Fuel:modified_by","field":"modified_by","label":"Modified by","type":"string","input":"text","variable":"fuel_modified_by"},{"id":"Fuel:createdtime","field":"createdtime","label":"Created time","type":"datetime","input":"text","variable":"fuel_createdtime"},{"id":"Fuel:modifiedtime","field":"modifiedtime","label":"Modified time","type":"datetime","input":"text","variable":"fuel_modifiedtime"}]
Manage custom links
Manage
Variables
$today - Current day
$year - Current year
$month_short - Current month short
$month - Current month
$weekday - Current weekday
{"JS_YES":"Yes","JS_NO":"No","JS_TODAY":"Today","JS_YESTERDAY":"Yesterday","JS_JAN":"January","JS_FEB":"February","JS_MAR":"March","JS_APR":"April","JS_MAY":"May","JS_JUN":"June","JS_JUL":"July","JS_AUG":"August","JS_SEP":"September","JS_OKT":"October","JS_NOV":"November","JS_DEC":"December","JS_YEAR_AGO":"Year ago","JS_YEARS_AGO":"Years ago","JS_DELETE_CONFIRM":"Do you want to delete record ?","JS_MAX_LENGTH":"Max length","JS_SELECT_OPTION":"Select an option","JS_YEAR":"Year","JS_TYPE":"Type","JS_MINUTES":"Minutes","JS_EMPTY_EMAIL":"Empty email address.","JS_DATA_LOADED":"Data loaded","JS_RECORD_RATED":"Rated","JS_REMINDER_COMPLETED":"Reminder Completed","JS_REMINDER_COMPLETE_QUESTION":"Do you really want to complete your reminder?","Stars":"Stars","Rating":"Rating","Persons":"Persons","Nights":"Nights","Departure":"Departure","JS_RANDOM_VALUE_WINNER":"Draw result","JS_COPY_TO_CLIPBOARD_SUCCESS":"Copied to clipboard","JS_TIMER_FINISHED":"Timer finished","JS_IMPORT_INVALID_JSON":"Invalid JSON","JS_API_LIMIT_REACHED":"The API limit or tokens are used up. Check the API key credit\/quota and try again later.","JS_API_LOAD_FAILED":"API loading failed. Please try again later.","JS_CREATE_DASHBOARD":"It's required to create Dashboard before Widget","JS_CALENDAR_ALL_DAY":"All day","JS_CALENDAR_ADD_EVENT":"Add event","JS_CALENDAR_DAY":"Day","JS_CALENDAR_DAY_0":"Sunday","JS_CALENDAR_DAY_1":"Monday","JS_CALENDAR_DAY_2":"Tuesday","JS_CALENDAR_DAY_3":"Wednesday","JS_CALENDAR_DAY_4":"Thursday","JS_CALENDAR_DAY_5":"Friday","JS_CALENDAR_DAY_6":"Saturday","JS_CALENDAR_DAY_SHORT_0":"Sun","JS_CALENDAR_DAY_SHORT_1":"Mon","JS_CALENDAR_DAY_SHORT_2":"Tue","JS_CALENDAR_DAY_SHORT_3":"Wed","JS_CALENDAR_DAY_SHORT_4":"Thu","JS_CALENDAR_DAY_SHORT_5":"Fri","JS_CALENDAR_DAY_SHORT_6":"Sat","JS_CALENDAR_LIST":"List","JS_CALENDAR_MONTH":"Month","JS_CALENDAR_MORE":"more","JS_CALENDAR_NO_EVENTS":"No events","JS_CALENDAR_TODAY":"Today","JS_CALENDAR_WEEK":"Week","JS_CALENDAR_WEEK_SHORT":"Wk","JS_SUCCESS_UPDATE_SCORE":"Successfully updated score","JS_WHEEL_OPTION":"Option","JS_WHEEL_SPINNING":"The wheel is spinning...","JS_WHEEL_SELECTED_VALUE":"Selected value","JS_WHEEL_VALUES_REFRESHED":"Values refreshed. You can spin."}