Skip to main content

I've created a formula within the Title control/field that pulls through details from another field along with the current date and time.


However, as the other field isn't populated on form load the detail is not added.  How do I get it to re-calculate and add this detail to the Title field?


This is what i've added to the default value of the Title control:







When i preview the form, it just displays the Current Date and Time, but doesn't change when the Project Name field is populated.

You could maybe try a workflow to update the Title field with Project name, current time & date when new items are created.


@DonnaArtis try below steps:


 


  • I'm not sure if you're using Item Property or Named Control

  • If you're using Item Property then it will work only after you submit the form

  • Instead follow below steps:
    • Assuming your Project Name control is a single line, open the control settings and in the name put slt_Project_Name (this helps me in distinguishing with item property and named control)

    • In calculated control use slt_Project_Name+" - "+Current Date Current Time

    • Instead of straight formula, I'll use the formula to check if Project Name is null or not, if it's null then will set calculated control to display nothing. This way you won't see #Value thing.

    • Make sure your formula gets calculated in all 3 views


 


Note: Anything you type in calculated control formula has to be put in " " and plus sign


Thanks @kunalpatel , the previous comment about creating a workflow has worked perfectly.  But for your reference, the Project Name that was used was an Item property, as I wasn't able to select Named Control, even after submitting the form, the field didn't populate with this information.


I needed to have the "Title" field populated, so couldn't use a calculated value control.


 


@DonnaArtis...Your title field is a single line text control, correct? If that's true then when you open the control setting, is the "Name" field empty? If it's not then whatever name it shows, it should be listed under Named Control. I use all the time and it works for me.


Reply