Forum Replies Created
-
AuthorPosts
-
Marcus Khoo
ParticipantHi Alexander
I am trying to fill the new item field with the existing current value of the same field.
(I am using vLookup to make a “copy” of the current item)Best regards
/MarcusMarcus Khoo
ParticipantSuper job Alexander. Many thanks
Marcus Khoo
ParticipantI eventually got round to testing this.
If you create a brand new rule with a Yes/No field and do NOT change the default value from “No” then the rule does not fire.
WORKAROUND
You need to edit the rule change the trigger to “Yes”, Save the form. Open the form back up, go to Rules and change the trigger value back to “No”. Then it works.Found this effect on the “New” form (haven’t tested the others)
Marcus Khoo
ParticipantAlso, in a vLokokup would it be possible to customise the message which current defaults to:
“There are no items matching this query”
I may just like to say “None” or even “”
😀
/MarcusFebruary 1, 2024 at 17:06 in reply to: Can I have an example of calling a jscript function from a rule #37450Marcus Khoo
ParticipantThanks Alexander, but what calls this function? Is it called automatically whenever any field is changed?
ThanksFebruary 1, 2024 at 11:14 in reply to: Can I have an example of calling a jscript function from a rule #37446Marcus Khoo
ParticipantSpoke too soon. Don’t quite get the example.
I want to trigger the update of a specific field when another changes and i want to do the same for twenty fields
i.e.
when A is changed, B is updated
or
when C is changed, D is updated
or
When E is changed, F is updated
or
etc.Thanks
February 1, 2024 at 10:46 in reply to: Can I have an example of calling a jscript function from a rule #37445Marcus Khoo
ParticipantDoh! you have it already in the Examples. Sorry.
Marcus Khoo
ParticipantHi Alexander, yes that may work but I would still need the users to be able to Save – without going to the Edit form.
How about a “Save and Edit” option on Quick Save? That gives me all three options:
1. Stay on New form with QuickSave
2. Go to the Edit form with “Save and Edit”
3. Just “Save and Close”/Marcus
Marcus Khoo
Participant(OOps, I meant “Ver”, DFFS already has a “Version” which it uses to track itself)
Marcus Khoo
ParticipantHi Chrisoph,
I have created my own view (not changed the default one) in this list that has “Title”, “Form” (first instance of the column) and Last Modified date.
This is great if you want to see the last time you updated the form and what form type is being used.
If you are developing your own forms, this is a great way of easily identifiing the form configurations to copy if you do updates
You could also add a “Version” column to keep track of form changes
/MarcusMarcus Khoo
ParticipantWendi,
Also note that this works great for Lookup fields. So
getFieldValue(“your_field_name”);
returns the VALUE in the field not just the ID of the item being looked up.Marcus Khoo
ParticipantWonderful!
Marcus Khoo
ParticipantThanks Alexander
Marcus Khoo
ParticipantMore info:
My “original” item has tweleve columns, eleven of them are Lookup columns (Which do NOT retrieve the “Title” of the source).I am trying to “clone” my twelve column item and I am using the “New” opiton in a vLookup.
I want to create a brand new item and set the default values of nine of the eleven lookups with the same values as the original.
This used to work but now when I use the “New” button, only the first of the eleven lookups gets popualted in the new item and I have to manually select the other ten.
Hope this explains it better.
Best regards
/MarcusMarcus Khoo
ParticipantThanks!
-
AuthorPosts