Is it possible to loop over a list e.g. SPLIT(โemail1, email2, email3โ, โ,โ) and for each email create a row in a table?
Yes, there is a SPLIT() function that can do this.
help.appsheet.com - SPLIT() SPLIT() help.appsheet.com
Well I know there is a split function, the question is can I loop over it somehow?
Not directly but you should be able to do that with the Webhook / Appsheet API.
The part that is a problem is โcreate a rowโ. We donโt yet have an action to create a row in another table. Once we do, it will become easier to support this kind of composite action.
Some kind of iteration is essentially required.
There are scenarios:
While() or Loop() function will definitely help
Is there any alternative available? Any concrete example?
Check out this postโฆ
Hi Steve
I am trying to develop an app for EHR (Electronic Health Records). But I get stuck due to these type of limitations. Just imagine if I have to repeat this implementation many times, how much effort will get involved. Appsheet needs to come forward and address its limitations
Hi Praveen
Without this missing feature, I have to use FileMaker Pro to develop my app for Electronic Health Records. For sure, Appsheet has best architecture for mobile apps development. But it still lacks some essential features.
Hi Praveen
Please take lead to take initiative. Do not miss this opportunity for making
Appsheet a true leader in mobile app development
Yes, this is indeed missing. I ended using zapier-code, it gets very complicated to do it in appsheet. I almost managed to simulate a loop with Action and Workflow, but the workflow does not response to a second event on a table in the same round.
Hi @Riazsg, I would first like to understand why you need to โiterateโ over a list of records. That is fundamentally a programming construct and AppSheet is fundamentally trying to be a no-code (i.e. no programming environment). So you wonโt see us provide loops and iterators. On the other hand, we try to provide mechanisms to specify end-states or results.
For example, a SELECT() function allows you to select records in a table that match a filter condition. It is logically a query rather than an iterator.
If you could describe your use case further, I can try to steer you in the best direction. Thanks
Hi Praveen
Thanks for your interest. Appsheet is a no-code platform with sugar-coated low-code.
My background is health informatics. I am planning for different apps.
I want to create an app for potential patients with clinics data viewed as Onboarding. Instead of clicking back and next or moving across manually, I want it to happen automatically with ability to configure time interval and pause and stop the flow.
Depending upon my need or some business rule, I want to be able to select only records of specific clinics to be displayed. I understand, currently Select function / expression works only on a single table
Workflow 1: Create New Clinics
Login into Appsheet app
Select a template to create new clinics
Specify type and number of clinics
Create required number of clinics with pre-filled data
Verify created clinics
N.B Inability to add required number of records negates the purpose of automation.
Currently, appsheet allows to add only 1 row based upon a row
Workflow 2: Search and View Clinics
Login into Appsheet app
Specify a search to find only a specific category of clinics
Goto result view
View results as Onboarding view
Workflow 3: Preview a report before generating it
I think appsheet needs need to enhance the view capabilities of Onboarding widget and add add more to do steps
I will really appreciate if you help me in some way
Regards, Riaz
Not possible with AppSheet.
A SELECT() expression can only return results from a single table, but can use data from any table.
Look here.
Not possible.
Hi Praveen,
I have replied to your message and have provided a sample for
the type of work I am trying to achieve. I will appreciate your help
to achieve my goal
I wonder how soon some response or some communication will start
in this direction
@Riazsg, of the workflows listed, I think it is workflow1 that we tend not to focus on. This pre-population of data is usually an โinvoked occasionallyโ backend/scripting task rather than an โinvoked dailyโ user-facing app task. Our customers tend to solve for this by just accepting the user input (type and number of clinics) and then have some backend logic populate the data. As @Steve points out, you could do this this with a workflow rule that populates N rows, but this is not a sweet spot for AppSheet.
For the search & view scenario, why do you want to use an Onboarding view? Why not use the Details view which is intended for this purpose?
For previewing a report, you can save a report as a file. So that is definitely an option. @Steve donโt you think this addresses the need?
Iโd think so, myself, but I keyed on โbefore generating itโ.
@Riazsg, Praveenโs suggestion is that the report can be generated and saved. You can then view the saved report, and chose afterward to distribute it. Itโs not whatโs commonly expected with the term โpreviewโ, but it is an available workaround.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |