Undo 'Action-> Change the current user & the current date/time'

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
  • (Edited)
I have in one of my forms a dynamic rule that 'timestamps' a date and user field when a checkbox field  is flagged.
Works nice :-)

It might sound unlogical but in my situation I would like to undo these timestamps (empty them) when a certain condition is met.
- In a perfect world the emtpy trigger should be when another person is selected from a drop downbox
- as an alternative I already whould be happy when the fields are emtied when we unflag the checkbox field again. (like toggling between two statuses)
I cannot find a way in dynamic form to empty a field based on a change in another field.
Any workarounds or options I simply missed??



(for whom is interrested:
This has to deal with that projects in preparation bounce for certain preparing actions between contacts that provide certain information for a project before it is eventually assigned to a PM.
This bouncing can happen a variable amount of times in any random direction- it's like controlling an Q&A process and trace where the action needs to go and who the current owner of te action='project-in-startup-phase'  is).

Thanks!
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Not sure how to do this natively but it may be possible. I would solve this with custom code. For example 
If(_fid_1.value == false){_fid_2.value = ' ' }
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Jan,
Why can't you have a form rule to change some fields to blank?
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
There seems no condition 'when <field> change'
the only conditions are like equal, not equal, less, after, etc.

When I create dynamic rule on the same checkbox field and timestamps fields
I could say 'When <field> in not equal to [checked]

However in the actions there is no possibilty to:
'action change <user field> [blank]'
You are forced to select a user
  But I agree for a date  this could work, I will test that scenario later (tonight)
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
There is a form rule that triggers "when the record is saved".  Then you get to change fields based on fields changing.  Look for that a a choice in the form rule setup for the "When" box
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
smile smile smile.

I woull have been surprised if you wouldn't be able to surprise me this time.
This indeed seems to open the door to what I'm looking for .

Thanks again!
 
Photo of Jan-Willem

Jan-Willem

  • 490 Points 250 badge 2x thumb
Thanks for your suggestion Chuck,
Immediatly a stupid -newbie- question back on your end:
Where to put that code as the fields are normal date and user fields?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,166 Points 50k badge 2x thumb
Jan, we should look at native solutions first. Form Rules or else Actions.