Best Of
Re: Restricting Access to card based on Criteria
@Logan_Jolly That sounds like a good time to implement PDP's. For the PDP's you would need to set up a trusted attribute (email, employee id) that you use in the data to identify their data in the table rows. You would then add users who need to see everything to the All Data PDP, and then set up a PDP using that trusted attribute and add the field members or an everyone group to that PDP. Then each field member would only be able to see the data that is tied to them, and anyone in the all data PDP could see everything.
Re: Restricting Access to card based on Criteria
@Logan_Jolly Depending on what the restriction is you want to apply and your data, you could look into PDP's. This would be applied to the dataset, so as long as the PDP would be fine across any card on this dataset, then you could set up a PDP so the user can only see a certain department or type of product or any other condition.
Re: How do I convert a 12 Hour Time into a 24 Hour time
@Devin_Garrison As a side note, if you just need those timestamps to show up in a card in 24 hour format, it actually displays them that way without needing to do anything. I tried it out with a couple of timestamp columns in my data and it displayed everything in 24 hour format. It seems that when you look at them at the dataset level, Domo displays them in 12 hour format.
Re: How do I convert a 12 Hour Time into a 24 Hour time
DATE_FORMAT function if your friend in this case. You can format the date as a specific string format.
You can find more information on the codes used here: https://www.w3schools.com/sql/func_mysql_date_format.asp
DATE_FORMAT(`Date`, '%Y-%m-%d %H:%i:%s')
Re: PDP shield
You can't remove the filter or PDP icons but you can change the justification within Analyzer. For your column select it then go to Format - Justification and set it there.
Re: Grant to Share Cards and Page, but not Edit
In general, it would be helpful to separate the actions of 'edit', 'create' and 'delete' into separate grants (across cards, pages and datasets).
