Jump to content

Shiro

Members
  • Content Count

    8
  • Joined

  • Last visited

About Shiro

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Is there someway I can design a trigger so when I Import a records to my table, it will only import those records which have an actual value. When I try to update some records on my table via import, it overwrites everything even though some of the records imported are blank. I made a trigger that shall only update records which are not null via condition statement but it seems not working.
  2. Thanks @NiceDuck, the passing parameter worked. Im not using the JS for this since I am also not adept on it. If it aint much, may I also ask if there is a possible way I can count the number of times the record is been downloaded? That would also be helpful
  3. Thank you @NiceDuck, However, when I redirect my user to the duplicate search and report datapages, they have to search again for the data they want. Is it possible to automatically set the search of it to be automatically same as before the user click the first download?
  4. Hello Is there a way where I can make my users submit my email first before they can download files or reports from my datapages? ThankYou.
  5. Hi NiceDuck, It's seems like a nice Workflow. However, as I see it, you are also using the work order table as the lookup table for this workflow. Also, those new work orders which is actually a clone of an old record will also be considered as a new record. Therefore, in the Long run, I think this will cause a stress on your data traffic specially when the Work_order table becomes heavily populated. You may not notice that now, but when your records starts to reach hundreds or thousands, The dropdown button that you assigned to look for previous may cause a huge data spike. .... hope that helps
  6. Hi NiceDuck, I just want to ask, are you sure that it is the trigger is the one that is detecting which user made the actions? I think it was the data-page which is able to detect the current user via user authentication. In regards to the delete function. It will just remove the selected record so it even though you have a field which captures the user id of the user, it wont update your records. I think on Delete triggers will only capture the deleted records,
  7. That workflow looks "Nice"Duck hahaha however, I'm only on explore plan so triggers are not available to me. Thank you though
  8. Hey MayMusic, Hey NiceDuck Your workflows are terrific. Thank you so much. I modified your workflow a little to also record the log out date/time of the user . first, I added another text field 255 in my table. This will be our indicator if the user logged in or logged out on that certain time. Then, I made another auto submission form similar to what MayMusic describes, the only difference is the new text field 255 which has an auto value of 'Log out'. Note that you have to add this field to the auto submission form you are using for your log-in and make its auto value a 'Log in'. Then we make it redirect to the logout link. Its going to make a lot of redirection though, specially if your authentication has an auto redirection somewhere too. Thank you again.
×
×
  • Create New...