You are viewing limited content. For full access, please sign in.

Question

Question

Trying to autofill a field from a variable

asked on March 10, 2022 Show version history

I have two date time fields that can be used. One will populate from time submitted, the other is an overwrite if needed. I am creating a third field that will be the published date/time. I tried a calculation of:

=if(variable2="",variable1,variable2)

Nothing is populating in the "published date/time" field. 

This is all from the same form.

 

In the monitor page, it populates the variable for the published date/time as "invalid date"

0 0

Replies

replied on March 10, 2022

Sounds like you might want to try setting the default date to "instance start date", like so...

0 0
replied on March 15, 2022

I always use <> "" 

I just tried it and it worked for me (in Forms 10.4.5).

=IF(variable2<>"",variable2,variable1)

0 0
replied on March 15, 2022

Thank you for your replies. The issue with this appears to be with using the newer form online as opposed to the classic form. I do not have this problem with the classic form.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.