Unable to select time field in table connected to dataset

Ask the community
,
1

Hi,

I would like to display time in a table from a time field, but after I connected the table with the dataset I am only able to select text fields to display data. It is not possible to select the time fields. any idea?

I would appreciate your feedback a lot, looking for this now for hours…

Thanks
LKR

2

Here is an example of a Connect Table panel. As you can see, I am able to connect the Date column with the appropriate collection field from the dataset.

294×581 23.8 KB

3

Hi Yisrael,
thanks a lot for your reply. I am able to add a „text“ column, but when the collection filed is „time“ I am unable to select it…
thanks
LKR

4

Please post the editor URL of your site. Only authorized Wix personnel can get access to your site in the editor. Please include the name of the page involved.

5

Was this issue ever resolved? I am experiencing the same problem. I have a Time field, but it is disabled in the Connect Text panel.

3024×4032 682 KB

6

https://www.wix.com/corvid/forum/community-discussion/displaying-time-from-database

7

I managed it like so by Code

Time = 12:00 (from DataBase field Time)

function FormatTime (time) {
let format = time.split( “:” ).slice( 0 , 2 );
return format.join( “h” );
}

=> 12h00

8

https://www.wix.com/corvid/forum/community-discussion/issue-how-to-display-a-time-value