Missing field types

[fredericalpers]

Regarding Issue 557.

"Some fields are not displayed in the correct format "default value" feature for that field type. The reason is that the "field type" API result responses of these fields are not covered in the source code. These are the fields whose type is not covered in the code. Please check the file listed by name and type as follows.."

Current state

The following field keys & types are missing as mentioed in the issue above:

• bisdatum ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:date
• balkon ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:tinyint
• benutzer ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:User
• Kundenlogo ➤ blob
• placeholderEnergy ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:BlackHint

Desired state

The following field keys & types should be added to the code:

• bisdatum ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:date
• balkon ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:tinyint
• benutzer ➤ urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:User (the frontend has to be a single select not a input field)

The field keys & types do not have to be added:

• Kundenlogo since it is not possible to transfer/send images to onOffice enterprise with the API.
• placeholderEnergy --> urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:BlackHint

[yeneastgate]

@fredericalpers

1. For "urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:date" type fields:

• We must submit "value for these fields" as "DateTime" format to create the correct data in Enterprise.
  example: "yy/mm/dd", "yy-mm-dd" or "yy.mm.dd"
• In the master branch, these fields display in both the front-end and back-end as image below:
  
  => Would you like to keep this format or use a "Datepicker" format as shown in the image below?
  

2. For "urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:tinyint" type fields:

• We must submit "value for these fields" as "boolean" format
  example: "0" corresponds to "No" or "1" corresponds to "Yes"

cmt.missing.field.mp4

• In the master branch, these fields display in the front-end and back-end as image below
  

=> Would you like to display them in a "BOOLEAN" format as shown in the image?

[fredericalpers]

@yeneastgate I will be able to give you feedback on this tomorrow, thank you :)

[fredericalpers]

@yeneastgate As for no.1 please implement the suggested date picker. Make sure it has a good usability on mobile devices and it works in all browsers. E.g. Chrome, Firefox, Safari etc.

As for no.2 is it possible to use radio buttons instead of a select? This way we can show both possible values and its easier to change for customers.

[yeneastgate]

@fredericalpers I will try implementing it and will update the results for you ASAP.

[yeneastgate]

As for no.1 please implement the suggested date picker. Make sure it has a good usability on mobile devices and it works in all browsers. E.g. Chrome, Firefox, Safari etc.

@fredericalpers The "date picker" feature has been already implemented in the Estate List. I tested and it works fine.
Mobile devices:
iPhone 13 (1170 x 2532)
iPhone 7 (750 x 1334)
iPhone 6 (750 x 1334)
iPhone XR (414x 896)
Ipad Gen 7 (2160 x 1620)
Realme 11 Pro (1080 x 2412)

iPhone6_IOS_Safari_Version_12.5.7.mov

iPhone13.mov

Browsers:
Chrome: version 117, 107
Edge: version 117, 107
Opera: version 102, 98
Safari: 16.5.1

Recording.79.mp4

edge_version117.mp4

Do you want me to test it on any other specific browsers or mobile versions?

[yeneastgate]

@fredericalpers

1. If there's no need for further testing, I will implement the 'date picker' feature similar to the one in the Estate List
2. .This is the list of fields that will be implemented.

=> It will take 6 days to implement and test it. Thanks!

[fredericalpers]

@yeneastgate please go ahead and implement the date picker and the missing field list, thank you :)

[yeneastgate]

@yeneastgate please go ahead and implement the date picker and the missing field list, thank you :)

OK. I will implement it.

[yeneastgate]

@fredericalpers I checked and found that:
To change from "input text" to "date picker" and type "tinyInt" to "radio button".


=> Can I edit the "fields.php" file?

[fredericalpers]

@yeneastgate please go ahead :)

[yeneastgate]

@fredericalpers
Currently, in the form, I see fields with the "Date" or "DateTime" type Which display as "text field"

=> Please confirm:
Do you need to change those types "text field" to "Date picker"?

[yeneastgate]

@fredericalpers
I have added types for the missing fields:

• urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:date ("input text" => "date picker")
• urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:tinyint ("input text" => "radio button")
• urn:onoffice-de-ns:smart:2.5:dbAccess:dataType:User ("input text" => "single select")

Please watch my video demo and let me know your opinion. Thanks!
https://files.fm/u/u7puprntxt