You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to update the format of a lookup table query result set?

asked one day ago

Basically what it says in the title. For example, if I'm populating a dropdown list with dates from a lookup table, it will currently show the full date and time, but in some cases I would just like the date and not the time. Currently the Cloud LFForm object does not allow me to modify the values of a dropdown with code so I can't do anything that way. If there was a way to change the format that gets sent from the lookup rule, that would be great, but I don't currently see a way to do that either. I'm sure there's likely other use cases besides dates, but that's currently my biggest obstacle in this regard.

If anyone has any ideas or workarounds, I'd love to know!

0 0

Replies

replied one day ago

Lookup rules don't have any formatting, you should store the exact format you want to use on the form. In your case you may need two columns one with the full date time and the other with just the date.

0 0
replied one day ago

What, if any, date format should be used in the csv when uploading to create the lookup table that Cloud will detect as only Date not DateTime? 

1 0
replied 18 hours ago

There is no date datatype , lookup tables only support datetime. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.