Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

ReluctantProgrammer
Community profile ReluctantProgrammer Level 2
Job title here
Location here
10 BADGES
Level 2

Level 2

Learn more
Joined the community 02-02-2021 6:11:05 AM
Offline
Top badges earned by ReluctantProgrammer
Customize the badges you want to showcase on your profile
Re: Cannot assign True
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
Exactly! 😉 This is what I needed. It's working great! Thank you so much!!!

Views

33

Likes

2

Replies

0
Re: Cannot assign True
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
Thank you Kosta. Being a novice I'm not sure where the "true" is defined in my formula.... if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10)

Views

37

Like

1

Replies

2
Re: Cannot assign True
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
My apologies.  I totally overlooked it. This is the same issue.

Views

45

Like

1

Replies

0
Cannot assign True
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
I am using Math.floor in the Exit action of a field ((headwaterExistingMain10 is the field name) and this is the formula in Calculate action: if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10) and though the calculations work I'm getting this error message "illegal value: cannot assign 'True' to xfa[0].form[0].form1[0].page1[0].table1[0].row5[0].headwaterExistingMain10[0].#valu...

Views

60

Likes

0

Replies

7
Null not working
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
This formula worked but I'm trying to leave the field (headwaterExistingMain10) blank unless there is an amount in one of the fields in the formula using this.. if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10) ....When I Preview the form I get this error..."Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0.headwaterExistingMain10[0].#...

Views

52

Likes

0

Replies

1
Re: How do you calculate formatted values
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager
This formula worked but taking it one step further, I'm trying to leave the field (headwaterExistingMain10) blank unless there is an amount in one of the fields in the formula using this.. if (headFtExistingMain10.rawValue==null)this.rawValue==nullelse this.rawValue = (Math.round(hweFtMain10.rawValue*10)/10)+(Math.round(headFtExistingMain10.rawValue*10)/10) ....When I Preview the form I get this error..."Illegal value: cannot assign 'True' to xfa[0].form[0].form1[0]0.page1[0].table1[0].row5[0]0....

Views

34

Like

1

Replies

1
Re: How do you calculate formatted values
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager
Awesome!  I was soooo close.  Thanks so much!! 

Views

44

Like

1

Replies

0
How do you calculate formatted values
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager
I'm trying to calculate the total of 2 fields which have been formatted using math.floor; I want to calculate the formatted amount of these 2 fields, NOT the rawValue. How can I do this? example: Field 1 rawValue = 700.44 Field 1 formatted value = 700.4Field 2 rawValue = .42 Field 2 formatted value = .4Total rawValue = 700.86 (rounded 700.9) Total formatted value = 700.8 ; this is what I need to do

Views

63

Likes

0

Replies

4
Paper Forms Barcode - unsupported node
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
I'm trying to add form field to the barcode but in the list of fields in the barcode setup the field itself is grayed out as an unsupported node. Is there any way around this "unsupported" issue?

Views

88

Likes

0

Replies

1
Betreff: Recreate Excel formula to locate smallest number...
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
That's what I needed. Thanks!!

Views

74

Likes

0

Replies

0
Recreate Excel formula to locate smallest number in a table
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
Looking for code to re-create this Excel formula which identifies the lowest number in a table column and places it in a different field. ="Single Unit:" &CHAR(10)& IF(COUNT(AB17:AB23)>0,TEXT(ROUNDDOWN(MIN(AB17:AB23),0),"0") & " tons",IF(COUNT(AB24:AB27)>0,TEXT(ROUNDDOWN(MAX(Z17:Z23),0),"0") & " tons",IF(AND(ISNUMBER(G28),ISNUMBER(G29),ISNUMBER(G30),ISNUMBER(G31),MIN(G28:G31)<1),"LL","n/a")))

Views

123

Likes

0

Replies

3
Betreff: Setting pattern in a script
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
Perfect! Thank you so much!!

Views

82

Likes

0

Replies

0
Setting pattern in a script
Avatar
Boost 5
Level 2
ReluctantProgrammer
Level 2

Likes

6 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Give Back 5
Ignite 5
Boost 1
View profile
ReluctantProgrammer
- Adobe Experience Manager Forms
Along with rounding up I'm trying to set a the pattern of a field in a form based on the number entered. I.E. if the field is <10 then use 1 decimal; if 10 or greater use 0 decimals. So basically, if 0.47 is entered it will round to 0.5. Likewise if 2.84, it would round to 2.8. But if 10.85 is entered it would round to 11 and 25.83 would round to 26 because both are greater than 10. Can this be done?

Views

125

Likes

0

Replies

3
Likes from