Aaron_Trent Member

It has been resolved for us!

A list of functions that work in the tool would be very helpful.

Unfortunately while it looks like Paste is working, when trying to paste in a high volume of data (25,000 rows) it is not actually being saved to the underlying dataset so refreshing the page causes the data to be lost. Pasting works with smaller data but is still failing to address the initial question.

Edit, see the updated reply for most recent information. Paste is not working for the OP use case. Paste does work. I can copy an entire column but it includes the header and makes the entire column incremented one off. For some columns I can paste to excel and clear the header row, but this may be problematic for data…

I have been able to paste in multiple rows. That may work for small data sets, but if there are tens of thousands of rows it becomes unrealistic. I'll submit a suggestion ticket.

It can be useful in a scenario where many people are concurrently editing a sheet. Sometimes a field may get dragged too far and will overwrite something it shouldn't. Including the person who made the edit and the time of change can help business users catch errant changes. If John Doe is editing a field on Susie Q's…

This would be a very useful addition!

I was able to restore functionality by sharing the forms data set with the business users. Documentation claims this is unnecessary, but as of Friday morning I believe this is incorrect.

Please refer to this accepted answer to see the resolution. https://community-forums.domo.com/main/discussion/comment/103145?utm_source=community-share#Comment_103145

I had not, but that fixed it.

Thanks, the details link sent me to the same dead end. I have submitted a support ticket.

When I responded Arbor Rose' response wasn't visible. That suggestion seems like the better option.

You could use DATEDIFF(minute, Created Time, Response Time) This will return the number of minutes between Creation and Response. If you want to exclude non-working hours you might need to use a master calendar with a field like date start time and date end time with work start and end time for every day and use the sum of…

We are happy with the speed gains for a first pass. I'm also testing out the idea of only processing the multi-item entries in Magic and the single entries in Views. I'm currently fighting with Window functions in Views. Single entries make up about half of all user inputs. I am comfortable in both R and Py but this…

I checked and the max number of selections so far has been 80. I did add a pre-processing step in the morning that handles all old entries. This allows my main ETL to only need to import form entries from today. ETL time has dropped from 40-45 seconds to 18-20. This is better, but still not as performant as using Views.…

T

Hey, I joined the call and am excited for editable tables and linked tables! I'd love to know more about these and what we can do with them. Will multiple users be able to make edits concurrently? Will we be able to limit inputs to a specific data type, say date or integer? Will we be able to further limit inputs through a…

The users sees a table with appx. 25,000 unique items, where Item is the key. The most recent non null value for Vendor, Status is joined to that table for each Item.

Thanks, I am going to submit this as an idea.

@ggenovese I am accepting this answer. It's a bit clunky compared to the filter cards but this seems like a Domo limitation.