Value Form Puns

This represents a change in shares of 423.63 percent and a change in value of 190.46 percent during the quarter. Wow!

This represents a change in shares of 427.22 percent and a change in value of 192.57 percent during the quarter.

Goldman Sachs Group Inc currently hold PUT options as well, representing 640,000 of underlying shares valued at $4,730,000 USD as of 2021-09-30.

I’ve been struggling to figure out this problem with trying to pass data values from fields inside a Form object, to fields outside. To be honest, I’m not 100% sure if this is even the right problem, but the best I’ve done to pinpoint the problem has led me to that conclusion.

So, I have a Canvas App, with a form using a SharePoint List as a Data Source. I wanted to add the functionality that, depending on what’s chosen for a dropdown box, other fields in the form will be hidden, visible, etc. No problem with that. However, I then tried to Copy this functionality to a field outside the Form object, that’s still looking at the same dropdown inside the Form, and the function didn’t work. Trying to look at what the function is returning in the preview bar, the dropdown inside the form was always returning “Blank,” no matter what was selected. After trying several iterations back and forth, the best I can tell is that functions staying “inside” the Form object can read the data values no problem, but once an unrelated field is trying to read a value from the Form, it returns blank? I even tried having the dropdown onChange set a variable, but that didn’t work, it just stayed Blank. I have no clue why that didn’t work, but I don’t know what else to try at this point.

I don’t know if there’s some syntax problem I’m running into (there’s no error messages in that case), a problem with the data source, or if this is just how fields inside a Form work… trying to Google search “PowerApps Form” is no help at all trying to find answers about specifically the Form objects…

I am trying to complete an aggregate query that will return the record text of a particular field IF all the records in the query have the same text - I would appreciate suggestions.

The database has tables for various activities. Each activity can have anywhere from 1 to several sub-activities, data for each sub-activity is stored in a separate table with the overall activity ID as a one to many foreign key. I want to build a query that tabulates the data for all an activity's parts.

Building most of the query is simple such as when the component field is numerical (duration, cost, or billing) but for a couple records the field is a foreign key representing a text entry is a separate table (e.g. tool used, work group, or tracking device). Ideally I would like the query to return the text represented by the foreign key only if all components of the overall activity had that same foreign key (e.g. return "torque wrench" if each tool field had that entry) BUT if any one of the activity sub-parts is different from any other, I would like to return "VARIES".

Any suggestions?

Thanks

Most value investors considerably factor growth into their determinations of intrinsic value (in DCF models or in other ways) so what is really the difference? It’s true that a value investor may find companies that they don’t expect to grow at all but still deem undervalued. Would a GARP investor just rule those out entirely? Otherwise it sort of seems like all modern value investing is GARP investing. When I say modern I’m distinguishing it from a more net-net/Benjamin Graham /cigar butt /whatever you want to call it type approach which is something else.

This represents a change in shares of 57.51 percent and a change in value of -12.61 percent during the quarter.

So, like Baillie Gifford & Co and Swiss National Bank, BlackRock Inc also did NOT sell when they were down 12.61% as of 2021-09-30. Instead of taking a loss, they bought 57.51 percent more shares - just like most retail investors on r/clov do.

The way I see it – these Institutional investors are better than a Short.

They could also be ADDING more shares between Oct1 and Dec 31, 2021; they have until 2022-02-14 to file another Form 13F to notify their position as of 2021-12-31.

I work in sales and have multiple products I can sell to the customer, each product having it's own commission rates. Unfortunately the company doesn't provide us with any software to keep tabs on monies owed and so I'm trying to create a Google Form which I can fill out after each sale which then populates a spreadsheet.

So far I have created a sheet with 12 pages, one for each month, and they are organised based on the month of install (or the month we are owed that commission). This all happens automatically.

I'm wondering if I can assign a number to each answer given in the form so that when it gets to Sheets I can calculate what is owed? eg - if a customer has bought Product A then it tells Sheets that the salesperson is owed £x

The closest I've come to finding an answer is with a Vlookup table which I made a start on but not really sure how to actually implement it.

So I developed a page that has a form and within this form there are multiple pickers so when you select one it navigate to a list of items to choose from , I want one of the pickers when clicked to view items in grid view rather than a list I tried Lazyvgrid even implementing my Grid view but it shows them in grid but as one Item !!!! what can I do guys ?

This is available near me secondhand and the person selling it doesn't seem to know how big it is. I don't think the pics are accurately demonstrating how much this can expand, but I have also never used one of these before either.

Looking at the third pic, I'm reading this as expanded to 100cm and 43 inches. Not sure if that is correct though.

They're selling it for $70.

