Hi Team,
I'm trying to create a Analytic app using some tool like List Box and Text Box.
So here I'm not sure how to make sure when the Text Box kept as Blank it should take available data and update the cell.
We are just users - not support team 😊. Now that you've added it back, you need to update the string to be updated at the bottom and just have XXXXX in that field.
I'd approach it like this:
i.e. if the cell is empty, take data from a different column, else use the user input from the textbox
Thank you for the quick reply!
I think was missed to add my workflow snapshot.
I had already updated the replace formula. Request you please take a look to that and help. Thanks!
@Shakil1 Where does "XXXXXX" come from? Is this a value you have assigned if the cell is blank? The screenshot doesn't provide enough context.
The main motive is, if the Text box is empty, it should take the "Status" column (available text from the particular cell).
"XXXXXX" It's a sample text given, so whenever "Text box" is updated so that it can replace it (I'm not sure what formula will work here so I had used this formula)
Could you please help me out with the correct formula to use? So, it should replace the Status column date to blank cell.
Hi @Shakil1 . I built a quick test app for this. When I added the output, I had to add a file browse to the output and then remove in order for it to work. When it runs, I do get the message "There Were No Output Files", but if I click on show output log, It does reference the Output .yxdb file. You can open and see that it is there. Are you receiving a different message? Also, check to make sure there is no default text in the text box configuration.
Thank you for the reply!
I do not have any issues with my output files it's working as needed.
The problem is here, if the Text box tool is empty, it should take the "Status" column (available text from the particular cell) and it's not working as needed. (Please refer the below screenshots.
So, I'm not sure where I'm wrong. Please help me to fix this as soon as possible. I really appreciate what you did. Thanks!
Ah, I see. That is not what you're telling it to do. You should be able to fix with an IF statement.
Thank you so much for the quick reply!
I have updated that formula as shown below, now it's only taking the "XXXXX"
Not taking the text added in the Text Box tool.
Note: 1. If I added the text in Text box tool it should take that added text
2. If Text box tool is empty (not updated with any text) then it should take data from STATUS column. Thanks!
That's only if you run the workflow by itself. You need to run it as an app.
I'm running this with that magic app only. Thanks!
The output only appears in the output file. The screenshot you are sharing is not from the output. Can you open the output and check?
Here is the output file screenshot. Thanks!
What happened to your action tool?
Previously I had removed that as shown by the support team @BS_THE_ANALYST
Now I have added the action toll still it's not working.
Ohh.. Sorry, my bad!
Finally, it's worked.
Thank you so much @jdminton! YOU ROCK!!!
I am grateful for your support!🙂
Ohh... sorry my bad!
Finally, it's worked! YOU ROCK!!
Thank you so much for support. I'm really grateful for your support!.
@Shakil1 well done for getting it sorted. Yes, we're not the support team 😂
