Field Grouping Layout Element

I really don't know what to say as an observer and user of Ninox. There are many requests that seemingly would be easy to implement given the model of the app, but they are ignored. In one of the few webinars I tuned into Alex mentioned they started using React... does that mean a complete rewrite? Of course there is the relatively new focus on No Code Low Code, but this request would seem to fit in that paradigm.

 

At this point, if you use the html() function for anything other than displaying information it looks like you will need to create a parser to get the information out. Personally, I don't think that's any more difficult than using html if you are going that route, especially if you kept it very sparse. On that note, I wrote a data scraper using Ninox to create a forum database. I scraped the Technical Help section last night which took about 25 minutes per 1000 threads and most of that time was a result of the http calls. Scraping your own html in your database would be instantaneous.

Dean, I'll put something up as soon as I can. I mentioned in the other thread that it won't be seamless and by that I mean the user will have to click a button in the formula field with the html and then click a button on the Ninox form to submit it to the database. Will that still work for you?

Dean, That's the bridge I was never able to find and why I think you'll need to scrape the information. I wanted to finish up my scraping project and then I'll try to create an example database.

At this point I am unable to make it work. This is what I put in a Forumula field...

 

html("
<fieldset>
<legend>Group 1:</legend>
Text1:
<input type='text' name='Text1' value='Testing 1' id='input1'>
<p id='Text1'></p>
Text2:
<input type='text' name='Text2' value='Testing 2' id='input2'>
<p id='Text2'></p>
</fieldset>
<button type='button' onclick='getInputValue();'>Get Value</button>
<script>
function getInputValue(){
var value1 = document.getElementById('input1').value;
var myObj1 = document.getElementById('input1');
myObj1.remove();
document.getElementById('Text1').innerHTML = value1;
var value2 = document.getElementById('input2').value;
var myObj2 = document.getElementById('input2');
myObj2.remove();
document.getElementById('Text2').innerHTML = value2;
}
</script>
")

 

The changes are made in the field with the HTML, but the raw() function does not return the updated HTML. What I expected from the raw() function is the value between <p id='Text1'> and </p>. If that worked you could use the index() and substring() functions to parse the values and assign those to Ninox fields.

Dean, Have you looked at the REST API? I have zero experience with it and I don't know if it will work inside the html() function. You might want to look into one of the API webinars.

Dean, I haven't had any coffee yet and I shouldn't have said I have zero experience with it. I experimented with the examples using code in a button and copied the result to a Text field...

 

let response := do as server
http("POST", "https://api.ninox.com/v1/teams/NDKpJAeL7bWtZBncq/databases/c43myvb6qcoh/tables/B/record", {
Authorization: "Bearer " + NK,
'Content-Type': "application/json"
}, {
A: "Stewart & Stevenson"
})
end;
if response.error then
alert(text(response.error))
else
'Returned Record' := text(response.result)
end

 

If we're following the same approach with a formula field, you would have to use something like fetch() in javascript instead of http() in Ninox. I just learned a little about it last night after a long day so I don't much detail to offer. I don't think something like Integromat is necessary to access their API.

Other than parsing, I don't know how you extract the field information. There is probably a way though.

@Mconneen, Thank you. I figured there was a better way and I'm afraid I have parsing on the brain right now. I really haven't spent any time with the REST API since this, https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/ninox-http-calls-syntax-5c83993071d2ba74f1399907. Dean's use case got me interested again.

 

In the thread above part of the discussion was about queries. I saw in the updated documentation that filtering is available. Have you tried it yet?

Hi Robert,

 

Whe you use the http() function to access a URL, you can get the HTML from the page. Then you have to find the items you want to save. This is what I use to get a forum page title...

 

let htmlString := response;
let startString := "<h3 class=""mt-16 mb-24"">";
let endString := "</h3>";
let startStringLen := length(startString);
let substringStartPos := index(htmlString, startString) + startStringLen;
let substringEndPos := substringStartPos + index(substr(htmlString, substringStartPos), endString);

 

This is how I save it to the 'Thread Title' field...

 

'Thread Title' := replaceHTMLEntitiesAndTags(substring(htmlString, substringStartPos, substringEndPos))

Robert, please reread page 2 of this thread.