What do you think? Worth it? Also, have they expanded it all the way?

https://preview.redd.it/jfg6r7ppad581.jpg?width=720&format=pjpg&auto=webp&s=3a9a2a0aa65d5c543b9700c5e4b12bf85372a3d1

https://preview.redd.it/yg280cppad581.jpg?width=720&format=pjpg&auto=webp&s=63296acc1b12904b565a24e14fe8600558b9c869

https://preview.redd.it/0lnljgppad581.jpg?width=1536&format=pjpg&auto=webp&s=31c6f122c32985da29bdaa01bb2e989daae516e6

https://preview.redd.it/792u6oppad581.jpg?width=1536&format=pjpg&auto=webp&s=0094df7a46f41e4d9f0f02004de7bb9e07b04dd7

https://preview.redd.it/7qqzbrppad581.jpg?width=1536&format=pjpg&auto=webp&s=5a7def51db9de717701bf43504eaf0c769a54c6f

https://preview.redd.it/wgde2ippad581.jpg?width=1536&format=pjpg&auto=webp&s=7ed2d4a5e1b382c53c664015e71219733a6f61de

https://preview.redd.it/dq1dpbppad581.jpg?width=1536&format=pjpg&auto=webp&s=6be2abbcbb9b0cc129d5830bc542bc3bfa7a434a

I'm fetching a cart from my API and it has a number of line items in it. Each line item has a quantity and an options array, which is empty.

I want to create a couple of text fields for each quantity in each line item, so, for example, if there is a single line item with a quantity of three, I want to display three text fields labelled 'name' and three text fields labelled 'email'. That's easy enough:

{#each Array(lineItem.qty) as _, i}
<label>Name <input type="text" /></label>
<label>Email <input type="text" /></label>
{/each}

I then want to save these details to the options array for the line item. That can be done like so:

<label>Name <input type="text" bind:value="{lineItem.options['name'+i]}" /></label>
<label>Email <input type="text" bind:value="{lineItem.options['email'+i]}" /></label>

It works, but it looks really messy in the backend, looking like:

name1 | James
email1 | james@james.com 
name2 | Grant 
email2 | grant@grant.com 
name3 | Sarah 
email3 | sarah@sarah.com

What I really want is to save the options array as an array of objects like so:

{'name': 'James, 'email': 'james@james.com'},
{'name': 'Grant, 'email': 'grant@grant.com'},
{'name': 'Sarah, 'email': 'sarah@sarah.com'}

But I can't figure out a way to do that because you can't bind a value to part of an object if the object doesn't exist in the first place. For example, this doesn't work because the options array is initially empty (Cannot read properties of undefined (reading 'name')):

<label>Name <input type="text" bind:value="{lineItem.options[i]['name']}" /></label>

I could pre-process the cart after fetching it so the options array contains pre-created empty options, but that adds other problems. Can anyone suggest anything?

UPDATE: I've taken u/slantyyz's approach and used a component for this. It works quite nicely. Will add to the REPL if anyone is interested. Repl: https://svelte.dev/repl/6b268861ef35476cae73d83498403f48?version=3.44.2

I know quite a few retail investors have higher positions in $CLOV, but it is still a positive move by an institution. As they say, every little bit helps.

Capitalism and the class system are the ultimate forms of a deeper entrenched and much more ancient evil- the value form. Whenever we buy or sell something we suffer it’s curse. We need to establish systems that operate entirely without money. Look up mutual aid organizations in your area.

Hello everyone,

It's quite simple to hide a column, adding a condition for a particular field that has a finite value via:

SharePoint Edit Columns> Edit Columns in the form>? Edit conditional formula

if([$ColumnField] =='Complete', 'true, 'false' )

But supposedly, one can also use the NOT statement to make it so that if the aforementioned field is NOT 'Complete' ? However, I can't get that to work.

I get a 'Enter a valid condition'

Also according to Microsoft one may also check against a value:

The following formula checks if the lookup column [$City]

has a value equal to Toronto. To do so, it splits the lookup value result by the separator and checks against the value.

=if(substring([$City],indexOf([$City],';#')+2,1000) == 'Toronto', 'true', 'false')

That also doesn't seem to work.

Can any of these advanced conditional formulas work editing columns( hiding fields ) on a SP List Form?

Thank you,

Ted

This represents a change in shares of -6.27 percent and a change in value of -47.98 percent during the quarter.

Slightly down 6.27% - nothing to worry about. Main thing is that they still own 205,081 shares of Clover Health despite the value went down from $2,914,000 to $1,516,000 USD as of 2021-09-30.

This represents a change in shares of 30.36 percent and a change in value of -27.72 percent during the quarter.