Sinky
-
Posts
25 -
Joined
-
Last visited
Sinky's Achievements
-
Hey, no need to trouble yourself further with this. The solution you offered works perfect. Thank you once again!
-
You're right, that's my mistake. There should be space after 2nd full stop.
-
Sorry I should have been more specific. The imported text is a transcription of speech via speech-to-text app. Because of this, the very first letter is always capitalized but other first letters of sentences are not. The first character after a full stop is never a punctuation character. However, there are carriage returns. Here is an example of text: Woke up early. did twenty push-ups plus 3 minute plank. skipped lunch. gym after work.
-
Thank you for quick reply. I would make it simple. The first letter after the full stop should be capitalized. There is space between the full stop and first letter. I hope this helps.
-
Hi! I have a question about the capitalization of sentences via calculation. I have a text field to which I usually import certain amount of text (cca. 10 sentences) in the form of sentences but without the capitalization of the first letter in a sentence. Is there a way to capitalize the fist letter of each sentence via calculation? Any help is appreciated!
-
Checkbox value via script issue
Sinky replied to Sinky's topic in Script Workspace and Script Triggers
HI! Tnx so much for your answer. After some testing I went with the first solution you proposed. It's not precisely what I was aiming for but it did open some other possibilities which nicely fit into my plan. BTW... (not related to the current issue)....is there a way FM can recognize hidden status of an object or a field that can be used in a script? Something like IF Object 1 is hidden THEN..... Tnx once again! -
Hi! Hope that someone can shed some light on the following issue: I have two checkboxes from the same table. First one is a text field with Auto-enter calculation which says if Checkbox 2 contains certain value, Checkbox 1 should be empty/unchecked: Case ( Checkbox 2= " EXPELLED"; ""). It works fine. However if I decide to override Auto-enter calculation, meaning having both Checkboxes checked and then uncheck Checkbox 2 making it empty, Checkbox 1 gets also unchecked although Checkbox 2 in fact does not contain value "Expelled" defined in the calculation. What am I missing? Any help is appreciated!
-
The filed was on the Form layout. Well, you're right.... I can't recreate the problem but I don't understand how I managed to solve it. 😑
-
For what is worth, I think I found the source of the problem. Table::Years field was not included in the Table view layout.
-
You're right....so, the field contains one value which is chosen via drop-down list attached to the list Tnx for trying!
-
Yes...it's global field. It's called "years" because it's a dropdown list that contains a list of years.
-
Hi FM people! I have one problem which is probably simple to solve but so far solution eluded me. I have a dropdown text field which offers a list of years (Table::Years). This is global field. I have very simple find script: Enter Find Mode [Pause: Off] Set Field [Table::Order Date; Table::Years] Constrain Found Set [ ] Table::Order Date is a date field. Idea is to perform find according to the value chosen from a dropdown list. However, this does not work. I'm getting "provided find criteria not valid". But, if I enter manually one of the years from the list, It works. Same is valid if I write down a year in the script e.g. Set Field [Table::Order Date; 1980]. Set Field [Table::Order Date; Table::Years] itself works when in browse mode, but in find mode, nope This is I guess a format issue, so I tried several combinations changing fields to text or date but without success. Any help is appreciated
-
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Great! Thank you for taking the time to help me and provide some insight. I will look into your instructions and figure the rest out. Respect! -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Charting is one of many aspects of FM with which I don't have much experience. What I'm about to say therefore might not sound reasonable. One reason why I would like to avoid charting by the found set is because I'm trying to build a dashboard with several charts and I would like that these charts are independent from the sort or find changes in a table view. Therefore I opted for delimited data. That being said, your calculation works like magic and provides exactly what I had hoped for. Thank you a million times! 🥳🥳🥳 -
Count list of values from Summary list field
Sinky replied to Sinky's topic in Calculation Engine (Define Fields)
Sure. But I would like to design the charts according to delimited data. So far, the summary list fields and ValueCount ( FilterValues ( MyList ; MyItem ) worked really good. However, now I stumbled on a situation where MyItem is not anymore an item from fixed list of values but an item from the list of values that can be expanded with new values. You probably have a better suggestion. My idea was to look for a way how I can automatically generate a list of sums according to the current state of the value list. Do you think that something like Fast Summaries would be of any use for this?