I want to know when text formula fields are supposed to update themselves and even if they update themselves?
I thought the formulas would run after a submit but it does not seem to be the case. Will I need to invoke this manually through J query or javascript?
any assistance would be helpful.
thanks
Mike.
Hello Mike,
It’s works automatically. no need to invoke until you fill all fields that are used in the formula.
Regards,
Sunny Singla
ssingla1985@gmail.com
Hmm… I have deleted the fields now but I can re-add them. I had two text update fields. Field 1 did a bunch of regex-based on the value of another field we will call Field A . Field A had values like “mopping (mop), sweeping (sweep)” It was a checkbox and it contained the values of the items I checked for that record.
Field 1 would end up with a value of “(mop) (sweep)” by using the Regex to parse out the part of Field A that were between brackets.
then Field 2 took that response from Field 1 and added the values of two additional fields (Field B/C) and made a unique key name field.
So both Field 1 and Field 2 were Text formula fields. and Fields A, B, C were multiple-choice fields. As mentioned Field A was a checkbox with multiple selections possible however Field B and C you could only select one option.
So what I noticed was, when I created a new record the value of Fields 2 would be correct based on the options selected in Fields A,B,C. However, if I updated the record then Field 2 would not update.
Is there something I am missing? is the fact that this has two fields updating or the update of one field is based on the other causing a problem?
Hello Mike,
Yes, I think the same as field 2 is based upon field 1.
Also, try to order properly and check again.
Like If field_2 is depends upon field_1 then field_1 is always placed before field_2.
Regards,
Sunny Singla
ssingla1985@gmail.com
+919855089359
If I can I would like to resurrect this.
I have a quite simple file which records the HISTORY of UNITS a Soldier has served with and the date he started in that service.
It is therefore a one to one file relationship with his PERSONNEL RECORD.
File : History
Field: Unit Name (connected field dropdown from the Units file)
Field: Date (exact date he transferred in)
Text-Formula: Surname-ServiceNo (from connected PERSONNEL RECORD field: FILE-NAME)
Its working fine, creating THE UNIT HISTORY FILE: entries and recording them on the PERSONNEL RECORD using the Unit Name
UNIT HISTORY FILE:
PERSONNEL RECORD
So the issue is the text formula field which shows the Surname-ServiceNo does not automatically update on saving of entries.
It will update if you go back in and hit submit all over again on one of the stored fields but NOT at the time of creation of the record !!!
UNIT HISTORY FILE:
Text Formula not Updated. But by doing a “fake update” of a blank field in this file the text formula’s get updated.
I must be missing something here as to why its not updating at the time of creation ?
Any ideas ???
And while I think of it Knack created an entry for a connected field “Rats Personnel File” but it nevers contains anything in that field. As I did a connection both ways is this the result of establihsing a redundant link between the two ?
Cheers for the assist.
Thought I had fixed with an update record action but not so.
Problem appears to be because the page is called from a grid, internally it knows what PERSONNEL RECORD FILE ENTRY it is working with and updating IT CORRECTLY.
BUT that information is not being stored within the UNIT HISTORY FILE into the connection field which remains empty ?
Note: You can manually type the Service No which is the key to the PERSONNEL RECORD FILE and it will find it progressively as you type in the unique key, but then requires manual intervention but there is no need to as the connection exists for intents and purposes.
It knows what the value is because it is updating the PERSONNEL RECORD.
And, if you update any field within the UNIT HISTORY FILE it will update the text formula field correctly .
So why isn’t it capable of updating this at the same time as the record is created ?
Sorry if its somewhat confused explanation
